This report helps the project manager align the projects in pipeline with the planned & actual resource utilizations 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.
This 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 in for the last quarter. Lets
Lets take an example of Peter Parker.
Utilization (Est) = Hours (Est)/Hours (Available) as a percentage.
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 |
Peter works 8 hours a day from Monday to Friday. The Assume Peter's Hours(Actual) on planned activities 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 plan smarter.
Note | ||
---|---|---|
| ||
If your users play multiple roles in different workspaces, then we recommend creating a custom field (single select dropdown) on users - "Primary Department" and group on that field, instead of Workspace . |