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 'Hours(Available)' column will show you this information.
| Apr | May | June |
|---|---|---|
| 176 | 176 | 168 |
Assume, Peter's Hours(Est) for last quarter is as follows. The Resource Load Chart or the 'Hours(Est)' column will show you this information.
| Apr | May | June |
|---|---|---|
| 131 | 168 | 214 |
Assume Peter's Hours(Actual) on planned activities for last quarter is as follows. The 'Hours(Actual)' column will show you this information. e g
| Apr | May | June |
|---|---|---|
| 128 | 58 | 164 |
So, the Estimated Utilization of Peter is as follows:
Utilization (Est) = Hours (Est)/Hours (Available) as a percentage.
For Apr (131/176)*100=74%.
| Apr | May | June |
|---|---|---|
| 74% | 95% | 127% |
Similarly, the Actual Utilization is as follows:
Utilization (Actual) = Hours (Actual)//Hours (Available) as a percentage.
For Apr (128/176)*100=73%
| Apr | May | June |
|---|---|---|
| 73% | 33% | 98% |
Using this, the PM can see how a particular resource is utilized for a period and can plan smarter.