How to Forecast Revenue When Your Available Hours Change Every Month

Your revenue model is simple on paper: hours times rate equals revenue. But the hours change every month. Vacations, sick time, onboarding, turnover, and just the fact that not every month has the same number of working days. So your forecast is simple in theory and unreliable in practice.

Why Fixed-Hour Forecasts Break Down

A lot of services businesses build their revenue forecast by taking their current team, assuming a fixed number of billable hours per person per month, and multiplying by rates. That model looks clean in a spreadsheet and falls apart by February.

The problem is that available capacity is not a fixed number. It changes based on holidays, leave, part-time arrangements, utilization rates, and whether you're fully staffed or carrying an open role. If your forecast doesn't reflect those changes, you'll consistently over-forecast in light months and under-forecast in heavy ones. Neither error is useful.

What Owners Get Wrong

The most common mistake is confusing theoretical capacity with billable capacity. If you have a staff member who works 160 hours a month, that's their total available time. But not all of it is billable. Training, admin, internal meetings, business development, and non-billable project overhead eat into it. The gap between total hours and billable hours varies by role and by month, and it matters for forecasting.

The second mistake is not modelling planned absences. If three team members are taking vacation in August and you know that in January, August's forecast should reflect it. Most owners build the forecast and then explain the August miss after the fact. That's backwards.

The third mistake is using last month's actuals as next month's forecast. If last month was unusually light or heavy, carrying it forward embeds the anomaly into the plan. A forecast needs a forward-looking driver, not a backward-looking copy.

The CFO Perspective

A professional services firm with eight billable staff was forecasting revenue using a simple headcount-times-hours model. The forecast was off by 15 to 20 percent most months. Not always in the same direction, which made it hard to learn from. When we built out the actual capacity drivers, we found three things happening simultaneously: utilization varied by role, summer vacation clusters weren't modelled, and one open role had been carried in the forecast as fully staffed for four months while it was vacant.

We rebuilt the forecast around actual available hours by person by month, applied a utilization rate by role, and adjusted for known planned absences. The first month it ran, variance dropped to 6 percent. The owner stopped having surprise months.

How to Build a Capacity-Based Revenue Forecast

Start with working days, not months

January has 22 working days. February has 20. August might effectively have 15 if your team takes summer vacation. Build your forecast off working days, not calendar months. This alone removes most of the systematic over-forecast in short months.

Calculate available hours per person per month

For each person on your team, take their working days for the month, subtract any planned vacation or leave you already know about, and multiply by their daily hours. That's their available time. Not their billable hours yet.

Apply a utilization rate by role

Senior delivery staff might run 75 to 80 percent billable. Junior staff or anyone with significant administrative responsibility might run 60 percent. Use your historical actuals by role to set these rates. If you don't have historical data, start with an estimate and refine it over three months.

Multiply by rate to get revenue capacity

Available hours times utilization rate gives you expected billable hours. Multiply by the billing rate for each role to get your revenue capacity for the month. This is not a guarantee of revenue. It's the ceiling given your current team and planned absences.

Adjust for demand

If you have confirmed contracts or retainers, those set a floor. If your pipeline is thin, you may not fill capacity. Your forecast should sit somewhere between the demand floor and the capacity ceiling, adjusted for your current pipeline confidence.

What to Do About It

1. Build a 12-month working-day calendar. Count the actual working days in each month of the year, accounting for statutory holidays in your province. This is the foundation of an accurate capacity forecast.
2. Create a capacity grid. Rows are team members, columns are months. Fill in available days after known vacation and leave. Multiply by hours per day. This is your raw capacity.
3. Set utilization rates by role. Pull three to six months of actual billable hours versus available hours for each role. Use those averages as your utilization inputs. Revisit quarterly.
4. Connect capacity to revenue. Available hours times utilization times rate equals revenue capacity. Compare this to your pipeline and contracted revenue to set a realistic forecast range.
5. Update monthly with actual absences. As the year progresses, replace estimated absences with confirmed ones. The forecast improves in accuracy as you get closer to the month.
6. Track variance by driver. When actuals miss forecast, categorize why. Was it a capacity miss (fewer hours available than planned) or a demand miss (hours were available but not filled)? Different causes need different fixes.

A Forecast That Moves With Your Business

Revenue forecasting for a services business is not a set-it-and-forget-it exercise. It's a monthly update that reflects your actual team, their actual availability, and your actual pipeline. When the model connects to the real drivers, surprise months become rare.

If your revenue forecast is consistently off and you're not sure why, book a free call at peterxiacpa.com/book.

Next step: see it in your free Instant CFO Snapshot.