How to Calculate Capacity Planning for Service Businesses (Simple Guide)

We hit $2.3M in revenue last year. And I still couldn't answer one question: "Can we afford to hire?"

My ops lead would Slack me on Fridays: "Sarah's at 140% capacity this week. Should I push the rebrand to May?" And I'd sit there, staring at a spreadsheet I hadn't updated in three weeks, completely guessing.

That's when I learned the hard way: You can't scale what you can't see.

If you run a service business — whether that's consulting, creative work, or software delivery — capacity is your most valuable asset. But phrases like "utilization models" and "FTE curves" make capacity planning feel like something reserved for spreadsheet wizards.

It's not. Here's the simple framework I wish someone had given me years ago.

Why Capacity Planning Actually Matters

Let me translate the textbook reasons into real business pain:

When left unmanaged, capacity leaks profit just as quietly as scope creep or underpriced proposals. The difference? Capacity problems are invisible until they become emergencies.

The Two Numbers That Tell You Everything

Forget the 17-column spreadsheet. Capacity planning boils down to two numbers: supply and demand.

Supply = Your Team's Available Billable Hours

Here's the formula:

Supply = (Head count × Standard hours) − (PTO + Training + Admin) × Utilization target

Example calculation:

• 10 team members × 40 hours/week = 400 hours
• Minus 40 hours for PTO, training, and admin
• × 80% utilization target (you need buffer)
• = 288 available billable hours this week

Demand = Hours Required to Deliver Your Commitments

Demand = Active project hours + Pipeline hours (weighted) + Retainer obligations

Example calculation:

• Active projects need 220 hours this week
• Pipeline deals: 100 hours × 60% close probability = 60 hours
• Retainer work: 40 hours
• = 320 hours of demand

In this example: You're 32 hours over capacity. That's almost a full person's week. Without knowing this number, you'd find out Friday at 6pm when someone misses a deadline.

The Golden Rule

Aim for supply to exceed demand by 5-10%. That's enough buffer for surprises without leaving people on the bench.

The 30-Minute DIY Capacity Check

You can run this analysis right now with nothing but a calculator. Block 30 minutes on your calendar and do this:

Step 1: List Every Active Project (10 min)

Open your project tracker (or that spreadsheet you've been avoiding) and write down:

• Project name
• Remaining hours estimated
• Due date

Don't overthink it. Rough numbers are fine for this exercise.

Step 2: Add Your Sales Pipeline (5 min)

For each deal in your pipeline:

• Estimated hours if it closes
• Probability of closing (be honest)
• Multiply hours × probability

A 500-hour project at 30% probability = 150 hours of weighted demand.

Step 3: Calculate Available Hours (10 min)

For each team member:

• Standard hours (usually 40)
• Minus any PTO, training, or blocked time
• Multiply by your utilization target (80% is standard)

Sum it all up. That's your supply.

Step 4: Compare and Act (5 min)

If Demand > Supply:

• Shift lower-priority tasks to next cycle
• Bring in contractors for the peak
• Have the scope/timeline conversation with clients NOW (before it bites your margin)

If Supply > Demand:

• Accelerate pipeline deals (offer incentives for earlier start dates)
• Invest in training that raises future bill rates
• Loan talent to other teams or internal projects

Moving Beyond Spreadsheets

The DIY method works. I used it for two years. But here's what breaks: Manual models go stale within days. Someone logs time late, a project scope changes, a deal closes unexpectedly — and suddenly your spreadsheet is fiction.

The upgrade path has three steps:

1. Centralize time tracking so actuals feed your model automatically
2. Create a single source of truth for project budgets and milestones
3. Set up alerts when teams exceed 85-90% of their capacity

Modern operations platforms (like LetWorkFlow, Productive, or even a well-configured Airtable) can automate all three. The key is getting real-time visibility instead of weekly guesswork.

The Weekly 10-Minute Review

Consistency beats sophistication. Here's the habit that changed everything for us:

Every Friday at 3pm, I block 10 minutes to:

1. Scan the dashboard for red (over) and blue (under) indicators
2. Ask project leads one question: "Any tasks slipping or new scope that needs sign-off?"
3. Approve or deny any overtime or contractor requests for the coming week

That's it. Ten minutes. No hour-long capacity meetings. No Monday morning fire drills.

Small, regular corrections keep you off the roller coaster.

Common Myths (And Why They're Wrong)

What Good Looks Like

After implementing weekly capacity reviews, here's what changed for us:

• Overtime requests dropped 60% (we saw overload coming)
• Utilization improved from 68% to 81% (we stopped underloading senior people)
• Client satisfaction scores went up (fewer missed deadlines)
• I stopped dreading the "can we hire?" question (I finally had data)

The numbers won't be identical for you. But the pattern will be: visibility creates control, and control creates margin.

Key Takeaways

1. Capacity planning is just supply vs. demand. Two numbers. No PhD required.
2. The 30-minute DIY check works. You can do it today with a calculator and your project list.
3. Automate your data flow. Manual spreadsheets die within days. Real-time tracking keeps you honest.
4. Review weekly. 10 minutes every Friday prevents Friday night fire drills.
5. Aim for 80-85% utilization. Buffer isn't waste — it's insurance against scope changes and sick days.

Frequently Asked Questions

What is capacity planning in simple terms?

Capacity planning is comparing what your team can deliver (supply) against what you've committed to deliver (demand). If demand exceeds supply, you'll miss deadlines or burn out your team. If supply exceeds demand, you're paying for idle time. The goal is to keep them balanced with a 5-10% buffer for surprises.

How do you calculate capacity for a service business?

Use this formula: Available Hours = (Headcount × Standard Hours) − (PTO + Training + Admin) × Utilization Target. For example, 10 people × 40 hours = 400 hours, minus 40 for non-billable time, times 80% utilization = 288 available billable hours per week.

What's a healthy utilization rate for agencies?

Target 75-85% utilization. Going above 90% leaves no buffer for unexpected work, sick days, or scope changes — leading to burnout and missed deadlines. Below 70% means you're leaving money on the table with underutilized talent.

How often should I review capacity?

Weekly reviews are essential. A 10-minute Friday check prevents Monday fire drills. Monthly reviews are too slow — by the time you spot a problem, it's already cost you money or a deadline.

What's the difference between capacity planning and resource planning?

Resource planning assigns specific people to specific tasks. Capacity planning looks at the bigger picture: do we have enough total hours across the team to meet our commitments? You need both, but capacity planning comes first.