By Siddharth GangalA sales quota calculator should expose the assumptions between a finance target and a rep number. This one converts the quota-bearing target, planning attainment, productive capacity, ramp, OTE, and pay mix into a scenario you can reproduce. It does not claim that one attainment rate or quota-to-OTE ratio fits every business.
Direct answer. Required issued quota equals quota-bearing team target divided by planned attainment. Full-capacity quota equals required issued quota divided by effective rep-years. Effective rep-years equal full-year reps plus ramp hires multiplied by productive months divided by 12. Then test expected yield, capacity gap, quota-to-OTE, and the implied target-variable rate before assigning rep quotas.
This page owns the calculation artifact. Use sales quota setting to choose a planning method, quota distribution to account for different territories, and quota management for operating cadence.
Calculate a capacity-adjusted sales quota
Enter one scenario at a time. Use the same currency and annual period throughout. “Productive months” means months in which a ramp hire carries the modeled full-capacity equivalent; use a weighted ramp factor outside this simple calculator when monthly ramp is gradual.
Quota-bearing target: —
Effective rep-years: —
Required issued quota: —
Required quota per effective rep: —
Proposed plan expected yield: —
Proposed plan capacity gap: —
Proposed quota-to-OTE: —
Target variable rate: —
This is a planning aid, not legal, employment, tax, accounting, or compensation advice. Review the final plan with finance, HR, legal, and affected sales leaders.
Understand every formula
- Quota-bearing target = annual team target − revenue outside rep quotas. Outside revenue might include a channel, self-serve, services, renewals, or another team only when finance confirms it is genuinely outside this quota pool.
- Effective rep-years = full-year productive reps + (ramp hires × productive months ÷ 12). Two hires with six productive months each add one effective rep-year.
- Required issued quota = quota-bearing target ÷ planned attainment. At 75% planning attainment, a $5.4M target requires $7.2M of issued quota in this simplified scenario.
- Required quota per effective rep = required issued quota ÷ effective rep-years. This is a capacity baseline, not the final quota for every territory.
- Expected yield = proposed quota × effective rep-years × planned attainment. Capacity gap equals expected yield minus quota-bearing target.
- Quota-to-OTE = proposed quota ÷ annual OTE. Target variable rate = (OTE × variable share) ÷ proposed quota. Both are disclosed outputs, not universal recommendations.
Salesforce’s official forecast quota documentation defines a quota as a monthly or quarterly goal assigned to a user or territory and allows revenue, quantity, or custom measures. Freeze the measure before calculating; bookings, ARR, units, and gross profit are not interchangeable.
Define the inputs before trusting the output
The arithmetic is deterministic; the inputs are judgments. Write an owner, source, snapshot date, and approval state beside every input. The team target should reconcile to the finance plan. Outside revenue needs an explicit owner so it is not counted twice. Planned attainment should use a comparable cohort and reflect material changes in product, pricing, territory, staffing, and market conditions.
Headcount is not capacity. Exclude vacant seats and distinguish full-year productive reps from hires whose start date, onboarding, sales cycle, or territory creation limits productive months. Xactly’s capacity and quota planning overview explicitly includes ramp times, seasonality, historical performance, headcount changes, what-if scenarios, and monthly forecasts. Its product claims are not an independent benchmark, but the input categories are useful audit prompts.
OTE means annual base salary plus annual commission at 100% of quota, according to QuotaPath’s OTE definition. Enter annual OTE and the variable share approved for this role. Do not enter the maximum possible earnings under accelerators.
Work through two quota examples
Example A: six productive reps and two ramp hires. The annual target is $6.0M, of which $0.6M belongs outside the AE quota pool, leaving $5.4M. Six full-year reps plus two hires with six productive months each produce 7.0 effective rep-years. At a 75% planning-attainment assumption, required issued quota is $5.4M ÷ 0.75 = $7.2M. The capacity baseline is $7.2M ÷ 7.0 = $1.029M per effective rep-year.
If leadership proposes a $1.05M full-capacity quota, expected yield is $1.05M × 7.0 × 0.75 = $5.5125M, a positive $112,500 scenario gap. With $200,000 OTE and a 50% variable share, quota-to-OTE is 5.25× and target variable pay is $100,000. The implied target-variable rate is $100,000 ÷ $1.05M = 9.52%. Those ratios describe the proposal; they do not prove it is attainable or compliant.
Example B: do not confuse seats with capacity. A $3.0M quota-bearing target, 80% planning attainment, four full-year reps, and two hires with only three productive months gives 4.5 effective rep-years—not six. Required issued quota is $3.0M ÷ 0.80 = $3.75M, and the capacity baseline is $833,333 per effective rep-year. Dividing by six seats would show $625,000 and quietly create a $937,500 issued-quota shortfall.
Pressure-test capacity, attainment, and OTE
Run at least three scenarios: the approved plan case, a lower-attainment case, and a slower-hiring or ramp case. Do not relabel the optimistic case as “base” merely because it closes the finance gap. The calculator’s capacity gap is a signal to revisit strategy, staffing, territory, price, productivity, or target—not permission to inflate individual quotas.
| Constraint | Test | Failure response |
|---|---|---|
| Attainment | Is the cohort comparable by role, segment, tenure, and period? | Segment the assumption and show sensitivity. |
| Ramp | Do start date, onboarding, cycle length, and territory readiness support productive months? | Use monthly capacity weights instead of a single fraction. |
| OTE | Are base, target variable, quota measure, and credit timing defined consistently? | Return to compensation design before publishing. |
| Territory | Can assigned accounts plausibly support the proposed quota? | Rebalance capacity or target; do not hide it in a team average. |
| Seasonality | Does the annual allocation match customer buying and implementation patterns? | Allocate by approved monthly or quarterly weights. |
For role feasibility beyond this team-level model, use the AE quota guide. It adds territory, cycle, and pipeline questions that a calculator cannot settle.
Move from team math to rep quotas
Do not assign the calculated average equally by default. First allocate the annual team requirement by segment, role, territory, and period. Apply explicit ramp weights. Confirm that each owner has the corresponding account or activity capacity. Then sum every owner-period cell back to required issued quota.
Salesforce says quotas align sales effort with broader objectives and recommends ongoing attainment review in its sales quota guidance. Store the approved owner, territory, measure, currency, and period with each quota. If a manager’s number includes the team, document whether it is a reporting rollup or additional quota so it is not double-counted.
Reconcile the plan before publication
- Finance: team target, excluded revenue, currency, measure, and fiscal periods equal the approved operating plan.
- People plan: start dates, attrition assumptions, leaves, vacancies, and ramp weights equal the approved headcount model.
- Territory plan: every rep quota has enough defined market capacity and one accountable owner.
- Compensation plan: OTE, pay mix, crediting, thresholds, accelerators, splits, timing, and exceptions use the same quota measure.
- CRM: rep-period quota rows sum to the signed allocation; manager and overlay records do not double-count the pool.
- Scenario archive: inputs, formulas, version, approvals, and changes are preserved so the number can be reproduced.
After launch, use quota attainment rate with frozen numerator and denominator rules. A miss does not diagnose its own cause; separate capacity, territory, skill, execution, product, and market evidence.
Apply governance and compensation guardrails
This calculator does not design a complete commission plan. The sales commission structure guide covers the adjacent design job. Have qualified owners review wage, employment, tax, disclosure, clawback, leave, termination, and local requirements. Provide reps a readable plan document and a route to resolve errors.
Define change control before the year begins: which events permit a quota review, who approves a change, whether it is prospective, how pipeline and credits transfer, and how the CRM record is corrected. Do not quietly change the attainment denominator after results are known. Preserve the original plan and an effective-dated amendment.
Finally, guard against false precision. A quota printed to the dollar can still rest on uncertain hiring and attainment assumptions. Round only after reconciliation, show sensitivity, and make the key assumptions visible beside the result.
Copy the quota-planning record
PLAN: version ___ · owner ___ · fiscal period ___ · currency ___ · quota measure ___ · snapshot date ___.
TARGET: team target ___ − outside revenue ___ = quota-bearing target ___.
ATTAINMENT: assumption ___ · cohort/period ___ · source ___ · sensitivity cases ___.
CAPACITY: full-year reps ___ + ramp hires ___ × productive months ___ ÷ 12 = effective rep-years ___.
QUOTA: target ___ ÷ attainment ___ = required issued quota ___; ÷ effective rep-years ___ = baseline ___.
PROPOSAL: full-capacity quota ___ × capacity ___ × attainment ___ = expected yield ___; gap ___.
OTE: annual OTE ___ · variable share ___ · quota-to-OTE ___ · target variable rate ___.
RECONCILIATION: finance ___ · headcount/ramp ___ · territory ___ · compensation ___ · CRM sum ___.
APPROVAL: sales ___ · RevOps ___ · finance ___ · people/legal as required ___ · effective date ___.
Attach the input sources, monthly allocation, owner-level quota file, compensation-plan reference, and approval record. That package—not the calculator result alone—is the auditable quota plan.