Decide what to do with obsolete and excess factory inventory

Why backward-looking inventory aging fails manufacturing

Many plants identify Excess and Obsolete (E&O) inventory by running a backward-looking stock aging report: anything with zero issue transactions in the past 90, 180 or 365 days enters a write-down schedule. In discrete and batch manufacturing, backward movement history is an unreliable proxy for economic utility:

1. False positives on valid long-cycle stock: Imported supplier Minimum Order Quantities (MOQs) or critical maintenance spares may sit untouched for eight months while remaining committed to next quarter's production schedule.
2. False negatives on immediate ECO obsolescence: When engineering releases an immediate-effectivity Engineering Change Order (ECO) to replace a component, the old revision may have moved yesterday—so a backward aging report marks it 0–30 days fresh for the next six months even though its forward production demand is now zero.

Decide what to do with obsolete and excess factory inventory — reporting workflow

Follow the workflow below, or open its complete text version.

Read the complete workflow as text

1. Extract slow-moving and ECO-superseded pool → Net stock against forward MRP and spares demand
2. Net stock against forward MRP and spares demand → Evaluate alternate-BOM and vendor RMA recovery
3. Evaluate alternate-BOM and vendor RMA recovery → Segregate terminal lots for scrap liquidation
4. Segregate terminal lots for scrap liquidation → Prepare tiered E&O reserve proposal for finance

Four-stage forward-netted E&O governance workflow

To give operations and finance an evidence-based disposition table, quarterly E&O reviews run through four stages:

Stage 01 — Forward MRP netting and horizon partitioning

Instead of looking only backward, the review compares each SKU's unrestricted plus quality-hold balance against forward 12-month gross requirements from the Master Production Schedule (MPS) and aftermarket service forecasts:

• Covered active stock (up to 12 months cover): Retained in active stock.
• Horizon excess (12 to 24 months cover): Active part with valid BOM links, but carrying surplus quantity from forecast drops or high supplier MOQs. Replenishment buying is frozen immediately.
• Zero-demand / superseded stock: No active parent BOM link or zero forward demand across the 12-month horizon.

Stage 02 — Engineering alternate-BOM substitution review

Before purchasing or finance writes down superseded stock, engineering evaluates whether the part can be consumed via an approved deviation or alternate BOM entry on secondary product lines, non-critical sub-assemblies or internal fixture builds.

Stage 03 — Commercial recovery (supplier RMA & customer claims)

For standard catalogue components, purchasing negotiates supplier return-to-vendor (RMA) credits (often subject to a restocking discount) or swaps against open purchase orders. Where excess stock was bought specifically against a customer's binding Make-to-Order commitment or cancelled project, commercial teams prepare a contractual recovery claim.

Stage 04 — Aftermarket spares transfer versus physical scrap liquidation

Components for phased-out machines often retain value for aftermarket service commitments. Valid service quantities transfer to the spares store (WH-SVC-01), while shelf-life-expired chemicals and unrecoverable custom castings are physically rendered unusable and sold as scrap so they cannot re-enter active production bins.

Worked example: quarterly E&O review (EO-REV-2026-Q3)

An illustrative industrial machinery manufacturer conducts its Q3 inventory disposition review (EO-REV-2026-Q3) across 480 flagged SKUs carrying a gross book value of ₹1,60,00,000 (₹1.60 Crore). Rather than applying a flat aging percentage, the cross-functional committee evaluates forward netting and recovery across five disposition cohorts under the company's finance-approved reserve matrix:

Reconciling the recovery and reserve arithmetic

• 100% gross pool conservation: ₹50,00,000 (Forward absorption) + ₹45,50,000 (Active recovery) + ₹64,50,000 (Net unrecovered exposure) = ₹1,60,00,000 (31.25% + 28.44% + 40.31% = 100.00%).
• Working-capital salvage: Engineering and commercial actions recover ₹45,50,000 in value—comprising ₹21,00,000 consumed via approved alternate BOMs, ₹12,00,000 credited by vendors on RMA returns, ₹10,00,000 recovered from the cancelling MTO customer and ₹2,50,000 realized in certified scrap liquidation.
• Itemized reserve proposal: The ₹47,00,000 reserve proposal (29.38% of gross book value) is tied cohort-by-cohort to net uncovered exposure (25% × ₹18L = ₹4.5L, 100% × ₹15L = ₹15L, 100% × ₹6L = ₹6L, 50% × ₹8L = ₹4L, and 100% × ₹17.5L = ₹17.5L) for finance sign-off.

Implementation checklist for E&O prevention

• Mandatory ECO depletion check: Require an on-hand and open-PO stock depletion plan before switching a non-safety ECO to immediate effectivity.
• Automated MRP buy-block: Freeze new purchase requisitions on any SKU whose net uncovered horizon exceeds 12 months.
• Physical quarantine of written-down stock: Move fully provisioned obsolete lots into locked location WH-OBSOLETE-HOLD so written-down stock cannot be re-issued without finance review.