Skip to content
Cost and Controlling | Part 7 of 10

Variance Analysis: Split the Month by Cause

Price, quantity, efficiency, rate and volume variances turn one number into causes with owners. A worked example from a machining plant.

March closed EUR 25,708 above the standard cost of the parts produced. In many plants, the monthly meeting now produces five separate explanations from five people. In a good one, it produces one cause and one action.

The tool is variance analysis: splitting the total difference into effects that point to different causes and owners.

Five variances

Variance Formula Usual owner
Material price (actual price minus standard price) x actual quantity Purchasing
Material quantity (actual quantity minus standard quantity) x standard price Production, quality
Labor efficiency (actual hours minus standard hours) x standard rate Production
Labor rate (actual rate minus standard rate) x actual hours HR, planning
Volume (planned minus actual volume) x fixed cost per planned part Sales, planning

Standard quantities and hours are always those for the actual output. Positive values are unfavorable.

The example: March 2027

12,600 good parts were produced instead of 13,000.

Variance Calculation EUR
Material price (14.90 minus 14.20) x 13,400 castings 9,380
Material quantity (13,400 minus 12,990) x 14.20 5,822
Labor efficiency (1,960 minus 1,848 h) x 36.30 4,066
Labor rate (37.10 minus 36.30) x 1,960 h 1,568
Volume (13,000 minus 12,600) x 12.18 4,872
Total 25,708

The standard quantity for 12,600 good parts at 3 percent scrap is 12,990 castings. Standard hours are 0.1467 hours per part. Monthly fixed costs of EUR 158,333 over 13,000 planned parts give EUR 12.18 per part.

Read across, not down

Look at the first three lines together. Purchasing bought castings from a second foundry at a higher spot price. The castings were porous: scrap rose to 6 percent in week 11, and the rework needed extra hours, partly as overtime.

Four of five variances share one root cause. The action is one decision with purchasing and the supplier, not five comments in a report. Only the volume variance has a different cause: a customer moved a call-off to April.

Rules for the meeting

  • A limit. Every variance above an agreed amount, for example EUR 2,500, gets a cause, an action, an owner and a date within ten working days.
  • Trends for the rest. Smaller variances are watched over three months.
  • Causes from the shop floor. The controller explains how the number is made. The area manager explains what happened at the machine.

What it changes

Without the split, the area manager defends a total. With it, purchasing sees its decision cost money in production, and the plant manager sees that the month was not a performance problem of the line. That is the point of controlling in operations: the right conversation with the right people, early enough to matter.

Newsletter

One Lean idea.
Every week.