Percentile Analysis report

Overview

This report shows a number of key performance metrics for selected teams and highlights their Latent Capacity at a target percentile of Productivity (i.e. the amount of time they would have gained if they had worked at that percentile). It also shows how closely Work In and Productivity are correlated.

This report shows how much potential time could be available and work that could be completed if the current Productivity were stabilised, encouraging the best practise of the AOM method. It also helps team leaders to monitor how successfully the implementation of AOM is breaking the link between Work In and Productivity.

 

Team

Select the workgroup that you would like to view the report for. Selecting a level of the hierarchy higher than a team will display the overall values of the parent workgroup and the individual metrics for each child workgroup.

Date Range

Enter the first and last date of data that you want to include in your report. You can do this by typing the dates directly into the cells or by clicking on the calendar function . The data will display the metrics for the entire reporting period with the option to expand to see the same metrics by day.

Percentile

Select the percentile value you would like to use to calculate Latent Capacity from the drop-down menu.

Advanced Options

Clicking advanced Options allows you to select to include or exclude non-working periods from the report.

Interval

You can view your data in hours, or FTE by selecting the required unit here.

Notes / Export

You can add notes the report using this icon .

Export the report to Excel using this icon. This will export the data displayed on the screen in the key metrics table. If you require team level data, be sure to expand the data before exporting.

 

 

Latent capacity details the proportion of the team's Core Time that would have become available to them if they had consistently worked at the level of Productivity selected in the Productivity Percentile field when running the report. Fluctuating daily performance will impact the amount of Latent capacity within each workgroup.

For each team included in the workgroup selected when running the report, the chart will detail the:

  • Latent Capacity, additional capacity that would have been available for the team to utilise if they had maintained daily performance at the percentile value selected when running the report. The chart displays Latent Capacity in hours.

  • Productivity Improvement Implied, the percentage increase to the actual productivity achieved that could have been achieved had actual productivity stabilised at the percentile value selected when running the report.

The chart will also illustrate the Overall Latent Capacity in hours for the workgroup over the period being reviewed.

 

The key metrics table displays metrics relating to workload, performance and opportunity for the selected workgroup and each child workgroup for the reporting period. The metrics displayed at the highest level represent the entire reporting period, but each team can be expanded to view this data by day.

Workload

Time Worked (Hours)

The total time available to complete work within the workgroup for the period being reviewed.

Core Time (Hours)

The hours that were available for the workgroup to complete core work during the period being reviewed. (Time Worked – Diverted)

Work In (Hours)

The total new work received by the workgroup during the period being reviewed based on items received x standard time for all the workgroups core tasks.

Work Out (Hours)

The total work completed for the workgroup during the period being reviewed based on items completed x standard time for all the workgroups core tasks.

WIP (Hours)

The Work in Progress for the last day of the period being reviewed based on WIP items x standard time for all the workgroups core tasks.

Diverted (Hours)

The total hours invested in all Diverted tasks for each workgroup during the period being reviewed.
 

Performance

Utilisation (%)

The percentage of the workgroups Time Worked that was available to complete core work. Utilisation decreases as Diverted time increases.

Productivity (%)

The actual Productivity achieved by the workgroup during the period being reviewed. This is an actual calculation based on Work Out/Core Time for the whole reporting period.

Lowest Productivity (%)

The lowest daily Productivity score achieved by the workgroup during the period being reviewed. When compared to the Highest Productivity value this illustrates the size of variation in daily performance.

Highest Productivity (%)

The highest daily Productivity score achieved by the workgroup during the period being reviewed. When compared to the Lowest Productivity value this illustrates the size of variation in daily performance.

Opportunity

Productivity At 85th Percentile (%)

The overall Productivity score the workgroup would have achieved if they had reduced variation and stabilised daily performance at the selected percentile value.

Work Out Opp. At X Percentile (Hours)

The Work Out opportunity, how much core work could have been completed during the period being reviewed if the workgroup had reduced variation and stabilised daily performance at the selected percentile value.

Latent Capacity (Hours)

The additional capacity in hours that would have been available for the team to utilise if they had maintained daily performance at the percentile value selected when running the report.

Latent Capacity (%)

The additional capacity as a % of the core time that would have been available for the team to utilise if they had maintained daily performance at the percentile value selected when running the report.

Correlation Co-efficient (r)

Details the extent of the relationship (r) between Work In and Productivity.

The closer to 1 this value is the stronger the relationship between Work In and Productivity.

  • A positive value indicates that as Work In increases Productivity increases too

  • A negative value indicates that as Work In increases Productivity decreases

  • A 0 indicates there is no relationship between the 2 values. The closer to 0 a workgroup is the more successful they have been in applying the AOM method to break the relationship between Work In and Productivity.

 

This chart combines a bar graph with a line graph to show measures of overall performance for the workgroup selected in the Key Metrics table above.

 

The chart illustrates the following metrics by day for the period being reviewed:

  • Work In illustrates the total new work received by the workgroup during the period being reviewed based on items received x standard time for all the workgroups core tasks.

  • Productivity Percentile illustrates the productivity percentile value selected when running the report allowing for comparison between this value and the actual daily or overall Productivity.

  • Overall Productivity illustrates the actual Productivity achieved by the workgroup across the entire period being reviewed. This is an actual calculation based on Work Out/Core Time for the whole reporting period.

  • Daily Productivity illustrates the actual Productivity achieved by the workgroup by day for the reporting period allowing for comparison between the selected Productivity Percentile value and a view of daily variation.

  • Utilisation illustrates the actual Utilisation value for the workgroup for each day included in the reporting period.

 

 

For more information on...
Percentile Analysis Video Percentile Analysis Video

Calculations

See Key Equations
Frequently Asked Questions See FAQs
Video Library See Video Library