| Rep | Quota | Closed | Pipeline | Win Rate | Days Elapsed |
|---|---|---|---|---|---|
| Ayesha | $120,000 | $46,000 | $160,000 | 28% | 35 |
| Hassan | $100,000 | $30,000 | $110,000 | 22% | 35 |
| Sara | $90,000 | $41,500 | $95,000 | 30% | 35 |
| Bilal | $110,000 | $38,000 | $140,000 | 24% | 35 |
- Attainment (%) = (Closed Revenue / Quota) * 100
- Current Velocity = Closed Revenue / Days Elapsed
- Remaining Quota = max(Quota - Closed Revenue, 0)
- Required Velocity = Remaining Quota / Remaining Days
- Weighted Pipeline = Pipeline Value * (Win Rate / 100)
- Projected Total = Closed Revenue + Weighted Pipeline
- Pipeline Coverage = Pipeline Value / Remaining Quota
- Pace Index = Attainment% / Time Elapsed%
- Enter quota, closed revenue, and days elapsed for your period.
- Add pipeline value and win rate to estimate likely conversions.
- Review required velocity and forecast gap to see urgency.
- If you know average deal size, use deal planning outputs.
- Export results to CSV or PDF for weekly reviews.
Quota pace vs time elapsed
Quota velocity compares what you have closed to how much of the period has passed. If 40% of the quarter is complete, attainment near 40% is typically on pace. A pace index above 1.0 indicates you are ahead; below 1.0 signals a catch-up requirement. Tracking this weekly reduces end-of-period surprises and makes performance conversations objective.
Daily run-rate needed to finish
Required velocity converts remaining quota into a per-day target. For example, a $60,000 gap with 30 days left needs $2,000 per day. When required velocity is 30% higher than current velocity, most teams must either increase pipeline creation, raise conversion probability, or prioritize larger deals. This metric is a clean urgency signal.
Weighted pipeline and forecast quality
Weighted pipeline applies win rate to open pipeline, producing an expected value forecast. A $200,000 pipeline with a 25% win rate yields a $50,000 weighted figure. Compare projected attainment to quota to see if the pipeline is sufficient. If projections rely on unrealistic win rates, forecasts become fragile, so align win rate with recent historical performance.
Coverage ratio to protect outcomes
Coverage ratio is pipeline divided by remaining quota. Many revenue teams use 3.0x as a starting point, but the right level depends on deal size, stage hygiene, and seasonality. If coverage is 1.5x and stages are early, the team usually needs more top-of-funnel activity. If coverage is 4.0x with late-stage deals, execution becomes the focus.
Deal count planning with average deal size
When average deal size is known, the calculator converts quota into an estimated number of deals. A remaining $75,000 gap with a $5,000 average deal implies about 15 deals. Splitting this across five reps suggests three deals per rep. This helps managers set activity targets, identify who needs help, and balance effort across segments.
Sales-cycle risk and timing constraints
Even with strong pipeline, long cycle times can reduce what closes within the period. If the average cycle is 60 days and only 25 days remain, pipeline created today is unlikely to land in time. Use the cycle note as a timing check and prioritize opportunities already in later stages. Combining timing with velocity creates a practical weekly operating cadence.
1) What is quota velocity?
Quota velocity is the rate of revenue progress toward a target over time. It highlights whether current closed revenue is keeping pace with the period’s elapsed time and remaining requirement.
2) What does the pace index mean?
Pace index is attainment percent divided by time-elapsed percent. A value near 1.0 is on pace, above 1.0 is ahead, and below 1.0 indicates you must accelerate to hit quota.
3) How is weighted pipeline calculated?
Weighted pipeline equals open pipeline value multiplied by win rate. It estimates expected conversions and supports a simple forecast, but it depends on win rate quality and clean pipeline stages.
4) What pipeline coverage should I target?
Many teams start around 3x coverage, but your ideal depends on stage mix, cycle length, and conversion reliability. Use historical results to set coverage thresholds by segment and period.
5) Why can forecast still miss quota with high pipeline?
High pipeline can be misleading if win rate is overstated, opportunities are early-stage, or sales cycle exceeds remaining time. Review stage aging, next steps, and late-stage quality weekly.
6) How often should I update inputs?
Weekly updates are common for leadership reviews, while fast-moving teams update twice per week. Consistent cadence matters more than frequency, because trends reveal whether actions improve velocity.