Skip to main content

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 roleAvailable
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.

OverbookedOver targetOn targetUnderbooked
PersonTarget
hrs/wk
Week 1Week 2Week 3Week 4Week 5Week 66 week
avg
Senior designer28
102%Overbooked
95%Over target
85%Over target
75%Over target
65%On target
50%On target
79%
Junior designer30
30%Underbooked
35%Underbooked
45%On target
55%On target
60%On target
40%Underbooked
44%
Developer28
65%On target
70%On target
75%Over target
60%On target
50%On target
30%Underbooked
58%
Strategist20
55%Over target
45%On target
50%On target
40%On target
35%On target
25%Underbooked
42%
Team total106
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%
Team totals hide per-person overload. In week 1 the team is booked to 63% of available hours, which looks like room, yet 1 person is past 100% and 1 is underbooked. Move work between people before you hire or turn work away.
Team load, 6 weeks
56%
535 of 960 available hours booked
Overbooked person-weeks
1
1 hour booked past available
Underbooked person-weeks
5
Under 60% of billable target
Open billable hours
136
Billable target hours not yet booked, summed per person

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.