Blog · Territory, capacity and quota planning · Professional services
Resource utilization compares actual used hours with available workforce capacity for the same period. Calculate total and billable utilization from capacity and timesheet exports, then reconcile leave, internal work, and idle hours.
Resource utilization is actual used hours divided by available hours for the same people and reporting period. It shows how much defined capacity was used, but the numerator determines whether it describes total workload or billable delivery. A useful report shows both and reconciles the hours that sit outside them.
Available hours = Scheduled hours minus approved unavailable hours
Total work utilization = Actual client and internal work hours / Available hours
Billable utilization = Actual billable hours / Available hours
Multiply each ratio by 100 when displaying it as a percentage. This article measures workforce capacity in a US professional services company. Seat occupancy, equipment use, and the sports attendance measure in the utilization glossary have different numerators and denominators.
Define “used” before opening the spreadsheet. Client delivery, internal administration, training, and business development may all consume time. In this example, client work is billable, internal work is productive nonbillable work, and recorded idle time is excluded from used hours. Another company may classify client work differently; its mapping should make the distinction explicit.
Do not subtract internal work from capacity and also count it as used work. That would shrink the denominator while retaining the same hours in the numerator.
Take scheduled hours from the staffing calendar, approved leave from the absence export, and actual work categories from submitted timesheets. Keep an employee identifier, team, and period on every row. Use the same staffing population in both files, including part-time people and starters or leavers where relevant.
Scheduled hours should reflect the person's actual work arrangement, rather than assigning identical capacity to everybody. Confirm whether holidays are already removed from the schedule. An absence cannot reduce capacity twice because it appears in both the calendar and leave file.
Use one summarized row per person and period after grouping the exports. Repeated schedule rows against multiple project entries are a common source of inflated capacity. For a Google Sheets export, SUMIFS can total hours matching both an identifier and period:
=SUMIFS(HoursRange,EmployeeRange,A2,PeriodRange,$M$1)
The named ranges must cover matching detail rows. Apply the same period boundary to work dates, leave dates, and scheduled dates. Covirage is not affiliated with Google.
A consulting practice reviews one closed monthly period. The timesheets classify every scheduled hour as approved leave, client work, internal work, or recorded idle time. The part-time consultant has a smaller schedule; that difference should remain visible.
| Consultant | Scheduled hours | Approved leave hours | Billable client hours | Internal work hours | Recorded idle hours |
|---|---|---|---|---|---|
| A | 160 | 16 | 104 | 32 | 8 |
| B | 160 | 0 | 128 | 24 | 8 |
| C | 80 | 8 | 48 | 16 | 8 |
| Total | 400 | 24 | 280 | 72 | 24 |
The total schedule is 160 + 160 + 80 = 400 hours. Approved leave is 16 + 0 + 8 = 24 hours, leaving 400 - 24 = 376 available hours. Actual used hours are 280 + 72 = 352.
| Consultant | Available hours | Used hours | Total work utilization | Billable utilization |
|---|---|---|---|---|
| A | 144 | 136 | 94.44% | 72.22% |
| B | 160 | 152 | 95.00% | 80.00% |
| C | 72 | 64 | 88.89% | 66.67% |
| Team | 376 | 352 | 93.62% | 74.47% |
Place the source table in columns A through F, with detail in rows 2 through 4. Add available hours in G, used hours in H, total work utilization in I, and billable utilization in J:
G2 = B2-C2
H2 = D2+E2
I2 = H2/G2
J2 = D2/G2
Fill down, and format the utilization columns as percentages. The team formulas divide totals:
=SUM(H2:H4)/SUM(G2:G4)
=SUM(D2:D4)/SUM(G2:G4)
The team used 352 / 376 = 93.62% of available capacity for work, while 280 / 376 = 74.47% was billable. Displayed percentages are rounded to two decimal places; retain unrounded ratios in the workbook.
Each person's scheduled hours must equal leave plus client work plus internal work plus idle time. Across the team, that identity is:
400 scheduled hours = 24 leave + 280 client work + 72 internal work + 24 idle
Available capacity also reconciles as 376 = 352 used + 24 idle. If these checks fail, the residual is unexplained time until someone resolves it. Do not automatically label an incomplete timesheet as spare capacity.
A second check weights each person's utilization by available hours. SUMPRODUCT multiplies corresponding entries and adds the products, so this must equal the team utilization:
=SUMPRODUCT(G2:G4,I2:I4)/SUM(G2:G4)
Using the unrounded ratios, the weighted numerator returns 136 + 152 + 64 = 352 hours. An unweighted average would give 92.78%, because it gives the part-time consultant the same influence as each full-time consultant. The correct team rate remains 93.62%.
Keep the same 352 used hours but use scheduled hours before leave. The calculation becomes 352 / 400 = 88.00%, rather than 93.62%. Both are reproducible ratios, but they measure different capacity bases. Moving between them without labeling the change makes a trend misleading.
The numerator also changes the business question. Total work utilization says the team is occupied, while billable utilization shows a smaller share of available hours generating billable delivery. Review the 72 internal hours by approved category before assuming they can be converted into client work. Training, supervision, and required administration may be necessary to deliver the work well.
For planning assigned hours against capacity, use resource allocation and utilization; assignments are not evidence of actual hours worked. For the next staffing review, the capacity planning report covers how to present capacity alongside demand.
Bring a sample of your own staffing calendar, approved leave export, and categorized timesheets. Covirage maps the columns; its tools compute and check utilization, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring your team's file.
See Covirage for professional services for the supporting business use.
Not necessarily. Total work utilization includes client delivery and internal work under the agreed definition. Billable utilization includes only hours classified as billable. Both can use the same available-hours denominator, but they answer different questions about workload and commercial capacity.
This example removes approved leave from scheduled hours before calculating available capacity. A business can also report a separate paid-hours measure, but it must label that denominator clearly. Changing leave treatment between periods creates a measurement change that can look like an operating improvement.
Yes, when recorded work exceeds the defined available capacity, such as when overtime is included in used hours but excluded from the standard schedule. Investigate workload, duplicate entries, and denominator assumptions before interpreting that result as sustainable productivity.
Use a target that reflects the role, internal responsibilities, and capacity definition. Client delivery staff, managers, and people in training have different work mixes. Compare the same definition over time and inspect overtime, quality, and unfilled demand before setting a staffing target.