Resource Forecasting: Why Services Firms Fly Blind

Your next quarter’s revenue depends on people you haven’t staffed to projects you haven’t won yet. Most firms handle this poorly.

According to the SPI Research 2025 PS Maturity Benchmark, billable utilization across professional services fell to 68.9%, the fourth consecutive year of decline. But the utilization number is a symptom. The root cause is that firms can’t see what’s coming. They staff reactively, scramble when projects close, and discover gaps only after they’ve already cost money. An RMI survey on forecasting practices found that 95% of services organizations recognize forecasting as critical, yet only 47% have a formalized process for it. The gap between knowing it matters and actually doing it is where firms lose money.

What Resource Forecasting Actually Means

Resource forecasting is not the same as resource allocation. Allocation answers “who works on what right now?” Forecasting answers “what will we need three months from now, and do we have it?”

Good forecasting connects three things:

• Pipeline visibility. What deals are likely to close, when, and what skills will they require?
• Current commitments. When do existing projects release people, and with what availability?
• Capability gaps. Where will demand exceed supply, and how far in advance can you see it?

Most firms handle the first two informally. A partner knows what’s in the pipeline. A project manager knows when their people roll off. But connecting those two views into a forward-looking picture of supply and demand is where things break down. The information lives in different heads, different spreadsheets, and different systems.

Why Gut Feel Stops Working

In a 15-person firm, the founder can keep resource forecasting in their head. They know every consultant, every project, and every deal in the pipeline. Mental models work at that scale because the variables are small enough to hold.

At 40 people, the math changes. You have multiple project managers, several active proposals, overlapping timelines, and mixed seniority levels. No single person can see the full picture. Yet many firms at this size still rely on the same approach that worked at 15: a weekly check-in, a shared spreadsheet, and a senior partner’s judgment.

Three things break:

• Timing mismatches. A deal closes two weeks early and you need three senior consultants. But they’re committed until month-end. You either delay the client or pull people off existing work, damaging both projects.
• Skills mismatches. You have bench capacity, but not in the right discipline. Four available people doesn’t help if the new project needs a data architect and you have four front-end developers.
• Invisible bench time. People roll off projects without the next engagement ready. A week of bench time for one consultant is a rounding error. A week of bench time for five consultants, repeated quarterly, is a line item worth tracking.

The RMI forecasting survey found that 50% of services organizations cannot forecast resource needs beyond two months. Only 22% meet the six-month planning horizon that best-practice firms maintain. When you can’t see further than eight weeks out, every staffing decision is reactive.

The Spreadsheet Forecasting Trap

The same RMI research found that 71% of professional services firms still rely on spreadsheets for resource forecasting. Spreadsheets work well for static snapshots, but resource forecasting is inherently dynamic. People’s availability changes daily. Pipeline deals advance or stall. Project timelines shift.

A spreadsheet-based forecast has three specific weaknesses:

1. It’s already stale. By the time you’ve gathered inputs from every project manager, compiled the data, and formatted the view, reality has moved. A deal closed. A project scope changed. Someone gave notice.
2. It can’t model scenarios. “What if we win both the Acme and Beta proposals?” requires manually rebuilding the allocation grid. Most firms don’t bother, so they can’t see conflicts until both deals close simultaneously.
3. It lacks skill-level granularity. Spreadsheets track people and hours. They rarely track competencies, certifications, or experience levels in a way that makes skill-matching queryable. The RMI survey found that only 31% of firms can forecast at the skill level.

The result is that resource forecasting remains the top business challenge for professional services decision-makers, with 59% calling it “very challenging.”

If your firm has already outgrown spreadsheet-based processes, we’ve covered the broader transition from spreadsheets to structured systems in a previous post.

What Does Good Forecasting Look Like?

Firms that forecast well share a few characteristics. None of them require exotic tools. They require discipline and connected data.

They forecast at the skill level, not just the person level. Instead of knowing “we have 6 people available in March,” they know “we have 2 data engineers, 1 project manager, and 3 junior analysts available in March.” This changes the conversation from “do we have capacity?” to “do we have the right capacity?”

They connect pipeline probability to resource demand. A deal at 80% probability in week six creates a different planning signal than a deal at 20% probability in week twelve. Good forecasting weights pipeline stages and builds tentative resource plans that sharpen as deals progress.

They hold regular interlock meetings. Sales, delivery, and resource management review the same data together. The RMI research found that 65% of firms lack formalized interlock meetings, which means sales commits timelines without knowing whether delivery can staff them.

They maintain a rolling horizon. Best-practice firms forecast at least six months ahead, updating weekly. This doesn’t mean six-month accuracy. It means six-month visibility. You see the shape of demand early enough to act: hire, train, subcontract, or adjust sales targets.

They separate strategic from operational forecasting. Operational forecasting covers the next 4 to 8 weeks: who’s on what, who’s rolling off, what starts soon. Strategic forecasting covers 3 to 12 months: what skills are we short on, where should we invest in hiring, which service lines are growing. Many firms do the first and skip the second entirely.

How Forecasting Failures Become Financial Losses

The financial impact of poor resource forecasting is rarely visible as a single line item on the P&L. It shows up across several categories at once.

Bench time. When people finish a project and wait for the next one, the firm pays their salary while generating no revenue. According to the SPI Research benchmark, the gap between the industry average (68.9% utilization) and the healthy threshold (75%) represents significant recoverable revenue. For a 50-person firm billing at $150 per hour, closing that 6.1-point gap means roughly 6,710 additional billable hours per year, or just over $1 million in revenue capacity.

Rushed hiring. When you can’t see demand three months ahead, you hire reactively. Reactive hiring means higher recruiting costs, less vetting, and longer ramp-up times. It also means you’re competing in a tight labor market with less lead time than firms that planned ahead.

Overcommitment. Without a clear view of capacity, sales teams commit delivery timelines that operations can’t meet. Projects start understaffed, which leads to the rework loops and scope creep we’ve covered before. EBITDA margins across professional services dropped to 9.8% in 2024, down from 15.4% the prior year, according to SPI Research. Overcommitment is one driver.

Turnover. Consultants with extended bench time leave. So do consultants who are chronically overworked because demand wasn’t distributed evenly. Both are forecasting failures. We’ve discussed the related context-switching cost that comes from juggling too many projects per person.

Is Resource Forecasting Worth the Effort?

Yes, but the value depends on how much invisible cost you’re currently absorbing.

If your firm runs at 70% utilization and you have 30 billable people, each point of utilization improvement represents roughly 660 additional billable hours per year (30 people multiplied by 22 working days multiplied by 8 hours, divided by 100). At $150 per hour, that’s $99,000 per point. Moving from 70% to 74% is nearly $400,000 in annual revenue capacity without adding a single person.

The investment isn’t primarily in tools. It’s in process: connecting pipeline data to resource data, holding interlock meetings, and maintaining a rolling forecast. The tools make it easier and more reliable, but the discipline comes first.

For a deeper look at how capacity planning and utilization connect, see our earlier posts on capacity planning and resource utilization.

Frequently Asked Questions

What is resource forecasting in professional services?

Resource forecasting predicts what skills and people a services firm will need in the coming weeks and months, based on pipeline deals, current project timelines, and known availability. It goes beyond allocation (who works on what today) to anticipate future supply-and-demand gaps before they create bench time or missed deadlines.

How far ahead should a services firm forecast resources?

Best-practice firms maintain a rolling six-month forecast, updated weekly. Most firms forecast only four to eight weeks ahead. The RMI survey found that 50% of professional services organizations cannot forecast beyond two months, which limits their ability to hire proactively or redistribute work.

Why do services firms still use spreadsheets for resource forecasting?

Spreadsheets feel familiar and flexible. At small scale, they work. But as firms grow past 20 to 30 people, spreadsheets can’t keep up with the pace of change in availability, pipeline, and project timelines. They lack real-time updates, scenario modeling, and skill-level tracking, which are all required for reliable forecasting.

What is the cost of poor resource forecasting?

Poor forecasting creates bench time (paying salaries with no billable work), rushed hiring (higher costs, longer ramp-up), overcommitment (projects start understaffed), and turnover (from either boredom or burnout). For a 50-person firm, even a 5-point utilization gap can represent over $800,000 in unrealized annual revenue.

What is the difference between resource forecasting and capacity planning?

Capacity planning determines your firm’s total available capacity (how many hours your team can deliver). Resource forecasting predicts future demand and matches it against that capacity, factoring in pipeline probability, skill requirements, and timing. Capacity planning is the supply side. Resource forecasting connects supply to demand.

How Tier2 Keel Connects Pipeline to Delivery

The forecasting gap described above exists because pipeline data, project data, and resource data usually live in separate systems. Sales tracks deals in a CRM. Project managers track assignments in a spreadsheet or project tool. Finance tracks utilization after the fact.

Tier2 Keel keeps the full business lifecycle in one place. Leads and opportunities flow into the same system where projects are managed, people are assigned, time is tracked, and invoices are generated. When a deal moves to 80% probability, the delivery team can already see what skills it will require and whether those skills are available. When a project timeline shifts, resource availability updates immediately.

That means the interlock meeting starts with shared data rather than three people reading from different spreadsheets. The forecasting horizon extends because the inputs are current, not two weeks old.

See how Keel handles resource planning or book a walkthrough.

The firms that forecast well don’t have better intuition. They have better visibility. The forecast you need is hiding in information you already have, in your pipeline records and your project data. Connecting those two sources is where the work begins.