Service revenue forecast: hours, utilization and hiring

Forecast service revenue from deliverable hours × billable utilization × realized hourly price. Build the hours from the actual roster before applying the percentage. Then check that the right people are available for the work and that the forecast separates delivery, invoicing and collection.

Reconcile paid hours to the utilization denominator

Assume four delivery staff each have 160 paid hours in the month. Paid time is 640 hours. Leave, mandatory administration and training reduce the hours available for client work as shown below. These are example planning inputs, not utilization benchmarks.

Define utilization here as billable hours divided by those 544 available hours. At 65%, planned billable time is 353.6 hours. At $90 realized revenue per billable hour, monthly service revenue is $31,824. Fractional forecast hours are reasonable; actual recorded time follows the firm's timekeeping unit.

Applying 65% to all 640 paid hours instead gives $37,440, an overstatement of $5,616 under this definition. The alternative definition may be legitimate if your historical utilization already includes leave and administration in its denominator. Choose one convention: subtracting those hours and then applying a utilization rate measured against all paid hours can understate capacity.

Check the work behind the billable hours

Compare the 353.6-hour plan with signed work by delivery date, skill and client. If 300 hours are booked, the plan still needs 53.6 additional billable hours. Label those as unbooked demand rather than treating a capacity calculation as evidence of sales. A 65% planning assumption is not a physical ceiling; any higher proposed utilization needs a schedule showing what other work is displaced.

Team totals can also conceal a specialist bottleneck. Suppose a signed project needs 100 hours of specialist work, but that specialist has only 80 available in the delivery window. Spare generalist hours do not close the 20-hour gap. Reassign suitable work, obtain the missing skill or move the delivery date before including the full project in that month's feasible forecast.

For fixed-fee work, calculate the implied realized rate. A $9,000 project planned at 100 hours implies $90 per hour. If delivery expands to 130 hours at the same fee, the realized rate falls to about $69.23. Revenue has not grown, while 30 more hours are no longer available for another engagement.

Calculate a hire's ramp-up economics

Assume a hire costs $4,500 per month in salary and other included fixed employment costs. After the same kinds of time deductions, the hire has 136 available hours. Each billed hour produces $90 revenue and $10 incremental delivery cost, leaving $80 contribution before the hire's fixed cost.

The hire needs $4,500 ÷ $80 = 56.25 billable hours to cover those included costs, equivalent to about 41.36% of 136 available hours. The mature-month case can cover them; the first-month case cannot. Include recruitment fees, equipment or supervision time separately when they change the decision. More capacity is valuable only if suitable work can fill it.

Convert the work into cash dates

For an hourly contract that bills accepted work at month-end, delivery value enters the invoice schedule at that point. If the customer pays thirty days later, the cash arrives in the following month while payroll may already have been paid. Use the contract's actual acceptance, invoice and collection terms instead of putting revenue directly into bank receipts.

Forecasting assumptions should draw on current timesheets, booked work and the delivery team's knowledge. Forecasting: Principles and Practice discusses judgment when data are incomplete or a new activity lacks history. It does not supply a universal utilization rate; the percentages here are explicit teaching assumptions.

Use the project milestone guide for larger fixed-fee engagements, the capacity and break-even guide for operating thresholds, and the weekly cash forecast for the payroll-to-collection gap.