Sales capacity planning for small teams

Sales capacity planning answers a blunt question: given the revenue target, how many fully productive selling seats do you need after ramp and real attainment, not after hopeful quotas. On a small team the answer is a dated headcount plan, not a slogan about stretch goals.

A fully productive selling seat (call it a productive seat for short) means one ramped seller delivering at your team's real attainment, not at 100% of quota on paper.

What sales capacity planning computes

Start from the target and work backward. Public capacity models usually use some form of required productive seats = target / (quota x expected attainment), then discount new seats for ramp and for people leaving (Revenue Lab; ORM Tech capacity planning writeups, checkedOn 2026-11-01).

Every number in the worked examples below is an example input you replace with your closed-won history. None of them is a benchmark to copy.

Case (example inputs only; replace each figure): target $2.4M, quota $600k, median attainment 70%. One fully productive selling seat is then worth $420k of bookings. You need about 5.7 productive seats, not four quota lines on a slide.

Label example inputs in the sheet

Mark example rows Example input. Your closed-won history is the hard input. Ramp percentages and departure assumptions stay labeled until your own cohorts prove them.

Build productive-seat math before you open reqs

A productive seat's annual bookings value is quota times median attainment. Spell that product on the sheet so nobody confuses it with raw quota.

Pull the last four full quarters of closed-won by owner. For each seller, take the median quarter, not the mean. Sum those medians for a reality check on current capacity. Small-team guides stress person-by-person medians because one departure moves the math hard (Salesbond small-team capacity writeup, checkedOn 2026-11-01).

Compare current productive seats to required productive seats. The gap is what hiring, productivity, or target changes must close.

Refuse to plan as if every seat will hit 100% of quota. That assumes every new hire clones your best closer. Use your median attainment as an example input only after you compute it from your data.

Sheet columns that keep the math auditable

Those closed-won and quota cells are placeholders. Paste your CRM export before you brief leadership.

Freeze the export date on the sheet. Capacity debates that cite undated CRM screenshots waste the room.

Dual view: dollars and seats

Show the gap in both bookings dollars and fully productive selling seats. Finance hears dollars. Recruiting hears seats and start months. One view without the other creates polite confusion.

Discount ramp so new seats are not fake capacity

A seat in month two is not a full productive seat. Sketch a ramp curve with percentages of full productivity by month until the seller is fully ramped.

Example ramp inputs only (replace with your cohort data): months 1-2 at 20%, 3-4 at 45%, 5-6 at 75%, 7+ at 100%. These percentages are not industry standards. Integrate across the remaining months of the plan year to get first-year contribution per hire date.

A January start contributes more productive-seat months than a September start. Capacity planning without hire months is fiction.

Label every ramp percentage Example input until five or more historical hires support it. Thin history means wide error bars, not false precision.

Worked ramp contribution

Example inputs only: suppose full monthly productivity is 1.0 after month 6, and the hire starts 1 April in a calendar-year plan. Sum the monthly factors for April through December. If those nine months average 0.55 of a full seat (your sheet may show a different average), that hire is about 0.55 productive seat-years for that year. Do not treat 0.55 or 0.75 as a rule of thumb to copy.

Recalculate when the start month slips. A slipped start is a capacity cut, even if the req stays open.

Onboarding load

Count manager hours and enablement slots consumed per hire. Capacity plans that ignore manager load create a second bottleneck: ramping people with nobody to coach them.

Model sudden exits, not smooth percentages

On a five-person team, a round "30% attrition" line is not one-and-a-half people. Treat 30% as an example input you may discard. Either nobody leaves or one named person leaves and a fifth of capacity vanishes the same week.

List each planned or likely departure with a month. Add backfill lag from notice to start. The backfill ramps from month one again.

Open-seat weeks between exit and start destroy capacity even when headcount looks stable on paper.

If your best seller might leave, stress-test the plan with that seat at zero for a quarter. Soft averages hide a sudden exit.

Named scenario tabs

Keep three tabs: Base, Exit of top seller, Slow ramp. Change only one assumption per tab. Multi-factor nightmare tabs teach drama, not decisions.

Write the probability you assign to each scenario in plain language (likely, possible, remote). Do not fake decimal precision you do not have.

Convert the gap into a dated hire calendar

Required productive seats minus current productive seats equals the gap.

Divide the gap by first-year productive contribution per hire (from your ramp curve and start month) to estimate how many starts you need, plus named backfills.

The seat-year fractions above are worked examples from a sample six-month ramp, not benchmarks. Rebuild them from your percentages.

Work backward from required start months to recruiting open dates using your real time-to-offer. A capacity plan that ignores recruiting lag just moves the miss earlier.

Case (example inputs only): gap of 1.8 productive seats, April starts contributing 0.5 each on your sheet, needs about four April starts before backfills, or fewer January starts. Recalculate with your gap and your contribution column. The calendar decides, not the slogan.

Recruiting lead time reverse schedule

Example input: if your time-to-start averages 60 days (replace with your recruiting history), an April 1 start needs an accepted offer in early February and a sourced pipeline in December. Put those dates on the same sheet as productive seats.

Missed sourcing weeks are capacity misses with a longer fuse. Treat them like missed quota, not like HR trivia.

Segment and motion tags

Tag each planned seat by segment (SMB, mid-market) and motion (inbound close, outbound). Extra seats in a motion you cannot feed with pipeline still miss. Capacity without pipeline math is half a plan.

Keep the sheet honest each month

Rebuild median attainment quarterly from closed-won, not from pipeline fantasy.

Update ramp factors when a cohort finishes month six. If reality is slower, change the curve; do not leave a wrong example input in place.

Track open reqs against the hire calendar. A green capacity sheet with empty seats is still a miss.

When the target changes mid-year, rerun productive-seat math the same week. Do not wait for the annual planning theater.

Monthly fifteen-minute review

Agenda: attainment medians still valid, ramp assumptions vs latest cohort, open seats vs calendar, target changes. End with one sentence on whether Base still holds.

Archive each month's sheet as a dated file. Overwriting the only copy erases why you hired when you hired.

What sales capacity planning is not

It is not a quota pep talk. Quotas without median attainment are posters.

It is not a hiring binge to cover a target you will not staff in time. Late seats mostly buy next year.

It is not an excuse to ignore territory and segment design. Extra seats in the wrong segment still miss.

Owner of the sheet

Name one owner for the capacity sheet (usually the GTM lead) and one challenger (usually finance). Dual ownership without a challenger turns the sheet into advocacy.

Publish the Base tab to the leadership channel after each monthly review. Hidden sheets invite side models that disagree in the board meeting.

Pipeline cover check

Before you approve a hire month, check whether pipeline creation can feed that seat. A simple cover ratio (pipeline created per month vs quota) beats optimism. If cover is thin, fix demand gen or narrow the seat's segment before you add cost.

Compensation shape note

Capacity assumes the variable plan still pays for the behavior you model. If you change accelerators mid-year, restate expected attainment from your data. Comp changes without capacity updates create silent misses.

Board one-pager

When you show the plan upstairs, put four numbers on one page: target, productive seats required, productive seats current, next three start months. Leave the ramp curve in the appendix. Boards buy clarity; they endure detail.

For CRM hygiene that keeps closed-won trustworthy, keep source data clean in your system of record. Product docs live in the Help Center. Scheduling workflows sit in Meetings. Plan limits are on pricing.

Close the loop with enablement

Every new start month on the calendar should map to a named onboarding week on the enablement calendar. Orphan starts without training slots ramp slower than the curve you showed upstairs.

Change log

Append a one-line change log at the bottom of the sheet: date, what changed, why. When someone asks why you hired three in April, the log answers without an archaeology dig in Slack.

Sales capacity planning earns trust when fully productive selling seats, ramp example inputs, named departure plans, and hire dates live in one sheet the GTM lead and finance both open.