free capacity planning template is a key topic in modern project management and teamwork. Every project manager knows the moment: the team has agreed to a deadline, and only then does someone ask “but who is actually free that week?” The answer is usually a shrug, because availability lives in a calendar, a timesheet, and two people’s heads — nowhere that matches the project’s required hours. Capacity planning exists to close that gap, and a capacity planning template is the fastest way to start doing it without building everything from scratch.
This article gives you a complete, copy-paste-ready capacity planning template with every field explained, a worked example with real hours and utilization numbers, the strategies that shape how you use it, where to find free templates, and the mistakes that make capacity plans wrong.
Quick Answer: What Is a Capacity Planning Template?
A capacity planning template is a reusable spreadsheet or document that compares the hours your projects require (demand) with the hours your team can actually deliver (capacity) over a given period, so you can spot gaps before they become missed deadlines or burnout. It typically lists tasks with estimated durations, the people assigned, each person’s available hours, and the resulting utilization percentage.
The nuance: capacity planning is not the same as resource planning or workload management. Capacity planning asks “can the team deliver this much work?” — it compares available hours to required hours. Workload management asks “is anyone over-loaded right now?” Capacity is the forecast; workload is the current state.
What Sections Should a Capacity Planning Template Include?
A complete capacity planning template answers three questions: what work needs to be done, how many hours it requires, and how many hours the team has available. The template below follows that logic in nine blocks.
Join Doitify Today
Move projects forward without the chaos: all your tasks, progress, and team reports in one unified workspace. Built for companies, startups, and remote teams — with a quick setup and a free trial.
1. General project information
Project name, project manager, department, and the start and end dates of the planning period. As with any reusable template, the header matters when you archive plans and compare them later.
2. Task list
Every task in the project scope. You can keep this brief in the capacity template — the point is the hours, not the task detail. If you have a full work breakdown structure, reference it here.
3. Task estimated duration
How long each task will take, in hours (or days, if that is more natural for your team). Estimates come from experience with similar tasks; if you have timesheet history, use the actuals from the last comparable project.
4. Start and end dates
When each task begins and when it must finish. The dates let the template place hours on the calendar so you can see load by week or month.
5. Resource list
The people available to work in the period, plus their roles and skills. In a team capacity template, this includes everyone who might be pulled into the project.
6. Hourly rates
What each person costs per hour. Rates matter even for internal staff — they turn the capacity gap into a dollar figure, which is how you argue for a contractor or a deadline change with finance.
7. Availability
Each person’s total capacity in the period: working days × hours per day, minus holidays, PTO, meetings, and time already committed to other projects. A common starting point is 5 days × 8 hours = 40 hours per week, or about 160 hours per month, before subtracting everything else.
8. Utilization
Required hours ÷ available hours, as a percentage. This is the number that tells you who is over, under, or exactly at capacity. A sustainable planning target is usually 75–85% of available time; above ~100% is overload.
9. Cost summary
Required hours × hourly rates for the people involved, plus any contractor hours you plan to add. This connects capacity planning to the project budget.
The Free Capacity Planning Template (Copy-Paste Ready)
Copy the structure below into Excel, Google Sheets, Word, Notion, or your project management tool and fill in every bracket.
General Information
- Project name: ____
- Project manager: ____
- Department: ____
- Planning period: ____ (e.g., 4 weeks starting ____)
Tasks and Required Hours
| Task | Estimated duration (hours) | Start date | End date | Assigned to |
|---|---|---|---|---|
| ____ | __ | ____ | ____ | ____ |
Resources and Availability
| Team member | Role | Hourly rate | Working days in period | Available hours | Required hours | Utilization % |
|---|---|---|---|---|---|---|
| ____ | ____ | $____ | ____ | __ | __ | __% |
Capacity Gap Summary
- Total required hours: ____
- Total available hours: ____
- Surplus (+) or gap (−): ____ hours
- Cost of required hours: $____
- Plan if gap: add contractor / reprioritize / push timeline (circle one) + note: ____
Review Cadence
- Owner of this plan: ____
- Review date(s): ____ (e.g., weekly, every Monday 9:00)
- Strategy in use: lead / lag / match / adjustment (circle one)
Filled-In Example: A Capacity Plan With Real Numbers
To show the template working, here is a condensed example — a software team of 4 planning one month (4 weeks, 20 working days per person, 8 hours/day).
- Project info: “Mobile app v2 release,” PM: Dana, period: May 1–May 28.
- Tasks and hours: API work 80h, UI build 60h, integration 40h, QA 30h, release prep 20h → 230 required hours total.
- Resources and availability: Dana (PM, $60/h) 160h available; Marco (dev, $70/h) 160h; Priya (designer, $55/h) 160h; Lena (QA, $50/h) 160h → 640 available hours before deductions.
- Reality check (availability): each person subtracts ~15% for meetings, admin, and other commitments → effective availability ≈ 136h each, 544h total.
- Assignments: API 80h → Marco; UI 60h → Priya; integration 40h → Marco; QA 30h → Lena; release 20h → Dana.
- Utilization per person: Marco = 120h required / 136h available = 88%; Priya = 60/136 = 44%; Lena = 30/136 = 22%; Dana = 20/136 = 15%.
- Gap read: Marco is nearly at capacity and takes most of the load, while Lena has room. The PM rebalances 15h of QA to Lena’s earlier availability and asks Marco to confirm he can absorb 120h alongside his support rotation — or the release slips.
This example shows why the utilization column is the heart of the template: without it, the imbalance between Marco at 88% and everyone else under 50% would stay invisible until Marco burns out.
Which Capacity Planning Strategy Should Your Template Support?
The same template can support different planning strategies. Pick the one that matches how predictable your demand is:
| Strategy | How it works | Best for | Trade-off |
|---|---|---|---|
| Lead | Add capacity (hire, cross-train, contract) before demand rises | Predictable spikes — seasonal retail, annual launches | Costs money before revenue arrives; wastes capacity if forecast is wrong |
| Lag | Add capacity only after real demand appears | Low-cost ops where delays are acceptable | Can strain the team when demand surges suddenly |
| Match | Add capacity in small steps as demand grows | Steady-growth businesses | Requires frequent re-planning and close monitoring |
| Adjustment | Continuously monitor demand and tune capacity in real time | Fast-moving, unpredictable environments | Demands a live view of workload, not a static sheet |
The template itself works for all four — the difference is how often you update it and which fields you emphasize. A lead-strategy team forecasts demand heavily and updates the availability column rarely; an adjustment-strategy team updates both every week.
Where Can You Find Free Capacity Planning Templates?
You do not need to build from scratch. Several reputable sources offer free, ready-to-use capacity planning templates:
- ProjectManager — a free capacity planning template for Excel with project info, task durations, resource hourly rates, a week-by-week timeline, resource availability, utilization, over/under allocation, and costs per resource. Pros: purpose-built for capacity, auto-calculates utilization. Cons: static spreadsheet; manual updates, no live connection to task progress.
- Asana — a free capacity planning template that opens as a live project, comparing required hours to available hours with custom fields and automatic hour totals. Pros: real-time, connects to task ownership and due dates. Cons: lives inside Asana’s model; account required; the hourly math depends on how you set up custom fields.
- Smartsheet — a template gallery with capacity and resource planning sheets in a spreadsheet-like grid. Pros: familiar, formula-friendly, good for teams already on Smartsheet. Cons: automation depth mostly sits behind paid plans.
- Vertex42 — free Excel templates including gantt charts, timesheets, and project management sheets you can adapt into a capacity view. Pros: genuinely free, no account. Cons: generic — you build the capacity logic and utilization formulas yourself.
- Microsoft Create — free Excel/Google Sheets planners, schedules, and trackers. Pros: universal and free. Cons: generic; no capacity-specific structure, so you adapt it.
- ClickUp — workload and capacity views inside a full work-management platform. Pros: combines capacity with task execution. Cons: richer features need paid plans.
Trade-off to remember: spreadsheet templates are free and universal but static — availability drifts as people book holidays and join other projects. Tool-native templates (Asana, ClickUp, ProjectManager) stay live because the capacity view reads from the actual task assignments, but they lock you into the tool’s model. Choose based on how often your capacity picture changes.
Real Scenarios: Capacity Planning in Practice
Scenario 1: A SaaS team checks if a launch is feasible (numbers)
A SaaS startup plans to ship a major release in 6 weeks. The template shows the 5-person team has 5 people × 240 hours = 1,200 available hours in the period (after 20% meeting/admin deduction). The task list totals 1,340 required hours. The gap is 140 hours — about one person-week. Before the template, the team would have discovered the shortfall in week 4. Instead, they add 140 contractor hours at $65/h ($9,100) into the plan, and the release keeps its date. The cost view made the decision concrete rather than emotional.
Scenario 2: A marketing team rebalances a campaign (numbers)
A marketing lead plans a 4-week campaign with a 3-person team. Utilization shows: designer 95%, writer 60%, coordinator 30%. The designer is the bottleneck. The lead moves the landing-page copy (which needs the writer) earlier, pushes two design variants to week 3, and shifts the designer’s non-campaign tasks to the coordinator. Final plan: designer 78%, writer 72%, coordinator 55%. No new hires, no missed deadline — the template turned a single-person bottleneck into a rebalancing plan in one planning session.
Scenario 3: A PMO forecasts Q3 staffing (numbers)
A PMO runs a quarterly capacity review for 18 people across 9 projects. The Q3 template shows total required hours of 7,400 against effective available hours of 6,700 — a 700-hour shortfall, roughly 5 person-weeks. Because the review happens before the quarter, the PMO can reprioritize two lower-priority projects, ask for one contractor, and push one project’s kickoff by two weeks. The cost: one contractor for 3 weeks at $5,400, versus the estimated schedule slippage of every project in the portfolio. The template turned a vague “we’re stretched” into a specific plan with a price tag.
Scenario 4: An agency decides whether to take a new client (numbers)
A design agency of 6 reviews a potential new retainer before signing. The template shows average utilization at 82% with the current book of work; a new retainer would add 90 hours/month of demand and push utilization to 97%. The decision becomes binary: decline the retainer, hire/contract one more designer, or raise the retainer price to cover a contractor. The agency quotes a higher rate that funds a part-time contractor — the capacity template just paid for itself in one negotiation.
What Are the Common Mistakes When Using a Capacity Planning Template?
- Planning for 100% utilization. If everyone is at 100%, the first sick day, holiday, or support incident derails the plan. Plan for 75–85% of available hours and hold the buffer.
- Forgetting the deduction. “160 hours available” is fiction for most people — subtract meetings, admin, and other projects. The 15–20% deduction is not pessimism; it is realism.
- Ignoring skills. Two people at 80% utilization are not interchangeable if only one can do the work. Match required tasks to the right skills, not just to spare hours.
- Never updating the plan. Capacity changes every week — holidays get booked, scope shifts, people leave. A capacity plan reviewed monthly in a fast-moving team is already stale.
- Confusing capacity with workload. Capacity is the forecast (“can we deliver this?”). Workload is the current state (“who is loaded right now?”). Using one template for both without clear owners causes confusion.
- No dollar view. If the gap never becomes a number with a cost, you cannot argue for a contractor or a deadline change with anyone.
Know This Before You Choose
- Size the template to the planning horizon. A 4-week sprint needs a weekly view; a quarterly portfolio review needs a month-by-month summary. Pick the grain that matches how often you act on the numbers.
- Know your utilization target before you fill anything in. Decide whether your team plans to 75%, 80%, or 85% — then the template’s red flags mean something.
- The gap number is the decision, not the detail. Surplus or shortfall in hours is what you act on; the task rows exist to produce that number.
- Choose your strategy first. A lead-strategy team updates availability rarely; an adjustment-strategy team updates weekly. The template is the same — the update cadence is the difference.
- Static templates are free but fragile. If your capacity changes weekly, the cost of manual upkeep may be higher than the cost of a tool that reads from live assignments.
How Do You Run a Capacity Plan in a Project Management Platform?
A static capacity template becomes a live system the moment the hours and the task assignments are the same place. To be transparent: Doitify is our product, which is why we know its capabilities from the inside. In Doitify you can turn a project into tasks, sub-tasks, and checklists with owners, due dates, and schedules, then manage execution with Kanban boards, calendars, Gantt charts, sprints and backlogs, and resource and workload management — with work and performance reports that show how committed hours compare with availability. The Doitify Copilot can help you build the task breakdown and the plan from a stated goal. So the “free capacity planning template” from this article stops being a spreadsheet you manually update and becomes a workspace where required hours, assignments, and progress are one live thing — which is what capacity planning needs to stay honest.
FAQ
Conclusion
A free capacity planning template gives you one honest number — the gap between required hours and available hours — and everything else is detail. Fill in the tasks and their hours, subtract the reality of meetings and holidays, set a utilization target of 75–85%, and review it on a fixed cadence. Pick your strategy (lead, lag, match, or adjustment), update the plan as availability changes, and never plan for 100%. The strongest move is to run the capacity plan where the work lives — so required hours, assignments, and progress stay connected and the plan never goes stale.
Join Doitify Today
Move projects forward without the chaos: all your tasks, progress, and team reports in one unified workspace. Built for companies, startups, and remote teams — with a quick setup and a free trial.
