Capacity Planning Template for Software Agencies (2026)

Quick Answer. A capacity planning template converts your team's available billable hours into a single committable number. Multiply headcount by scheduled hours by a target utilization rate, then subtract the hours already booked, and you have the real capacity you can sell for the next quarter. Below is a copy-paste template, a worked example for a five-person agency, and the three thresholds that tell you when to hire, when to raise rates, and when to decline the next project. Updated July 2026.

Most agencies do not run out of capacity all at once. They run out of it quietly, one over-promised deadline at a time, because capacity lived in someone's head instead of in a number. The symptom shows up as either a bench nobody is billing or a delivery team quietly working weekends to cover work that was sold on optimism. Both are planning failures, and both are avoidable with one spreadsheet you update every week.

What capacity actually is

Capacity is not headcount, and it is not the sum of everyone's contracted hours. It is the number of hours your team can realistically bill against client work after you subtract the meetings, the internal projects, the sales calls, the sick days, and the context-switching that no delivery week escapes. That gap between contracted hours and truly billable hours is captured in one figure: target utilization.

The equation is deliberately simple:

Available billable hours = headcount x scheduled hours x target utilization

The only input that requires judgment is utilization. A senior delivery engineer might realistically sustain 70 to 75 percent. A designer splitting time across pitches and delivery lands closer to 60 to 65 percent. A founder still selling and running the business is often 30 to 40 percent billable at best. Plan with those real numbers, not with the fantasy that everyone bills 40 hours out of 40.

A worked example: the five-person agency

Here is the calculation for a small delivery team. Every number is a weekly figure.

This agency has roughly 128 billable hours per week, or about 1,660 hours per quarter across a 13-week planning window. That single number is the ceiling. Every proposal, every change request, and every "quick favor" for an existing client draws against it. When you know the ceiling, you can size your pipeline to it instead of discovering it by burning out your team.

Utilization is also the hinge between capacity and money. The same hours planned here are the hours you divide your costs across to get your effective hourly rate, and the utilization you assume directly changes what a healthy blended rate has to be. Plan capacity and price from the same utilization figure, or the two documents will quietly contradict each other.

The template (copy-paste)

Paste this into a sheet or a Markdown doc and fill the top block. The formulas are written in plain arithmetic so they port to any tool.

# Capacity Plan, Q_ 2026

## 1. Team capacity (weekly)
| Person | Role | Scheduled hrs | Target util % | Billable hrs |
|--------|------|---------------|---------------|--------------|
|        |      | 40            | 70%           | =sched*util  |
|        |      | 40            | 70%           | =sched*util  |
| TOTAL  |      |               |               | =SUM         |

Weekly billable capacity = SUM(Billable hrs)
Quarterly capacity      = Weekly capacity x 13

## 2. Committed hours (this quarter)
| Client / project | Hrs committed | End date |
|------------------|---------------|----------|
|                  |               |          |
Total committed   = SUM(Hrs committed)

## 3. Remaining capacity
Remaining hours   = Quarterly capacity - Total committed
Remaining %       = Remaining hours / Quarterly capacity

## 4. Signals
Team utilization  = Committed (this week) / Weekly capacity
Bench %           = 1 - Team utilization

The value of the template is not the arithmetic. It is that it forces you to write down committed hours before you sign the next contract, which is exactly the moment most agencies skip.

Reading the number: three thresholds

A capacity plan is only useful if it changes a decision. Three thresholds do most of the work:

• Utilization runs above target for three-plus weeks straight. You are not efficient, you are overbooked. This is the earliest and cleanest signal to raise rates on new work or add a hire, before quality slips and before your team decides the fix is to leave.
• Remaining quarterly capacity drops below 15 percent. Stop selling net-new delivery and protect the commitments you already have. Discounting to squeeze in one more project at this point trades a small revenue bump for a large delivery risk.
• Bench sits above 25 percent for two-plus weeks. You have real idle capacity. Sell it or reallocate people to productized work, but resist the reflex to discount hard just to fill it. A cut rate is much easier to give than to take back, and it resets the client's anchor for every future project.

Where AI-assisted delivery changes the math

Faster build tooling has genuinely moved this equation in 2026. When a team ships a working feature in hours that used to take days, the hours-per-deliverable falls, which raises effective capacity without adding headcount. That is real, and it is worth planning around.

The honest caveat is that the saved hours do not disappear evenly. AI-assisted builds shift the mix toward specification, review, and QA time, so your utilization assumptions should be re-measured, not assumed to hold. Track actual billable hours against plan with a resource tool such as Float, and lean on the utilization and profitability framing that Parakeeto has documented for agency operators. Recompute your utilization targets once a quarter from real timesheet data rather than trusting last year's percentages. The agencies that treat the AI-driven speedup as a reason to sell more carefully, not just more, are the ones keeping the margin. For the packaging side of that decision, our rate-card benchmarks by agency archetype show where the freed capacity is best repriced.

Action checklist

1. Build the team-capacity table with real, role-specific utilization targets, not 100 percent.
2. Multiply by 13 to get quarterly capacity, and treat that as a hard ceiling.
3. Log every committed project's hours before it starts, not after.
4. Recompute remaining capacity and bench weekly, on the same day, every week.
5. Wire the three thresholds to a decision: hire, hold, or reallocate.
6. Re-measure utilization from timesheets each quarter, especially if AI tooling changed your delivery speed.

If you take one thing from this: Capacity is a number you recompute every week, not a feeling you have on Friday. The agencies that stay profitable size the pipeline to the number, not the number to the pipeline.