Projects template

Resource Capacity Planning Template

See who is over- or under-allocated across the weeks ahead before you commit to a deadline — no more surprise bottlenecks.

Use this template free →
Opens in your browser with sample data · export to Excel any time · your data stays yours

Prefer the spreadsheet? Attendance & Absence Template · Capacity Planning Template · Erlang C Contact-Centre Staffing · Resource Levelling & Over-Allocation · Shift Rota Coverage & Fairness · Timesheet & Utilisation Template · Utilisation & Rate Card · Class Schedule & Utilisation Template · Headcount Plan & Attrition Forecast · Skills Matrix & Training Gap · Clinic Utilisation & DNA Template · Labour Scheduling vs Covers Template · Warehouse Pick Productivity Template · Void & Letting Performance Template — free with an account, 3 free downloads.

See inside before you download: Attendance & Absence Template · Capacity Planning Template · Erlang C Contact-Centre Staffing · Resource Levelling & Over-Allocation · Shift Rota Coverage & Fairness · Timesheet & Utilisation Template · Utilisation & Rate Card · Class Schedule & Utilisation Template · Headcount Plan & Attrition Forecast · Skills Matrix & Training Gap · Clinic Utilisation & DNA Template · Labour Scheduling vs Covers Template · Warehouse Pick Productivity Template · Void & Letting Performance Template

capacity-planning · sample dataLive
120%
Chen
95%
Patel
70%
Silva
110%
Okoro
60%
Diaz
Utilisation %

What's inside this template

Utilisation by personInstantly spot who’s over 100%.
Week-by-week viewPlan the weeks ahead, not just today.
Overload flagsBottlenecks surface before they bite.
Rebalance easilyMove work and watch load level out.

How it works

Open the template

It loads with realistic sample data so you see a finished result immediately — nothing to set up.

Swap in your data

Type over the sample values, or upload your own file and map the columns in a couple of clicks.

Read, export, share

The planner recalculates instantly. Export to Excel or send a live link.

Related templates

Common questions

How do I work out who's over-allocated?

Sum committed hours per person per week and compare against their available hours. Anyone over 100% is over-allocated on paper, and in practice anything over about 80% leaves no room for the unplanned work that always arrives.

Should I plan to 100% utilisation?

No. Teams planned to full utilisation have no slack for sickness, support or estimation error, so the first surprise pushes every deadline. 70–85% is the range most teams can actually sustain.

Can it handle part-time and shared people?

Yes — available hours is a per-person, per-week number, so a three-day-a-week person or someone split across two projects is just a smaller figure in that column.

Start from the Resource capacity planner template

Open it with sample data, swap in your own, and export in seconds — no formulas, no blank page.

Use this template free →
No card required · works in your browser · export any time