By Ryan Kramer, founder of Wisegrid. Last updated November 2026.
A capacity planning template compares each person’s available hours with the hours their project work needs, week by week, so you can see who is overloaded and who has room before a deadline slips. For an engineering team, it is one row per engineer, a few weeks of columns, and a utilization percentage that turns red above 100%.
The math is simple. The hard part is keeping the plan current, because capacity spreadsheets go stale the week after someone builds them. This guide gives you the formulas, the template columns, a worked example for a six-person engineering team, a 15-minute weekly review, and the mistakes that break capacity plans. It also shows how capacity planning fits with utilization and staffing plans.
Key takeaways
– Capacity planning needs two numbers per person per week: available hours and allocated hours.
– Nobody has 40 plannable hours. Plan at 70% to 80% of nominal hours for engineers, and less for principals.
– Utilization over 100% is a late deliverable that nobody has admitted yet.
– Plan per person, not per team. A healthy team average can hide one engineer at 129%.
– Staleness is the main risk. If hours are typed in twice, the plan loses.
What is capacity planning for an engineering team?
Capacity planning for an engineering team answers three questions every week: how many productive hours does each person have, how many hours of project work are booked to them, and where do the two collide? It covers the next four to six weeks in detail, which is the window where you can still move work, dates or people.
It is the week-by-week part of a bigger picture. A staffing plan decides whether the firm has enough people in each role over the next quarter. Capacity planning decides who does what in the next month. Utilization rate looks back and tells you how much of last month was billable.
How do you calculate capacity?
You calculate capacity by taking each person’s nominal hours, subtracting time off, and multiplying by a focus factor: the share of the week they can realistically spend on planned project work. The rest goes to email, meetings, proposals, training and questions from colleagues.
- Available hours = (nominal hours − time off) × focus factor. A full-time engineer at 0.75 has 30 plannable hours; with a day off, 24.
- Allocated hours = the hours of project tasks booked to that person in that week.
- Utilization = allocated hours ÷ available hours.
Focus factors of 0.7 to 0.8 suit most engineers and drafters, and 0.5 or lower suits principals and project managers who spend much of the week on clients and management. For part-time staff, start from their contracted hours; our guide to full-time equivalents (FTE) explains how. Read the result like this:
| Utilization | What it means | What to do |
|---|---|---|
| Under 60% | Under-allocated | Pull work forward or reassign |
| 60% to 85% | Healthy | Leave room for surprises |
| 85% to 100% | Fully loaded | Watch for slips |
| Over 100% | Overloaded | Move work or move dates |
The capacity planning template
The template is one row per person and one block of columns per week. Repeat the weekly block for four to six weeks. Beyond that, plan monthly in person-weeks, because task estimates are too rough to plan hour by hour.
| Column | What it holds |
|---|---|
| Person | Name of the engineer or drafter |
| Role | Senior engineer, project engineer, drafter |
| Nominal hours | Contracted hours per week, such as 40 |
| Focus factor | 0.5 to 0.8, set once per person |
| Time off | Vacation, holidays, training that week |
| Available | (Nominal − time off) × focus |
| One column per project | Hours booked to that project |
| Allocated | Sum of the project columns |
| Utilization | Allocated ÷ available |
| Status | Under, OK, Full or Over |
Wisegrid’s free capacity planning template has these columns ready, and the resource planning template adds the project-by-project bookings behind them.
Capacity planning example: a six-person engineering team
A six-person structural engineering team plans next week. First, available hours. J. Ortiz has one day of vacation, and L. Novak works three days a week.
| Person and role | Nominal | Focus | Time off | Available |
|---|---|---|---|---|
| A. Rivera, principal | 40 | 0.5 | 0 | 20 |
| M. Chen, senior engineer | 40 | 0.75 | 0 | 30 |
| J. Ortiz, project engineer | 40 | 0.75 | 8 | 24 |
| R. Brooks, project engineer | 40 | 0.75 | 0 | 30 |
| S. Kim, drafter | 40 | 0.8 | 0 | 32 |
| L. Novak, drafter | 24 | 0.75 | 0 | 18 |
| Total | 224 | 8 | 154 |
Next, the hours booked to each person across three projects: a bridge deck, a school addition and a warehouse. Bold rows need action this week.
| Person | Available | Allocated | Utilization | Status |
|---|---|---|---|---|
| A. Rivera | 20 | 14 | 70% | OK |
| M. Chen | 30 | 27 | 90% | Full |
| J. Ortiz | 24 | 31 | 129% | Over |
| R. Brooks | 30 | 17 | 57% | Under |
| S. Kim | 32 | 30 | 94% | Full |
| L. Novak | 18 | 12 | 67% | OK |
| Total | 154 | 131 | 85% |
What this tells you: the team as a whole is at 85%, which looks fine. But J. Ortiz is booked for 31 hours in a four-day week, while R. Brooks, in the same role, has 13 hours free. Moving 8 hours of bridge deck calculations from Ortiz to Brooks puts Ortiz at 96% (23 of 24) and Brooks at 83% (25 of 30). The team total does not change; the risk of a late deliverable does.
Watch: Capacity Planning in 2 Minutes (2 minutes)
Watch “Capacity Planning in 2 Minutes” on YouTube →
How to run a weekly capacity review
A capacity plan only works if someone looks at it every week. Keep the review to 15 minutes with the project managers:
- Update time off first. Vacation, holidays and training change available hours more than anything else.
- Look four weeks ahead, not just next week. Overloads you see three weeks out are easy to fix.
- Resolve every Over cell. Move work to someone with room, move a date with the client, or record it as an accepted risk in the project’s RAID log.
- Ask about anyone under 60% for weeks in a row. It often means hidden work that is not booked, or estimates that are too high.
- Compare last week’s plan with actual hours from the timesheet template. If someone always works more than planned, their estimates or focus factor need adjusting.
- Recalibrate focus factors every quarter, using the gap between planned and actual hours.
How do capacity, utilization and staffing fit together?
They answer the same question over different time frames. Capacity planning looks one to six weeks ahead, person by person. A staffing plan looks three to six months ahead, role by role, and decides whether to hire. Utilization looks back at what share of last month’s hours was billable.
One difference trips people up: capacity utilization counts all booked project hours against focus-adjusted hours, while billable utilization counts billable hours against all available hours. An engineer can be at 100% capacity and 75% billable in the same week. Use the utilization rate calculator for the billable view, and compare booked hours with each project’s fee in your budget vs actual report.
Common capacity planning mistakes
- Planning at 100% of nominal hours. Every plan looks fine and every week runs late.
- Ignoring meetings, proposals and support. They are real hours, so give them a column or lower the focus factor.
- Using team totals. As the example shows, 85% for the team can hide 129% for one person.
- One-off snapshots. A plan built once for a crisis and never updated is wrong within two weeks.
- Booking hours with no link to the schedule. If the project dates move in the Gantt chart but not in the capacity plan, the plan is fiction.
- Double data entry. When hours are typed into the schedule and again into the capacity sheet, the second copy is always behind.
From spreadsheet to a plan that updates itself
Capacity plans usually live in a spreadsheet owned by one person, who copies hours in from each project manager’s schedule. It works for a few weeks. Then a project slips, nobody updates the copy, and the plan shows someone as free when they are not. Emailing versions around makes it worse, as we explain in why spreadsheet edits disappear.
In Wisegrid, the capacity plan reads from the project sheets themselves. Resource heatmaps add up booked hours by person and week across up to 30 sheets, compare them with availability, and flag anyone over capacity. Project managers can view the summary for free, and when a task moves, the plan moves with it. It is still a grid, so the columns and formulas above work as written. Start from the capacity planning template, and report the result to principals with the executive project status report template.
FAQ
What is the difference between capacity planning and resource planning?
Resource planning is the broad job of deciding which people, equipment and budget go to which projects. Capacity planning is its numerical core: comparing each person’s available hours with the hours booked to them, week by week. Most engineering firms do resource planning in meetings and capacity planning in a sheet.
What utilization should an engineering team plan for?
Aim for 60% to 85% of focus-adjusted available hours for most weeks. That leaves room for client calls, design changes and reviews that were never booked. Short periods at 90% to 100% are normal before a deadline; weeks above 100% mean something will be late or done in unpaid overtime.
How far ahead should we plan capacity?
Plan four to six weeks in detail, by person and week. Beyond that, plan monthly by role, because task estimates are too uncertain. The longer view belongs in your staffing plan, where you decide whether to hire, bring in contractors or move dates on new work.
How do I estimate demand without detailed hour estimates?
Use size buckets. Call a small task 4 hours, a medium task 8 hours and a large task 16 hours, and book each task to a person and week. After a month, compare the buckets with timesheet hours and adjust. It is rough, but far better than no plan at all.
Why does someone at 100% capacity have a lower billable utilization?
Because the two use different denominators. Capacity utilization divides booked project hours by focus-adjusted hours, so it already leaves out meetings and admin. Billable utilization divides billable hours by all available hours. A fully booked engineer at a 0.75 focus factor, on billable work only, bills about 75% of their available time.
See who is overloaded before the deadline does
Keep projects, timesheets and the capacity plan in one Wisegrid workspace, and share it with project managers for free. Start with the capacity planning template, the resource planning template and the timesheet template.
Start free → · Staffing plan guide → · Utilization calculator →
About the author Ryan Kramer is the founder of Wisegrid, a higher-capacity work management grid built around a 1,000,000-cell-per-sheet limit, date-triggered automations with run history, and cross-sheet reporting. He writes about the project management documents teams actually keep updated. More from Ryan →