| Month | Qualified | Proposal | Negotiation | Seasonality | Growth | Forecast |
|---|---|---|---|---|---|---|
| 2026-01 | 18,000 @ 10% | 22,000 @ 30% | 12,000 @ 60% | 0.95 | 2% | 11,742 |
| 2026-02 | 20,000 @ 10% | 20,000 @ 30% | 10,000 @ 60% | 1.00 | 3% | 11,330 |
| 2026-03 | 24,000 @ 12% | 26,000 @ 35% | 14,000 @ 65% | 1.10 | 3% | 17,336 |
- Stage‑weighted pipeline = Σ(stage_value × stage_probability)
- Pipeline forecast = pipeline × win_rate × seasonality × (1 + growth)
- Historical moving average = (M1 + M2 + M3) / 3
- Historical forecast = moving_average × seasonality × (1 + growth)
- Capacity ceiling = avg_deal_size × sales_reps × rep_capacity
- Final forecast = min(max(raw, floor), capacity_ceiling)
- Select the forecast month and currency for reporting.
- Choose a forecasting method: pipeline or historical average.
- For pipeline, enable stage weighting to model funnel reality.
- Set seasonality and growth to reflect your current motion.
- Enter capacity inputs to avoid overcommitting in planning.
- Click Calculate, then export CSV or PDF for stakeholders.
Pipeline quality metrics
A reliable monthly forecast starts with measurable pipeline health. Track coverage ratio, stage conversion, and average cycle time by segment. For example, 3.0× coverage with 25% close rate implies 0.75× expected attainment before seasonality. If qualification-to-proposal conversion rises from 28% to 34%, the weighted pipeline increases even when total value stays flat. Also monitor average deal size to detect pricing or mix shifts.
Stage-weighted forecasting
Stage weighting reduces optimism by applying probabilities to each funnel stage. If Qualification is 20,000 at 10%, Proposal is 20,000 at 30%, and Negotiation is 10,000 at 60%, expected value is 2,000 + 6,000 + 6,000 = 14,000. Applying a seasonality factor of 1.10 and growth of 3% produces 14,000 × 1.10 × 1.03 = 15,862.
Historical baseline comparison
Use a three‑month moving average to anchor your pipeline view. With recent sales of 42,000, 38,000, and 45,000, the baseline is 41,667. If seasonality is 0.95 and growth is 3%, the adjusted baseline becomes 41,667 × 0.95 × 1.03 = 40,734. Comparing pipeline and baseline highlights risk when pipeline expected value falls materially below run‑rate.
Seasonality and growth controls
Seasonality should reflect recurring patterns such as renewals, budget cycles, and holidays. A factor of 0.90 models a lighter month, while 1.15 models peak demand. Growth captures strategic change: added marketing, pricing, or new territories. Keep growth modest; moving from 3% to 8% on a 50,000 pipeline lifts the projection by 2,500, which should be justified by leading indicators.
Capacity-based ceiling
Forecasts must respect delivery capacity. This calculator estimates a ceiling using average deal size × active reps × deals per rep. With 2,500 average deal size, 3 reps, and 12 deals per rep, the ceiling is 90,000. If your calculated forecast is 110,000, the cap prevents overcommitting and flags the need for more coverage, higher ASP, or additional headcount.
Operational use in CRM reviews
Use the result card during weekly pipeline reviews. Update stage values, probabilities, and seasonality as new information arrives. Export CSV for finance, and PDF for leadership updates. Track variances: if final forecast misses by more than 10%, inspect which stage probability or capacity assumption drifted. Over time, refine default probabilities per segment to improve accuracy and confidence.
1) Should I use pipeline or historical forecasting?
Use pipeline when your CRM data is current and stages are well maintained. Use historical when pipeline is thin or volatile. Comparing both helps detect over-optimism or under-coverage quickly.
2) What probabilities should I assign to stages?
Start with your observed conversion rates by stage and segment, then revise monthly. If qualification-to-close averages 12% for SMB, set Qualification near that range and increase probabilities only with verified signals.
3) How do I choose a seasonality factor?
Review the last 12–24 months and compare each month to your average. If April typically runs 10% above average, use 1.10. Keep a note of one-off events that should not repeat.
4) Why does the calculator cap my forecast?
The capacity ceiling prevents plans that exceed sales throughput. If the cap triggers, adjust coverage, increase average deal size, improve conversion, or add selling capacity. It’s a planning guardrail, not a ceiling on demand.
5) What does “minimum forecast floor” do?
It sets a conservative lower bound to avoid extreme dips caused by incomplete pipeline entry or temporary reporting gaps. Use it for budgeting stability, then validate with weekly pipeline updates.
6) How often should I export reports?
Export weekly for pipeline reviews and monthly for finance closes. Use CSV for analysis and PDF for leadership summaries. Consistent exports make variance analysis easier and improve probability calibration over time.