A team capacity planning template compares each person's available hours with the work already committed to them, week by week. Available hours are the hours they work, less leave and holidays. Committed hours are the estimates on their open tasks and bookings. The gap shows who has room for the next job and who is already over.
Key takeaways
- Capacity is hours, not headcount. Two people can carry very different loads, and a person on leave carries none.
- The formula is simple: available hours minus committed hours. The hard part is having honest estimates on the work.
- Plan four weeks ahead, not one. A job that fits this week can collide with a colleague's leave in week three.
- Never plan at 100%. Leave room for meetings, interruptions and the job nobody saw coming.
- Tasks with no estimate are the weak point. If a task has no hours, your capacity figure is a guess.
What is team capacity planning?
Capacity planning is the process of working out how much capacity an organisation needs to keep up with demand; on the workforce side, it includes making sure there are enough properly trained people to run the business. For a small team, it comes down to one question: can we take this job on, and who should do it?
Consider Kemi, who runs a six-person design and print studio in Lagos. A client asks for a rebrand to start Monday. Kemi says yes, because the team "seems quiet". Three weeks later two designers are working until 10 pm, a printing job is late and a client is cross. The team was not quiet. Nobody had added up the hours.
A capacity plan is how you add them up before you say yes.
What goes into a team capacity planning template?
Every capacity plan has five parts. Put them in a spreadsheet, one row per person and one column per week.
| Part | What it means | Where it comes from |
|---|---|---|
| Weekly hours | Hours the person works in a normal week | Contract or agreement, such as 40 |
| Time off | Leave, sickness, training and public holidays in that week | Your leave record and the holiday calendar |
| Focus factor | The share of working hours that goes on planned work | Your judgement, often 70% to 85% |
| Available hours | Weekly hours, less time off, times the focus factor | Calculated |
| Committed hours | Estimated hours on open tasks and bookings due that week | Your task list and diary |
The focus factor is our own rule of thumb, not a published standard. It allows for meetings, messages and the small jobs that always arrive. Start at 80% and adjust after a month, when you can see how much of the week really went on planned work.
The formula, per person, per week:
Available = (weekly hours − time off) × focus factor
Room = available − committed
A positive number is room. A negative one is over capacity.
A worked example: Kemi's studio, one week in December
Hours are invented for the example. It is the week of 14 December, with a focus factor of 80% and a normal week of 40 hours.
| Person | Role | Weekly hours | Time off | Available (× 80%) | Committed | Room |
|---|---|---|---|---|---|---|
| Tolu | Senior designer | 40 | 0 | 32 | 38 | −6 |
| Amaka | Designer | 40 | 8 (one day) | 25.6 | 20 | +5.6 |
| Seyi | Designer | 40 | 0 | 32 | 30 | +2 |
| Bola | Print production | 40 | 0 | 32 | 26 | +6 |
| Emeka | Account manager | 40 | 0 | 32 | 28 | +4 |
| Hauwa | Part-time admin | 20 | 0 | 16 | 10 | +6 |
Read the table, not the average. Tolu is six hours over, which a team average of "a bit busy" would hide. Bola has six hours spare, but is she the right person for design work? That is the second half of capacity planning: room is not the same as fit. Match the next job to someone who both has the hours and has the skill.
Do the sum for the rebrand. Kemi estimates 50 design hours over three weeks. Amaka has 5.6 hours of room this week and Seyi has 2, so the first week can take about 8 hours of design, not 17. She tells the client the work starts with a discovery week, and does not say "Monday" and hope.
How far ahead should you plan capacity?
Four weeks is a good horizon for a small team. One week is too short to act on, and three months is too far to estimate.
| Horizon | Use it for | How accurate |
|---|---|---|
| This week | Rebalancing today's work | High |
| Next week | Moving jobs, booking cover | Good |
| Weeks 3 and 4 | Spotting leave clashes, deciding whether to say yes | Rough |
| Beyond a month | Hiring decisions, with the trend rather than the week | Directional |
December deserves its own look in Nigeria. Many people take leave around Christmas, and Christmas Day falls on a Friday in 2026. Public holidays are announced by the Federal Government and some are set by the lunar calendar, so check the official announcement each year and enter the days in your plan rather than relying on a list from last year. Do the same for your state's holidays if they differ.



