Scrap cost analysis by product and cause

Scrap cost analysis measures the recorded cost of rejected production, less matched recovery credits, by product, plant, and cause. Separate the quantity scrapped from the cost attached to each rejected unit. That distinction tells you whether a loss increased because more material was rejected, the same rejection became more expensive, or both changed.

Define what counts as scrap before totaling it

Use the production disposition: scrapped, reworked, returned to stock, or held for inspection. A temporary quality hold is not automatically a final loss. Retain the original event reference so repeated inspections of one rejected item do not create multiple scrap records.

The EPA's Lean and Environment Toolkit includes excessive raw-material consumption and discarded scrap among environmental wastes. That makes material loss worth investigating, but the financial measure still needs a defined cost basis. Do not replace recorded cost with an unsupported estimate of total business impact.

Set the scope with the plant controller and quality manager. Decide which posting date, cost basis, rejection stage, and recovery treatment the report uses. Manufacturing cost analysis covers the wider production-cost comparison; this schedule isolates the loss records inside it.

Build one loss row per disposition event

Export scrap quantities and reason codes from production or quality records, together with the corresponding inventory or expense postings. Include plant, product revision, batch, event date, disposition reference, quantity unit, material rate, conversion rate, and recovery credit.

Here, an Ohio manufacturer uses recorded material and conversion rates at the stage of rejection. Conversion comprises the labor and overhead attached to the rejected items. IRS Publication 538 identifies direct materials, direct labor, and certain indirect costs as manufactured inventory cost components; the controller's approved book-costing policy determines the amounts used here.

Put the following inputs in an Excel Data worksheet. Columns A through G are plant, product, reason, scrap units, material per unit, conversion per unit, and recovery credit.

Conversion rates reflect rejection stages. The example excludes disposal expense and rework. If those costs belong in your review, show separately recorded amounts rather than assuming they are already included in the rates.

Calculate gross loss, recovery, and net loss

Gross scrap cost = Scrap quantity × (Material cost per unit + Conversion cost per unit)

Net scrap cost = Gross scrap cost − Matched recovery credit

Enter gross scrap cost in H2 and net scrap cost in I2, then fill down through row 4:

=D2*(E2+F2)
=H2-G2

The check is $1,360 + $640 − $160 = $1,840. Whole-dollar results require no rounding; retain the underlying precision when actual cost rates have more decimal places.

Use Microsoft's SUMIFS function, which sums values meeting multiple criteria, to retrieve Ohio product A's net loss:

=SUMIFS(Data!I2:I4,Data!A2:A4,"Ohio",Data!B2:B4,"A")

Covirage is not affiliated with Microsoft.

Reconcile gross cost and recovery separately to their ledger postings. Follow the treatment actually recorded: scrap can already be embedded in production consumption or inventory cost. The cost flow analysis provides the broader inventory reconciliation, so this analytical view does not become another expense added to the ledger.

Separate quantity effects from cost effects

Suppose only the setup loss changes in a second month. The rejected quantity increases and the material rate rises; conversion per unit and recovery credit remain unchanged.

Net loss rises by $1,030 − $750 = $280. Calculate the quantity effect at the old combined rate: (120 − 100) × (6 + 2) = $160. Calculate the material-rate effect at the new quantity: 120 × (7 − 6) = $120. Conversion-rate and recovery effects are both zero, so $160 + $120 = $280 reconciles the increase.

This ordering assigns the interaction to the rate effect; keep the same convention every month. Quality owns the quantity investigation, while purchasing and finance validate the material rate. A changed posting rate does not by itself prove that supplier pricing caused the change.

For prioritization, compare losses with the product's commercial importance using revenue concentration by line. Start with a documented cause and an owner, then measure whether the proposed process change reduces recorded loss.

Where scrap cost analysis goes wrong

• Finished-product cost applied too early. Rejects before processing may carry less conversion cost. Use the documented rejection stage.
• Standard cost called actual cost. Label the basis and reconcile any standard-to-actual adjustments separately. Do not imply a precision the records cannot support.
• Units mixed across products. Pounds, pieces, and batches cannot be added into a meaningful quantity total without conversion. The example uses pieces throughout.
• Recovery matched to the wrong period. Later resale proceeds can flatter a month's result. Keep unmatched credits visible until their attribution is supported.
• Loss counted twice. Quality reports, material issues, and inventory write-offs can describe the same event. Retain their relationship rather than summing every report.

Analyze your own scrap records in Covirage

Bring your scrap log, production cost export, and recovery-credit records to Covirage. Covirage maps the columns, its tools compute and check the quantity and cost comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for industrial manufacturers for the manufacturing context.