Assigned Hours / Capacity (Contracted Hours - Time off) * 100
The utilization report shows you what percentage of workable hours (capacity) have been assigned to a person, excluding any tentative projects.
The Capacity is calculated as Contracted Hours - Time Off. For example, if someone is contracted for 40 hours, and they have 1 day (8 hours) off, their capacity will be
40 hours - 8 hours = 32 hours.
The Total Utilization is the percent of capacity assigned for someone. If they have a capacity of 40 hours, and have been assigned 20 hours work. Their utilization will be 50%.
20 hours / 40 hours * 100 = 50%.
The Billable Utilization is the percentage of billable work assigned. This is anyone work except individual assignments marked 'non-billable' or work on internal projects.
The Non-billable Utilization is the percentage of capacity assigned to non-billable work. This is all individual non-billable assignments (grey assignments) or any work done on internal projects.
The Billable Utilization + Non-billable Utilization = Total Utilization.
Contracted hours = 40 hours
Time off = 1 day (8 hours)
Capacity = 40 - 8 = 32 hours
Non-billable assignments = 8 hours
Billable assignments = 16 hours
Non-billable Utilization = 8 / 32 * 100 = 25%
Billable Utilization = 16 / 32 * 100 = 50%
Total = 16 + 8 / 32 * 100 = 75%
- Work on Tentative Projects is not included in the capacity report
- The total gives the average capacity of all people (100% + 50% = 75%), not the capacity of the entire business (e.g. it is not total hours / total capacity)
N/Ameans the person has no contract, or no contracted hours during that time period. These people are excluded from the total/average,