Standard cost variance calculator

A plant that made 10,000 brackets should have spent $290,000 at standard cost. It spent $318,650, so the total variance is $28,650 unfavorable. The surprise is where it sits: $10,000 of it is a fixed overhead volume variance that says nothing about spending, and another $5,160 is a material price variance that belongs to purchasing. The floor’s own material usage and labor efficiency variances together come to $6,500.

This calculator splits a period’s cost into eight variances: material price and usage, labor rate and efficiency, variable overhead spending and efficiency, and fixed overhead spending and volume. It labels each as favorable or unfavorable, flags the ones above your threshold, and proves that standard cost plus variances equals actual cost.

Who reaches for this

The starting point is flexing the standard to the actual output. If 10,000 units were produced, the standard quantity allowed is 10,000 times the standard quantity per unit, and the standard hours allowed are 10,000 times the standard hours per unit. Every variance compares what happened with that flexed standard, so it is not distorted by producing more or less than planned.

Each cost element then splits into two pieces that answer different questions. The price piece asks whether the company paid more or less per unit of input than the standard. The quantity piece asks whether it used more or less input than the standard allows for the output. Fixed overhead has its own pair: spending, which compares the actual cost with the budget, and volume, which compares the budget with what production absorbed. The proof at the bottom ties all of it back to the actual cost, which catches entry mistakes before they turn into wrong conclusions.

Standard costing is a method of recording production and inventory at predetermined costs. Before the period begins, the company decides how much material, labor and overhead a unit of product should use and what each should cost. The result is a standard cost card. During the period, inventory moves through the books at the standard, and any difference between what was actually spent and what the standards allowed is captured as a variance.

The reason to do it is control. A total cost overrun of $28,650 tells you little. Eight variances, each with an owner, tell you where to look. Standards also speed up bookkeeping, since inventory is valued at a known unit cost, and they support pricing, budgeting and performance reviews. The method is common in manufacturing, and the same logic applies to recipes in a restaurant, standard hours on a service job, or standard yields in food processing.

A standard cost card

Here is the card for the running example, a metal bracket. Normal capacity is 12,000 units, which is 6,000 direct labor hours.

The four types of standard

Standards come from engineering estimates, time studies, supplier quotes, historical data and, ideally, the people who do the work. Standards imposed without input tend to be resisted, and standards based only on last year’s performance lock in last year’s inefficiencies. In systems such as SAP, “standard price” is also the name of an inventory valuation setting. This page is about the cost accounting method, not that setting.

The same method outside a factory

Nothing in standard costing requires a machine. A restaurant sets a standard for each dish and measures the kitchen against it. Say a chicken plate should use 8 ounces of chicken at $0.35 an ounce and 6 minutes of cook time at $18 an hour. The standard is $2.80 of chicken and $1.80 of labor. If a week’s sales of 500 plates used 4,300 ounces at $0.38, the price variance is $129 unfavorable and the usage variance, 300 ounces over the 4,000 allowed at $0.35, is $105 unfavorable. The names change. The arithmetic does not.

Service firms do the same with hours. An accounting practice with a standard of 20 hours for a return and a standard rate per hour measures efficiency by comparing actual hours with the standard, and rate by comparing the pay of the people who did the work with the rate assumed. The labor variances here apply directly. What such firms usually lack is the materials pair, and that is fine.

Sign conventions differ between textbooks and web pages. Some write (standard − actual) so that a positive result is favorable, and others write (actual − standard) so that a positive result is unfavorable. This page uses the second convention throughout: a positive variance is unfavorable, because it means costs went up.

AP is the actual price and SP the standard price. AQ is actual quantity, SQ the standard quantity allowed for the actual output, AR the actual labor rate, SR the standard rate, AH actual hours and SH the standard hours allowed. There are two rules worth memorizing. Price-type variances multiply a price difference by an actual quantity, so the whole quantity is judged at the price that occurred. Quantity-type variances multiply a quantity difference by a standard price, so a usage problem is not blurred by a price problem.

The bracket’s standard is 2.5 kg at $4.00 per kg. The plant made 10,000 units, so the standard quantity allowed is 25,000 kg, costing $100,000. It bought 26,000 kg at $4.20 and used 25,800 kg.

The price variance is (4.20 − 4.00) × 26,000 = $5,200 unfavorable when it is recognized at purchase, on the quantity bought. The usage variance is (25,800 − 25,000) × $4.00 = $3,200 unfavorable, on the quantity used compared with the standard allowed. Together they say the plant paid too much per kg and then used 800 kg more than it should have.

Purchased or used?

The textbook answer is to recognize the price variance when the material is bought, because that is when purchasing made the decision. Inventory then sits on the books at standard price, and every issue to production is charged at standard. The other approach recognizes it on the quantity used. It proves directly to the actual cost of production and it postpones the variance until the material is consumed.

The difference in the example is $40: the 200 kg bought but not used, at $0.20 over standard. The calculator lets you choose the basis, and the proof adjusts, so you can see both. If your reporting policy is to record price variances at purchase, that is what the journal entries in the workbook show.

Read them together

The two variances are not independent. If purchasing switches to a cheaper grade at $3.80 and the plant then uses 26,600 kg because more pieces are scrapped, the price variance is (3.80 − 4.00) × 26,600 = $5,320 favorable and the usage variance is (26,600 − 25,000) × $4.00 = $6,400 unfavorable. The net is $1,080 unfavorable. Purchasing looks like a hero and the plant looks like the problem, but the decision cost the company money. That is why standard costing systems review price and usage variances together before assigning blame.

The standard is 0.5 hour per unit at $22.00, so 10,000 units allow 5,000 hours. Workers actually put in 5,150 hours at $22.60. The rate variance is (22.60 − 22.00) × 5,150 = $3,090 unfavorable. The efficiency variance is (5,150 − 5,000) × $22.00 = $3,300 unfavorable. The first is about pay and the second is about time.

The rate variance is the smaller and more explainable one. Common causes are overtime premiums, a wage settlement that was not in the standard, or a mix of workers who are paid above the standard grade. The efficiency variance is driven by the process: machine downtime, poor material quality, rework, training and scheduling. Because efficiency is measured at the standard rate, a highly paid employee working faster shows up as a favorable efficiency variance and an unfavorable rate variance.

A trade-off like the material one exists here. Assigning more experienced workers at $23.50 an hour might bring hours down to 4,850. The rate variance would be (23.50 − 22.00) × 4,850 = $7,275 unfavorable, and the efficiency variance (4,850 − 5,000) × $22 = $3,300 favorable. The net is $3,975 unfavorable, so the faster crew costs more in this case. Whether that trade is worth it turns on what the saved time is worth, which a variance report alone will not tell you.

Overhead has two problems that materials and labor do not. It cannot be traced to a unit directly, so it is applied using a rate, and much of it does not change with output. Standard costing handles that by setting a rate per unit of an allocation base, here direct labor hours, and by treating variable and fixed overhead separately.

Variable overhead

The standard rate is $6.00 per labor hour. At 5,150 actual hours the flexed budget is $30,900, and actual variable overhead was $32,400. The spending variance is $1,500 unfavorable: the company spent more than the flexed budget. The efficiency variance is (5,150 − 5,000) × $6.00 = $900 unfavorable. It is not extra spending. It is the overhead that the extra 150 hours of labor drove, and it always moves with the labor efficiency variance.

Fixed overhead

Fixed overhead is budgeted at $60,000 for normal capacity of 6,000 hours, a rate of $10.00 per hour. The 10,000 units earned 5,000 standard hours and so applied $50,000. Actual fixed overhead was $61,500. Two variances explain the $11,500 that was not absorbed. The spending variance is $61,500 − $60,000 = $1,500 unfavorable, the real overrun. The volume variance is $60,000 − $50,000 = $10,000 unfavorable, because its output earned only 5,000 of the 6,000 standard hours that normal capacity assumes.

The volume variance is the most misread number in the report. It does not say fixed costs were mismanaged. It says production was 2,000 units below the volume the rate assumed, so fixed costs were spread over fewer units than planned. Had the plant made 12,000 units, the volume variance would be zero. It usually reflects demand and planning, and holding a plant manager responsible for it is a mistake unless the manager also controls the production schedule. The rate behind these figures is worked through, with jobs and year-end closing, on the predetermined overhead rate calculator.

How the choice of capacity changes the volume variance

The volume variance depends on the denominator used to set the fixed overhead rate. The same $60,000 budget and the same 5,000 standard hours of output produce three different answers.

A lower denominator absorbs more overhead per unit and shrinks the variance. A higher one gives a lower unit cost and a larger unfavorable variance that shows the cost of idle capacity. Neither is wrong. Using expected output hides unused capacity, while using practical capacity makes it visible, so the choice should follow what the report is meant to reveal. Whatever you choose, use the same denominator when comparing periods.

Here is the whole period for the bracket, with every variance and the proof.

The proof works because the eight variances are a complete split of the difference between actual and standard. If the two figures do not match, an input is wrong. The calculator shows the same check, and the workbook computes it in a cell that must read zero.

The journal entries

With the price variance recognized at purchase, the entries for the period follow. The material price variance is $5,200 in this version, since it is recorded on the 26,000 kg bought.

Total debits to variance accounts are $28,690: the $28,650 from the used basis plus the $40 of price variance on material still in the storeroom. Inventory accounts hold everything at standard, which is what makes reports and pricing decisions simple.

Standard costing works by exception. A plant that investigates every variance spends more on investigation than the variances are worth. The alternative is to set a materiality rule and look only at what exceeds it. A common rule uses both a percentage of the standard and a dollar amount, so that a small element with a large percentage swing and a large element with a small percentage swing are both reviewed when they matter.

In the example, a 5% threshold flags two variances. The material price variance is 5.2% of the $100,000 standard for materials. The fixed overhead volume variance is 20% of the $50,000 of overhead applied. The others sit between 2.8% and 5.0%, and the variable overhead spending variance lands exactly on 5.0%, which is not above the line. A threshold is a policy, not a law, and where it sits should follow the size of the company and the cost of looking.

Questions to ask about each one

Three rules keep the investigation useful. Pair variances that share a cause before assigning blame, as in the cheap-material and skilled-worker examples above. Look at trends, not only single periods, since a small variance that grows every month matters more than a large one-off. And confirm the standard itself before concluding that performance was the problem: a standard set two years ago can produce a favorable or unfavorable variance on every unit for reasons that have nothing to do with the plant.

Variance accounts are temporary in practice. At period end they have to go somewhere. When they are small relative to cost of goods sold, the usual treatment is to close them directly to cost of goods sold. When they are material, they are prorated to the accounts that hold the affected costs, in proportion to the standard cost in each: work in process, finished goods and cost of goods sold. Materials price variances recognized at purchase can also reach raw materials inventory.

Suppose 7,000 of the 10,000 units are sold and 3,000 remain in finished goods. Closing everything to cost of goods sold would charge the full $28,650 to the income statement. Prorating puts 70% of it, $20,055, in cost of goods sold and $8,595 in finished goods. Cost of goods sold is $28,650 × 0.7 = $20,055 higher than standard, and inventory is carried closer to actual cost. Which treatment applies is a question of materiality and on the accounting policy under your reporting framework.

Standard costs are acceptable for external reporting when they approximate actual cost. IAS 2 allows them if they are reviewed regularly and revised for current conditions, and U.S. GAAP inventory guidance takes a similar view. Persistent unfavorable variances are a signal that inventory may be overstated at standard, or that the standards need to move.

The method has a long history and a set of known distortions. Knowing them is part of using it well.

None of this makes standard costing wrong. It makes it one input. Companies that use it well pair variances with quality, delivery and inventory measures, and revisit the standards often. Where overhead is large and varied, activity-based costing gives a better view of what drives it, and the contribution margin and break-even pages show what the cost structure means for profit. The contribution margin calculator and the break-even point page are the natural next steps.

See what a cost structure does to profit with the contribution margin calculator, or price goods delivered to your door with the landed cost calculator.