Next quarter's capacity by role, before you sell more

Set each role's client hours for the quarter against its booked work plus pipeline hours weighted by win chance. The role with the highest load runs out first. Check the all-win case too, so you know which deal tips it.

You have three proposals out, all due to start in January. Each one would be good news. Together they could land on the same two designers.

This guide checks that before anyone signs. Count next quarter's client hours for each role. Add the work already booked. Then add the pipeline, weighted by how likely each deal is. The role with the highest load runs out first. A fictional studio works through every step for January to March 2027, then plans its answers.

Roles run out before teams do

A team total adds up hours that can't stand in for each other. A developer's free week doesn't help a designer who is full. The December capacity guide shows this person by person for one month. This guide does it for a quarter, by role, with deals that haven't signed yet.

The U.S. Government Accountability Office makes a related point about project schedules in its Schedule Assessment Guide. A plan with no resources assigned assumes people are unlimited. The guide says to compare the resources the work needs with what is available, by time period. It describes planning by skill set as a compromise between named people and whole departments. In a small studio, a skill set is a role.

Capacity (role)       = people × working days × client hours a day − leave hours
Weighted hours (deal) = hours the deal needs from the role × win chance
Demand, weighted      = booked hours + weighted hours of every open deal
Demand, all win       = booked hours + full hours of every open deal
Load                  = demand ÷ capacity

The role with the highest load runs out first. A load over 100% means the role is short of hours for the quarter.

The method in four steps

Step 1: Count the quarter's working days

Count the weekdays, then take out the holidays your studio closes for. January to March 2027 has 64 weekdays: 21 in January, 20 in February and 23 in March.

The U.S. Office of Personnel Management's list of federal holidays has three dates in those months. New Year's Day falls on Friday, Jan 1. The Birthday of Martin Luther King, Jr. is on Monday, Jan 18, and Washington's Birthday is on Monday, Feb 15. A studio that takes all three has 19, 19 and 23 working days, or 61.

Private businesses set their own holidays. The Department of Labor says the Fair Labor Standards Act doesn't require pay for holidays. It says that is generally a matter of agreement with your staff. So use the days your studio actually closes.

Step 2: Turn days into client hours by role

Multiply each person's working days by the client hours they log in a day. That is the part of the day left after email, internal meetings and admin. The utilization target guide shows how to set it by role. Add up the people in each role. Then take out the leave already booked, in hours.

Step 3: Add the work already booked

Booked work is the retainers and projects already signed for the quarter. Book each retainer at the hours it has used lately, not the hours in its contract. How to tell when a retainer is underwater shows how to read that. For projects, use the hours left in the estimate, role by role.

Step 4: Add the pipeline, weighted and in full

List the hours each open proposal needs from each role. Give each one a win chance. Multiply, then add across deals.

Weighted hours are a planning figure, not work anyone will do. A deal is won or lost whole. So work out a second line with every deal won. The gap between the two lines shows how far the pipeline can move your quarter.

The win chance is your own estimate. If you keep a record of past proposals, how often similar ones were won is a better start than a guess.

A worked example (fictional)

Fictional example. Larch Ferry Studio is not a real business. The figures are illustrative and are not a customer result.

Larch Ferry is a five-person design and web studio. It has two designers, two developers and one strategist who also runs projects. In November it plans January to March 2027.

Everyone plans on 6 client hours a day. The studio takes all three federal holidays. One designer has 5 days of leave booked in March, which is 30 hours. The strategist has 2 days, which is 12 hours.

Capacity. Each person has 61 × 6 = 366 client hours in the quarter.

Role People Client hours Leave Capacity
Design 2 732 30 702
Development 2 732 0 732
Strategy and projects 1 366 12 354
Studio 5 1,830 42 1,788

Booked work. Retainers and signed projects need 560 design hours, 480 development hours and 300 strategy hours.

Pipeline. Three proposals would all start in January.

Deal Win chance Design Development Strategy and projects
A 60% 120 200 40
B 40% 160 60 30
C 25% 80 160 20
Weighted 156 184 41
All win 360 420 90

The weighted rows work like this:

  • Design: 120 × 0.60 + 160 × 0.40 + 80 × 0.25 = 72 + 64 + 20 = 156.
  • Development: 200 × 0.60 + 60 × 0.40 + 160 × 0.25 = 120 + 24 + 40 = 184.
  • Strategy and projects: 40 × 0.60 + 30 × 0.40 + 20 × 0.25 = 24 + 12 + 5 = 41.

Load. Booked plus weighted is 560 + 156 = 716 for design, 480 + 184 = 664 for development and 300 + 41 = 341 for strategy. With every deal won, it is 560 + 360 = 920, 480 + 420 = 900 and 300 + 90 = 390.

Role Capacity Booked + weighted Load Booked + all win Load
Design 702 716 102.0% 920 131.1%
Development 732 664 90.7% 900 123.0%
Strategy and projects 354 341 96.3% 390 110.2%
Studio 1,788 1,721 96.3% 2,210 123.6%

Design runs out first. It is 716 − 702 = 14 hours over at weighted demand, a load of 716 ÷ 702 = 102.0%. At the same demand, development has 68 hours spare and strategy has 13. The studio as a whole has 1,788 − 1,721 = 67 spare hours. The team total says yes. Design says no.

Which deal tips which role. Take booked work off capacity. Then set each deal's hours against what is left.

Role Free after booked work Deal A Deal B Deal C
Design 142 120 160 80
Development 252 200 60 160
Strategy and projects 54 40 30 20

Design has 702 − 560 = 142 free hours. Deal B alone needs 160, which is 18 more. Any two deals put design over too: A and C together need 200.

Development goes over only if A wins with B or C. A and B together need 260 hours, and development has 252 free. Strategy goes over in the same two cases. A and B need 70 strategy hours, and it has 54 free. So one win can break design, and it takes two to break the other roles.

Reading the result

The two lines call for two kinds of answer.

  • Over at weighted demand. The expected load is already more than the role has. Arrange hours or dates before deals sign. At Larch Ferry, that is design.
  • Over only when deals win together. You don't need more people yet. Decide now what you will do if the tipping deal signs, and keep that answer ready. At Larch Ferry, that is development and strategy.

A second rule tells missing hours from poor timing. If a role is over for the quarter as a whole, no schedule fixes it inside the quarter. You need more hours, or less work in those months. If the role fits the quarter but one month is over, it's a timing problem. Move starts within the quarter instead.

Three mistakes to avoid:

  • Reading the studio line. Larch Ferry's total is 96.3% at weighted demand, which looks full but workable. Design is over.
  • Planning on the all-win line only. The quarter looks impossible, and you turn down work you could have done.
  • Planning on the weighted line only. No deal arrives at 40%. When B signs, design needs all 160 hours.

Four answers when a role runs out

In the GAO schedule guide's terms, answers 1 and 2 are resource leveling: they delay a start until people are free. Answers 3 and 4 change the work or add hours instead. The example tries all four on the hardest case: all three deals win.

  1. A later start date. Ask a client whose deadline has room to start in April. If more than one can, pick the deal that takes the most hours from the roles that are over. Deal A's client wants a June launch, so an April start still works. It takes 120 design, 200 development and 40 strategy hours out of the quarter.
  2. Staggered starts. Start part of a deal later. Deal B's design comes in two phases of 80 hours. Starting the second phase in April, after the client approves the first, moves 80 design hours out.
  3. Reshaped scope. Change what you sell this quarter. Deal C includes a second round of design concepts, 20 hours. Offering it as an option in April moves those hours out, along with their fee.
  4. Freelance cover. Add hours to the role. A freelance designer for 60 hours, two weeks at 6 client hours a day, takes that much off the designers.
Step Design Development Strategy and projects
All three win 920 900 390
Deal A starts in April 800 700 350
Deal B's second phase in April 720 700 350
Freelance designer, 60 hours 660 700 350
Capacity 702 732 354
Load 94.0% 95.6% 98.9%

Larch Ferry uses answers 1, 2 and 4. Reshaping C's scope instead of the freelancer would also fit design, at 700 of 702 hours, but it leaves only 2 spare hours for the quarter. The freelancer leaves 42. Strategy is now the tightest role, with 4 spare hours.

The smaller cases need less. If only B signs, answer 2 alone does it: design falls to 560 + 160 − 80 = 640 hours, a load of 91.2%.

Because design is over even at weighted demand, Larch Ferry lines up the freelance designer now, before any deal signs.

Each answer has a price. A later start can cost you the deal. A staggered start makes the project longer. Reshaped scope takes fee out of the quarter. A freelancer costs money. If you call a freelancer for the same role every quarter, compare that with hiring. Hire or keep using freelancers shows the break-even hours.

Repeat it every month

Run the check at the start of each month, not only when a new lead arrives.

  1. Move deals you won into booked work, at their full hours.
  2. Take out the deals you lost.
  3. Update the win chance on the rest, starting with proposals that haven't moved.
  4. Roll the quarter forward a month, so you always look three months ahead.
  5. Add leave as people book it.

Write down one decision each time: a start date to offer, a phase to move, or a freelancer to line up.

What this method doesn't do

  • It works in quarter totals. A role can fit the quarter and still be over in one month. Split the quarter by month for the role closest to full.
  • It rests on estimates. Win chances, deal hours and client hours a day are guesses until the work is done. Compare them with what you logged at the end of each quarter.
  • It counts booked leave, not sickness. At 6 client hours a day, a sick week takes 30 hours from one person.
  • It treats everyone in a role as the same. A senior and a junior designer aren't. Split the role if their work differs.
  • It doesn't price anything. It shows when hours run out, not whether a deal pays or what a freelancer costs.
  • It doesn't settle employment questions. Holiday pay, and whether a freelancer can be treated as a contractor, depend on where you work and on your agreements. Ask an employment lawyer or adviser.

A planner for this

The Retainer Burn & Capacity Planner looks one month ahead. It works out each person's client-work hours for next month, after their time off and the public holidays you list. It sets them against the retainer and project hours already planned for that person. It plans by person and by month. It holds no pipeline or win chances, and it doesn't group people by role. For a quarter, check each month as it comes, or do the quarter by hand as above.

It takes hours you have already tracked and doesn't record time. You type or paste the figures into an Excel 365 workbook, tested in Excel 365 for Windows desktop. It spreads each person's weekly hours evenly over Monday to Friday and applies public holidays to everyone, so part-time days and regional holidays are approximate. Its page shows every sheet.

The method above works in any spreadsheet. One row per role for capacity and one row per deal for the pipeline are enough.

Independence

Metricvalley is independent. This guide isn't affiliated with, or endorsed by, the U.S. Office of Personnel Management, the U.S. Department of Labor or the U.S. Government Accountability Office. Nothing in this guide is financial, tax, employment or legal advice.

Sources and method

Every figure in the worked example is fictional (Larch Ferry Studio). Weekdays are counted from the calendar. The holiday dates come from the Office of Personnel Management's list. The client hours a day, the leave, the bookings, the deals, their win chances and the answers are the example's own assumptions.

Common questions

How many working days are in the first quarter of 2027?

January to March 2027 has 64 weekdays. The federal holiday list puts three holidays in them: New Year's Day on Friday, Jan 1, the Birthday of Martin Luther King, Jr. on Monday, Jan 18 and Washington's Birthday on Monday, Feb 15. If your business takes all three, that leaves 61 working days: 19 in January, 19 in February and 23 in March.

How do you weight pipeline hours by win chance?

Multiply the hours a proposal needs from each role by its estimated chance of winning. Then add across proposals. A proposal that needs 120 design hours at a 60% chance adds 72 weighted hours. Weighted hours are a planning figure, not work anyone will do: a deal is won or lost whole. So also work out a line with every deal won, and see which deal tips each role over.

What if a role is over capacity only when every deal wins?

Then you don't need more people yet. Find the deal that tips the role over, and decide now what you will do if it signs: offer a later start, move a phase into the next quarter, trim the scope or call a freelancer. Add hours before any deal signs only for a role that is over at weighted demand.

How we research, check and update these guides. Found an error? Email [email protected] and we’ll correct it and note the change here.

All guides