Sales-Variance & Revenue Analysis

Overview

• What you’ll learn: How to decompose sales variances into volume, mix, and quantity components; how to further split quantity variance into market-share and market-size effects; and how to apply these frameworks to multi-product revenue analysis.
• Prerequisites: Lesson 3 — Cost Allocation: Customer Profitability.
• Estimated reading time: 18 minutes

Introduction

The Grand Historian records: When the imperial treasury reports that revenue fell short of the budget by 2 million gold pieces, the emperor demands to know why. “We sold less” is not an acceptable answer — it is the accounting equivalent of “things happened.” Did we sell fewer units overall? Did we sell the wrong mix of products — too many cheap ones and too few profitable ones? Did the entire market shrink, or did our rivals steal our customers? Each of these failures has a different cause and a different remedy, and the general who cannot distinguish them is the general who loses the next war as well.

Sales-variance analysis is the ancient art of decomposing a revenue shortfall (or surplus) into its constituent causes. It peels the onion layer by layer, from the broadest explanation down to the most granular, so that managers can direct their attention — and their remedies — precisely where they will do the most good.

The Variance Framework: An Overview

The total sales variance (actual results minus budgeted results) can be decomposed hierarchically:

• Level 1: Total Sales Variance = Actual Revenue – Budgeted Revenue
• Level 2: = Selling-Price Variance + Sales-Volume Variance
• Level 3: Sales-Volume Variance = Sales-Mix Variance + Sales-Quantity Variance
• Level 4: Sales-Quantity Variance = Market-Share Variance + Market-Size Variance

Each level provides additional diagnostic precision. The Grand Historian likens it to a physician’s examination: Level 1 says “the patient is unwell”; Level 4 identifies the specific organ and the specific disease.

Selling-Price Variance

The selling-price variance isolates the effect of charging a different price than planned:

Selling-Price Variance = (Actual Price – Budgeted Price) x Actual Quantity Sold

If you budgeted to sell widgets at $50 but actually sold them at $47, and you sold 10,000 units, the variance is ($47 – $50) x 10,000 = -$30,000 Unfavorable. You got $3 less per widget than planned.

Causes of selling-price variances include: competitive pricing pressure, unplanned discounts, changes in customer mix (more wholesale, less retail), currency fluctuations (for international sales), and promotional pricing.

Sales-Volume Variance

The sales-volume variance captures the effect of selling a different number of units than planned, valued at the budgeted contribution margin per unit:

Sales-Volume Variance = (Actual Units – Budgeted Units) x Budgeted CM per Unit

If you budgeted to sell 10,000 widgets at a contribution margin of $20 each but sold only 8,500, the variance is (8,500 – 10,000) x $20 = -$30,000 Unfavorable.

This variance tells you the total profit impact of selling more or fewer units, but it conflates two very different effects: mix and quantity. Decomposing further reveals the truth.

Sales-Mix Variance

When a company sells multiple products, the mix — the proportion of total units sold by each product — affects profitability because products have different contribution margins. The sales-mix variance isolates this effect:

Sales-Mix Variance = (Actual Mix % – Budgeted Mix %) x Actual Total Units x Budgeted CM per Unit

Worked Example

Imperial Beverage Corp. sells two products:

In this case, the actual mix (60/40) equals the budgeted mix (60/40), so the sales-mix variance is zero. The entire volume variance is due to selling fewer total units.

Now suppose the actual mix shifts:

Sales-Mix Variance:

• Dragon Ale: (70% – 60%) x 9,000 x $15 = +$13,500 U (sold more of the cheaper product)
• Phoenix Wine: (30% – 40%) x 9,000 x $30 = -$27,000 U
• Total Mix Variance: $13,500 – $27,000 = -$13,500 U

The shift toward lower-margin Dragon Ale and away from higher-margin Phoenix Wine cost the company $13,500 in contribution margin — even though total units remained at 9,000. This is the mix effect: what you sell matters as much as how much you sell.

Sales-Quantity Variance

The sales-quantity variance captures the effect of selling a different total number of units, holding the mix constant at budget:

Sales-Quantity Variance = (Actual Total Units – Budgeted Total Units) x Budgeted Mix % x Budgeted CM per Unit

Using the example above:

• Dragon Ale: (9,000 – 10,000) x 60% x $15 = -$9,000 U
• Phoenix Wine: (9,000 – 10,000) x 40% x $30 = -$12,000 U
• Total Quantity Variance: -$21,000 U

Verification: Mix Variance (-$13,500) + Quantity Variance (-$21,000) = -$34,500 = Sales-Volume Variance. The framework decomposes perfectly.

Market-Share and Market-Size Variances

The sales-quantity variance tells us we sold fewer total units than planned, but it does not explain why. Two possibilities exist:

1. The total market shrank (market-size effect) — everyone sold less because demand fell.
2. We lost market share (market-share effect) — demand was fine but competitors took our customers.

These require external data: the actual total market size in units.

Market-Share Variance

Market-Share Variance = (Actual Market Share – Budgeted Market Share) x Actual Market Size x Budgeted Weighted-Avg CM

Market-Size Variance

Market-Size Variance = (Actual Market Size – Budgeted Market Size) x Budgeted Market Share x Budgeted Weighted-Avg CM

Worked Example

Suppose Imperial Beverage budgeted 10% market share in a market of 100,000 units (hence 10,000 budgeted units). Budgeted weighted-average CM = 60% x $15 + 40% x $30 = $21.

Actual: market size was only 80,000 units, and Imperial sold 9,000 (11.25% market share).

• Market-Share Variance: (11.25% – 10%) x 80,000 x $21 = +$21,000 F
• Market-Size Variance: (80,000 – 100,000) x 10% x $21 = -$42,000 U
• Total Quantity Variance: +$21,000 – $42,000 = -$21,000 U (matches)

This is enormously valuable intelligence. The company actually gained market share — its competitive position improved. But the entire market shrank by 20%, overwhelming the share gains. The response should be: defend the competitive strategy (it is working) while preparing for a smaller market. Without this decomposition, management might have concluded that its sales force was failing — precisely the wrong diagnosis.

Comprehensive Variance Summary

Key Takeaways

• The total sales variance decomposes into selling-price and sales-volume components. Never stop at Level 1.
• Sales-volume variance further decomposes into sales-mix variance (effect of changing product proportions) and sales-quantity variance (effect of selling more or fewer total units).
• Sales-quantity variance further decomposes into market-share variance (company performance vs. competitors) and market-size variance (total market growth or contraction).
• Each level of decomposition provides different actionable intelligence: price discipline, product mix strategy, competitive positioning, and market dynamics.
• Market-share and market-size analysis requires external market data, but the diagnostic value is immense — it separates controllable performance from uncontrollable market forces.

What’s Next

In Lesson 5, we examine how support departments allocate their costs to operating departments using direct, step-down, and reciprocal methods — each with increasing accuracy and complexity.