Sales mix and quantity variances

Introduction to Sales Mix and Quantity Variances

Welcome to one of the most practical parts of the Performance Management (PM) syllabus! So far, you have probably learned how to calculate a simple Sales Volume Variance. But in the real world, most businesses don't just sell one thing. Think about a coffee shop: they sell lattes, cappuccinos, and muffins.

If the shop sells more items than expected, that's great! But what if they sold more cheap muffins and fewer expensive coffees? Their total profit might actually go down, even if the total number of items sold went up. That is exactly why we need to break the Sales Volume Variance into two parts: the Sales Mix Variance and the Sales Quantity Variance. By the end of these notes, you will be able to calculate these with confidence and explain what they actually mean for a business.

Prerequisite: The Big Picture

Before we dive in, remember that the Sales Volume Variance measures the difference between how many units we planned to sell and how many we actually sold, valued at the Standard Profit (for absorption costing) or Standard Contribution (for marginal costing).

Don't worry if this seems tricky at first! Just remember this simple "Family Tree":
Sales Volume Variance splits into:
1. Sales Mix Variance (Did we sell the right proportions of products?)
2. Sales Quantity Variance (Did we sell the right total amount of units?)

1. The Sales Mix Variance

The Sales Mix Variance looks at the relative proportions of the products sold. If a company sells more of a product that has a higher profit margin than the average, the mix variance will be Favorable. If they sell more of a product with a lower margin, it will be Adverse.

The Analogy: The Fruit Bowl
Imagine you sell bowls of fruit. Each bowl should have 5 grapes and 5 strawberries. Strawberries are expensive (high profit), and grapes are cheap (low profit). If you sell a bowl with 2 grapes and 8 strawberries, your Mix has changed. Because you sold more of the high-profit item (strawberries) than planned, your Mix Variance is Favorable!

How to calculate it (Step-by-Step):
Step 1: Calculate the Total Actual Quantity sold (all products combined).
Step 2: Calculate the Actual Quantity in the Standard Mix. This means taking that total and splitting it up using the original budget percentages.
Step 3: Compare the Actual Quantity of each product to the Actual Quantity in the Standard Mix.
Step 4: Multiply the difference by the Standard Profit (or Contribution) per unit.

The Formula:
\( (\text{Actual Quantity} - \text{Actual Quantity in Standard Mix}) \times \text{Standard Profit/Contribution per unit} \)

Key Takeaway: The Mix Variance tells us if the change in the "recipe" of our sales was profitable. It ignores the total volume and focuses only on the proportions.

2. The Sales Quantity Variance

The Sales Quantity Variance (also known as the Sales Volume Profit Variance) ignores the mix and looks only at the total number of units sold. It asks: "Regardless of what we sold, did we sell more or fewer total units than the budget?"

The Analogy: The Fruit Bowl (Continued)
Using our fruit bowl example: if you planned to sell 100 bowls of fruit but actually sold 120 bowls, your Quantity Variance is Favorable because you sold more "stuff" in total, regardless of whether there were more grapes or strawberries inside.

How to calculate it (Step-by-Step):
Step 1: Take the Actual Quantity in the Standard Mix (which you already calculated for the Mix Variance).
Step 2: Take the Budgeted Quantity for each product.
Step 3: Find the difference between these two.
Step 4: Multiply the difference by the Standard Profit (or Contribution) per unit.

The Formula:
\( (\text{Actual Quantity in Standard Mix} - \text{Budgeted Quantity}) \times \text{Standard Profit/Contribution per unit} \)

Key Takeaway: The Quantity Variance tells us the impact of selling more or fewer units in total, assuming the "recipe" (mix) stayed exactly as budgeted.

3. Bringing it Together: A Numerical Example

Let's look at a quick example to see how this works in practice.

Budget:
Product A: 100 units (Profit \$5/unit)
\nProduct B: 100 units (Profit \$10/unit)
Total Budget: 200 units (Mix is 50% A, 50% B)

Actual:
Product A: 110 units
Product B: 130 units
Total Actual: 240 units

Calculation for Mix Variance:
Total Actual units = 240. At Standard Mix (50/50), this should be 120 units of A and 120 units of B.
Product A: \( (110 - 120) \times \$5 = \$50 \) (Adverse because we sold less of A than the mix suggested)
Product B: \( (130 - 120) \times \$10 = \$100 \) (Favorable because we sold more of B than the mix suggested)
Total Mix Variance: \$50 Favorable

\n\nCalculation for Quantity Variance:
\nProduct A: \( (120 - 100) \times \$5 = \$100 \) Favorable
\nProduct B: \( (120 - 100) \times \$10 = \$200 \) Favorable
\nTotal Quantity Variance: \$300 Favorable

Quick Check: Add them together! \$50 (F) + \$300 (F) = \$350 (F). This should equal your total Sales Volume Variance!

4. Common Pitfalls and How to Avoid Them

Mistake 1: Using Actual Profit.
Always use Standard Profit/Contribution. Variance analysis is designed to isolate the effect of volume and mix; we don't want price changes or cost changes confusing our numbers here (those are handled in Price and Cost variances).

Mistake 2: Mixing up Favorable and Adverse.
In the Mix Variance, if you sold more of the high-margin product than the standard mix suggested, that specific line is Favorable. If you sold more of the low-margin product, it's Adverse.

Mistake 3: Forgetting the costing method.
If the question says the company uses Marginal Costing, use Contribution. If it says Absorption Costing, use Profit. If you use the wrong one, your final answer will be wrong even if your logic is perfect!

5. Why do managers care about this? (The "So What?")

Understanding why a variance happened is more important than just calculating the number for your PM exam.

Did you know? A favorable Sales Quantity variance might be linked to an adverse Sales Price variance. For example, the manager might have lowered the price (Price Variance = Adverse) to encourage people to buy more (Quantity Variance = Favorable).

Interpreting the Mix: If the Mix Variance is favorable, it means the sales team is successfully pushing the high-margin products. However, if they are doing this by ignoring the cheaper products, they might be losing "entry-level" customers who would have bought more in the future.

Quick Review Box

1. Sales Volume Variance = Mix Variance + Quantity Variance.
2. Mix Variance: Compares Actual units to Actual units in Standard Mix.
3. Quantity Variance: Compares Actual units in Standard Mix to Budgeted units.
4. Favorable = Selling more of a high-margin product (Mix) or selling more units in total (Quantity).
5. Always use Standard Profit or Standard Contribution per unit.