Calculator Inputs
Example Data Table
Use this sample scenario to understand how a quota plan can be distributed across mixed-tenure sellers.
| Scenario | Team Target | Ramped Reps | New Hires | Ramp % | Coverage | Win Rate |
|---|---|---|---|---|---|---|
| Quarter Plan A | $1,200,000 | 6 | 2 | 45% | 3.2x | 24% |
| Quarter Plan B | $950,000 | 5 | 1 | 60% | 3.0x | 28% |
| Quarter Plan C | $1,500,000 | 8 | 3 | 40% | 3.5x | 22% |
Formula Used
Effective Capacity = Fully Ramped Reps + (New Hires × Ramp Productivity)
Capacity-Adjusted Goal = Team Target × Seasonality Factor × (1 + Stretch Buffer) × Territory Adjustment
Net Assignable Quota = Capacity-Adjusted Goal − Manager Reserved Revenue
Gross Quota Required = Net Assignable Quota ÷ Attainment Target
Required Pipeline = Gross Quota Required × Pipeline Coverage Ratio
These formulas help planners distribute targets fairly, reflect partial productivity from ramping reps, and estimate pipeline volume needed to support bookings.
How to Use This Calculator
- Enter the overall revenue target for the planning period.
- Add the number of fully productive reps and incoming hires.
- Set the expected productivity level for new hires.
- Adjust attainment, coverage, seasonality, and territory assumptions.
- Include reserve revenue, average deal size, and win rate inputs.
- Click the calculate button to show the result above the form.
- Use CSV or PDF export to share the output with stakeholders.
Frequently Asked Questions
1. What does this calculator estimate?
It estimates team quota allocation, effective selling capacity, required pipeline value, average seller burden, and opportunity volume needed for a period.
2. Why include ramp productivity?
New hires rarely perform like experienced reps immediately. Ramp productivity converts them into partial capacity so quota distribution stays more realistic.
3. What is attainment target?
Attainment target is the expected percentage of quota the team will actually achieve. Lower attainment means gross assigned quota must be higher.
4. Why use a pipeline coverage ratio?
Coverage ratio links quota to pipeline demand. If your process needs 3x coverage, the team should build three dollars of pipeline for each dollar of quota.
5. What is manager reserved revenue?
It captures revenue not assigned to individual reps, such as house accounts, partner-sourced deals, renewals, or executive-managed strategic business.
6. How does seasonality affect quota?
Seasonality increases or decreases the planning target based on strong or weak periods. It helps quota reflect expected market timing.
7. Can I use this for monthly or quarterly planning?
Yes. The model works for monthly, quarterly, or annual planning as long as all assumptions, targets, and working days match the same period.
8. Does this replace detailed territory planning?
No. It supports high-level quota planning. Territory potential, account distribution, segment mix, and compensation rules still need separate review.