Free Tool
Capacity Planning Calculator
Enter each person's available hours and the hours already booked for the next six weeks. See who is overbooked, who has room, and what the team total hides.
Your team
The example team is filled in so you can see how it works. Replace it with your own people. Week 1 is the coming week. Nothing you enter leaves your browser.
| Name or role | Available hrs/wk | Billable target % | Wk 1 booked | Wk 2 booked | Wk 3 booked | Wk 4 booked | Wk 5 booked | Wk 6 booked | Remove |
|---|---|---|---|---|---|---|---|---|---|
Load by person and week
Load is booked hours as a share of available hours. Overbooked means more than 100% of available. Over target means past the billable target but still under available. Underbooked means under 60% of the billable target.
| Person | Target hrs/wk | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | 6 week avg |
|---|---|---|---|---|---|---|---|---|
| Senior designer | 28 | 102%Overbooked | 95%Over target | 85%Over target | 75%Over target | 65%On target | 50%On target | 79% |
| Junior designer | 30 | 30%Underbooked | 35%Underbooked | 45%On target | 55%On target | 60%On target | 40%Underbooked | 44% |
| Developer | 28 | 65%On target | 70%On target | 75%Over target | 60%On target | 50%On target | 30%Underbooked | 58% |
| Strategist | 20 | 55%Over target | 45%On target | 50%On target | 40%On target | 35%On target | 25%Underbooked | 42% |
| Team total | 106 | 63%101 / 160 hrs1 over | 61%98 / 160 hrs | 64%102 / 160 hrs | 57%92 / 160 hrs | 53%84 / 160 hrs | 36%58 / 160 hrs | 56% |
How the numbers work
- Available hours are the same every week. For a week with time off, add the hours off to that week's booked hours so the load shows the person as busy.
- Target hours are available hours times the billable target. 40 hours at 70% is 28 billable hours.
- Load is booked hours divided by available hours, per person and per week.
- Open billable hours count only the gap under each person's target, so one person's overtime never cancels another person's spare time.
- Booked hours should include project work, retainer hours the client expects to use, and support time that shows up every week.
- The full method, with a worked example and a weekly routine, is in our guide to capacity planning for agencies without a resource manager.
- To check what your billable targets imply over a month, try the utilization rate calculator.
Capacity planning questions
What does this capacity planning calculator do?
It compares the hours each person has available against the hours already booked to them, week by week, for the next six weeks. It shows each person's load as a percentage of available hours, flags anyone booked past 100 percent, flags anyone well under their billable target, and adds up team totals.
What is the difference between available hours and the billable target?
Available hours are the hours a person works in a week after time off. The billable target is the share of those hours you expect to be client work. A person with 40 available hours and a 70 percent target has 28 billable hours of room. Booking past 28 eats into internal time. Booking past 40 means overtime or missed deadlines.
Why does the team total look fine when people are overbooked?
Totals add the overbooked people and the underbooked people together, so one person 13 hours over and another 18 hours under can net out to a team that looks like it has room. Capacity fails one person at a time, which is why the calculator flags each person and each week separately.
When does the calculator flag someone as underbooked?
When booked hours fall below 60 percent of that person's billable target for the week. A designer with a 28 hour target and 12 hours booked gets the flag. Those are hours of payroll you cannot invoice unless new work lands.
Does this tool save my team's data?
No. Everything runs in your browser. Nothing you type is sent to a server or stored, so the numbers are gone when you close or reload the page.
How far ahead should I plan?
Six weeks suits most agencies under 50 people. It is far enough out to see a hiring or subcontracting decision coming and close enough that the booked hours are real work rather than guesses.
Plan capacity from the hours you already track
Vantage puts time tracking, retainer hours, and billing in one place, so the plan stays current without retyping.