By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated October 23, 2026
A standard-costing workbook is most useful when its material, labor, and overhead variances reconcile to the actual cost of production, not just to each other. This Excel tutorial uses a fictional 1,000-unit manufacturing run and shows how to calculate $24,000 standard cost versus $26,870 actual production cost, with a fully explained $2,870 unfavorable variance.
A key distinction: material bought is not necessarily material used. We calculate the purchase-price variance on 2,200 lb purchased, the production-usage variance on 2,100 lb consumed, and the $30 price difference related to 100 lb still unused. We also work through fixed and variable manufacturing-overhead variances, rather than leaving overhead as an unexplained plug.
The accompanying Excel SAMPLE shows formula-driven worksheets, investigation flags, and independent QA checks; this article provides the source assumptions and business interpretation. Results are for internal management illustration only, not a complete inventory accounting or regulatory reporting policy.
TL;DR: a reconciled standard-costing model
- Standard manufacturing cost per unit: $24 = $8 materials + $10 labor + $6 applied manufacturing overhead.
- Materials: 2,200 lb purchased versus 2,100 lb used. The $660 unfavorable purchase-price variance is not all a production variance; $30 relates to unused raw material at the stated actual price.
- Labor: $540 unfavorable rate and $800 unfavorable efficiency, summing to $1,340.
- Overhead: $150 U variable spending + $200 U variable efficiency + $150 U fixed budget + $0 fixed volume = $500 U.
- Actual production cost is $26,870, versus $24,000 standard: $2,870 U, reconciling to the production-basis component variances.
- For all tutorial calculations positive variance means unfavorable, negative means favorable. Standards, quantity units and costs need source evidence and effective dates. Production cost is not automatically this month’s COGS.
Table of Contents
- What standard costing measures
- Workbook structure and assumptions
- Complete 1,000-unit production example
- Material, labor, overhead and cost reconciliation
- Excel formulas and investigation thresholds
- Variance interpretation and inventory valuation
- ABC and overhead double counting
- Standard controls and methodology
- Frac CFO products and services
- Monthly close and QA checks
- Spreadsheet versus ERP requirements
- FAQs
- Sources
What standard costing actually measures
A standard cost reflects a planned or normal quantity of materials, labor time, and production overhead multiplied by standards for their prices or rates. Standards allowed for actual production output must be distinguished from an original static budget, actual hours worked, and denominator capacity used to derive fixed overhead rates.
Variance analysis compares the allowed standard with actual quantities and rates. It supports operational investigation, not automatic blame. A favorable purchase price may mean a discount, but also a lower material grade; unfavorable labor efficiency can result from rework, late supplies, product mix or unrealistic standards.
Management versus financial accounting: A standard-cost worksheet can be used for planning and process improvement. For financial reporting, standard costing may be acceptable only under the applicable accounting framework and where the technique appropriately approximates inventory cost. Inventory, WIP, finished goods, abnormal waste, unused capacity and COGS require proper end-of-period reconciliation and accounting policy rather than leaving all variances in an unreviewed account.
Our figures use a cost-based unfavorable-positive sign convention throughout: actual cost or usage exceeding standard is positive U; lower cost is negative F. The example assumes a single homogeneous material priced at $4.30/lb for both purchased and consumed quantities, no material returns and no other manufacturing adjustments.
Set up the Excel standard-cost workbook
A three-tab model may demonstrate the concept, but practical production costing requires source separation and reconciliation. The SAMPLE uses ten worksheets: Guide, Standards, Material Purchases, Production Actuals, Overhead, Variance Analysis, Reconciliation, Dashboard, Investigations and QA Checks.
Start with units and stable product IDs. For the fictional one-product, one-period example, the Standards worksheet records 2 lb material/unit at $4/lb, 0.5 labor hours/unit at $20/hour, and overhead rates of $5 variable plus $7 fixed per standard labor hour.
=StandardMaterialQtyPerUnit*StandardMaterialPrice
+StandardLaborHoursPerUnit*(StandardLaborRate+StandardVariableOHRate+StandardFixedOHRate)
Expected total: $24 per unit. Set standard hours allowed based on actual good production output, not hours paid, material purchased or machine capacity. Actual manufacturing cost uses material used, actual direct labor, and actual manufacturing overhead. Record purchase/receipt and material issue quantities separately.
Store the effective date and source for each cost standard; use approved rates when products, suppliers or process standards change. Include units of measure and conversion checks for pounds, kilograms, hours and other drivers; avoid silently mixing incompatible quantities.
Worked example: 1,000 units, $24,000 standard cost and $26,870 actual cost
A fictional manufacturing shop produces 1,000 finished units. Its standards and actuals below are chosen to let you check every part of the variance bridge.
| Standard input | Standard | Cost/unit |
|---|---|---|
| Direct material | 2 lb × $4/lb | $8 |
| Direct labor | 0.5 h × $20/h | $10 |
| Variable overhead | 0.5 h × $5/h | $2.50 |
| Fixed overhead | 0.5 h × $7/h | $3.50 |
| Standard unit cost | $24 |
Actuals: material purchased 2,200 lb at $4.30/lb; material used 2,100 lb at the same $4.30/lb; 540 paid direct labor hours at $21/h; actual variable overhead $2,850 and fixed overhead $3,650. The applied fixed overhead rate of $7/h comes from a $3,500 fixed budget and 500 normal-capacity denominator hours. Standard hours allowed for 1,000 units = 1,000 × 0.5 = 500 h.
Material bought versus material consumed
Purchase-based price variance: 2,200 × ($4.30 − $4.00) = $660 U. Material usage variance: (2,100 − 2,000) × $4 = $400 U. However, these two figures together do not equal the material production cost difference because 100 lb purchased were not consumed.
Usage-based price variance: 2,100 × ($4.30 − $4.00) = $630 U. The unused-inventory purchase-price difference = (2,200 − 2,100) × $0.30 = $30 U. This is a reconciliation of price differences, not an assertion that every ERP will post the amount to inventory under the same accounting policy.
Production-material reconciliation: actual consumed cost 2,100 × $4.30 = $9,030 versus standard allowed cost 2,000 × $4 = $8,000; difference is $1,030 U = $630 usage-based price + $400 quantity.
Direct labor variances
Labor rate: 540 × ($21 − $20) = $540 U. Labor efficiency: (540 − 500) × $20 = $800 U. Actual labor $11,340 − standard allowed $10,000 = $1,340 U = $540 + $800.
Variable and fixed manufacturing overhead
Standard variable overhead rate is $5/h; standard fixed overhead rate is $7/h. Actual hours are 540, standard hours allowed for actual output are 500. Budgeted fixed overhead is $3,500, reflecting the 500 denominator hours.
| Overhead variance (unfavorable-positive) | Calculation | U |
|---|---|---|
| Variable spending | $2,850 − (540 × $5) | $150 |
| Variable efficiency | (540 − 500) × $5 | $200 |
| Fixed budget/spending | $3,650 − $3,500 | $150 |
| Fixed production volume | $3,500 − (500 × $7) | $0 |
| Total overhead variance | $6,500 actual − $6,000 applied | $500 |
At a different production volume, fixed production-volume variance need not be zero. It compares budgeted fixed overhead with fixed overhead applied at standard hours allowed for actual output, not fixed overhead budget with actual hours worked. Consult the OpenStax overhead-variance explanation for this important distinction.
Reconcile the complete standard-cost versus actual-cost result
| Cost component | Standard cost | Actual production cost | Variance (U) |
|---|---|---|---|
| Material consumed | $8,000 | $9,030 | $1,030 |
| Direct labor | $10,000 | $11,340 | $1,340 |
| Manufacturing overhead | $6,000 | $6,500 | $500 |
| Total production | $24,000 | $26,870 | $2,870 |
Sum production-basis component variances, not purchase-price variance plus usage without adjustment: material $630 price on used + $400 usage + labor $540 rate + $800 efficiency + overhead $150 variable spending + $200 variable efficiency + $150 fixed spending + $0 fixed volume = $2,870 U. The reconciliation difference should be $0.
Illustrative production-cost bridge
$1,030 U
Labor variance
$1,340 U
Overhead variance
$500 U
The three variances sum to $2,870: actual manufacturing cost $26,870 less $24,000 allowed standard cost. This is a cost-accounting example, not a statement of inventory expense or cash flow.
Production ≠ COGS. If finished units are unsold at period-end, applicable costs remain in work-in-progress or finished-goods inventory rather than all appearing in current-period COGS. Financial valuation of raw materials, WIP, finished goods and variances requires a reviewable policy and inventory movement schedule.
Copyable Excel formulas for purchase, usage and overhead variances
The companion workbook uses source inputs on Standards, Material Purchases, Production Actuals and Overhead. For the initial demonstration, the formulas below show precisely how the example is calculated; all variances use positive = unfavorable.
Purchase price, Material Purchases!F12:
=F7*(F8-Standards!$F$9)
Usage-based material price, Material Purchases!F13:
=F9*(F8-Standards!$F$9)
Material usage variance, Variance Analysis!F9:
=('Production Actuals'!F8-Standards!F7*Standards!F8)*Standards!F9
Labor rate, Variance Analysis!F10:
='Production Actuals'!F10*('Production Actuals'!F11-Standards!F11)
Labor efficiency, Variance Analysis!F11:
=('Production Actuals'!F10-Standards!F7*Standards!F10)*Standards!F11
Variable overhead spending, Overhead!F14: =F12-F8*F9. Variable overhead efficiency, F15: =(F8-F7)*F9. Fixed budget variance, F16: =F13-F11. Fixed production-volume variance, F17: =F11-F7*F10. These formulas assume F7 standard hours allowed, F8 actual hours, F9 standard variable OH rate, F10 standard fixed OH rate, F11 budgeted fixed OH, F12 actual variable OH and F13 actual fixed OH.
Investigation rules: specify both an approved dollar threshold and an appropriate positive standard-cost base. A formula such as =IF(OR(ABS(D5)>=1000,IF(E5<=0,TRUE,ABS(D5)/E5>=5%)),"Investigate","") flags exceptions above $1,000, above 5% of the standard base, or where the denominator is invalid. Adjust the tolerance to your business and document every change. A zero denominator should not automatically be deemed immaterial.
Minimum workbook validation
Check purchased quantity ≥ used quantity in this simple no-opening-inventory example; purchase-price variance = usage-based price variance + unused-quantity price component; total labor variance = labor rate + efficiency; actual overhead − applied overhead = sum of four overhead variances; and actual production cost − standard cost = summed production-basis variances. An individual product’s standard effective date, UOM and source coverage must also be reviewed. All formula checks can pass while raw ERP data remain incomplete.
Interpret cost variances as investigation signals, not automatic explanations
Materials: pricing may change because of supplier terms, foreign exchange, quality substitutes or shipment mix. Usage may change with scrap, rework, defects, machine calibration or an unrealistic bill of materials. Labor: rates reflect staffing and overtime; efficiency can reflect line balance, downtime, material quality, maintenance and employee training. Overhead: distinguish usage of the driver from spending against the flexible budget and from fixed capacity volume.
Investigate large favorable and unfavorable deviations. Include purchasing, operations, engineering and quality personnel, rather than automatically assigning a single manager blame. Maintain an investigation log recording SKU/batch, variance, root-cause evidence, action, owner, due date and approval.
Financial statement inventory costing: important limitations
Under IAS 2, standard-costing techniques may be used when their results approximate cost, with standards reflecting normal quantities, efficiency and capacity and reviewed as necessary. Fixed production overhead allocation is generally based on normal capacity, not inflated simply because output is low. Certain abnormal waste and unallocated overhead costs may need immediate expense recognition.
For an entity following US GAAP, relevant inventory guidance includes ASC 330 and the company’s applicable cost-accounting policy. The journal-entry treatment of purchase price, efficiency, overhead and inventory variances may differ by system and framework. Do not automatically expense all $2,870 or capitalize it all into finished goods. Reconcile opening raw materials, purchases, material issues, WIP, finished goods, actual sales and inventory at the period end; determine appropriate variance allocation or disposition with your accountant.
Changing the standard rate does not retroactively eliminate the variance. Retain versioned standards, approved effective dates and historical reports. Separate management-standard variances from formal cost-of-sales entries unless proper accounting treatment has been applied.
Activity-based costing and standard costing can work together
Material and labor can remain on standard quantity/rate cards while overhead uses separate drivers where products demand different setups, inspections or dispatches. Activity-based costing (ABC) groups eligible overhead into activity cost pools, divides by valid activity driver totals, and assigns costs according to usage.
| Activity pool | Pool total | Total activity | Rate |
|---|---|---|---|
| Machine setups | $30,000 | 150 | $200/setup |
| Quality inspections | $18,000 | 600 | $30/inspection |
| Packing/shipping | $12,000 | 2,400 | $5/order |
A product using 40 setups, 100 inspections and 200 orders receives $12,000 of this illustrative $60,000 activity-pool total. That is one product’s share, not the total overhead of the company. All products’ consumption should reconcile to each pool’s eligible cost, with treatment of unused capacity and other exceptions separately explained.
Prevent double counting: when replacing an existing applied overhead rate with ABC for the same factory cost pools, do not also charge that original rate on top of the ABC allocation. A simple ABC model may be more suitable than a single-rate model for diverse products, but the correct level of detail depends on the source data and decisions. See Frac CFO’s Cost Allocation Model in Excel for driver selection, support reallocation and QA.
Keep standards accurate, versioned and understandable
Standard-cost models are only as reliable as their BOM quantities, normal scrap allowance, work-time standards, wage assumptions, overhead budgets and production records. Review standards when material prices, production processes, product specifications or capacity assumptions change, and at a documented recurring interval. Changes should take effect on a recorded date and retain prior cost cards for comparisons.
Before calculating variance, reconcile good finished units produced, source material purchased and issued, time records, actual direct labor spending and the total fixed and variable factory-overhead pools. Keep dimensions consistent: pounds must not be added to kilograms, payroll clock-hours need treatment of downtime and production labor, and standard hours allowed must be based on finished output.
Need a new standard-cost model or an audit of the one you have?
For a tailored production-cost engine, material standards, activity drivers, variance classifications, flexible budgets, inventory movements, reports and QA, start with Custom Finance Project: Build to Your Budget. Submit the proposed scope and budget; feasibility and a written project scope are agreed before any payment.
If your existing workbook has broken formulas, unexplained variances or unreliable references, the Excel Spreadsheet Audit & Repair service (published starting at $29 at the time reviewed) offers scope-based diagnosis and agreed corrections. One-time Projects lists additional finance work.
The Custom Financial Model focuses on integrated financial-statement forecasting, not automatically a standard-cost and production-variance system. For ongoing finance services, refer to the published STARTER, GROWTH and SCALE pages for current payment and service terms, including any annual-payment savings; do not represent twelve times the monthly rate as a confirmed discounted annual quote.
Share your SKUs, standards, actuals and reporting needs. Define the production, accounting and analysis scope before a workbook build begins.
Monthly standard costing close checklist
- Import approved production output, material receipt and issue records, time data and actual overhead from source systems.
- Validate effective standard version, SKU IDs, units of measure, quantities and abnormal production/quality exceptions.
- Reconcile materials purchased, used and unused; calculate purchasing and production variances on their respective bases.
- Separate variable overhead spending and efficiency from fixed spending and production volume.
- Prove actual production cost − allowed standard cost = sum of production-basis variances.
- Reconcile inventory movements, WIP and finished goods before financial reporting or posting variance dispositions.
- Flag variances against approved dollar and percentage thresholds; log cause, responsibility and corrective action.
- Preserve approved period snapshots and standard versions before changing assumptions.
Spreadsheets and ERP systems: where each fits
Excel is effective for documenting standards, importing source exports, analyzing variances and testing assumptions. Enterprise ERP systems add controlled material receipts, inventory movements, BOM revisions, work orders and posted journal entries. Oracle’s standard-cost spreadsheet integration is an example of Excel used alongside a controlled ERP.
A spreadsheet-only management model can support decisions for a simpler business, but it does not automatically substitute for an accounting general ledger, approved cost rollups, physical inventory records, bank support or financial reporting reconciliations. Match the tool to your manufacturing operations, control requirements and audit needs.
Frequently asked questions about standard costing
What is standard costing versus actual costing?
Standard costing assigns expected unit rates and usage before or during production and separately analyzes deviations. Actual costing reflects actual costs for the applicable period or batch. Management variance analysis and financial inventory valuation must follow the applicable cost-accounting policy.
Why don’t purchase-price plus usage variances equal my material production-cost difference?
Purchase-price variance may use quantity purchased, while production cost uses quantity consumed. In the sample, 100 of the 2,200 lb were not used, creating a $30 purchased-but-unused price difference. Purchase-based $660 plus $400 quantity less $30 unused price difference = $1,030 production material variance.
How is the fixed overhead production-volume variance calculated?
It is budgeted fixed overhead minus fixed overhead applied to actual output at the standard activity requirement, under the stated convention. This is not the difference between actual hours worked and budgeted fixed overhead hours. In our specific 1,000-unit example, $3,500 budgeted and $3,500 applied result in $0 volume variance.
Should unfavorable variances be posted entirely to COGS?
Not automatically. Differences may relate to inventory remaining in raw material, work in progress and finished goods, or to expenses such as abnormal waste. The accounting treatment depends on the recognized framework, cost method, materiality and accounting policy. Review end-of-period inventory movement and variance dispositions.
When should standard costs be updated?
Use a documented periodic review and revise when suppliers, labor rates, production procedures, specifications or normal-capacity assumptions change materially. Maintain dated approvals and historical standard versions rather than erasing past variances.
Is a favorable cost variance necessarily good?
No. Lower material price could hide poor quality; faster production could hide missed inspections. Investigate both favorable and unfavorable differences based on materiality, business context and supporting records.
Can I combine standard costing with activity-based costing?
Yes. Use well-supported standards for direct materials and labor and more detailed activity drivers where the original overhead allocation is misleading. Avoid applying both the old overhead rate and a new ABC allocation to the same underlying cost pools.
About the author
Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.
Sources and further reading
- OpenStax – Compute and Evaluate Materials Variances
- OpenStax – Compute and Evaluate Labor Variances
- OpenStax – Compute and Evaluate Overhead Variances
- IFRS Foundation – IAS 2 Inventories
- Oracle – Manage Standard Costs in a Spreadsheet
All manufacturing figures and assumptions in this article are fictional. They are not an approved accounting policy, tax treatment or independently audited inventory valuation.

One Response