Variance calculations and analysis

Welcome to the World of Variance Analysis!

Hi there! If you’ve ever planned to spend $50 on a night out but ended up spending $70, you’ve already done a basic "variance analysis." In Management Accounting, Variance Analysis is just a fancy way of being a business detective. We look at the difference between what we thought would happen (our budget) and what actually happened.

Don't worry if these formulas look like alphabet soup at first. We are going to break them down into simple, logical steps. By the end of this guide, you'll be able to explain exactly why a company made more or less profit than expected.

1. The Basics: What is a Variance?

A variance is the difference between a planned (standard) amount and the actual amount. There are two main types you need to know:

1. Favourable (F): This is good news! It means you spent less than expected or earned more revenue than planned. It increases your profit.
2. Adverse (A): This is bad news (usually). It means you spent more than expected or earned less revenue. It decreases your profit.

Quick Review: The Golden Rule

If Actual Profit > Budgeted Profit, the variance is Favourable.
If Actual Cost < Budgeted Cost, the variance is Favourable.

2. Sales Variances

We start with sales because it’s the top line of our accounts. There are two reasons why our sales revenue might be different from the budget: we changed our prices, or we sold a different number of items.

Sales Price Variance

This tells us how much our profit changed because we sold our products at a price different from the standard.

The Formula:
\( (Actual Price - Standard Price) \times Actual Quantity \)

Example: If you planned to sell 100 cakes for \$10 each but actually sold them for \$12, you have a Favourable variance of \$2 per cake!

Sales Volume Profit Variance

This looks at the "lost" or "extra" profit because we sold more or fewer units than planned.

The Formula:
\( (Actual Quantity - Budgeted Quantity) \times Standard Profit per unit \)

Common Mistake to Avoid: When calculating the Volume variance, always use the Standard Profit (or Standard Contribution if using marginal costing), not the price. We want to know how the bottom line changed!

3. Material Variances

Now we look at the costs of making our products. For materials, we look at the Price we paid and the Quantity we used.

Material Price Variance

Did the purchasing department find a bargain, or did prices go up?

The Formula:
\( (Standard Price - Actual Price) \times Actual Quantity Purchased \)

Material Usage Variance

Did the production team waste material, or were they super efficient?

The Formula:
\( (Standard Quantity for Actual Production - Actual Quantity Used) \times Standard Price \)

Memory Aid: "PURE"
Price variance uses Units (Actual Quantity Purchased).
Rate variance uses Efficiency (Actual Hours).

4. Labour Variances

Labour is very similar to materials. Instead of "Price," we call it the "Rate." Instead of "Usage," we call it "Efficiency."

Labour Rate Variance

The Formula:
\( (Standard Rate - Actual Rate) \times Actual Hours Paid \)

Labour Efficiency Variance

The Formula:
\( (Standard Hours for Actual Production - Actual Hours Worked) \times Standard Rate \)

What about Idle Time?

Sometimes workers are paid but cannot work (e.g., a machine breaks down). This is Idle Time. It is always Adverse.
Idle Time Variance: \( (Hours Worked - Hours Paid) \times Standard Rate \)

Analogy: If you hire a plumber for 5 hours but he spends 1 hour waiting for a part to arrive, that 1 hour is "Idle Time." You still have to pay him, but no work is being done!

5. Variable Overhead Variances

Variable overheads (like electricity for machines) usually behave just like labour. We assume they vary based on the hours worked.

1. Expenditure Variance: The difference in the hourly rate.
2. Efficiency Variance: The difference in hours used compared to what should have been used.

6. Fixed Overhead (FOH) Variances

This is often the part students find the most challenging. In Standard Costing (Absorption Costing), we "absorb" fixed costs into products using a predetermined rate.

FOH Expenditure Variance

This is the simplest one! It's just the difference between what you planned to spend on fixed costs and what you actually spent.

The Formula:
\( Budgeted Fixed Overheads - Actual Fixed Overheads \)

FOH Volume Variance

This happens because the number of units we actually produced is different from what we budgeted. If we produce more units, we "absorb" more overhead, which is seen as favourable.

The Formula:
\( (Actual Production - Budgeted Production) \times Standard Absorption Rate \)

Breaking down Volume Variance: Capacity and Efficiency

If you want to be an expert, you can split the Volume variance into two:

1. Capacity Variance: Did we work more or fewer hours than planned? \( (Actual Hours - Budgeted Hours) \times Standard Rate \)
2. Efficiency Variance: Did we produce more or less than expected in those hours? \( (Standard Hours for Actual Production - Actual Hours Worked) \times Standard Rate \)

7. Summary and Key Takeaways

To master variances, remember these three steps:

1. Identify the "Standard": What should have happened for the actual level of activity?
2. Calculate the Difference: Subtract the actual from the standard (or vice versa).
3. Assign a Direction: Is it Favourable (better for profit) or Adverse (worse for profit)?

Quick Review Box:

- Materials: Price and Usage.
- Labour: Rate and Efficiency (and maybe Idle Time).
- Fixed Overheads: Expenditure and Volume.
- Sales: Price and Volume.

Don't worry if you need to practice these formulas a few times. Variance analysis is a skill that gets much easier with repetition. Try a few practice questions now while these formulas are fresh in your mind!