Business
Sales Capacity Planning Calculator
Estimate effective representatives, gross quota capacity, attainment-adjusted capacity, attrition loss, and net annual revenue capacity. Review a capacity-loss visual, planning examples, caveats, and a professional report.
Productivity-adjusted rep capacity-
Gross annual quota capacity-
Capacity after expected attainment-
Annualized capacity loss from attrition-
Net annual revenue capacity-
Net capacity per total named rep-
Decision view
Named reps to net revenue capacity
Named reps to net revenue capacityRamp productivity, attainment, and attrition remain separate capacity adjustments.
Net capacity and attrition drag by hiring scenarioNew-representative count changes across the exact scenarios; net revenue capacity and the annualized attrition loss remain separate monetary series.
Exact scenario comparisonNew representatives in ramp changes while all other entered assumptions remain constant.
| New representatives in ramp | Productivity-adjusted rep capacity | Gross annual quota capacity | Capacity after expected attainment | Annualized capacity loss from attrition | Net annual revenue capacity | Net capacity per total named rep |
|---|
Period-by-period detail
Rep capacity and attrition ledger
How to use Sales Capacity Planning Calculator
- Enter fully ramped and ramping representative counts.
- Estimate average ramp productivity for the planning period.
- Apply a realistic attainment rate to gross quota capacity.
- Deduct attrition capacity and compare net capacity with the revenue plan.
Calculator guide
Understanding Sales Capacity Planning Calculator
Sales capacity planning translates named representatives into productivity-adjusted selling capacity. Ramping representatives, expected attainment, and attrition are distinct deductions, so headcount alone does not describe attainable revenue.
Calculation method
How the calculation works
Convert ramping representatives into effective capacity, apply expected attainment, and separately deduct an annualized attrition capacity loss. New representatives are multiplied by their average productivity and added to fully ramped representatives. Effective reps times annual quota gives gross quota capacity; attainment is applied before the annualized capacity loss from attrition is deducted.
Hiring decision
Separate capacity creation from hiring volume
A hiring plan should explain when capacity becomes productive and what enables it.
Worked situations
Practical examples
- Six new reps at 45% productivity add only 2.7 effective reps.
- An 82% attainment assumption reduces gross quota capacity before attrition.
- Hiring more representatives may not close a gap if ramp time extends beyond the plan.
Better inputs
Useful tips
- Model start dates by cohort when hiring is uneven.
- Use quota attainment from comparable territories and tenures.
- Check manager, lead, and territory capacity before adding headcount.
Before relying on the result
Limitations and common mistakes
- The model uses an average ramp productivity instead of a monthly cohort curve.
- Attrition loss is annualized and does not schedule replacement timing.
- Territory quality, lead supply, seasonality, vacancies, and over-assignment are excluded.
Reference
Key terms
- Effective reps
- Fully ramped reps plus productivity-adjusted new reps.
- Quota capacity
- Effective reps multiplied by quota.
- Attainment
- Expected share of assigned quota achieved.
- Attrition loss
- Annualized revenue capacity removed by expected departures.
Important note
Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.
Frequently asked questions
Why use effective reps?
It prevents a newly hired representative from being counted as fully productive immediately.
Is quota capacity the same as forecast revenue?
No. Attainment and attrition reduce theoretical quota capacity.
How should new-rep productivity be estimated?
Use the average productive share expected during the planning period from historical ramp cohorts.
Does attrition include new reps?
This simplified formula applies attrition to fully ramped reps; a cohort schedule is needed for more detail.