Set spare-parts stock by asset risk and replenishment reality

Why a uniform usage-history rule fails in a sparse-demand storeroom setup

When maintenance and inventory leads search for maintenance spares management or review critical spare parts inventory, established industry and academic references already lay out core concepts:

• IBM's overview of spare parts management already explains asset criticality, supplier lead times, inventory control levels, insurance spares and stock/no-stock decisions.
• Grainger's guide on how critical spare planning protects uptime outlines a practical review chart combining criticality, supplier lead time and maintainability (note that direct open-text extraction from that page was limited during review, so we cite its framework summary without claiming a complete page audit).
• In operations research, Janne Huiskonen's (2001) study on maintenance spare parts logistics characteristics in the International Journal of Production Economics (cited here from the primary research abstract) identifies criticality, specificity (standard versus user-specific parts), demand pattern (erratic/sparse versus predictable), and value as distinct control dimensions that a single inventory formula cannot collapse.

In practice, however, an individual plant team sometimes configures a single trailing-usage script (Reorder Point = 12-month average daily usage × supplier lead time) across every maintenance SKU during an initial setup. That configured rule is a local implementation choice—not a built-in default in ERPNext material request or auto-creation of material request (S05), where item-level reorder levels and quantities are configured per item and warehouse—and applying it uniformly produces three predictable distortions in the hypothetical plant examined below:

1. Zero-usage penalty on single-point bottleneck parts: A custom 45 kW extruder drive module or main gearbox shaft that has run without failure for 18 months shows 0.00 monthly consumption. In a storeroom governed by a trailing-usage script, its reorder level is calculated as zero, leaving the line exposed to a 16-week OEM import lead time.
2. Untracked rotable cores bought repeatedly as new consumables: Rotary cutter heads, servo motors and hydraulic proportional valves that can be overhauled by an approved workshop in 14 days for a fraction of replacement cost are issued as one-way consumables when the local setup does not track the worn core in a WORKSHOP_REPAIR bin.
3. Orphan spares retained on retired equipment: When a legacy mixer or packaging machine is decommissioned, its dedicated spares remain active in the item master with active auto-reorder rules if no equipment-to-part where-used link (Asset BOM) is checked before running replenishment (S05).

Set spare-parts stock by asset risk and replenishment reality — reporting workflow

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

Read the complete workflow as text

1. Link active spare SKUs to equipment hierarchy and Asset BOM → Score stoppage consequence and approved redundancy with maintenance
2. Score stoppage consequence and approved redundancy with maintenance → Compare vendor lead time, workshop repair loop and approved alternates
3. Compare vendor lead time, workshop repair loop and approved alternates → Assign P1 insurance, P2 rotable, P3 buffered wear or P4 non-stock rule
4. Assign P1 insurance, P2 rotable, P3 buffered wear or P4 non-stock rule → Route stock additions, repair cores and orphan stock to named owners

Four-class stocking matrix and cross-functional ownership boundaries

Consistent with the four control characteristics highlighted in Huiskonen's (2001) spare-parts logistics framework and the planning principles in UK HSE maintenance guidance (S19—which provides general UK guidance on planned, competent maintenance rather than a universal statutory inventory mandate), maintenance stocking policies should separate sparse-demand risk protection from routine preventive consumption. In the matrix below, quantities such as Min 1 / Max 1 or specific rotable pool sizes are scenario-dependent parameter choices that must be set from site engineering, failure-mode and availability evidence rather than applied as universal constants:

Worked example: reclassifying 120 maintenance spares on an extrusion and packaging line (Batch MSP-CRIT-2026-10)

Scope note: All equipment IDs (EXT-L04, RET-MIX-01), part numbers (SPR-4012 to SPR-4210), fictional specification codes, lead times, issue counts, scenario Min/Max choices and rupee figures below are hypothetical illustrative planning records at assumed unit costs. They do not represent statutory book values, universal stocking ratios, reliability predictions, or guaranteed working-capital savings; actual equipment criticality, safety-component classification, accounting treatment of repairable cores and capital/inventory additions, and safe return-to-service decisions remain with qualified site engineering, EHS and finance personnel.

Consider synthetic plastic film extrusion and converting plant PUNE-EXT-02, which reviews 120 active maintenance spare SKUs (Batch MSP-CRIT-2026-10) supporting 18 active machines on primary extrusion line EXT-L04 (plus one legacy mixer RET-MIX-01 that was decommissioned 18 months earlier). Prior to the review, the plant had configured a single custom reorder formula based on trailing 12-month issue history across all 120 SKUs, resulting in an illustrative pre-review stock value of Rs 49,00,000 at assumed unit costs while leaving four single-point bottleneck drives and shafts at zero stock.

Table 1: Portfolio reconciliation across 120 reviewed maintenance SKUs (Batch MSP-CRIT-2026-10)

Table 2: Item-level decision trace for 5 representative SKUs from Batch MSP-CRIT-2026-10

To see how the four Huiskonen dimensions (criticality, specificity, demand pattern and value) interact with actual replenishment lead times and equipment links in this scenario, trace five individual part records from the 120-SKU batch:

Three governance rules that keep this reclassification audit-safe

1. Why illustrative target-stock changes (-Rs 14,00,000 gross / -Rs 6,80,000 net) are not instant P&L savings or automatic book revaluations: All rupee amounts in Tables 1 and 2 represent illustrative target stock values at assumed unit costs. Lowering SPR-4105 from 24 SET (Rs 1,08,000) to a target of 6 SET (Rs 27,000) or pooling SPR-4048 from 3 EA (Rs 3,30,000) to 2 EA (Rs 2,20,000) reduces future replenishment orders (S05) as stock draws down; how repairable cores (SPR-4048) and workshop overhaul charges (Rs 18,500/turn) are carried on the books or expensed depends on company finance policy. Similarly, proposing 4 missing P1 spares (+Rs 7,20,000, including SPR-4012 at Rs 1,80,000) requires formal funding and purchasing approval, and does not trigger immediate cash outflow upon target reclassification or automatic fixed-asset capitalisation. For the 35 Class P4 items (Rs 4,90,000), planners must explicitly disable item auto-reorder rules (auto-creation of material request, S05) and govern open or manual MRs/POs—because setting Min = 0 alone does not prevent purchasing if projected quantity falls below a configured reorder level or if a user submits a manual request—and any write-down of the 10 orphan RET-MIX-01 SKUs (Rs 3,10,000, including SPR-4210 at Rs 62,000) requires the Finance Controller's approved valuation workflow (see deciding what to do with obsolete and excess factory inventory).
2. Why technical and safety classification cannot be inferred from an inventory rule: Scenario parameters such as Min 1 / Max 1 for P1 or a 2-unit rotable pool for P2 must be validated by engineering for each asset duty, and P2 procurement rules must allow approved exceptions when workshop repair turnaround slips, capacity is constrained, or an emergency breakdown occurs—not solely upon certified core condemnation. Likewise, non-stock (Class P4) treatment applies to non-safety items such as workshop storage-cabinet hardware (SPR-4189); components on machine perimeter guarding, interlocks or pressure/electrical boundaries require qualified EHS and engineering assessment (S19) and must never be downgraded to non-stock by a stores planner alone. Any alternate vendor part must also pass effective-dated engineering approval before use (see approving alternate components without changing the BOM by accident and governing item masters so duplicate parts do not break factory planning).
3. Why stocking readiness remains distinct from safe work execution: Having 1 EA of SPR-4012 on the shelf closes the planning-data gap tracked in showing parts and access gaps before maintenance scheduling, but physical installation and return to service remain governed by competent maintenance execution (S19) and site EHS permit controls.

Run a 90-day spare-parts criticality review on one bottleneck line

Before changing reorder parameters across a plant storeroom, validate this four-class matrix on 100–150 spares tied to a single production line:

1. Map every candidate spare to an active parent equipment ID (Asset BOM) and disable orphan auto-reorders: Flag any spare with an active reorder rule that has no active equipment link or is tied only to retired machinery (Class P4 orphan candidate); disable its auto-reorder rule (S05), review any open MRs/POs, and require EHS/engineering review before reclassifying any guarding or safety-related part.
2. Size Class P1 insurance coverage and Class P2 rotable pools from engineering and turnaround evidence: Have Maintenance Engineering document asset redundancy, failure modes, OEM lead time and workshop repair turnaround before submitting funding and purchasing requests for missing P1 spares or setting P2 pool sizes.
3. Create a dedicated WORKSHOP_REPAIR ERP bin and exception gate for Class P2 rotables: Enforce a 1-for-1 core return workflow when issuing a serviceable rotable assembly, agree core carrying-value rules with finance, and define the approval path for new purchases when cores are condemned or workshop repair turnaround is delayed.
4. Protect approved Class P1 reorder levels in ERP replenishment (S05): Restrict changes to Class P1 reorder parameters so they require joint Maintenance Engineering, Plant Head and Finance sign-off following an equipment modification, reliability review or retirement.