Free Resource and Capacity Planning Template
A plan for setting up resource and capacity planning and running its first month: work out the hours your people really have, list the work that needs them by role, compare the two, resolve the clashes with the project owners, then review it every month. Thirteen tasks, five milestones, and a method that works in a spreadsheet.
No credit card. Opens as a real project on the Free plan.
The spreadsheet is a 13-task plan with phases, durations and milestones, ready for Excel or Google Sheets. It carries no dates, so set your own start, or paste it into the Gantt chart generator to have the schedule built for you. Want to compare the plans side by side first? Every one of them is on the project plan template page, with the rows shown before you download.
The Microsoft Project file (.xml) is the same plan with its dates worked out: every task is scheduled from Monday 4 January 2027. Open it in Microsoft Project, or open it free in Onplana Schedule, the desktop app that edits Project files without Microsoft Project.
What’s inside
All 13 tasks are below, in four phases, each with its description, duration and priority. The first three phases set the plan up once; the fourth is the monthly review you repeat.
13
Scheduled tasks
4
Phases
5
Milestones
~7
Weeks end to end
Capacity planning is a comparison, done again every month
Resource and capacity planning comes down to one comparison: the hours your people have, by role and by period, against the hours the work needs. Everything in this template serves that comparison. The first phase works out supply honestly: each person's weekly hours minus leave, public holidays and the time that goes to running the business, which is usually 20 to 30 percent and is the figure most plans forget. The planning unit and horizon are agreed up front, weeks or months, three to six months ahead for most teams.
The second phase lists demand: every project and the hours it needs from each role in each period, plus the work that is not a project at all, such as support, maintenance and recruiting. Then the two are compared. Where a role is over capacity in a period, the plan offers four ways out, in the order to try them: move dates, change who does the work, cut scope, or bring in help. Each one is agreed with the owner of the project it affects, because a capacity plan that only the resource manager believes in does not change anything.
The last phase is the habit that keeps it true. After a month working to the plan, the first monthly review updates actual hours, re-forecasts the next periods and decides new requests against the room the sheet shows. In a spreadsheet that review is manual. When it outgrows the file, the resource management page shows how Onplana tracks each person's weekly hours against their work across projects, and which plans include it.
The plan, phase by phase
Know Your Capacity3 tasks
List the people and their roles
Everyone whose time the plan covers, with one main role each, such as developer, analyst or designer.
Record each person's available hours
Weekly hours minus leave, holidays and the time that goes to running the business, usually 20 to 30 percent.
Agree the planning unit and horizon
Weeks or months, hours or days, and how far ahead: three to six months for most teams.
Know Your Demand3 tasks
List every project and the roles it needs
All active and approved projects, with the roles each needs and when, from the project owners.
Estimate the hours per role and period
Ranges are fine: a confident estimate for the next month, a rough one beyond it.
Add the work that is not a project
Support, maintenance, recruiting and other regular work, so it stops being invisible in the plan.
Compare and Resolve3 tasks
Compare demand with capacity by role and period
One table per role: hours needed against hours available, period by period, with the gaps marked.
Resolve the over-allocations
Move dates, change who does the work, cut scope or bring in help, in that order, with the project owners.
Agree the capacity plan with the project owners
Each owner accepts the dates and people their project gets, and the plan becomes the one everyone works to.
Review Every Month4 tasks
Work to the plan for the first month
Record actual hours as you go, by person and project, so the review compares the plan with what happened.
Hold the first monthly capacity review
The plan against actual hours, role by role, with the project owners in the room.
Update the actuals and re-forecast
Roll the horizon forward a month and update the estimates with what the last month taught you.
Decide new requests against the room you have
New work is accepted for the periods where the plan shows capacity, or something else moves to make room.
Milestones
Five milestones: capacity known, demand known, the capacity plan agreed, the first monthly review held and the next periods re-forecast. From then on the review is a monthly date in the calendar.
Capacity known
Day 6 of the plan
Demand known
Day 16 of the plan
Capacity plan agreed
Day 22 of the plan
First monthly review held
Day 43 of the plan
Next periods re-forecast
Day 46 of the plan
Frequently asked
What is in the download?
A CSV file with the 13 tasks of setting up and running the plan, each with its phase, duration in days, priority and notes, and the five milestones as zero-day rows. Excel opens it directly and Google Sheets imports it. The capacity tables themselves, people by period, are a second sheet you build in the first phase.
What is the difference between resource planning and capacity planning?
Capacity planning asks whether you have enough hours of each role for the work ahead. Resource planning goes one step further and decides which person does which work. This template does both: the comparison by role is capacity planning, and resolving the clashes with named people is resource planning.
How much of someone's week should I plan?
Rarely more than 70 to 80 percent. Meetings, email, support and the rest of running the business take the remainder, and a plan that books people at 100 percent is over capacity on its first day. Measure the real figure in the first monthly review and use it from then on.
How often should the plan be reviewed?
Monthly for most teams, with the horizon rolled forward each time. Weekly is too often for anything but a small team on short work, and quarterly lets an over-allocation run for weeks before anyone sees it.
Start with the plan already built
Open the Resource and Capacity Planning template free and your phases, tasks, and milestones are scheduled before the kickoff meeting. No credit card, no time limit.