Download the editable workbook: Multi-Project Capacity Planning Template (Excel). It includes team-capacity calculations, overload warnings, project decisions and a weekly evidence log.
Multi-project planning becomes unreliable when every project has its own roadmap but the team has only one shared pool of time. The fix is not a more elaborate task list. It is a single capacity view that shows how much delivery time is actually available, where that time is allocated, and which commitment must move when demand exceeds capacity.
The multi-project capacity planning template
Use four connected views. Together they answer four different questions:
- Team capacity: How much focused delivery time is realistically available?
- Project demand: How much time does each project need during the planning period?
- Allocation: Which people and skills are assigned to each project?
- Flow guardrails: How much work may be active at the same time?
1. Team-capacity worksheet
Start with availability, not requested work. A simple planning formula is:
Planning capacity = (working hours − leave − fixed meetings − support and operational work) × chosen focus factor
The focus factor is your own planning buffer for context switching, small interruptions, and uncertainty. It is not a universal benchmark. Start with an explicit assumption, compare it with completed work, and adjust it using evidence.
| Team member | Working hours | Leave | Meetings | Support / operations | Focus factor | Planning capacity |
|---|---|---|---|---|---|---|
| Alex | 40 | 0 | 6 | 5 | 80% | 23.2 hours |
| Sam | 32 | 4 | 5 | 3 | 80% | 16 hours |
| Jordan | 40 | 0 | 8 | 8 | 75% | 18 hours |
| Team total | 112 | 4 | 19 | 16 | — | 57.2 hours |
These figures are deliberately conservative and purely illustrative. The important part is that every deduction is visible. Hidden support work and recurring meetings are still demand on the team, even when they never appear on a product roadmap.
2. Project-demand worksheet
List only work that may consume capacity during the selected period. Keep estimates at a level the team can discuss without pretending to know more than it does.
| Project | Outcome for this period | Owner | Requested capacity | Critical skill | Priority | Decision |
|---|---|---|---|---|---|---|
| Customer onboarding | Reduce manual handoffs | Alex | 24 hours | Engineering | 1 | Fund |
| Billing migration | Complete test migration | Sam | 20 hours | Data | 2 | Fund |
| Marketing site | Publish two core pages | Jordan | 18 hours | Design | 3 | Reduce scope |
| Internal dashboard | New reporting view | Alex | 12 hours | Engineering | 4 | Defer |
In this example, requested demand is 74 hours while team capacity is 57.2 hours. The table is doing its job: it exposes the conflict before the team starts. The answer is a portfolio decision, not an instruction to work faster.
3. Allocation view
Translate funded demand into a small allocation table. Keep one row per person and make the total visible.
| Team member | Project A | Project B | Project C | Unallocated buffer | Total |
|---|---|---|---|---|---|
| Alex | 16 h | 4 h | 0 h | 3.2 h | 23.2 h |
| Sam | 4 h | 12 h | 0 h | 0 h | 16 h |
| Jordan | 4 h | 4 h | 8 h | 2 h | 18 h |
Do not use the table to optimise every hour. Its purpose is to reveal overload, scarce skills, and fragile plans. If the same specialist is essential to three projects, team-level capacity may look healthy while that person remains the bottleneck.
4. Flow guardrails
Capacity allocation alone does not prevent the team from starting too much work. Add explicit work-in-progress controls, such as:
- No more than two active delivery projects per person.
- No new project starts while a blocked item can be unblocked.
- Expedited work must name the project that will lose capacity.
- Work older than the team’s normal cycle receives attention before new work is pulled.
The current Kanban Guide treats explicit control of work in progress as a core practice and describes WIP, throughput, work-item age, and cycle time as minimum flow metrics. Its practical implication is simple: start new work when capacity becomes available, not merely because another request appears.
How to run the planning meeting
- Update real availability. Enter leave, on-call duties, recurring support, and fixed meetings.
- Review the previous period. Compare planned capacity with work actually finished. Do not hide carry-over.
- Order outcomes. Decide which business outcomes matter most before discussing individual tasks.
- Fund projects in order. Allocate people and scarce skills until capacity is exhausted.
- Resolve overload explicitly. Reduce scope, move a date, change ownership, or stop work.
- Set WIP controls. Agree what can be active and how exceptions will be handled.
- Record assumptions. Note the estimates, dependencies, and planning buffer that could change the decision.
The Scrum Guide emphasises transparency, frequent inspection, adaptation, sustainable pace, and a single objective for a Sprint. You do not need to adopt Scrum to use those principles: make the plan visible, inspect it against actual delivery, and change it when evidence changes.
What to do when demand exceeds capacity
Overload is not a spreadsheet error. It is a choice that has not yet been made. Use this decision order:
- Remove work that does not change a meaningful outcome.
- Reduce scope while preserving the outcome.
- Sequence projects instead of running them simultaneously.
- Change the date or service level.
- Transfer work only when the recipient has the skill and capacity.
- Add capacity last. Hiring or contracting helps only when onboarding and coordination do not consume the expected gain.
Recurring manual work deserves its own line in the capacity model. Google’s SRE guidance on toil recommends identifying and measuring repetitive operational work before deciding how to reduce it. For a startup team, that may mean tracking support triage, manual reporting, release administration, or repeated data cleanup instead of treating those hours as unexplained variance.
Copyable blank template
Copy these column headings into a spreadsheet, database, or project tool.
Team capacity
Team member | Period | Working hours | Leave | Fixed meetings | Support/operations | Focus factor | Planning capacity | Scarce skills | Notes
Project demand
Project | Outcome | Owner | Requested capacity | Critical skill | Deadline | Priority | Dependencies | Decision
Allocation
Team member | Project | Allocated capacity | WIP limit | Start condition | Stop/review condition
Weekly evidence
Period | Planned capacity | Completed work | Carry-over | Blocked time | Unplanned work | Cycle-time note | Change for next period
Common capacity-planning mistakes
- Planning from contracted hours. A 40-hour week is not 40 hours of project delivery.
- Ignoring skill constraints. Ten available people do not equal ten interchangeable people.
- Counting partially started work as progress. More active projects can create more queues and more handoffs.
- Using estimates as commitments. Estimates are decision inputs, not guarantees.
- Filling every available hour. A plan without room for uncertainty becomes obsolete at the first interruption.
- Adding urgent work without naming the trade-off. New priority work should displace something visible.
Connect the template to your project system
The template works with a spreadsheet or any project-management platform. Tool choice comes after the decision model. If you are comparing software, use the existing guide to tools for managing multiple projects. For a broader operating model, see Startup Systems & Tools and Startup Operations & Scaling.
Frequently asked questions
Should capacity be measured in hours or story points?
Use the unit that supports the decision. Hours are useful for cross-project allocation and known calendar constraints. Relative sizing can be useful within one stable team. Avoid combining points from different teams as if they were a universal unit.
How much buffer should a startup team keep?
There is no universal percentage. Choose an explicit buffer based on interruption risk and uncertainty, then compare planned work with actual delivery. Increase it when unplanned work repeatedly displaces commitments; decrease it only when evidence supports the change.
How often should the plan be updated?
Update availability whenever leave, support duty, or a major dependency changes. Review allocation at a regular cadence—often weekly for a fast-moving startup—and avoid rewriting the plan for every small fluctuation.
Can one person work across several projects?
Yes, but make the cost visible. Multiple projects add coordination and switching. Set an explicit limit on concurrent active work and sequence tasks when one specialist becomes a bottleneck.
Next step
Build the team-capacity table first. If requested project demand exceeds the total, make one explicit portfolio decision before assigning another task. A plan becomes useful when it shows what the team will not do.

