Sales Capacity Planning

Executive summary

Sales capacity planning answers one question: given the team you have and the hires you can make, how many bookings can the team produce in the period, and is that enough for the target? The answer is a number, and the way to get it is arithmetic on quota, historical attainment, ramp time, and attrition. It is not the same as dividing the target by quota.

The common failure is dividing a bookings target by quota to get a headcount. That treats every rep as fully productive for the whole year, assumes everyone hits quota, and ignores that a rep hired in the second half of the year does little for this year's number. A target of $9.0M with a $1.2M quota seems to need 7.5 reps. In practice, the answer depends on how many reps reach quota, how long new hires take to ramp, and who leaves.

The method below produces a bookings capacity in dollars, shows the gap to target, and lets you test hire timing before you commit to a plan. It sits inside the wider revenue operations playbook, whose central claim is that forecast accuracy should be settled before growth targets are set. Capacity is one of the four numbers that claim depends on.

When to use this

Use this guide when:

• You are setting next year's bookings target and need to know whether current headcount can reach it.
• The board has asked for growth and you need to show how many hires, and by when.
• Rep attrition has been high and nobody has quantified the effect on the number.
• You are deciding between hiring reps and investing in pipeline creation or retention.
• Quota attainment has been below 100 percent for several periods and you want to set quotas that reflect reality.

This guide describes a capacity model for a direct sales team that sells to business customers. If part of your revenue comes through distributors, partners, or an installed base that renews without selling effort, model those separately. Compensation, commission, and employment terms are governed by your own agreements and by employment law, so involve counsel or HR advisers before changing quotas or comp plans.

Diagnostic questions

1. How many quota-carrying reps do you have today, by tenure band?
2. What is the quota for each rep, and how was it set?
3. What share of reps reached quota in each of the last four periods, and what was average attainment?
4. How long, from your own hire records, does a new rep take to produce at the level of a tenured rep?
5. How many reps left in the last 24 months, and how long did the territory sit empty before a replacement was productive?
6. How long does it take to recruit, from approved requisition to start date?
7. Is bookings productivity per rep stable across territories, or does a minority of reps produce most of the number?
8. Do reps spend time on tasks that do not generate bookings, such as quoting, admin, or renewals, that could move elsewhere?
9. What is the stage-based win rate, and is there enough pipeline to use the capacity you are planning to add? See pipeline coverage and forecast accuracy.
10. What does a fully loaded rep cost, including base, variable, benefits, tools, and travel?
11. Does the quota set for each rep add up to more than the company target, and by how much (the over-assignment)?
12. How does the quote process affect rep time? See CPQ and quote discipline.

Reading the answers: if question 3 shows that most reps miss quota, the problem is either quota level or pipeline, not headcount. If question 4 shows a long ramp, new hires made after mid-year will not reach the number. If question 7 shows concentration, losing one top rep matters more than the average attrition rate suggests.

The framework

Capacity has four inputs. Each comes from your own data.

From these you get three derived numbers:

Productive capacity per ramped rep = Quota × Historical attainment
Ramped-equivalent headcount = Σ over reps of (Σ monthly ramp factors ÷ 12)
Bookings capacity = Ramped-equivalent headcount × Productive capacity per ramped rep

Each rep's contribution for the year is the sum of their monthly ramp factors divided by 12. A tenured rep who stays all year contributes 1.0. A rep who leaves after six months contributes 0.5. A new rep with no output in the first three months, half productivity in months 4 to 6, and full productivity after that, contributes 0.625 if hired in month 1 and 0.125 if hired in month 7.

Why use attainment rather than quota

Quota is a target. Attainment is what happened. If ramped reps have averaged 80 percent of quota over several periods, plan on 80 percent unless something real has changed, such as a new product, a territory redesign, or a pricing change that you can point to. A plan that assumes 100 percent attainment from a team that has delivered 80 is a plan to miss by 20 percent.

Use the average of the last four to eight periods for ramped reps only. Exclude reps who were still ramping, because including them double counts the ramp loss.

Why quota should exceed the target

Companies commonly assign more total quota than the company target, because some reps will miss. This is called over-assignment. The right level is not a fixed percentage. It is the ratio of total quota to realized bookings, from your own history. If you have assigned $10.8M of quota to hit $9.0M in each of the last few years, your over-assignment is 20 percent and attainment on assigned quota is about 83 percent. Over-assignment and average attainment are two views of the same fact. Do not use both to adjust the same number.

Step-by-step process

1. List the team. Every quota-carrying rep with start date, current quota, trailing attainment, and status (ramping, ramped, leaving, open seat). Owner: sales operations. Output: roster table.
2. Compute historical attainment for ramped reps over the last four to eight periods. Owner: sales operations. Output: average attainment, and the distribution by rep.
3. Build the ramp curve from your own hire cohorts. For each past hire, record bookings as a share of the tenured-rep average by quarter of tenure. Average across hires. Owner: sales operations with HR. Output: ramp factors by month. If you have fewer than five past hires, use a stated assumption and mark it as one.
4. Estimate attrition from the last 24 months of departures, and the lag between a departure and the replacement reaching its first ramp stage. Owner: HR with the CRO. Output: expected departures by month, and replacement dates.
5. Compute baseline capacity. Apply the formula to current reps, expected departures, and backfills. Owner: sales operations. Output: bookings capacity with no net new hires.
6. Compare to target. Gap equals target minus baseline capacity. Owner: CRO and CFO. Output: a dollar gap.
7. Test hire plans. For each option, compute the ramped-equivalent contribution by hire month. Owner: sales operations. Output: a table of options with capacity, cost, and risk.
8. Check the pipeline. Capacity is a ceiling. If pipeline coverage cannot support it, adding reps adds cost without bookings. Owner: CRO. Output: required pipeline for the planned capacity.
9. Set quotas that sum to the plan, with explicit over-assignment, and document the assumptions. Owner: CRO and CFO. Output: quota table.
10. Review quarterly. Replace assumptions with actuals, and restate the capacity for the remaining periods. Owner: sales operations. Output: updated model.

Worked example (illustrative)

The numbers below are made up to show the method. They are not benchmarks.

A distributor has a new-business bookings target of $9.0M for the year. It has 9 quota-carrying reps, all ramped. Quota per ramped rep is $1.2M. Over the last four periods, ramped reps have averaged 80 percent attainment.

Productive capacity per ramped rep = 1.2 × 0.80 = $0.96M.

Naive headcount: 9.0 ÷ 1.2 = 7.5 reps. The company has 9, which looks like a surplus. The next steps show why it is not.

Attrition

Two reps are expected to leave at the end of month 6, based on the last 24 months of departures. Each works half the year. Seven reps stay all year. Their contribution is 7 + 2 × 0.5 = 8.0 ramped-equivalent reps.

The two seats are backfilled with hires starting in month 7. Ramp for new reps, from the company's own cohorts: no output in months 1 to 3, half productivity in months 4 to 6, full productivity from month 7 of tenure. A hire in month 7 contributes (months 10 to 12 at 0.5) ÷ 12 = 1.5 ÷ 12 = 0.125 in the year. Two backfills give 0.25.

Baseline: 8.0 + 0.25 = 8.25 ramped-equivalent reps.

Baseline bookings capacity = 8.25 × 0.96 = $7.92M.

Gap to target = 9.0 − 7.92 = $1.08M, which is 1.08 ÷ 0.96 = 1.125 ramped-equivalent reps.

Hire timing options

Option B needs three hires to reach the gap exactly, with no margin, because a month 4 hire spends the first three months at zero. Option A needs two hires and clears the target with $0.12M of room. Hiring earlier is cheaper in headcount, but a month 1 start requires that recruiting begins well before the year starts.

Cost check, using an assumed fully loaded cost of $220,000 per rep per year: Option A costs 2 × 220,000 = $440,000 for the year and adds 1.25 × 0.96 = $1.20M of capacity. Option B costs 3 × 220,000 × 9 ÷ 12 = $495,000 and adds 1.125 × 0.96 = $1.08M. Option B costs more and adds less, because ramp is a fixed delay that does not shorten when you hire late.

What the pipeline must support

At a stage-based yield from the company's CRM history, say 30 percent of qualified pipeline created in the period converts to closed-won in the period. Capacity of $9.12M then requires 9.12 ÷ 0.30 = $30.4M of qualified pipeline. If the pipeline tracking shows only $24M is likely, Option A's extra capacity would go unused. That is a pipeline problem and the next step is the coverage guide, not a third hire.

Arithmetic check: 1.2 × 0.8 = 0.96. 7 + 1.0 = 8.0. 1.5 ÷ 12 = 0.125. 8.25 × 0.96 = 7.92. 9.0 − 7.92 = 1.08. 1.08 ÷ 0.96 = 1.125. 9.5 × 0.96 = 9.12. 9.375 × 0.96 = 9.00. 1.25 × 0.96 = 1.20. 3 × 220,000 × 0.75 = 495,000. 9.12 ÷ 0.30 = 30.4.

Templates

Rep roster and capacity table (copy into a spreadsheet)

Ramp curve table

Hire plan options

Quota assignment check

Metrics and KPIs

Setting targets without invented benchmarks. Use your own history: the best trailing four-period attainment of ramped reps, the fastest ramp among your last hires if you can explain why it was fast, and the ratio of sales cost to bookings in your best year. For an outside reference, use named public peers' filings and read how they define sales cost before you compare. Do not take a ramp length or an attainment figure from a blog and apply it to your sales cycle.

Common mistakes

1. Dividing the target by quota. That ignores attainment, ramp, and attrition. It will tell you that the team is bigger than it needs to be.
2. Assuming full productivity from day one. A new hire in the second half of the year adds little to this year. Model the ramp.
3. Using quota instead of attainment. Plan on what the team has delivered.
4. Ignoring vacancy time. The gap between a departure and a backfill reaching productivity is lost capacity. Count it.
5. Hiring to a target without checking pipeline. Capacity without qualified demand is cost.
6. Averaging across very different reps. If a few reps produce most of the number, the average hides the risk of losing one.
7. Counting ramping reps in attainment history. They depress the average and make ramped reps look weaker than they are.
8. Leaving non-selling work with reps. Quoting and admin time is capacity. A process change can add more than a hire.
9. Never testing the assumptions. Replace the ramp and attrition assumptions with actuals each quarter.

AI prompt assistance

AI can build and check the spreadsheet logic. It cannot supply your ramp or attrition history. Provide those from your own records.

1. Build the capacity model.

I will paste a roster with rep name, start date, quota, trailing attainment, and expected departure month. I will also paste a ramp curve by tenure month. Build a month-by-month table of ramp factors for each rep for the year, compute ramped-equivalent headcount, and compute bookings capacity as ramped-equivalent headcount times quota times average attainment of ramped reps. Show formulas.

Check: recompute two reps by hand and confirm that the total ties to the sum of rep rows.

2. Derive a ramp curve from hire history.

Here are bookings by month of tenure for 8 past hires and the average monthly bookings of tenured reps in the same periods. Compute each hire's productivity share by tenure quarter and the average across hires. Flag any hire that is more than a stated distance from the average and note the sample size.

Check: confirm the tenured-rep average matches the CRM. With a small sample, treat the curve as an assumption and say so in the plan.

3. Compare hire options.

Using this baseline capacity, target, and fully loaded cost per rep, compare hiring N reps in month 1, month 4, and month 7. For each option show added ramped-equivalent headcount, capacity, cost in the year, and cost per dollar of added capacity.

Check: verify month 7 and month 10 hires against the ramp table, and confirm costs are prorated for months employed.

Implementation guide

Governance: the CRO owns capacity and quotas, the CFO owns the cost and the target, HR owns attrition and time-to-hire data, and sales operations owns the model. Present the baseline, the gap, and the options to the executive team before the plan is locked.

Downloadable assets

The roster table, ramp curve table, hire options table, and quota check above are designed to be copied into a spreadsheet. No capacity calculator exists on the site yet.

Related resources

• Revenue operations playbook: where capacity fits in the plan.
• Pipeline coverage and forecast accuracy: whether pipeline can feed the capacity.
• Net revenue retention: calculation and levers: the retention number that sets how much new business you need.
• Key account management cadence: moving renewal and expansion work away from new-business reps.
• CPQ and quote discipline: returning quoting time to selling.
• Price realization rate drift: why bookings at quote price can overstate realized revenue.

Hub: Revenue growth guides.

Frequently asked questions

How do you calculate sales capacity?

Sales capacity equals ramped-equivalent headcount multiplied by quota and historical attainment. Ramped-equivalent headcount adds up each rep's monthly ramp factors for the year and divides by 12, so a rep who leaves at mid-year counts as 0.5 and a late hire counts for very little. Use your own attainment and ramp history.

How many sales reps do I need?

Divide the bookings gap, target minus baseline capacity, by the capacity of one ramped rep (quota times attainment), then adjust for the month each hire starts. With the ramp used in this guide, a month 1 hire contributes 0.625 in-year and a month 4 hire 0.375. Check that pipeline supports the added capacity before you hire.

How long does it take a new sales rep to ramp?

It depends on your sales cycle and product, so measure it from your own hires: bookings by month of tenure as a share of tenured-rep productivity, averaged across hires. If you have fewer than five hires, treat the curve as an assumption, label it, and replace it with actuals as hires accumulate.

Should I plan on quota or on attainment?

Plan on attainment. Quota is a target and attainment is what ramped reps have delivered. If they averaged 80 percent of quota over recent periods, planning at 100 percent builds a 20 percent miss into the number, unless you can name a specific change that justifies a higher figure.

Does adding reps always increase bookings?

No. Added reps raise capacity, but bookings also need qualified pipeline to convert. If coverage is already thin, new reps share the same demand and cost rises without bookings rising. Compute the pipeline needed for the planned capacity at your own yield before approving hires.

How this works in a System of Performance

A capacity plan rests on assumptions about ramp, attrition, and attainment that go stale as soon as the quarter starts. A Performis routine can take on a recurring job like this, with the scope and fit agreed with you: it works from the records your team supplies, prepares the work for your named reviewer, and keeps each approval on record. If you want to see how far your current plan sits from your own history, bring it to us as a launch partner.