How to Calculate Price, Volume, and Mix Variances Without Fooling Yourself

I have a question whenever someone tells me revenue increased 12%.

What actually increased?

Did we sell more?

Did we charge more?

Did customers buy different products?

Or did we sell a tremendous amount of something that barely makes us any money?

Because those are four very different conversations.

And yet, somehow, they frequently end up on the same PowerPoint slide with a green arrow and the words strong revenue performance.

Lovely.

Now I’d like to know what happened.

That’s where price-volume-mix analysis comes in. It’s one of my favorite ways to take a revenue number apart and figure out whether the business actually did something worth celebrating.

The calculations aren’t particularly frightening.

The conclusions can be.

What Is Price-Volume-Mix Analysis?

Price-volume-mix analysis, often called PVM analysis, explains why revenue changed between two periods or between budget and actual results.

It separates the change into three drivers:

• Price: Did we charge more or less for what we sold?
• Volume: Did we sell more or fewer units overall?
• Mix: Did customers buy a different combination of products or services?

The point is to reconcile the total revenue change to those underlying drivers.

Then comes the part I care about.

What should management do with that information?

Because knowing revenue increased $100,000 is useful.

Knowing it increased because customers bought more of your least profitable product is considerably more useful.

Especially before someone decides to double the sales incentive.

Let’s Start With a Business That Looks Like It’s Doing Great

Imagine a company selling two products.

Product A is a premium offering. Product B is a more affordable alternative.

For simplicity, we’ll assume the company sells comparable units, uses consistent revenue recognition, and hasn’t changed its product definitions between periods.

Here is the original budget.

Product	Budget units	Budget price	Budget revenue
Product A	1,000	$200	$200,000
Product B	2,000	$100	$200,000
Total	3,000		$400,000

Now the actual results arrive.

Product	Actual units	Actual price	Actual revenue
Product A	800	$210	$168,000
Product B	2,500	$95	$237,500
Total	3,300		$405,500

Revenue exceeded budget by $5,500.

That’s a 1.375% favorable variance.

Not exactly champagne-and-a-parade territory, but a beat is a beat.

Management might look at the results and conclude that sales performance was slightly better than expected.

I wouldn’t argue with the arithmetic.

I’d just like to investigate the enthusiasm.

Because something interesting happened underneath that $5,500.

Step 1: Calculate the Price Variance

The price variance measures the revenue impact of changes in realized selling prices.

For this example, I’m using actual quantities to calculate the price effect.

Price variance = (Actual price − Budget price) × Actual units

For Product A:

($210 − $200) × 800 = +$8,000

For Product B:

($95 − $100) × 2,500 = −$12,500

Total price variance:

$8,000 − $12,500 = −$4,500

Interesting.

We raised the price of our premium product, but the lower-priced product sold at a discount large enough to offset that benefit.

Overall, pricing reduced revenue by $4,500 compared with selling those actual quantities at budgeted prices.

Now I’d want to ask Sales a few questions.

Were the discounts planned?

Did a competitor change pricing?

Did customers negotiate larger orders?

Were promotions responsible?

Or did we discover that the easiest way to hit the volume target was to lower the price?

I have seen enough corporate incentive structures to know that last possibility deserves a chair at the table.

But I’m not declaring it the answer.

Not yet.

Step 2: Calculate the Total Volume Variance

Here’s where price-volume-mix analysis becomes more interesting than simply calculating each product’s quantity variance.

We sold 3,300 units instead of 3,000.

That’s 300 additional units, or 10% more volume.

To isolate the impact of selling more units without confusing it with changes in product mix, I use the original budgeted average selling price.

Budgeted average selling price:

$400,000 ÷ 3,000 = $133.33 per unit, rounded.

The volume calculation uses the unrounded value.

Total volume variance = (Actual total units − Budget total units) × Budget average selling price

(3,300 − 3,000) × ($400,000 ÷ 3,000) = +$40,000

So higher total sales volume contributed $40,000 of revenue.

That’s good news.

But before we start congratulating everyone, we need to look at what those additional sales consisted of.

Because customers didn’t buy the same combination of products we expected.

And that’s where the story changes.

Step 3: Calculate the Sales Mix Variance

Sales mix tells us how much revenue changed because customers purchased a different proportion of products.

The company originally expected one-third of its unit sales to come from Product A and two-thirds from Product B.

Actual sales looked different.

Product	Budget unit mix	Actual unit mix
Product A	33.33%	24.24%
Product B	66.67%	75.76%

We sold proportionately fewer premium products and more lower-priced products.

Think of it like a school fundraiser.

You expected everyone to buy the expensive gift baskets.

Instead, the kids sold a mountain of $5 candy bars.

Wonderful participation.

Possibly not the revenue mix we had in mind.

To calculate the mix variance, I compare each product’s actual units with the units it would have sold if the actual total volume had followed the budgeted mix.

Expected units at budget mix = Actual total units × Budget mix percentage

For Product A:

3,300 × (1,000 ÷ 3,000) = 1,100 expected units.

Actual Product A sales were only 800 units.

Mix impact:

(800 − 1,100) × $200 = −$60,000

For Product B:

3,300 × (2,000 ÷ 3,000) = 2,200 expected units.

Actual Product B sales were 2,500 units.

Mix impact:

(2,500 − 2,200) × $100 = +$30,000

Total sales mix variance:

−$60,000 + $30,000 = −$30,000

And there it is.

The company sold more units overall, but the shift toward its lower-priced product reduced revenue by $30,000 relative to what those units would have generated at the original sales mix.

This is why I don’t like stopping at volume growth.

More units can be wonderful.

They can also be a very efficient way to become busier without becoming much better off.

Step 4: Reconcile the Revenue Bridge

Now let’s put everything together.

Revenue bridge	Impact
Budget revenue	$400,000
Volume variance	+$40,000
Mix variance	−$30,000
Price variance	−$4,500
Actual revenue	$405,500

The bridge reconciles exactly.

$400,000 + $40,000 − $30,000 − $4,500 = $405,500.

No unexplained difference.

No mystery adjustment.

No little cell at the bottom labeled Other that has somehow survived six monthly closes.

I like a reconciled model.

But I don’t confuse reconciliation with understanding.

The bridge tells me how the revenue changed under a defined calculation method.

It doesn’t automatically tell me why customers changed their purchasing behavior.

And it certainly doesn’t tell me whether the company became more profitable.

Those questions require more investigation.

Step 5: Don’t Confuse Revenue Mix With Profitability

Here’s where I think FP&A earns its keep.

Let’s assume Product A has a budgeted variable cost of $110 per unit and Product B has a budgeted variable cost of $75 per unit.

That gives us these budgeted unit contribution margins:

Product	Budget price	Variable cost	Contribution per unit
Product A	$200	$110	$90
Product B	$100	$75	$25

For this illustration, assume actual variable costs per unit stayed the same. We’re also assuming these costs are complete and consistently measured for contribution-margin purposes.

Budget contribution:

Product A: 1,000 × $90 = $90,000.

Product B: 2,000 × $25 = $50,000.

Total budget contribution = $140,000.

Now calculate actual contribution.

Product A: 800 × ($210 − $110) = $80,000.

Product B: 2,500 × ($95 − $75) = $50,000.

Total actual contribution = $130,000.

Wait a minute.

Revenue increased.

Unit volume increased.

But contribution decreased by $10,000.

That deserves more attention than the green arrow on the revenue slide.

Our hypothetical company sold 300 additional units and generated $5,500 more revenue, while producing $10,000 less contribution before fixed costs.

We got busier.

We made less contribution.

I believe the technical finance term is well, that’s unfortunate.

Why the distinction matters

The revenue bridge showed a favorable $40,000 volume effect.

But the business didn’t simply sell 300 more units at the same product proportions.

It shifted heavily toward Product B, which has a much lower contribution per unit.

Using budgeted contribution rates, the $10,000 decline can also be reconciled:

Contribution bridge	Impact
Budget contribution	$140,000
Total volume effect	+$14,000
Contribution mix effect	−$19,500
Selling price effect	−$4,500
Actual contribution	$130,000

The $14,000 volume effect uses the budgeted average contribution of $140,000 divided by 3,000 units.

The contribution mix effect measures the change in product proportions using the budgeted contribution per unit.

And because actual variable costs per unit were held constant, the selling price effect flows directly into contribution.

The bridge ties.

More importantly, it shows why a favorable revenue variance can coexist with deteriorating economics.

I would much rather find that out in a monthly FP&A review than after someone announces we’re expanding production capacity.

Step 6: Turn the Variances Into Management Questions

Once the numbers reconcile, I don’t want to spend another hour admiring the waterfall chart.

I want to know what we should investigate.

If the price variance is unfavorable

I’d examine discounting, customer contracts, promotional activity, rebates, and realized selling prices.

A negative price variance doesn’t automatically mean Sales did something wrong.

A discount might generate incremental contribution, improve customer retention, or support a deliberate market-entry strategy.

But it should have an economic justification.

I’d want to compare the incremental contribution with what the company would have earned without the discount, including any additional servicing or capacity costs.

If volume is favorable

I’d want to understand whether demand is sustainable.

Did we gain customers?

Did existing customers buy more?

Did orders move forward from another period?

Did promotions temporarily increase sales?

And can Operations support the volume without overtime, quality problems, or additional working capital?

Volume growth is not automatically valuable.

The economics of the additional volume matter.

If mix is unfavorable

I’d investigate why customers shifted toward the lower-priced offering.

Maybe Product B is genuinely becoming more popular.

Maybe Product A has a competitive problem.

Maybe sales incentives favor volume instead of contribution.

Maybe inventory availability pushed customers toward the cheaper alternative.

Or maybe Product B brings in customers who eventually buy Product A.

All plausible.

And all requiring different responses.

This is why I wouldn’t tell management to simply sell more premium products.

That’s not a strategy.

That’s a wish with a product name attached.

Step 7: Build the Analysis So You Can Repeat It

A useful price-volume-mix model should be repeatable without becoming a monthly spreadsheet renovation project.

At minimum, I want product-level data containing budget and actual quantities, net revenue, and consistently defined product identifiers.

For margin analysis, I also need reliable cost information.

The basic Excel calculations can be straightforward.

Assume:

• Column B contains budget units.
• Column C contains budget prices.
• Column D contains actual units.
• Column E contains actual prices.
• Rows 2 through 3 contain the two products.

For each product:

Budget revenue

=B2*C2

Actual revenue

=D2*E2

Price variance

=(E2-C2)*D2

Expected units at budget mix

=SUM($D$2:$D$3)*B2/SUM($B$2:$B$3)

Mix variance

=(D2-SUM($D$2:$D$3)*B2/SUM($B$2:$B$3))*C2

Then calculate total volume variance separately:

=(SUM(D2:D3)-SUM(B2:B3))*SUMPRODUCT(B2:B3,C2:C3)/SUM(B2:B3)

The sum of price variance, mix variance, and total volume variance should equal actual revenue minus budget revenue.

I’d make that reconciliation visible.

If it doesn’t equal zero, the model isn’t ready for management.

I’d also document the calculation convention. Different price-volume-mix methods can allocate interaction effects differently while still reconciling to the same total change.

That’s not necessarily an error.

Quietly changing methodologies between reporting periods, however, is a wonderful way to manufacture a trend that doesn’t exist.

Finance has enough problems without inventing new ones.

When Price-Volume-Mix Analysis Can Mislead You

There are situations where I’d be particularly careful.

Different units of measure. If one product is measured in hours, another in subscriptions, and another in physical units, adding their quantities together may be meaningless. Segment the analysis or choose an economically defensible common measure.

New or discontinued products. Products without a comparable baseline need separate treatment. Don’t hide their impact inside an unexplained mix variance.

Currency changes. If the business sells internationally, foreign exchange can distort apparent price changes. Isolate currency translation where material.

Acquisitions. Newly acquired revenue should not automatically appear as organic volume growth.

Returns and discounts. Use consistently defined net realized prices rather than mixing list prices with net revenue.

Cost changes. A revenue PVM bridge is not a complete profitability analysis. Labor, materials, freight, overhead, and other costs may change independently.

And one more.

The analysis doesn’t establish causation by itself.

A price variance tells us realized prices changed.

It doesn’t prove that customers responded to a pricing decision in a particular way.

A mix variance tells us the composition of sales changed.

It doesn’t prove why.

Those conclusions need operational evidence.

This distinction matters because a convincing explanation is not necessarily a correct explanation.

Especially when everyone in the meeting likes it.

When Is PVM Analysis Worth the Effort?

I wouldn’t insist that every business needs a detailed price-volume-mix model.

If you’re a small professional-services company with a handful of bespoke contracts, a contract-level revenue bridge may be more useful.

If you run a subscription business, customer counts, recurring revenue, expansion, contraction, and churn may tell a clearer story.

If you operate a manufacturing or distribution business with meaningful product-level volume and pricing information, PVM can be extremely useful.

I would use it when the business has comparable units, material changes in volume or pricing, meaningful differences in product economics, and management decisions that depend on understanding those changes.

And I’d choose the level of detail based on the decision.

A company deciding whether to change sales commissions may need customer- or product-level contribution analysis.

A CEO reviewing monthly performance may only need a clear bridge and the three biggest drivers.

More detail isn’t automatically more insight.

Sometimes it’s just more detail.

What I Want Management to Understand

Let’s return to our hypothetical company.

Revenue beat budget by $5,500.

That’s true.

But the more important findings were that total volume increased, realized pricing deteriorated overall, customers shifted toward the lower-priced product, and contribution fell by $10,000.

Now we have something worth discussing.

Should we revisit discounting?

Are we rewarding the wrong sales behavior?

Is the premium product losing demand?

Does the lower-priced product have strategic value that isn’t captured by this month’s contribution?

Should the revenue forecast change?

Those are real business questions.

And they’re much more useful than putting a green arrow next to revenue and moving on.

I don’t need every monthly reporting package to contain a spectacular financial investigation.

I do want Finance to notice when the numbers are telling two different stories.

Because a revenue increase is an outcome.

Understanding what produced it—and whether we’d like more of it—is where FP&A becomes useful.

And if your monthly reports are full of favorable variances that somehow never seem to translate into better business performance, you might enjoy taking a closer look at my variance analysis services.

We can find out what those green arrows have been up to.

I have questions.