Cost Accounting: Variance Analysis Advanced - Sales Variances, Sales Price, Sales Volume, Sales Mix, Sales Quantity

? What this actually is

Sales variances are the differences between budgeted and actual sales, broken down into sales price variance and sales volume variance. Sales volume variance can be further divided into sales mix variance and sales quantity variance. These variances help managers understand why actual sales differed from budgeted sales, which is crucial for performance evaluation and decision-making. The core idea is to isolate the effects of changes in price, product mix, and quantity sold.

? The core logic (or formula)

1. Sales Price Variance:
2. Formula: (Actual Price - Budgeted Price) × Actual Quantity Sold

3. This measures the impact of selling products at a different price than budgeted.

4. Sales Volume Variance:

5. Formula: (Actual Quantity Sold - Budgeted Quantity Sold) × Budgeted Price

6. This measures the impact of selling a different quantity than budgeted.

7. Sales Mix Variance:

8. Formula: (Actual Mix % - Budgeted Mix %) × Budgeted Quantity × Budgeted Price

9. This measures the impact of selling a different mix of products than budgeted.

10. Sales Quantity Variance:

11. Formula: (Actual Quantity Sold - Budgeted Quantity Sold) × Budgeted Price
12. This measures the impact of selling a different total quantity than budgeted, assuming the mix remains the same.

? Hidden rule nobody explains

In practice, sales variances are often analyzed at the product line level rather than the individual product level. This provides a more manageable and actionable view of performance. Additionally, variances are typically reviewed in the context of market conditions and internal factors to understand the root causes.

? Practical example / breakdown

Let's say a company budgeted to sell 100 units of Product A at $50 each and 200 units of Product B at $30 each. Actual sales were 120 units of Product A at $55 each and 180 units of Product B at $28 each.

1. Sales Price Variance:
2. Product A: ($55 - $50) × 120 = $600 (Favorable)

3. Product B: ($28 - $30) × 180 = -$360 (Unfavorable)

4. Sales Volume Variance:

5. Product A: (120 - 100) × $50 = $1,000 (Favorable)

6. Product B: (180 - 200) × $30 = -$600 (Unfavorable)

7. Sales Mix Variance:

8. Assume the budgeted mix was 33.33% for Product A and 66.67% for Product B.
9. Actual mix: Product A = 120 / (120 + 180) = 40%, Product B = 180 / (120 + 180) = 60%
10. Product A: (40% - 33.33%) × 300 units × $50 = $1,500 (Favorable)

11. Product B: (60% - 66.67%) × 300 units × $30 = -$600 (Unfavorable)

12. Sales Quantity Variance:

13. Total units: 120 + 180 = 300, Budgeted units: 100 + 200 = 300
14. Sales Quantity Variance = 0 (since total quantity sold matches the budget)

? Your move today

Goal: Calculate the sales variances for a simple scenario.

Step-by-step:
1. Choose two products with budgeted and actual sales data.
2. Calculate the sales price variance for each product.
3. Calculate the sales volume variance for each product.
4. Calculate the sales mix variance for each product.
5. Calculate the sales quantity variance for the total units sold.

What to save: A completed variance analysis table with your calculations.

? Quick reference asset

Common mistakes & recovery

• Common Error 1: Mixing up actual and budgeted figures in the formulas.

• Recovery: Double-check each variable in the formula against the budgeted and actual data.

• Common Error 2: Ignoring the impact of sales mix on overall performance.

• Recovery: Always calculate the sales mix variance to understand the full picture.

• Quick Check: Ensure that the sum of individual variances reconciles with the total variance.

• Exam Tip: Practice with realistic scenarios to get comfortable with the calculations and interpretations.

? Completion check

"I can calculate sales price variance, sales volume variance, sales mix variance, and sales quantity variance, and explain their implications for performance evaluation."