Browse Business Software Categories

Close  

Accounting

ERP

Manufacturing

Material Usage Variance: Formula, Causes and How Manufacturing ERP Tracks It

Material Usage Variance: Formula, Causes and How Manufacturing ERP Tracks It

Last updated: October 12, 2026 · Independent guide · We do not sell rankings or coverage.

Material usage variance is the difference between the quantity of material you actually used and the standard quantity your bill of materials allows for the good output you produced, valued at the standard price. It is unfavorable when production consumes more material than the standard allows and favorable when it consumes less. Because it is valued at standard price, it isolates consumption problems such as scrap, bad standards and substitutions, while purchase price variance captures what you paid.

Material usage variance formula and journal entries

The formula is:

Material usage variance = (Actual quantity used − Standard quantity allowed for actual good output) × Standard price per unit

A positive result is unfavorable. Sources use both sign conventions: NetSuite’s help computes production quantity variance as standard minus actual. Label your reports with “F” and “U” so nobody has to infer the meaning from the sign.

Purchase price variance (PPV) is its partner: (Actual price − Standard price) × Actual quantity purchased. When you record PPV at receipt, raw materials enter inventory at standard. Every later movement, including the usage variance, is then valued at standard price. AccountingCoach’s standard costing explanation (no date shown) uses this approach and records the entire price variance when materials are received.

Account Debit Credit Note
Raw materials inventory AQ purchased × SP Receipt: material enters inventory at standard
Purchase price variance If unfavorable If favorable Receipt: (AP − SP) × AQ purchased
Accounts payable AQ purchased × AP Receipt: supplier invoice amount
Work in process SQ allowed × SP Production: standard material for good output
Material usage variance If unfavorable If favorable Production: (AQ used − SQ) × SP
Raw materials inventory AQ used × SP Production: everything actually issued, at standard
Finished goods inventory Standard cost of output Completion: WIP relieved at standard
Work in process Standard cost of output Completion

AQ is actual quantity, SQ is standard quantity allowed, AP is actual price and SP is standard price. At period end, the variance accounts are usually closed to cost of goods sold, or allocated between inventory and cost of goods sold when they are material (see the accounting rule section below).

Worked example: a bracket line for one month

The figures in this section are an illustration, not data from a real company. A metal fabricator makes steel brackets. The standard cost card allows 2.5 lb of steel sheet per good bracket at a standard price of $3.20 per lb.

Step 1: Record the purchase. The company buys 30,000 lb at $3.35 per lb, a total invoice of $100,500. At standard, the receipt is worth 30,000 × $3.20 = $96,000. PPV is ($3.35 − $3.20) × 30,000 = $4,500 unfavorable.

Step 2: Find the standard quantity allowed. The line completes 11,000 good brackets. Standard quantity allowed is 11,000 × 2.5 = 27,500 lb. Use good output, not the quantity started, or scrapped units will hide inside the standard.

Step 3: Find the actual quantity used. Material issues to the production orders total 28,600 lb.

Step 4: Calculate the usage variance. (28,600 − 27,500) × $3.20 = 1,100 × $3.20 = $3,520 unfavorable.

Step 5: Reconcile to the actual cost of material used. If you compute the price variance on quantity used instead of quantity purchased, it is ($3.35 − $3.20) × 28,600 = $4,290. The price and usage variances then add up to $7,810, which equals the actual cost of material used (28,600 × $3.35 = $95,810) minus the standard cost of output ($88,000). This check confirms that nothing is double counted.

Account Debit Credit Note
Raw materials inventory $96,000 30,000 lb at $3.20
Purchase price variance $4,500 Unfavorable
Accounts payable $100,500 30,000 lb at $3.35
Work in process $88,000 27,500 lb allowed at $3.20
Material usage variance $3,520 1,100 lb excess, unfavorable
Raw materials inventory $91,520 28,600 lb issued at $3.20
Finished goods inventory $88,000 Material portion of 11,000 brackets
Work in process $88,000 Relieved at standard

The 1,400 lb left in raw materials carries a value of $4,480 at standard. Purchasing owns the $4,500 PPV, and production and engineering own the $3,520 usage variance.

Common causes of material usage variance

Scrap and yield loss. Setup scrap, trim loss, rejected parts and machine crashes all consume material without producing good output. AccountingTools lists more than the normal amount of scrap and poor-quality or damaged raw material among the causes. If scrap is a planned part of the process, build it into the BOM as a scrap or yield factor so the standard reflects normal loss and the variance shows only the abnormal part. Our guide to quality management in manufacturing ERP covers how scrap and nonconformance records are captured.

BOM inaccuracies. A quantity per that was never right, a unit of measure mismatch (pounds on the BOM, sheets on the issue) or an engineering change that never reached the costed BOM will produce a variance every time the item is built. AccountingTools names an incorrect standard and a BOM not updated after a design change as causes. A variance that repeats at the same rate on every order usually points to the BOM, not the shop floor.

Substitutions. When the floor uses an alternate component, the substitute shows as unplanned usage and the planned component shows as unused. Each line produces a variance, and the two offset only if the substitute has the same standard cost and quantity.

Backflushing errors. Backflushing issues components at the BOM quantity when you report completions. If the floor scraps material and nobody records it, the system still issues the standard amount, so the usage variance is zero and the loss appears later as a cycle count or physical inventory adjustment.

Timing and late transactions. Material issued after the final receipt to stock, or returned after it, often posts straight to variance. Practitioners on the Epicor User Help Forum (April 2024 and January 2026) describe late labor, material and scrap transactions as a frequent cause of unexpected job variances in Epicor.

The accounting rule behind it

US GAAP does not prescribe a formula for usage variance. It governs how standard costs and their variances reach the financial statements. ASC 330 accepts standard costs for inventory when they are adjusted at reasonable intervals to reflect current conditions and approximate one of the recognized cost bases. CLA (February 13, 2025), a CPA firm, quotes this language in its guidance on capitalized variances.

PwC’s Inventory guide (December 2021), section 1.4.2, explains that variances between actual costs and standards are absorbed into inventory so that, at the balance sheet date, the standard cost approximates actual cost. Section 1.3.1 adds that abnormal costs for wasted materials (spoilage) should be included in current period charges. In practice, normal usage variances follow the inventory, while abnormal scrap goes straight to expense. For the wider choice of costing method, see our comparison of standard cost vs actual cost.

Common mistakes

  • Using planned output instead of actual good output. The standard quantity allowed must flex to what you produced. Comparing usage to the original order quantity mixes a volume difference into the usage variance.
  • Valuing usage at actual price. This counts the price difference twice, once in PPV and again in usage.
  • Netting components. A favorable variance on one component can hide an unfavorable one on another. Review variances by component, not only by order.
  • Counting scrap as good output. If scrapped units are reported as completions, the standard quantity allowed rises and the variance shrinks.
  • Leaving the standard stale. When the same variance appears every month, update the BOM or the standard rather than explaining it again in each close.

How to report it

Report usage variance by production order, item and component, with quantities next to dollars and the percentage over standard, so small items with large overruns stand out.

Show PPV on a separate line owned by purchasing. Before closing the variance accounts to cost of goods sold, reconcile them to the variance report. If balances are significant, allocate them between inventory and cost of goods sold, and expense abnormal scrap in the period.

How ERP systems calculate and report it

Oracle NetSuite. Under standard costing, assembly item records carry a Production Quantity Variance Account and a Production Price Variance Account, and item records also carry a Purchase Price Variance Account. NetSuite calculates production variances on assembly builds per component and cost category. Its standard costing reports, under Reports > Cost Accounting, include Production Variances by Item and Purchase Price Variances by Item. Oracle says the first helps identify areas where too much scrapping occurs.

Epicor Kinetic. This paragraph relies on practitioner discussion rather than Epicor documentation. Users on the Epicor User Help Forum (threads from January 2023 to January 2026) describe MFG-VAR as a total job variance posted when standard-cost parts move from WIP to stock, covering labor, burden, subcontract and material together. To find the material share, practitioners start with the Production Detail report, comparing actual material, labor and burden costs with standard to see whether the problem is cost or quantity, and use the Inventory/WIP Reconciliation report filtered to MFG-VAR to trace the transactions.

Acumatica. According to the MYOB edition of Acumatica’s help, the Production Order Details form (AM209000) shows planned and actual material cost by operation on its Totals tab, whether materials were issued manually or backflushed. The Production Order Performance report (AM652000) summarizes planned, actual and variance costs for an order before you close it. Acumatica’s 2025 R2 Manufacturing guide states that Close Production Orders (AM506000) posts any remaining WIP balance to the WIP Variance account. That entry does not separate usage from other causes, so review the order before closing. For a broader comparison, see NetSuite vs Acumatica or our list of discrete manufacturing software.

How we researched this

We read the top-ranking pages for “material usage variance” (AccountingTools, AccountingCoach and Accounting Simplified). They explain the formula well, but only AccountingCoach shows journal entries, and none covers ERP software or backflushing. We then checked vendor documentation from Oracle NetSuite, Acumatica and the MYOB edition of Acumatica’s help, PwC’s inventory guide and practitioner forums for Epicor. All sources were checked on October 12, 2026. No vendor paid for inclusion.

Related guides

Frequently asked questions

Is material usage variance the same as material quantity variance?

Yes. Material usage variance, material quantity variance and material efficiency variance are names for the same measure. AccountingCoach uses all three. NetSuite calls it production quantity variance.

What does an unfavorable material usage variance mean?

It means production used more material than the bill of materials allows for the good units completed. Common reasons are scrap, rework, poor-quality material, an inaccurate BOM or substitutions. Investigate by component and order before deciding whether the standard or the process is wrong.

Can backflushing hide material usage variance?

Yes. Backflushing issues components at the BOM quantity, so unrecorded scrap does not create a usage variance. The loss surfaces later as an inventory count adjustment. Record scrap as it happens or switch high-scrap components to manual issue.

Where does material usage variance go at month end?

Most manufacturers close it to cost of goods sold. If the balance is significant, allocate it between inventory and cost of goods sold so that inventory approximates actual cost. Abnormal spoilage is expensed in the period.

Sources

  • AccountingTools (Steven Bragg), Direct material usage variance, February 19, 2026. accountingtools.com
  • AccountingCoach, Standard Costing: Direct Materials Usage Variance, no date shown. accountingcoach.com
  • Accounting Simplified, Direct Material Usage Variance, September 7, 2020. accounting-simplified.com
  • PwC, Inventory guide, sections 1.3.1 and 1.4.2, December 2021. viewpoint.pwc.com
  • CLA (CliftonLarsonAllen), Tips on When to Apply Capitalized Variances in Inventory Management, February 13, 2025. claconnect.com
  • Oracle NetSuite Help, Setting Up Item Records for Standard Costing, no date shown (metadata 2016). docs.oracle.com
  • Oracle NetSuite Help, Assembly Build Production Cost Variances, no date shown (metadata 2016). docs.oracle.com
  • Oracle NetSuite Help, Standard Costing Reporting, no date shown (metadata 2016). docs.oracle.com
  • Acumatica, End-User Guide: Manufacturing 2025 R2, last updated December 15, 2025. acumatica.com
  • MYOB Acumatica Help, Production Cost Drivers: Material Costs, no date shown. help.myob.com.au
  • MYOB Acumatica Release Notes, Enhancements to the Production Order Performance Report, no date shown. help.myob.com.au
  • Epicor User Help Forum (independent user community), MFG-VAR calculation, April 15 to May 14, 2024. epiusers.help
  • Epicor User Help Forum (independent user community), Manufacturing Variances, January 17 to 19, 2023. epiusers.help
  • Epicor User Help Forum (independent user community), Manufacturing Material Variance (MFG-VAR) calculation logic, January 14 to 15, 2026. epiusers.help

Sherman Hsieh

CEO & Editor-in-Chief, Business-Software.com
Independent analysis of enterprise software — ERP, CRM and more
Sherman Hsieh is the founder, CEO, and editor-in-chief of Business-Software.com. He leads the site's independent, buyer-focused coverage of ERP, CRM, and other business systems, including vendor-neutral comparisons, pricing analysis, and implementation guidance. Before founding Business-Software.com, Sherman was an executive at Siebel ...