Skip to content

Free template

Updated

Standard cost variance workbook

A standard cost variance is the difference between what a product actually cost and what it should have cost at standard, split into parts so you can see which input moved. Materials, labor, variable overhead and fixed overhead each give two: one for what the input cost (price, rate or spending) and one for how much of it was used or made (quantity, efficiency or volume). That is eight variances. Every one here is actual minus standard, so a positive number is unfavorable and a negative number is favorable. The Excel workbook takes the standards and the actuals for a product and a period. It works out all eight with the sign and the word favorable or unfavorable, and proves that they add up to actual cost less standard cost. A check cell turns red if they do not. It also has a 25-row sheet for several products or cost centers, a Where to look sheet with questions to ask on the floor, and a worked example. The PDF has the variance map on one page, the formulas, the example step by step and the questions. It does not set your standards or tell you why a variance happened; it tells you where to look.

Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.

Page 1 of the standard cost variance workbookA diagram with actual cost at the top, the flexed budget in the middle and the standard cost of the actual output at the bottom, with the price and spending variances between the first two and the quantity, efficiency and volume variances between the last two, and the sign rule below.
Variance mapEight variancesSign ruleFavorable or unfavorableReconciliation check25-row multi-line sheetWhere to look questionsWorked example

When to use it

When to use a cost variance workbook

  • In the monthly review where finance asks why the line is over standard and you need to know what the number is made of.
  • Before that review, to decide which variances are big enough to walk to the floor for.
  • When you inherit a variance report and want to check the sign and the arithmetic.
  • When a favorable variance looks too good and you want to see what it is made of.
  • When you teach supervisors and team leaders what the numbers in the cost report mean.

How to fill it in

  1. 1

    Enter the standards

    Material per unit and its price, labor hours per unit and the rate, the variable overhead rate per labor hour, the fixed overhead budget and the output level that budget was set for. Get them from finance; the workbook does not set them.

  2. 2

    Enter the actuals for the period

    Units made, material bought and used, the price paid, labor hours and rate, and the variable and fixed overhead incurred.

  3. 3

    Choose when the material price is measured

    At purchase (the default, on the quantity bought) or at use (on the quantity used). Pick one and keep to it, because the two differ in any month when you buy more or less than you use.

  4. 4

    Read the eight variances

    Each shows its sign, the word favorable or unfavorable and the formula in words. Start with the biggest in dollars, not the biggest in percent.

  5. 5

    Check that it adds up

    Actual cost less standard cost must equal the eight variances, plus any stock change. The check cell turns red if it does not, which means an input is wrong.

  6. 6

    Take the three biggest to the floor

    Use the Where to look questions. Go to the line, the stores or the timesheets with the question, not with the answer you expect.

The eight variances

What each variance measures, and what to ask first

Each is actual minus standard. Positive means unfavorable, negative means favorable. The questions are where to start when a variance is unfavorable, not causes. The formulas follow Principles of Accounting, Volume 2: Managerial Accounting (Franklin, Graybeal and Cooper, OpenStax, CC BY-NC-SA 4.0), checked against an open textbook from Saylor Academy and an ACCA article. The example numbers are our own.

  • 1. Materials price

    Formula
    (Actual price − Standard price) × Quantity bought
    Ask first
    Rush buy, small lot, different supplier, freight, an out-of-date standard?
  • 2. Materials quantity

    Formula
    (Quantity used − Standard quantity allowed) × Standard price
    Ask first
    Scrap, rework, yield, spills, set-up waste, over-issue, a wrong bill of materials?
  • 3. Labor rate

    Formula
    (Actual rate − Standard rate) × Actual hours
    Ask first
    Overtime, agency labor, a higher grade on a lower grade job?
  • 4. Labor efficiency

    Formula
    (Actual hours − Standard hours allowed) × Standard rate
    Ask first
    Waiting, breakdowns, changeovers, rework, new people, a standard time nobody has checked?
  • 5. Variable overhead spending

    Formula
    Actual variable overhead − Actual hours × Standard rate
    Ask first
    Which overhead lines moved, and was it price or use?
  • 6. Variable overhead efficiency

    Formula
    (Actual hours − Standard hours allowed) × Standard rate
    Ask first
    It follows labor efficiency, so look in the same places.
  • 7. Fixed overhead spending

    Formula
    Actual fixed overhead − Budgeted fixed overhead
    Ask first
    Which fixed line moved, and was it planned?
  • 8. Fixed overhead volume

    Formula
    Budgeted fixed overhead − Fixed overhead applied
    Ask first
    Why was output below the level the rate was set on? It is not extra spending.

A filled-in example

Illustrative, not a benchmark

An example (illustrative numbers, invented for this page): a bracket line for one month. Standards: 2.5 kg of steel at $3.20 per kg, 0.40 labor hours at $24.00, variable overhead $6.00 per labor hour, fixed overhead $45,000 set for 15,000 brackets. Actuals: 14,200 brackets, 36,000 kg bought and 35,200 kg used at $3.31, 5,900 hours at $23.70, variable overhead $33,900, fixed overhead $46,300.

  • Allowed for 14,200 brackets: 35,500 kg and 5,680 labor hours. The fixed overhead rate is 45,000 ÷ 6,000 hours = $7.50 per hour, so $42,600 is applied.
  • Materials price (3.31 − 3.20) × 36,000 = +3,960 unfavorable. Materials quantity (35,200 − 35,500) × 3.20 = −960 favorable.
  • Labor rate (23.70 − 24.00) × 5,900 = −1,770 favorable. Labor efficiency (5,900 − 5,680) × 24.00 = +5,280 unfavorable.
  • Variable overhead spending 33,900 − 5,900 × 6.00 = −1,500 favorable. Variable overhead efficiency (5,900 − 5,680) × 6.00 = +1,320 unfavorable.
  • Fixed overhead spending 46,300 − 45,000 = +1,300 unfavorable. Fixed overhead volume 45,000 − 42,600 = +2,400 unfavorable.
  • Total: +10,030 unfavorable. Actual cost $339,190 less standard cost $326,600 is $12,590, which is the 10,030 plus a stock change of 2,560 for the 800 kg bought and not yet used, valued at standard price.

Labor efficiency is the biggest item, so the first question is where the 220 extra hours went. The volume variance is the 800 brackets short of the 15,000 the rate was set on: fixed cost spread over fewer units, not extra spending. The two favorable items need a reason before anyone counts them as savings.

Common mistakes

  • Reading a variance as the cause

    A variance says where the actual cost left the standard. It does not say why. Go and look before you decide.

  • Counting every favorable variance as a saving

    A favorable usage or rate variance can come from a loose standard, thinner material, less experienced people or work put off. Ask what changed.

  • Treating the volume variance as waste

    It is fixed overhead spread over fewer or more units than the rate assumed. Building stock to make it look better only moves the cost into inventory.

  • Changing the price basis between months

    Measuring the material price at purchase one month and at use the next makes the trend meaningless. Choose one and say which.

  • Using variances as the plant scorecard

    Lean Enterprise Institute and BMA both warn that variances used as performance measures can drive buying in bulk, long runs and stock building. Use them to find where to look.

  • Standards nobody has checked

    Old prices, old times and old bills of materials give variances that point at nobody. Review the standards before you chase the variances.

Download the template

Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.

Run this template in LeanSuite

LeanSuite's Loss and Cost Management imports your loss data, shows a loss tree that puts a cost on each loss, and tracks the savings as you remove them.

See it in a 45-minute demo

FAQ

Standard cost variance workbook: common questions

  1. Each variance here is actual minus standard. A positive number means actual cost was above standard, which is unfavorable. A negative number means it was below standard, which is favorable. The word matters more than the sign, and a favorable variance can still hide a problem such as a loose standard or lower quality.

  2. OpenStax measures it at purchase, on the quantity bought, so a price change shows up when you buy. Measured at use, it is worked on the quantity used. Either is a valid treatment, but they differ in any month when you buy more or less than you use. The workbook has both and shows the difference as a stock change in the reconciliation.

  3. No. It is the fixed overhead budget less the fixed overhead applied to the units made, so it is the cost of making fewer or more units than the level the rate was set on. Look at the schedule, demand and downtime, not at waste, and do not build stock just to move the number.

  4. From Principles of Accounting, Volume 2: Managerial Accounting, chapter 8, by Mitchell Franklin, Patty Graybeal and Dixon Cooper (OpenStax, 2019, licensed CC BY-NC-SA 4.0, free at openstax.org). Its fixed overhead section names the two fixed variances without formulas, so those follow the Saylor Academy open textbook and an ACCA article, which agree. The workbook and the example are our own work, shared free for non-commercial use on the same terms.

  5. Used to find where to look, yes. Used as a plant scorecard they can push the wrong behavior: Lean Enterprise Institute and BMA Inc. both say variances can reward buying in bulk, running long batches and building stock. Use them in the monthly review, and keep the daily management on flow, quality and delivery.

More free templates

All templates
Browse all 205 templates

Can't find the template you need?

Tell us what you're looking for. We'll make it and send it to your inbox, free.

A shift handover sheet, a red tag log, a changeover checklist for one machine: if your team uses it on the floor, ask.

By sending this form you agree to our Terms of Service and Privacy Policy.

Pass it on

We want LeanSuite to be the best place on the internet for lean help. If this was useful, send it to someone on your team or in your network who needs it.