How do you do sales capacity planning for the next fiscal year?
Direct Answer
Sales capacity planning for next fiscal year is the math problem of figuring out how many quota-carrying reps you need to hit your bookings target — and it's almost always wrong because operators assume heroic productivity instead of historical reality. The formula is unforgiving: Required Bookings divided by (Quota per AE multiplied by Attainment Rate multiplied by Ramp Adjustment) equals AE headcount needed.
A $30M new bookings target with $1.2M quota, 65% attainment, and 0.85 ramp adjustment requires roughly 45 AEs — not the 25 your CFO budgeted assuming 90% attainment.
TL;DR
- The capacity math: Required Bookings divided by (Quota times Attainment times Ramp Adjustment) equals AE headcount, then add 25-30% on top for attrition.
- Use trailing-12-month attainment, NOT board-aspirational targets — Pavilion 2024 found 58% of B2B SaaS orgs missed plan because they modeled 90%+ attainment against a 65-72% historical reality.
- New hires deliver 60-75% productivity in their first 12 months; ramp drag is a real line item, not a rounding error.
- AE attrition runs 25-45% annually; if you don't over-hire, you'll enter Q3 with a capacity hole no recruiting team can close in time.
- Recruiting plus ramp is a 9-12 month round trip — Q4 hires don't produce in H1; this is the single biggest argument for finishing capacity planning by mid-November.
The 5 Inputs Every Capacity Model Needs
A capacity model that skips any one of these inputs is a wishlist, not a plan. The trick isn't sourcing the data — it's refusing to substitute aspirational numbers when historical ones look uncomfortable.
| Input | Source | Common Error |
|---|---|---|
| Revenue plan (new bookings by segment) | FP&A board-approved plan, segmented enterprise/mid/SMB | Treating one blended ARR target as the model — enterprise needs different headcount math than SMB |
| Productivity assumption (quota times attainment) | Salesforce trailing-12-month attainment dashboard, not next-year quota letters | Using "fully ramped tenured-rep" attainment as the org average; bottom-half AEs may only hit 40% |
| Ramp adjustment (new-hire productivity Year 1) | Cohort analysis of last 3 hire classes, time-to-first-deal and time-to-quota | Assuming new hires produce at 100% from month one; reality is 60-75% across the first 12 months |
| Attrition assumption (12-month AE retention) | HRIS exit data plus voluntary/involuntary split | Using 90% retention because "we don't have a culture problem"; SaaS AE attrition is structurally 25-45% |
| Recruiting cycle time (time-to-hire plus ramp) | Talent acquisition funnel data, requisition-to-start-date | Forgetting that a "headcount add" in Q1 is a productive AE in Q4 — nine months gone |
The 4 Failure Modes That Inflate Capacity Plans
The first failure mode is using average productivity. Average attainment hides the top-rep concentration problem — in most SaaS sales orgs, the top 20% of reps deliver 50-60% of bookings, and the bottom half hits 40% of quota or less. If you plan with the average, you implicitly assume every hire will be median or better.
They won't. Model with a productivity distribution (top quartile, middle two, bottom quartile) and stress-test what happens if next year's hire class skews toward the bottom half.
The second is under-hiring for attrition. Annual AE attrition in B2B SaaS runs 25-45% depending on stage and compensation competitiveness. If you plan for 45 AEs and don't bake in over-hiring, by Q3 you're operating with 32-34 productive reps and a hiring team that physically cannot close the gap before fiscal year-end.
The fix: over-hire by 25-30% at the start of the year, time the incremental hires to backfill predicted Q2/Q3 departures, and accept that some quarters will be "over-resourced" on paper.
The third is ignoring ramp drag on new hires. A new AE who starts in February isn't a full quota-carrier in March. ICONIQ and OpenView benchmarks consistently show 6-9 months to full productivity, with the first 90 days at near-zero bookings contribution.
If you load 15 new hires into Q1 and credit them with full quota for Q1-Q4, you've just overcounted bookings capacity by roughly 30-40% of their annual quota in aggregate.
The fourth is not segmenting by territory or segment. Enterprise AEs run $1.5M-$2.5M quotas at 50-60% attainment and 9-18 month sales cycles. SMB AEs run $600K-$900K quotas at 70-80% attainment and 30-60 day cycles.
Modeling them as one pool is how you end up with too many enterprise reps and a starved SMB motion — or vice versa. Build the model bottoms-up by segment, then aggregate.
Tooling: Anaplan vs Mosaic vs Spreadsheet
Anaplan and Pigment are the enterprise standard once you're past $100M ARR — multi-dimensional modeling, scenario planning, and the ability to roll up territory-level plans into a global view without breaking. They're expensive (six-figure annual contracts) and require dedicated admin headcount, but they pay for themselves when you're coordinating capacity across regions, segments, and product lines simultaneously.
Mosaic.tech sits in the middle: strong for $30M-$150M ARR finance teams that want pre-built sales capacity templates without an Anaplan implementation. Below $30M ARR, a well-built Excel or Google Sheets model with clean Salesforce data exports is genuinely fine — the constraint at that stage isn't tooling sophistication, it's discipline about using real historical attainment instead of round numbers.
The mistake is buying Anaplan to fix a discipline problem; it won't.
A Real Example
A $40M ARR Series C SaaS company built their FY26 capacity plan assuming 88% attainment — the prior three-year aspirational quota letter number. Actual attainment across that period was 67%. They hired against the 88% assumption, ran out of pipeline coverage in Q2, and missed plan by $4M.
For FY27, the same RevOps team rebuilt the model with 67% attainment, a 25% over-hire buffer for attrition, and a 6-month ramp adjustment that explicitly zeroed out new-hire productivity for the first 90 days. They closed FY27 within 6% of plan — the first time the company had hit plan in three years.
The model didn't get smarter; the inputs got honest.
Frequently Asked Questions
What attainment percentage should we assume? Use your trailing-12-month organizational attainment from Salesforce — not the board number, not the comp-plan quota letter. For most B2B SaaS orgs that's 60-72%. If your historical attainment is 85%+, your quotas are probably too low and your CFO will catch it.
How much should we over-hire for attrition? 25-30% above base headcount need for most growth-stage SaaS. If your trailing-12 voluntary attrition is above 35%, treat that as a leading indicator of a comp or management problem and address it before throwing more hiring budget at the symptom.
Should we plan for layoffs in the model? No — but you should plan for performance-based churn. Roughly 10-15% of new hires won't make it past their first year on performance grounds. That's part of the "over-hire 25-30%" buffer, not a separate line item. Planning macro layoffs into capacity is a different exercise entirely.
Sources
- Pavilion 2024 Capacity Planning Survey — pavilion.com/research
- Alexander Group 2024 Sales Compensation and Productivity Study — alexandergroup.com
- ICONIQ Growth 2024 Topline Growth and Operating Metrics Report — iconiqcapital.com
- OpenView 2024 SaaS Benchmarks Report — openviewpartners.com
- McKinsey "The future of B2B sales productivity" 2024 — mckinsey.com
- Bridge Group 2024 SaaS AE Metrics and Compensation Report — bridgegroupinc.com
- Anaplan Sales Capacity Planning Best Practices Guide — anaplan.com
- SaaStr 2024 AE Attrition and Ramp Benchmarks — saastr.com