Resource Utilization (Planned v/s Actual)

This report helps the project manager align the projects in pipeline with the planned & actual resource utilization on planned activities to get insight into long-term capacity plans. This helps in informed data-driven decisions to ensure the most efficient use of the resources for ensuring project success.

Estimated Utilization is computed as a percentage of estimated to available resource hours, while Actual Utilization is computed as a percentage of actual-approved to available resource hours. This report shows the Utilization of the resources for the last quarter.

 Lets take an example of Peter Parker.

Peter works 8 hours a day from Monday to Friday. The 'Available Hours' column will show you this information. 

Assume, Peter's Planned Hours for last quarter is as follows. The Resource Load Chart or the Planned Hours column will show you this information. 

Assume Peter's Actual Hours on planned activities for last quarter is as follows. The Actual Hours column will show you this information. e g

So, the Planned Utilization of Peter is as follows:
Planned Utilization = Planned Hours/Available Hours as a percentage.
For Apr (131/176)*100=74%.

Similarly, the Actual Utilization is as follows:
Actual Utilization = Actual Hours/Available Hours as a percentage.
For Apr (128/176)*100=73%

Using this, the PM can see how a particular resource is utilized for a period and can plan smarter.