How is a material price variance calculated?

Material price variance equals (actual price minus standard price) times actual quantity purchased. If standard is 4.00 dollars per pound, you paid 4.30 dollars, and used 2,000 pounds, the variance is 0.30 times 2,000, or 600 dollars unfavorable. This isolates the purchasing effect from usage. A separate material quantity variance, (actual quantity minus standard quantity) times standard price, captures scrap and overconsumption on the floor.

What is the difference between labor rate and labor efficiency variance?

Rate variance is (actual rate minus standard rate) times actual hours and reflects wages, overtime, or crew mix. Efficiency variance is (actual hours minus standard hours) times standard rate and reflects productivity. If you paid 28 dollars against a 25 dollar standard for 500 hours, that is 1,500 dollars unfavorable rate. If standard allowed 450 hours, the 50 extra hours at 25 dollars is 1,250 dollars unfavorable efficiency. Different owners, different fixes.

When is a variance favorable versus unfavorable?

Unfavorable means actual cost exceeded standard: you spent more, so it hurts profit. Favorable means actual came in under standard. Sign matters by category; a favorable material price paired with an unfavorable quantity variance often means you bought cheaper material that scrapped more. Do not celebrate a favorable total that hides offsetting problems. Always review categories individually before judging whether the period was genuinely under control.

How do I set a threshold for investigating variances?

Use both a dollar and a percentage trigger so you catch large absolute misses and small-but-systemic ones. A common rule is investigate anything over 5 percent of standard or 1,000 dollars, whichever is lower for the line. A 2 percent variance on a 500,000 dollar material line is 10,000 dollars and worth a look, while a 20 percent variance on a 200 dollar item may not be. Tune thresholds to your volume.

What causes an overhead variance and how do I split it?

Overhead variance splits into spending variance (actual overhead cost versus budgeted) and volume variance (actual hours or units versus the base used to set the rate). If you applied overhead at 40 dollars per machine hour on 1,000 planned hours but ran only 800, you under-absorbed 8,000 dollars of fixed overhead regardless of spending. Low volume, not overspending, drives that miss, so the fix is utilization, not cost cutting.

How often should standard costs be updated?

Review standards at least annually and re-roll whenever a material price moves more than 5 to 10 percent, a routing changes, or a labor rate is renegotiated. Persistent one-directional variances, for example six straight months of unfavorable material price, signal a stale standard rather than a process problem. Updating too often hides real performance drift, so change standards deliberately and document the reason, then compare future actuals against the new baseline.

Manufacturing Cost and Quoting

Standard Cost Variance Spreadsheet Template

Compare actual production costs to standard costs and quantify variance by material, labor, and overhead for a period or a job.

Overview

This template compares actual production costs against standard costs and quantifies variance by material, labor, and overhead for a job or a period. It is built for cost accountants, controllers, and operations managers who need to explain why actual spend missed the standard. Working variances on a spreadsheet instead of eyeballing a P&L isolates whether the miss came from paying more per unit or using more units, which points directly at purchasing, the shop floor, or the standard itself.

You enter standard material cost per unit, standard labor rate and hours, and standard overhead, then the actual figures from invoices and production records. The sheet computes variance in dollars and percentage for each category and totals them. Splitting labor into a rate variance (paid more per hour) and an efficiency variance (took more hours) matters because the fixes are different. A favorable rate but unfavorable efficiency tells you the standard is fine but the process is slow.

In a real close, pull standards from your cost system and actuals from job records, then review category variances to prioritize investigation. Flag every unfavorable variance above a threshold, say 5 percent or 1,000 dollars, for root cause review. Use the results to decide whether to fix the process or update an outdated standard. Feed recurring findings back into your quoting so estimates reflect true cost. Pair it with the Standard Cost Variance Calculator for quick single-item checks.

What this template includes

Standard material cost per unit input
Actual material cost per unit
Standard labor rate and hours
Actual labor rate and hours
Overhead standard vs. actual
Variance dollar and percentage by category
Total variance summary

Suggested use case

Use this for monthly cost accounting close, production variance reporting, or root cause analysis when actual costs exceed standard.

How to use it

Enter standard cost data from your cost system.
Enter actual costs from your production records or invoices.
Review variance by category to prioritize investigation.
Flag unfavorable variances for root cause review.

Frequently Asked Questions

How is a material price variance calculated?: Material price variance equals (actual price minus standard price) times actual quantity purchased. If standard is 4.00 dollars per pound, you paid 4.30 dollars, and used 2,000 pounds, the variance is 0.30 times 2,000, or 600 dollars unfavorable. This isolates the purchasing effect from usage. A separate material quantity variance, (actual quantity minus standard quantity) times standard price, captures scrap and overconsumption on the floor.
What is the difference between labor rate and labor efficiency variance?: Rate variance is (actual rate minus standard rate) times actual hours and reflects wages, overtime, or crew mix. Efficiency variance is (actual hours minus standard hours) times standard rate and reflects productivity. If you paid 28 dollars against a 25 dollar standard for 500 hours, that is 1,500 dollars unfavorable rate. If standard allowed 450 hours, the 50 extra hours at 25 dollars is 1,250 dollars unfavorable efficiency. Different owners, different fixes.
When is a variance favorable versus unfavorable?: Unfavorable means actual cost exceeded standard: you spent more, so it hurts profit. Favorable means actual came in under standard. Sign matters by category; a favorable material price paired with an unfavorable quantity variance often means you bought cheaper material that scrapped more. Do not celebrate a favorable total that hides offsetting problems. Always review categories individually before judging whether the period was genuinely under control.
How do I set a threshold for investigating variances?: Use both a dollar and a percentage trigger so you catch large absolute misses and small-but-systemic ones. A common rule is investigate anything over 5 percent of standard or 1,000 dollars, whichever is lower for the line. A 2 percent variance on a 500,000 dollar material line is 10,000 dollars and worth a look, while a 20 percent variance on a 200 dollar item may not be. Tune thresholds to your volume.
What causes an overhead variance and how do I split it?: Overhead variance splits into spending variance (actual overhead cost versus budgeted) and volume variance (actual hours or units versus the base used to set the rate). If you applied overhead at 40 dollars per machine hour on 1,000 planned hours but ran only 800, you under-absorbed 8,000 dollars of fixed overhead regardless of spending. Low volume, not overspending, drives that miss, so the fix is utilization, not cost cutting.
How often should standard costs be updated?: Review standards at least annually and re-roll whenever a material price moves more than 5 to 10 percent, a routing changes, or a labor rate is renegotiated. Persistent one-directional variances, for example six straight months of unfavorable material price, signal a stale standard rather than a process problem. Updating too often hides real performance drift, so change standards deliberately and document the reason, then compare future actuals against the new baseline.