CRO · Framework · Intermediate · Saves 30+ hours
Forecast Variance Analysis
A framework for analyzing forecast variance and improving accuracy.
What's included
- Variance calculation methodology
- Root cause categories
- Analysis process
- Improvement recommendations
- Tracking and trending
Best used when
- Analyzing forecast misses
- Improving forecast accuracy
- Post-quarter reviews
- Coaching on forecasting
The template
The Template
VARIANCE CALCULATION
Variance Analysis Framework
FORECAST VARIANCE ANALYSIS
PERIOD: Q___
OVERALL VARIANCE:
Forecast: $_____
Actual: $_____
Variance: $_____ (___%)
VARIANCE BREAKDOWN:
Commit variance: $_____
Best case variance: $_____
Upside variance: $_____
VARIANCE SOURCES:
Deals closed higher: +$_____
Deals closed lower: -$_____
Slipped to next Q: -$_____
Lost (forecasted): -$_____
Pull-ins (not forecast): +$_____
NET IMPACT: $_____
Variance by Category
| Category | Forecast | Actual | Variance | Accuracy |
|---|---|---|---|---|
| Commit | $ | $ | $ | % |
| Best Case | $ | $ | $ | % |
| Pipeline | $ | $ | $ | % |
| Total | $ | $ | $ | % |
ROOT CAUSE ANALYSIS
Variance Root Causes
ROOT CAUSE CATEGORIES
OVER-FORECAST CAUSES:
☐ Sandbagging by reps
☐ Conservative managers
☐ Pull-ins not expected
☐ Larger deal sizes
UNDER-FORECAST CAUSES:
☐ Optimistic reps
☐ Slippage underestimated
☐ Competitive losses
☐ Budget issues
☐ Champion departures
SYSTEMIC CAUSES:
☐ Stage probability wrong
☐ Win rate declining
☐ Cycle lengthening
☐ New market dynamics
PRIMARY CAUSE: _______________
CORRECTIVE ACTION: _______________
Improvement Tracking
| Quarter | Accuracy | Bias | Root Cause | Action Taken |
|---|---|---|---|---|
| Q-3 | % | Over/Under | ||
| Q-2 | % | Over/Under | ||
| Q-1 | % | Over/Under | ||
| Current | % | Over/Under |
Frequently asked questions
What is the Forecast Variance Analysis?
A framework for analyzing forecast variance and improving accuracy.
Who is the Forecast Variance Analysis for?
It is built for CROs and their teams working on Pipeline & Forecasting. The AI coach adapts it to your company, stage, and goals.
How long does the Forecast Variance Analysis take to use?
It saves roughly 30+ hours versus building from scratch. Our AI coach can tailor the framework to your situation in minutes, then hand you a step-by-step plan.
Is the Forecast Variance Analysis free?
Yes. You can read the full framework and start getting coached through it for free. Sign in to save your tailored version and track your next steps.
How does the AI coach help with the Forecast Variance Analysis?
The coach teaches you the framework, asks a few questions about your business, tailors the framework to you, and gives you measurable next steps to execute.