Why You Missed Your Sales Forecast: Price and Volume Variance Analysis

By Pete Furseth

The quarter ended. How was your forecast?

During the first week of every quarter, sales leaders huddle together to make a sales forecast for the next three months. The problem is that 80% of businesses end up missing their forecast by more than 10%, according to Forrester. That means most of us will miss it.

To improve our forecasts, we need to understand how and why we missed them. Not just "we were short by $100K" but specifically which factors drove the miss. A price and volume variance analysis provides exactly this level of detail.

This technique is borrowed from cost accounting, where it is used to manage operations and plan for the future. It works just as well for sales forecasting. The three factors to consider are: Average Sale Price (ASP), the number of deals decided in the quarter (win or loss), and the win rate.

The Formulas

Price Variance

The difference in forecasted sales and actual sales due to a change in ASP:

Price Variance = (Actual ASP - Forecast ASP) x Actual Wins

Volume Variance

The difference in forecasted sales and actual sales due to having more or fewer won deals than expected. Volume variance is a function of both the total number of deals decided and the win rate:

Volume Variance = (Actual Wins - Forecast Wins) x Forecast ASP

This can be further decomposed into:

Deal Variance = (Actual Deals - Forecast Deals) x Forecast Win Rate x Forecast ASP Win Rate Variance = (Actual Win Rate - Forecast Win Rate) x Actual Deals x Forecast ASP

Deal variance tells you whether the issue was pipeline generation. Win rate variance tells you whether the issue was conversion. These are two fundamentally different problems with different solutions.

A Worked Example

Let us walk through a concrete scenario.

	Deals	Win Rate	Average Price	Total Value
Forecast	100	60%	$10,000	$600,000
Actual	110	50%	$9,000	$495,000
Delta	+10	-10%	-$1,000	-$105,000

Now the variance calculations:

	Calculation	Result	% of Forecast
Total Variance	$495,000 - $600,000	-$105,000	-17.5%
Price Variance	($9,000 - $10,000) x 55 Wins	-$55,000	-9.2%
Volume Variance	(55 Wins - 60 Wins) x $10,000	-$50,000	-8.3%
Deal Variance	(110 - 100) x 60% x $10,000	+$60,000
Win Rate Variance	(50% - 60%) x 110 x $10,000	-$110,000

What This Tells Us

9.2% of the forecast missed because of a lower-than-expected ASP. Another 8.3% missed due to not winning enough deals.

The volume variance is the more interesting story. The pipeline actually had more deals than expected, which should have produced a positive variance of $60,000. But the win rate was 10 percentage points lower than expected, creating a negative impact of $110,000 that completely reversed the benefit of the additional pipeline.

This distinction matters enormously for what you do next.

Diagnosing and Fixing Price Variance

When the forecast misses due to price variance, the usual culprits are:

End-of-quarter discounting. Reps discount deals to get buyers to close before the deadline. This is typical behavior in many sales organizations. The fix is better deal qualification earlier in the cycle and pricing discipline enforced through approval workflows. Qualifying smaller deals. Your sales and marketing teams are bringing in deals that are smaller than the model assumes. This shifts your ASP downward. The fix is to specify deal size thresholds in your qualification criteria and track average deal size as a leading indicator. Market pressure. Sometimes competitive dynamics force prices down. This is harder to fix operationally, but you should adjust your forecast ASP to reflect market reality rather than historical pricing.

Diagnosing and Fixing Volume Variance

Volume variance breaks into two distinct problems:

Not enough deals (negative deal variance). This means your pipeline generation is falling short. The solution is typically to increase marketing activity, invest in outbound prospecting, or improve lead-to-opportunity conversion rates. This is a top-of-funnel problem. Low win rate (negative win rate variance). This means your team had enough at-bats but did not convert. The root causes include poor deal qualification (letting bad deals into the pipeline), sales rep turnover and training gaps, competitive losses, or a genuine market shift. Each requires a different response.

In our example, the deal variance was actually positive. The team generated more pipeline than expected. The entire miss came from win rate degradation. That is a clear signal to investigate conversion quality, not pipeline volume.

Applying This to Your Team

Here is a practical quarterly workflow:

1. Record your forecast inputs on Day 1: expected deals, expected win rate, expected ASP 2. Run the variance analysis as soon as the quarter closes 3. Identify the dominant variance type: price, deal count, or win rate 4. Drill into root causes using CRM data and rep conversations 5. Adjust next quarter's forecast to reflect what you learned 6. Track trends over multiple quarters to spot systemic issues

Over time, this analysis will reveal patterns. Maybe your win rate drops every Q4 as buyers defer decisions. Maybe your ASP decreases in quarters where you run promotional campaigns. These patterns should inform your forecast accuracy adjustments going forward.

For more on building a comprehensive forecasting process, including ensemble techniques that reduce overall forecast error, see our sales forecasting guide.

The Bottom Line

Saying "we missed by 17%" tells you nothing actionable. Saying "we missed 9% on price because reps discounted to close, and 8% on volume because win rate dropped 10 points despite strong pipeline generation" tells you exactly what to fix.

Price and volume variance analysis turns a vague disappointment into a specific action plan. Start using it this quarter.