How do I calculate billable utilization for a service team?

Calculate billable utilization by dividing recorded billable hours by the available hours defined for the same people and period. For a team, add the hours first and then divide. Do not simply average employees' percentages when their available hours differ.

Keep the definition beside the result. Does availability include approved leave? Are the hours actual or planned? Does billable mean work eligible to be charged under the agreement, or hours already invoiced? The percentage cannot answer those questions for you.

Choose the question before the dashboard

A useful actual-utilization question is: how much of this defined available time went into work chargeable to customers? That is different from asking how full next month's schedule looks, whether the work produced a good result or how much cash customers paid.

Deltek's resource-utilization explanation presents the billable-hours-over-available-hours formula and identifies choices about actual versus planned time, part-time staff and time off. Use those choices to make the report explicit, not to import a universal target.

A fixed-price project also can consume customer-delivery time. Its internal classification does not change what the customer agreed to buy. The price-basis guide explains that separate contract question.

For this article's example, the service contracts charge by eligible hours. The reported billable work meets the actual agreed scope and approval requirements. That supplied fact should not be assumed for an unapproved task in a real time sheet.

One month, three different schedules

Consider an invented service team reviewing one completed month. A has 160 paid scheduled hours, including twenty hours of approved paid leave. B has 120 paid scheduled hours and no leave. C has eighty paid scheduled hours, including twenty hours of approved paid leave.

The team's chosen net-availability definition excludes that approved leave but includes necessary internal work. A therefore has 140 available hours, B has 120 and C has 60. Total net availability is 320 hours.

Actual eligible billable work is 100 hours for A, 90 for B and 30 for C. The corresponding necessary internal work is forty, thirty and thirty hours. Every net-available hour is accounted for; there is no missing time or unrecorded overtime in this bounded case.

Paid scheduled hours total 360. Approved leave totals forty. Billable work totals 220, and internal work totals 100. The reconciliation is 220 plus 100 plus forty, giving the same 360 paid scheduled hours.

These are original planning and time-record inputs, not measurements of an actual employer, an industry benchmark or evidence that every team should use this availability policy.

Add hours before calculating the team rate

Scroll across for the original team record. Percentages are rounded only for display.

The team result is 220 ÷ 320 = 68.75%. Each hour has the same weight in that ratio.

A simple average of the three individual rates is about 65.48%, using their unrounded values. That gives C's sixty available hours the same influence as A's 140. It answers an equal-person averaging question, rather than the stated share of team hours.

You can reproduce the team result by weighting each person's rate by that person's share of available hours. Adding the original hours is simpler and avoids intermediate rounding.

A different denominator needs a different label

Using all 360 paid scheduled hours gives 220 ÷ 360 = about 61.11%. That is a valid differently defined ratio if clearly labeled: billable hours as a share of paid scheduled hours, including the supplied leave.

It is not the same 68.75% net-availability measure. Neither result establishes that people worked harder. The difference comes from the forty approved leave hours in the denominator.

When comparing months or firms, reconcile that policy first. A seasonal concentration of leave can change a gross-hours ratio without changing how available working time was used. A definition change can also make a trend appear to improve.

Keep necessary internal work visible. Removing training or administration from a report does not make those tasks disappear from the operation. If a manager excludes them from an availability measure, label that measure honestly and retain a separate account of the work.

Billable time is not the final invoice

The fictional team's agreed nominal rate is $100 per eligible hour. Its 220 billable hours therefore support $22,000 before a specifically approved commercial concession.

For this period, the business agrees to a complete $2,000 reduction across the work, with no other discount, tax, fee or billing change. The final invoiced amount is $20,000.

The concession changes the dollar amount, not the hours actually spent. Do not rewrite 220 worked hours as 200 hours simply because $20,000 divided by the nominal $100 rate happens to equal 200.

Under the stated time-report definition, billable utilization remains 68.75%. The final invoice represents about 90.91% of the original $22,000 value. That separate value comparison explains a result the utilization percentage cannot capture.

Per billable hour actually worked, final invoiced value is about $90.91. Per net-available hour, it is $62.50: $20,000 divided by 320. Neither is a replacement description of the original $100 nominal rate.

An invoice is not cash collected

By the fixed review cutoff, customers have paid $18,000 of the final $20,000. The remaining $2,000 is unpaid. No other collections, refunds or credits affect this limited record.

That unpaid $2,000 is different from the $2,000 concession already removed before the final invoices. One is a remaining receivable; the other is a reduction the business has already granted. Adding both back to claim $22,000 still collectible would be wrong.

Likewise, reporting $18,000 as the entire invoice value would erase an unpaid balance without an established reason. The current cash collected equals $56.25 per net-available hour, but that does not make $56.25 the contractual billing rate.

This example supplies no costs or complete bank calendar. None of these hourly-value measures is a profit calculation or evidence that every dated business payment is funded. The record keeps work, invoicing and collection separate so the next financial review starts from supported amounts.

Do not read a plan as an actual result

Deltek's Vantagepoint 4.5 documentation describes a utilization calculation based on planned billable hours and explains that project stage and settings affect inclusion. That is a useful reminder to identify the report you are looking at.

A planning report can include hours that have not been worked. Depending on its rules, it may include opportunities still being pursued. An attractive planned percentage is not evidence that all those customers accepted work, that employees completed it or that invoices were paid.

Keep an actual report and a prospective capacity report separately labeled. Compare them to learn where work changed, but do not close an actual-time gap by copying a planned entry into the completed column.

No software is required to understand the distinction. A worksheet can also confuse the two states if its date, source and definition are missing.

Investigate the unbilled work before setting a target

The team's hundred internal hours need examination, but calling them waste would go beyond the supplied facts. Preparing a proposal, maintaining tools, training colleagues or correcting a process can support useful work without being separately chargeable.

Identify what the hours accomplished, which were necessary and which might be reduced through a supported change. An employee assigned significant training or business-development responsibilities should not be compared blindly with someone assigned mostly client delivery.

A higher target does not supply another customer order or remove an internal commitment. Check the actual workload and available paid capacity. Do not make the metric look better by failing to record work or treating required time as free.

The hourly-rate guide connects billable capacity with the complete cost of the service. Use that separate cost-and-demand review when setting a rate; a utilization percentage alone cannot establish an affordable price or a sensible staffing decision.

Nonbillable does not mean unassigned

The hundred internal hours are already assigned to necessary work in this case. They are not a hundred empty hours available for the next customer. The 320-hour net schedule is fully accounted for by 220 billable and 100 internal hours.

Suppose an unaccepted new project needs twenty more hours during the same period, and none of the existing work can move or disappear. The resulting workload would be 340 hours against 320 available, a twenty-hour gap. A report showing utilization below one hundred percent has not supplied the missing time.

Before accepting that project, establish a real change: permitted rescheduling, a genuinely available qualified resource or another supported arrangement. Each needs its own scope, cost and customer consequences. Reclassifying existing administration as billable does not perform the new work.

A zero denominator needs a status

For a separate reporting example, an additional employee is on approved leave for the whole period and has zero net-available hours and zero billable hours. Their individual ratio is not calculated: zero divided by zero is undefined, not zero percent or one hundred percent.

Adding their zero hours to the team sums does not change 220 divided by 320. Inserting an invented zero-percent result into an equal-person average would change that average without adding any work capacity.

Explain the status and the availability policy instead of forcing every row to contain a percentage. A nonzero billable entry against zero availability is a discrepancy to investigate, including the period and schedule used, rather than a ratio to fix by choosing a convenient denominator.

Make the next report comparable

Keep the period, people, availability policy, billable definition, time-entry status and cutoff with the report. Add the original hours rather than relying only on rounded person-level percentages.

Resolve missing time through the actual review process. Label unresolved entries instead of assuming that an absent record proves idle time or customer work. If a correction changes a prior period, preserve the original and explain the revised result.

Then put the ratio beside the evidence it cannot supply: delivered quality, remaining commitments, the final invoice and actual collection. The useful question is what needs attention next, not whether a single percentage looks sufficiently ambitious.