Sales Capacity Planning: How to Build a Headcount Model That Actually Works

Every year, the same exercise: the CRO says "we need to hit $X million next year," finance says "how many reps do you need," and someone divides the target by the quota and calls it a plan.

This approach fails every time. It ignores ramp time, pretends attrition doesn't exist, assumes every rep will hit quota (they won't), and treats all territories as equally productive (they aren't). The result: you miss the number in H1 because you didn't hire early enough, overshoot in H2 because you panic-hired, and spend the year explaining variances that were entirely predictable.

Sales capacity planning done right is a bottoms-up model that accounts for the realities of hiring, ramping, and retaining sales teams. Here is how to build one.

The Fundamental Equation

Sales capacity is not headcount divided by quota. It's productive capacity — the actual selling capacity of your team after accounting for ramp and attrition.

Productive capacity = (Number of fully ramped reps × quota) + (Number of ramping reps × ramped quota fraction)

A team of 20 AEs with a $1M quota doesn't have $20M of capacity. If 4 are in their first quarter (25% ramped), 3 are in their second quarter (50% ramped), and 2 positions are currently open, your actual productive capacity is:

• 11 fully ramped reps × $1M = $11M
• 4 Q1 reps × $1M × 0.25 = $1M
• 3 Q2 reps × $1M × 0.50 = $1.5M
• 2 open positions = $0

Actual productive capacity: $13.5M — 67.5% of the theoretical $20M.

This gap between theoretical and productive capacity is where capacity plans die. Your model needs to account for it explicitly.

Building the Model: Step by Step

Step 1: Define Your Ramp Curve

Ramp time is the period from a new hire's start date to the point where they're performing at full productivity. This varies by segment:

• SMB/velocity sales: 2-4 months typical ramp
• Mid-market: 4-6 months typical ramp
• Enterprise: 6-12 months typical ramp

But "ramp" isn't binary. A rep doesn't go from 0% to 100% overnight. Model the ramp as a curve:

Month	SMB	Mid-Market	Enterprise
1	10%	0%	0%
2	30%	10%	0%
3	60%	25%	10%
4	90%	50%	20%
5	100%	75%	35%
6	100%	90%	50%
7	—	100%	65%
8	—	—	80%
9	—	—	90%
10	—	—	100%

Calibrate these numbers against your actual data. Look at historical cohorts: how long did it take your last 20 hires to close their first deal? To hit 50% of quota? To hit full quota? If you don't have this data, start tracking it immediately.

Step 2: Model Attrition

Sales attrition runs 20-35% annually in most B2B organizations. Some of this is voluntary (reps leave for better offers), some is involuntary (reps are managed out for underperformance), and some is role-change (reps are promoted or move to other teams).

Your model needs to account for all three:

Voluntary attrition: Budget 10-15% annually. Higher in hot markets, lower in downturns. Voluntary departures are hardest to predict and most damaging because they often take your best performers.

Involuntary attrition: Budget 5-10% annually. This should correlate with your performance management rigor — if you actively manage out bottom performers, involuntary attrition will be higher (and your team will be better for it).

Role change: Budget 3-5% annually for promotions and internal transfers.

Total attrition: plan for 20-30% annually. This means if you want to end the year with 20 fully ramped reps, you need to start with more than 20 and hire continuously to backfill departures.

The attrition math is brutal: every departing rep doesn't just create a vacancy. They create a vacancy + a ramp period for the replacement. A rep who leaves in June isn't replaced until August (2 months to hire), and the replacement isn't fully productive until February (6-month ramp). That's 8 months of lost productivity from a single departure.

Step 3: Map the Hiring Timeline

Hiring doesn't happen instantly. Model the realistic timeline:

• Requisition approval to job posted: 1-2 weeks
• Sourcing and interviews: 4-8 weeks
• Offer to acceptance: 1-2 weeks
• Notice period: 2-4 weeks
• Start date to first day selling: 1-2 weeks (orientation, tool setup, training)

Total: 2-4 months from decision to hire to first productive day. This means if you need capacity in Q3, you need to be hiring in Q1. Most companies hire too late and spend the year behind.

Step 4: Set Quota-to-OTE Ratios

The quota-to-OTE ratio determines how much revenue each dollar of sales compensation generates. Industry benchmarks:

• 3:1 ratio: Conservative. A rep with $200K OTE carries $600K quota. Common in enterprise and high-ACV sales.
• 4:1 ratio: Moderate. A rep with $200K OTE carries $800K quota. Common in mid-market SaaS.
• 5:1 ratio: Aggressive. A rep with $200K OTE carries $1M quota. Common in high-velocity and SMB. Requires strong inbound lead flow and product-market fit.

Higher ratios look better on a spreadsheet but break down if quotas are unattainable. Track historical quota attainment: if fewer than 60% of reps hit quota, your quotas are too high (or your reps are underperforming, or your product isn't competitive). The model should use realistic attainment rates, not aspirational ones.

Step 5: Calculate AE vs. SDR Ratios

If your model relies on outbound pipeline, you need SDRs. The typical ratios:

• 1 SDR : 2-3 AEs in mid-market
• 1 SDR : 1-2 AEs in enterprise
• 0 SDRs per AE in PLG/inbound-dominated models

Each SDR needs to generate enough qualified pipeline to support their assigned AEs. Work backward from AE quota: if an AE has a $1M quota and your average deal size is $50K with a 25% close rate, each AE needs 80 qualified opportunities per year, or about 20 per quarter. If an SDR generates 15 qualified opportunities per quarter, you need 1.3 SDRs per AE.

Don't forget SDR ramp time (typically 1-3 months) and attrition (often higher than AE attrition, typically 30-40% annually, due to the nature of the role as a stepping stone).

Step 6: Territory Coverage Analysis

Not all territories are equal. Your capacity model should account for territory potential:

Greenfield territories (new geographies, new segments) ramp slower than established territories. A new rep in a greenfield territory might operate at 50% of the productivity of a rep in an established territory for the first year.

Mature territories have existing customers, referral networks, and brand awareness. Reps in mature territories typically outperform those in greenfield territories by 20-40%.

Over-served territories are territories where you've already captured the addressable opportunity and adding more reps yields diminishing returns. If your win rates are high and pipeline is thin in a territory, you don't need more reps — you need more pipeline.

Map each territory's potential (TAM, existing customer base, competitive density) and adjust productivity assumptions accordingly.

Step 7: Build the Bottleneck Analysis

Your capacity model only works if other functions can support the planned headcount:

Can marketing generate enough pipeline? If your model assumes 50% of pipeline comes from marketing, validate that marketing can deliver. Check historical pipeline generation rates, planned programs, and budget. If marketing can't scale pipeline proportionally to sales headcount, you'll have reps sitting without deals.

Can you recruit fast enough? If your model requires 15 hires in Q1, can your recruiting team or agency partners deliver? Average time-to-fill for B2B sales roles is 45-60 days. If your recruiting engine can process 3-4 hires per month, 15 hires in Q1 is impossible without expanding recruiting capacity.

Can onboarding handle the volume? If you hire 15 reps in a quarter, do you have the training capacity, manager bandwidth, and ramp infrastructure to onboard them effectively? Batch hiring into cohorts (starting all new hires on the first Monday of each month) helps, but there are practical limits.

Can sales engineering support the deals? If you're adding AEs, you likely need to add SEs proportionally. SE-to-AE ratios vary (1:2 to 1:4 depending on product complexity), but SE capacity is a common bottleneck.

Aligning with Finance

The capacity model is a joint exercise between sales leadership and finance. Finance cares about several things:

Payback period. How long until a new rep generates more revenue than their fully loaded cost (salary + benefits + tools + recruiting + training + management time)? If the payback period is 12 months and your ramp time is 6 months, you have 6 months of productive time to recover the investment. This needs to pencil out.

Unit economics by cohort. Finance wants to see that each hiring cohort eventually reaches positive unit economics. Build the model to show revenue and cost by cohort over time.

Scenario modeling. Don't present a single plan. Present three scenarios: conservative (lower hiring, lower risk), base (your recommended plan), and aggressive (accelerated hiring, higher risk). Let leadership choose the risk profile.

Quarterly re-forecasting. The capacity model isn't set-and-forget. Reforecast quarterly based on actual hiring pace, actual ramp times, actual attrition, and actual productivity. Adjust the back-half plan based on first-half actuals.

Spreadsheet vs. Tools

You can build a capacity model in a spreadsheet. Most organizations do, especially for their first model. Use Google Sheets or Excel with clear assumptions, monthly cohort tracking, and sensitivity analysis.

As you scale, dedicated capacity planning tools become valuable. Anaplan, Pigment, and Workday Adaptive Planning handle complex multi-variable modeling better than spreadsheets and make it easier to run scenarios. But don't buy a tool until you've built the model manually and understand the logic.

Common Mistakes

Modeling to headcount instead of productive capacity. Twenty reps on the payroll is not twenty reps of capacity. Always model to productive capacity.

Ignoring ramp time. If you hire in January and the rep isn't productive until July, that hire doesn't help H1. Plan your hiring calendar backward from when you need the capacity.

Flat-lining attrition. Attrition isn't evenly distributed. It spikes after quota resets, after compensation changes, and during hot job markets. Model attrition by quarter, not as an annual average.

Not stress-testing the pipeline assumption. Every capacity model assumes a certain amount of pipeline. If that pipeline doesn't materialize, your reps will be expensive seat-warmers. Validate the pipeline plan independently.

Build the model, pressure-test the assumptions, align with finance, and reforecast relentlessly. The companies that plan capacity well don't just hit their number — they hit it efficiently.