A capacity planning template for a digital agency is a structured document, usually a spreadsheet, that compares the hours your team can deliver against the hours your projects need, week by week. It shows who is overbooked, where spare capacity sits and when demand will outrun supply. Good agency capacity planning turns that comparison into hiring, scheduling and freelancer decisions. Below, we answer the most common questions about building and using one.
What columns and metrics should a capacity template include?
A capacity template should include team member, role, skill set, contracted hours, non-billable hours, available billable hours, allocated project hours, remaining capacity and utilization rate. Together these columns show what each person can deliver and where time is already committed, so you can spot gaps before they affect delivery.
The core columns work best when kept simple:
- Team member and role: who they are and what they do.
- Skills or disciplines: writing, design, account management, QC or strategy, so you plan by capability and not just headcount.
- Contracted hours per week: the starting point for supply.
- Non-billable time: leave, public holidays, internal meetings, training and new business work.
- Allocated hours: time assigned to each client or project, ideally one column per project.
- Remaining capacity: available hours minus allocated hours, shown as a positive or negative number.
- Utilization rate: billable hours as a percentage of available hours.
Add a time axis, typically weekly for the next 8 to 12 weeks, and a notes column for confirmed versus provisional work. Colour coding for over-allocated and under-allocated people makes the sheet readable at a glance.
How do you calculate agency capacity and utilization rate?
Agency capacity is the total billable hours your team can realistically deliver in a period. Utilization rate is the share of those hours actually spent on billable work. Calculate capacity by subtracting non-billable time from contracted hours, then divide billable hours worked by that capacity figure to get utilization.
The basic formulas are:
- Available capacity = contracted hours minus leave, holidays and non-billable tasks.
- Utilization rate = (billable hours ÷ available capacity) × 100.
- Remaining capacity = available capacity minus allocated project hours.
For example, if someone works 40 contracted hours, spends 6 hours on internal meetings and admin, and has 28 hours of project work booked, their available capacity is 34 hours, their utilization is about 82 percent, and they have 6 hours spare.
Aim for a realistic target rather than 100 percent. Running people at full allocation leaves no room for revisions, sickness or late client feedback. Many agencies set different targets by role, since senior staff often carry more management and new business time than production roles.
How can a template forecast incoming project demand?
A template forecasts demand by adding a pipeline layer on top of confirmed work. List current projects, retainers and likely new business, estimate the hours each will need by discipline, then weight uncertain opportunities by their probability of winning. The result is a demand curve you can compare against your capacity.
A practical approach has three tiers:
- Confirmed: signed projects and retainers, entered at full estimated hours.
- Probable: proposals awaiting a decision, entered at a reduced percentage reflecting your usual win rate.
- Possible: early conversations or pitches, tracked but not yet counted toward the plan.
Break each project into phases and disciplines so the hours land in the right weeks. A publication plan or content programme, for instance, creates writing demand first, then editorial and QC, then design. Use your own past projects rather than guesswork to estimate hours, and update the estimates when actual time differs. Overlapping pitches and live deliveries are where forecasts matter most, because that is when capacity gaps appear.
What’s the difference between spreadsheet and software-based capacity planning?
Spreadsheet planning is flexible, cheap and quick to start but relies on manual updates. Software-based capacity planning automates allocation, syncs with timesheets and project tools, and shows real-time utilization, but costs more and takes time to set up. The right choice depends on team size, project complexity and how often plans change.
Spreadsheet-based planning
Spreadsheets suit small agencies and teams with a manageable number of projects. You control the layout, can tailor formulas to your workflow, and avoid subscription costs. The drawbacks are version control problems, formula errors, and the discipline needed to keep data current. Once several people edit the same file and projects multiply, accuracy tends to slip.
Software-based planning
Dedicated resource management and project tools pull in timesheets, leave and project budgets automatically, so forecasts reflect actual time spent. They suit growing agencies juggling many concurrent clients. The trade-offs are cost, onboarding effort and sometimes less flexibility than a custom sheet. Many agencies start with a spreadsheet and move to software once manual maintenance becomes a bottleneck.
When should an agency add freelancers to its capacity plan?
An agency should add freelancers when forecast demand exceeds available capacity, when a project needs a skill the team lacks, or when workload peaks are temporary. Freelancers suit variable demand because they extend capacity without permanent headcount, which makes them useful for both immediate briefs and planned cover.
Common triggers include:
- Overlapping deadlines: several projects landing in the same weeks.
- A missing specialism: for example, a therapy area or format your team has not delivered before.
- Planned absence: holidays, parental leave or training periods.
- A new account or pitch: demand rises before you can justify a permanent hire.
- Regular freelancers unavailable: your usual network is booked when you need support.
Build freelancers into the template as their own rows, marked as flexible capacity. For healthcare communications and MedComms agencies, relevant sector experience matters, because briefing a generalist on scientific content and compliance expectations consumes time you may not have. Planning ahead also helps, since checking availability early is easier than searching when a deadline is already close.
How often should a capacity plan be reviewed and updated?
A capacity plan should be reviewed weekly for near-term allocations and monthly for longer-range forecasting. Weekly reviews catch overbooking and shifting deadlines while there is still time to act. Monthly reviews check pipeline assumptions, utilization trends and whether hiring or freelancer needs have changed.
A simple review rhythm works well:
- Weekly: confirm the next two to four weeks, update actual hours against planned hours, and reassign work where people are over or under capacity.
- Monthly: refresh the pipeline, adjust win-rate assumptions and look 8 to 12 weeks ahead.
- Quarterly: assess utilization targets, skills gaps and whether permanent hiring or a wider freelancer bench makes sense.
Also update the plan whenever a major event occurs, such as winning a pitch, losing a client or a key team member leaving. A plan that is only revisited when problems appear is a record of the past, not a planning tool.
How Talus helps with agency capacity planning
Talus is the specialist freelance network for healthcare communications, helping MedComms and healthcare communications agencies cover the gaps a capacity plan reveals. When your template shows demand outrunning supply, you can find relevant expertise without lengthy sourcing.
- Search vetted, endorsed specialists across writing, editorial, design, account management and strategy.
- Filter by expertise, project type and therapy area to match the gap in your plan.
- Use Talus for live briefs, planned cover or ongoing support, and ask the team to help identify suitable options.
- Manage briefing, contracts, hours and invoicing in one place, reducing administrative loose ends.
- Joining is free, and agencies pay only when they engage a freelancer.
Spot the gap in your capacity plan, then close it with the right specialist. Explore the Talus network today and extend your trusted freelance bench before your next deadline pressure arrives.
Related Articles
- How do you plan capacity around holidays and team leave?
- How Can Agencies Increase Capacity Without Hiring More Permanent Staff?
- When Does It Make Sense for a MedComms Agency to Use Freelancers?
- What Should Agencies Look for in a Freelance Medical Editor?
- What Is the Best Way to Cover a Short-Term Resource Gap in a Agency?