This report helps the project manager align the projects in pipeline with the planned & actual resource utilizations 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.
This report shows the Utilization of the resources in the last quarter. Lets take an example of Peter Parker.
Utilization (Est) = Hours (Est)/Peter works 8 hours a day from Monday to Friday. The 'Hours(Available) as a percentage.' 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 |
Peter works 8 hours a day from Monday to Friday. The Assume Peter's Hours(Actual) for last quarter is as follows. The 'Hours(AvailableActual)' column will show you this information. e g
| Apr | May | June |
|---|---|---|
| 176128176 | 58 | 168164 |
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 |
|---|---|---|
| 75%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 re-assign resources accordingly.