Example of Resource Actual Utilization Calculation
Actual utilization for the current quarter is the percentage of actual hours worked at the beginning of the quarter, plus projected project assignment hours from the date the process ran through the end of the current quarter, compared to the available hours.
Scenario
Following is an example of an actual utilization calculation for the current quarter.
Example scenario:
-
Resource name: Lisa Jones
-
Current quarter date range: January 1 - March 31, 2016
-
Today's date: February 15, 2016
-
Latest run date of the Update Resource Utilization Data process: February 15, 2016
-
Work category that is eligible for utilization: Project Work
-
Work categories that aren't eligible for utilization: Training and Paid Time Off
Lisa Jones is available to work for 8 hours a day, 5 days a week. Weekends are nonworking days.
The following table lists the actual, projected, and available hours in the current quarter for Lisa Jones. The table doesn't include weekend nonworking days.
Work Dates by Week |
Work Category |
Eligible for Utilization |
Project Name |
Worked Hours |
Projected Hours |
Available Hours |
---|---|---|---|---|---|---|
January 1 (holiday) |
Not applicable |
Not applicable |
Not applicable |
0 |
Not applicable |
8 |
January 4-6 |
Project Work |
Yes |
Electrical |
24 |
Not applicable |
24 |
January 7-8 |
Training |
No |
Not applicable |
16 |
Not applicable |
16 |
January 11-15 |
Project Work |
Yes |
Electrical |
24 (worked partial days) |
Not applicable |
40 |
January 18-22 |
Project Work |
Yes |
Hardware |
40 |
Not applicable |
40 |
January 25-28 |
Paid Time Off |
No |
Not applicable |
32 |
Not applicable |
32 |
January 29 |
Training |
No |
Not applicable |
8 |
Not applicable |
8 |
February 1-5 |
Project Work |
Yes |
Hardware |
40 |
Not applicable |
40 |
February 8-11 |
Project Work |
Yes |
Hardware |
32 |
Not applicable |
32 |
February 12 |
Project Work |
Yes |
Hardware |
8 |
Not applicable |
8 |
February 15-19 |
Project Work |
Yes |
Hardware |
Not applicable |
40 |
40 |
February 22-26 |
Project Work |
Yes |
Hardware |
Not applicable |
40 |
40 |
February 29-March 4 |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 (no projected work) |
40 |
March 7-11 |
Project Work |
Yes |
Install |
Not applicable |
40 |
40 |
March 14-18 |
Project Work |
Yes |
Install |
Not applicable |
40 |
40 |
March 21-25 |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
40 |
March 28-31 |
Project Work |
Yes |
Launch |
Not applicable |
32 |
32 |
Results for the current quarter example:
-
Actual worked hours that are eligible for utilization: 168
-
Projected hours for project work: 192
-
Available hours: 520