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.

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.

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.

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.

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!