Standard Costing Variance Analysis Calculator
Calculates the full set of standard costing variances — materials price and usage, labor rate and efficiency, and variable and fixed overhead spending and volume — from your standard cost card and actual period results. Automatically flags which cost category drove the most variance and whether your total result was favorable or unfavorable. Built for cost accountants, controllers, and manufacturing finance teams who run this analysis every reporting period and are currently doing it by hand or rebuilding the same formulas in a fresh spreadsheet each time.
Download This Calculator
Get the Excel spreadsheet behind this calculator to use offline, customize for your needs, and publish as a web tool using Sheetflow.
All Eight Standard Variances
Materials price and usage, labor rate and efficiency, and variable and fixed overhead spending and volume — each computed with the correct sign convention so favorable and unfavorable are never flipped.
Automatically Ranks Your Biggest Driver
Compares every category and names the single biggest variance driver — regardless of whether your total comes out favorable or unfavorable overall.
Ties Out Exactly
Category variances sum directly to your total variance — no manual reconciliation, no plug figures, no chasing a rounding difference at month end.
Frequently Asked Questions
What is standard costing variance analysis and why does it matter?
Standard costing sets a predetermined ("standard") cost for materials, labor, and overhead before production happens, based on what things should cost under normal, efficient conditions. Variance analysis then compares those standards against what actually happened, breaking the difference into specific, actionable pieces rather than one vague "we're over budget" number.
The reason it matters is that a single total cost variance tells you nothing about why — did you pay more for materials, or use more of them? Did labor take longer, or cost more per hour? Using the calculator's defaults, a company with a $9,100 unfavorable total variance can see immediately that materials actually came in $600 favorable, while labor drove $6,200 unfavorable and overhead added another $3,500 unfavorable. That's a completely different conversation with your production manager than "we're $9,100 over" — it points directly at the labor line as where to start asking questions.
How do I calculate materials price variance and materials usage variance?
Materials Price Variance = (Actual Price − Standard Price) × Actual Quantity Used. Materials Usage Variance = (Actual Quantity Used − Standard Quantity Allowed) × Standard Price, where Standard Quantity Allowed is how much material should have been used for the actual output achieved (not the quantity budgeted for a different production volume).
Using the calculator's defaults: standard price is $2.50/unit but actual price paid was $2.40 — a favorable price variance of $3,100 on 31,000 units used. But 10,000 units of actual output should have only required 30,000 units of material (3.0 standard per unit), and 31,000 were actually used — an unfavorable usage variance of $2,500. Net: $600 favorable overall, but that net figure hides a real story. This is a classic pattern worth recognizing: buying cheaper material and then needing more of it to get the same output can mean the "savings" on price were partly or fully eaten by waste, scrap, or rework — the two variances together tell you whether a cheaper input was actually a good deal.
How do I calculate labor rate variance and labor efficiency variance?
Labor Rate Variance = (Actual Rate − Standard Rate) × Actual Hours Worked. Labor Efficiency Variance = (Actual Hours Worked − Standard Hours Allowed) × Standard Rate, where Standard Hours Allowed is the labor time that should have been needed for the actual output produced.
Using the calculator's defaults: standard labor rate is $18.00/hour, but workers were actually paid $18.50/hour across 5,200 actual hours — an unfavorable rate variance of $2,600. Meanwhile, 10,000 units at 0.5 standard hours each should have taken 5,000 hours, but 5,200 were actually worked — an unfavorable efficiency variance of $3,600. Both variances point the same direction here, for a combined $6,200 unfavorable — worth investigating together, since a higher-than-standard pay rate combined with more hours than standard can indicate anything from overtime premiums to a training or staffing issue slowing the line down.
What's the difference between overhead spending variance and overhead volume variance?
Spending variance measures whether you spent more or less on overhead than budgeted, independent of how much you produced. Volume variance measures whether you absorbed too much or too little fixed overhead because you produced more or less than the capacity level your fixed overhead rate was originally based on — it's purely a function of output volume, not actual spending.
Using the calculator's defaults: fixed overhead was budgeted at $40,800 but actually cost $41,000 — a $200 unfavorable spending variance, reflecting real dollars spent above budget. Separately, the predetermined fixed overhead rate ($8.00/hour) applied to the 5,000 standard hours allowed for actual output comes to $40,000 in applied overhead — $800 less than the $40,800 budgeted, an unfavorable volume variance. That volume variance doesn't mean anyone overspent; it means the plant produced at a level below the capacity the fixed overhead rate assumed, so each unit is carrying a bigger share of fixed cost than planned. Spending variance is about cost control; volume variance is about capacity utilization — mixing the two up leads to blaming the wrong team for the wrong problem.
My total variance is favorable — does that mean everything is fine?
Not necessarily, and a favorable total is exactly when it's most tempting to stop investigating. A small net favorable number can mask a large unfavorable variance in one category being offset by an equally large favorable variance in another — which is precisely what happens in the calculator's own materials example: a $3,100 favorable price variance and a $2,500 unfavorable usage variance nearly cancel out to a modest $600 favorable net, but the underlying story (cheaper material, more waste) is one a plant manager should still know about.
That's why the calculator always shows the category breakdown, not just the bottom line, and flags your single largest variance regardless of whether the total is favorable or unfavorable. A best practice is to set a materiality threshold — say, investigate any individual variance above a certain dollar amount or percentage of standard cost — rather than only reacting when the total looks bad, since a total near zero can still be hiding a real operational issue in one direction being masked by an unrelated favorable swing in another.
Transform Your Excel Models into Web Tools
Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.
Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.