Skip to content
SheetModel
Real EstateE-commerceConstructionB2B SaaSWorkforceAbout
B2B SaaS 3 Excel tabs included 10 min read Updated Jan 2026

Sales capacity & quota attainment model

Turn an ARR target into a hiring plan: ramp-adjusted AE capacity, pipeline coverage and the SDR headcount required to feed it.

Ramp to productivity
3–6 months
Pipeline coverage
3–4x
Reps at/above quota
60–70%
Advertisement
Advertisement

Capacity is not headcount

Ten AEs are not ten quotas. A rep hired this quarter produces a fraction of quota next quarter and full quota only after the ramp period. Planning on headcount rather than capacity is the most common reason a sales hiring plan misses its number by 30%.

The model converts each hire into a "productive AE equivalent" — a rep nine months in counts as roughly 0.9, one three months in counts as 0.5. Summed across the team, that gives the capacity the plan actually delivers, which is the number to compare against the target.

Productive AE equivalentlive formula
Productivity(months in seat) = min(1, months ÷ ramp months)
Productive AE equivalent      = Σ productivity across the team

Capacity ARR = productive AEs × quota × attainment %
Gap          = required ARR − capacity ARR
The workbook builds this quarter by quarter so you can see the quarter where capacity finally catches the target — or does not.

Plan at attainment you have actually observed

Quota attainment percentages are best treated as data, not aspiration. If your team has historically attained 78% of quota, planning at 100% builds a plan that is 22% short before anyone is hired. The discipline is to plan at observed attainment and manage the improvement separately.

The corollary matters for plan design: if you set quotas so that 60–70% of reps reach them, observed attainment across the team will be near 100% in aggregate. If everyone misses, the quota is not a target, it is a fiction that destroys morale and forecasting credibility.

Attainment planning reference
Observed attainmentInterpretationPlanning action
> 100%Quota too lowRaise quota; expect accelerator cost to rise
90–100%Well calibratedPlan at observed attainment
75–90%ChallengingPlan below quota; fix enablement
< 75%Quota unrealistic or pipeline shortReplan territory and coverage first
Advertisement

Pipeline coverage: the constraint behind the capacity

Sales capacity is useless without pipeline. Coverage ratio is pipeline value divided by the quota it must support, and the planning standard is three to four times. Below three, reps spend their time prospecting instead of closing and attainment falls regardless of talent.

Coverage requirements cascade backwards through the funnel: to close $6M at a 22% win rate you need $27M of qualified pipeline, which at a 45% SQL conversion is $61M of meetings-sourced opportunity, which at $24,000 ACV is roughly 1,130 meetings. Divide by SDR productivity and you have your SDR headcount requirement.

  • Coverage of 3–4x quota is the planning standard; below 3x attainment becomes unpredictable.
  • Model the funnel backwards from the ARR target to derive activity requirements per rep.
  • A sales cycle of 75 days means pipeline created now closes next quarter — plan with the lag.
  • If SDR headcount cannot be funded, the AE plan must be reduced to match.

What the capacity costs

Every AE carries a fully loaded cost of roughly $145,000 in base plus $65,000 of expected variable compensation at quota, before the SDR and management layer that supports them. The relevant metric is cost per ARR dollar: total sales capacity cost divided by the ARR it produces. Under $1.00 is the planning threshold; above it, the go-to-market model is not economically viable at that price point.

This is the calculation that determines whether a product can be sold with a field sales team at all. Below roughly $5,000 ACV, the cost of a human-led sales motion usually exceeds the revenue it generates, and the business needs a self-serve or product-led model instead.

  • Fully loaded AE cost: roughly $210,000 including variable at quota.
  • Add SDR cost and management overhead — typically 40–60% on top of the AE layer.
  • Cost per ARR dollar under $1.00 is the threshold for a viable sales-led motion.
  • Below $5,000 ACV, model a self-serve motion instead of adding reps.

How to use this tool

  1. Enter the ARR target and unit economics. Target ARR, ACV, win rate and SQL conversion. These determine both the capacity required and the pipeline that must feed it.
  2. Set quota and attainment. Use the quota you intend to assign and the attainment your team has actually observed, not the attainment you hope for.
  3. Model the ramp. Enter ramp months, current ramped AEs and hires per quarter. The matrix converts hires into productive equivalents quarter by quarter.
  4. Download and check the cost per ARR dollar. The workbook reports the hiring gap, the SDR requirement and the fully loaded cost per dollar of ARR, so you can see whether the plan is fundable and whether the motion itself is viable.

What is inside the download

A quarter-by-quarter ramp matrix that converts hires into productive capacity, a funnel ratios tab that derives the pipeline coverage an ARR target requires, and an output sheet that converts capacity into a cost per ARR dollar.

  • AE Ramp-up Matrix — a separate worksheet in sales-capacity-model.xlsx.
  • Pipeline Funnel Ratios — a separate worksheet in sales-capacity-model.xlsx.
  • Revenue Capacity Output — a separate worksheet in sales-capacity-model.xlsx.

Where these defaults come from

Every pre-filled value in the calculator above is listed below with its basis. None of it is proprietary to us — we do not run primary research. Statutory figures come from the regulator, fee schedules from the vendor that charges them, ranges from published industry surveys, and conventions are labelled as rules of thumb. When you have your own numbers, replace the default: the workbook formulas do not care where an input came from.

DefaultValue usedBasisSource
AE ramp to full productivityTransactional sales 3–4 months, mid-market 4–6, enterprise 6–9. Ramp timing is the main driver of hiring-plan accuracy.3–6 monthsMarket surveyBenchmarkitSaaS metrics benchmarksOpen source
Pipeline coverage ratioBelow 3x, reps prospect instead of closing and attainment becomes erratic.3–4x quotaRule of thumbNo authoritative source — industry convention
Share of reps at or above quotaHigher means quotas are too low; lower means they are unrealistic. A diagnostic, not a target to force.60–70%Rule of thumbNo authoritative source — industry convention
Sales cost of salesBase plus commission divided by credited revenue. Above 12% usually means the quota is miscalibrated.< 12% of credited salesMarket surveyBenchmarkitSaaS metrics benchmarksOpen source

Full source registry, verification status and review cadence: data sources & methodology.

Frequently asked questions

Convert each rep into a productive AE equivalent based on how far through the ramp they are, sum across the team, multiply by quota, then apply your observed attainment percentage. The result is capacity ARR, which you compare against the target to find the gap and the additional hires required.

Software that pairs with this model

These are the platforms our models are designed to work alongside, chosen because their pricing or data appears in the model itself. Some links are affiliate links — they cost you nothing, and they never influence a formula, a default value or a result.

Related models