How to Run Agency Capacity Planning Without Spreadsheets

What capacity planning actually means for a 5-person agency

Capacity planning sounds like something enterprise companies do with dedicated ops teams and resource management software. For a 5-person agency, it's simpler: you're trying to answer one question before a client signs a contract. Do we have the hours to do this work?

The answer isn't "yes, we're not that busy right now." That's gut feel. The answer comes from actual numbers: how many billable hours can each person realistically deliver in the next six weeks, after you subtract PTO, internal meetings, sales calls, and the admin overhead that eats 20% of every week whether you plan for it or not.

Agencies that skip this step end up in one of two failure modes. They over-commit and burn out their team trying to deliver. Or they under-commit and leave revenue on the table because they assumed they were busier than they were. I've watched both happen to agencies that were otherwise well-run. Both are avoidable with a simple capacity model.

The rolling 6-week forecast: how to build one

A rolling 6-week forecast gives you enough runway to make staffing decisions without pretending you can predict the future three months out. Here's how to build one from your time tracking data.

Step 1: Pull available hours per person.

Start with working days in the period. Multiply by daily hours (typically 8). That's your theoretical maximum. Nobody delivers at 100%, so this is your ceiling, not your target.

Step 2: Subtract confirmed PTO and holidays.

If someone is out for a week, remove those hours from their capacity. Public holidays count too. This step alone prevents the most common capacity planning mistake: promising a client delivery during a week when half your team is on vacation.

Step 3: Apply your non-billable overhead rate.

Look at your time tracking data from the last 90 days. What percentage of logged hours were non-billable? Internal meetings, sales calls, admin, professional development. For most agencies, this runs between 15% and 30%. Apply that rate to get your realistic billable capacity.

Step 4: Compare to your pipeline.

Map confirmed projects and likely pipeline to the available capacity. If confirmed work already fills 80% of capacity, you have limited room for new commitments. If you're at 50%, you can take on more. Update this every two weeks, not monthly. Projects slip, clients accelerate, people get sick. A two-week cadence keeps the forecast useful.

The capacity planning calculator does this math for you. Enter your team size, working days, PTO, and overhead rate, and it outputs available billable hours by person and in aggregate.

How do you account for non-billable time?

Non-billable time is the silent capacity killer. It's real work that consumes real hours, but it doesn't show up on client invoices. Agencies that don't track it systematically end up with capacity models that are consistently optimistic.

The categories to track separately:

• Internal meetings. Team standups, project retrospectives, all-hands. These are necessary but they're not billable. A 30-minute daily standup for a 5-person team is 12.5 hours per week of non-billable time before anyone opens a client file.
• Sales and business development. Proposal writing, discovery calls, pitch decks. For most agencies, this runs 5-10% of total hours. It's an investment, but it's capacity you can't sell.
• Admin and operations. Invoicing, contracts, HR, tool management. Often underestimated because it happens in small chunks throughout the week.
• Professional development. Training, conferences, reading. If you're not budgeting time for this, your team is either doing it on their own time (unsustainable) or not doing it at all (also unsustainable).

The right approach is to track all of these in your time tracking system with explicit non-billable project codes. After 90 days, you'll have a real overhead rate based on actual behavior, not assumptions. In my experience, most agencies are surprised by how high that number is the first time they measure it. Use that rate in your capacity model.

Handling PTO and holidays without blowing your forecast

PTO is predictable if you track it. The problem is most agencies don't have a single place where PTO is visible alongside project commitments. It lives in an HR system, or a shared calendar, or someone's memory. When you're building a capacity forecast, you need it in the same view as your project hours.

The practical fix: create a non-billable project code for PTO in your time tracking system. When someone books time off, they log it there. Now your capacity reports automatically reflect it. No separate spreadsheet to maintain, no manual reconciliation.

Public holidays need the same treatment. Create a holiday calendar for each country where you have team members. A US-based designer and a UK-based developer don't share the same holidays. If you're planning capacity for a project that spans both, you need to account for that difference.

The rule of thumb: any week with more than one person on PTO or a public holiday should be flagged in your forecast as reduced capacity. Don't commit to client deliverables in those weeks unless you've explicitly verified you have enough hours.

When to hire vs use freelancers to fill capacity gaps

Capacity gaps are inevitable. The question is how to fill them. Hiring a full-time employee adds permanent capacity but takes 3-6 months to ramp up and commits you to a fixed cost regardless of pipeline. Freelancers add flexible capacity quickly but at a higher hourly rate.

The decision framework:

• Hire when the gap is structural. If you've been consistently over capacity for 3+ months and your pipeline shows no sign of slowing, you need permanent headcount. A freelancer filling a 6-month gap is more expensive than a hire who ramps up in month 2.
• Use freelancers for project-specific gaps. A client needs a skill you don't have in-house, or a project creates a temporary spike that won't repeat. Freelancers are the right tool here. You get the capacity without the long-term commitment.
• Use freelancers to test before hiring. If you're unsure whether a gap is structural, bring in a freelancer for 2-3 months. If the work keeps coming, convert to a hire. If it was a one-time spike, you haven't over-hired.

The cost comparison matters here. Use the contractor rate calculator to compare the true cost of a freelancer (hourly rate, no benefits, no ramp time) against a full-time hire (salary, benefits, equipment, onboarding time). The break-even point is usually around 60-70% utilization for the hire.

How do capacity and utilization targets connect?

Capacity planning and utilization tracking are two sides of the same coin. Capacity tells you how many hours are available. Utilization tells you how many of those hours are actually being billed. Together, they tell you whether your agency is healthy.

Most agencies target 70-80% billable utilization. Below 70%, you're leaving revenue on the table. Above 85%, you're burning out your team and leaving no room for the non-billable work that keeps the business running. The sweet spot is somewhere in between, and it varies by role: senior people who do more sales and management will naturally run lower utilization than junior people who are primarily delivery-focused.

The connection to capacity planning: if your utilization target is 75% and you have 1,000 available hours in a month, your target billable output is 750 hours. If your confirmed pipeline only fills 500 hours, you have a business development problem. If it fills 900 hours, you have a capacity problem. Both are visible when you're tracking the numbers.

For a deeper look at how utilization and realization rates connect to agency profitability, see agency profitability: utilization and realization.

Where to go next

Capacity planning is one piece of the agency operations system. If you haven't set up time tracking as the foundation, that's where to start.

← The Agency Time Tracking Guide

• Agency profitability: utilization and realization — how to turn capacity data into margin analysis
• Agency client reporting — how to report hours and progress to clients without manual work
• Capacity planning calculator — calculate available billable hours for your team