Release Update: Better Team Utilization & Profitability Reports

At Orangescrum, we actively listen to user feedback and continuously refine our features to make project management more efficient. This latest update brings key improvements to Team Utilization Reports and Profitability Reports, ensuring better accuracy and usability.

This latest release focuses on accuracy, clarity, and decision confidence, with major enhancements to Team Utilization Reports and Profitability Reports—two of the most business-critical views for project managers, PMOs, and leadership teams.

Team Utilization Report Enhancement

What was the Objective?

Our esteemed customers wanted a Team Utilization Report that compares Spent Hours vs. Company-Defined Working Hours instead of just comparing Spent Hours vs. Estimated Project Hours (which was already available).

We introduced this capability, enabling project managers and admins to analyze discrepancies between actual logged hours and company-defined working hours (e.g., 45 hours/week). However, an inconsistency emerged when viewing the report across multiple projects.

Originally, company-defined working hours (e.g., 45 hours/week) were displayed separately for each project, which incorrectly implied that employees were expected to work 45 hours per week per project rather than across all projects collectively. This misrepresentation led to inaccurate utilization calculations.

Clear Pain Statement

Many customers told us that comparing Spent Hours vs. Estimated Project Hours alone wasn’t enough. They needed visibility into how actual logged time compares against company-defined working hours (for example, 45 hours per week).

We introduced this comparison—but quickly discovered a reporting issue when multiple projects were involved.

What Was Going Wrong?

Previously:

• Company-defined working hours (e.g., 45 hours/week) appeared under each individual project
• This unintentionally suggested that employees were expected to work 45 hours per project per week
• As a result, utilization percentages appeared inflated and misleading

What we achieved

Now, the company-defined working hours are displayed only when viewing the “All Projects” report instead of being repeated under each project.

Accurate Utilization Insights – Users can now properly track team utilization (based on actual logged hours across all projects, compared to the company-defined working hours.)

 More Transparency – Project managers now get a clear, consolidated view of team workloads without any misrepresentation of working hours per project.

Profitability Report Accuracy Enhancement

What was the Objective?

The Profitability Report, designed to measure project profitability based on Project Estimation Hours versus Task Estimation Hours, contained miscalculations. Project Estimation Hours were incorrectly computed, leading to unreliable profitability assessments.

Additionally, inaccuracies in Profit Margin % and Spent Hours calculations further impacted profitability insights.
Moreover, when exporting the report, only the headers were visible, while the actual data and metrics were missing.
What we achieved

• Corrected the Project Estimation Hour computation, ensuring precise profitability analysis.
• Rectified inaccuracies in Profit Margin % and Spent Hours calculations to provide more reliable financial insights.
• Fixed the report export functionality – ensuring all relevant details and metrics are included in the exported data.

Why This Was Critical

Inaccurate profitability data can lead to:

• Mispriced projects
• Poor forecasting
• Incorrect assumptions about project success

Impacts and Benefits

• Accurate Resource Utilization – Enables precise tracking of team workloads in relation to company-defined working hours.
• Reliable Profitability Insights – Facilitates better financial analysis and strategic decision-making.
• Enhanced Transparency – Offers a clear, comprehensive perspective on team performance and profitability.
• Improved Data Exporting – Ensures seamless export functionality with all relevant metrics included.

Who Benefits Most From This Update?

These improvements are especially valuable for:

• PMOs tracking utilization across multiple projects
• Service-based teams managing billable vs non-billable work
• Finance teams reviewing margins and cost efficiency
• Leadership teams making resourcing and pricing decisions

What is upcoming?

• Advanced Project Template – Properly track team workloads and compare them against actual company working hours.
• Organization Hierarchy – Establish a structured framework to define roles, responsibilities, and reporting relationships across teams and departments.
• Business Unit Management – Streamline operations by organizing teams, resources, and projects under distinct business units for better oversight and efficiency.
• Program Portfolio Management – Align multiple projects and programs with strategic objectives, ensuring optimized resource allocation and risk management.
• Test Case Management – Centralize and automate test planning, execution, and tracking to enhance software quality and accelerate release cycles.
• Custom Dashboard and Report Module – Gain real-time insights with customizable dashboards and reports tailored to specific project and business needs.
• Mapping Epic to Initiatives and Features in Agile Project Management (Scaled Agile) – Maintain alignment between high-level business goals and development efforts by linking epics to initiatives and features.
• Project-based Custom Fields – Enable tailored data tracking by defining project-specific custom fields for improved categorization and reporting.
• Guest User Accessibility – Grant controlled access to external stakeholders, enabling collaboration while maintaining security and data integrity.

We’re committed to making Orangescrum smarter, more accurate, and more powerful for all our users. Your feedback drives our improvements—so keep them coming!