Spares Criticality Matrix & MRO Stocking Toolkit

Purpose

This toolkit helps you reduce working capital while keeping the right parts on hand for fast repairs. Use the tools here to classify spares by criticality, set rational reorder points and safety stock, manage obsolescence, and tag parts in your CMMS so spares decisions align with your reliability strategy.

Who this helps

Maintenance planners, storeroom supervisors, reliability engineers, purchasers, and plant managers in any-size manufacturing operation who want to lower carrying costs, avoid emergency procurement, and shorten repair lead times.

Quick start — three practical moves

1. Score: Use the Criticality Scoring Template to score 100–200 parts most often requested for repairs.
2. Calculate: For each part, compute reorder point and safety stock using the Lead-time & Usage Calculators.
3. Tag: In your CMMS, link the part to failure modes, criticality score, priority flag and preferred supplier. Put high-criticality items on a fast replenishment method (consignment, VMI, Kanban) if lead time or single-sourcing risk is high.

What’s included (and how to use each piece)

• Criticality scoring template

  Dimensions (example): Safety risk, Production impact (minutes/hour lost), Single-source or long lead time, Repair time / complexity, Cost to carry, and Likelihood of failure. Score each 1–5 (1 = low, 5 = high). Multiply weights if you have priorities (safety > production > cost). Sum scores and map totals to priority bands (e.g., 20–25 = Critical, 15–19 = Important, 10–14 = Routine, <10 = Low).

  Tip: Start with a pragmatic weight set (safety 30%, production 35%, lead-time risk 20%, cost 15%). Revisit weights after a pilot.

• Lead-time and usage calculators

  Core formulas to use:

  • Average demand per day (D̄): total usage over a period / number of days in that period.
  • Reorder point (ROP) = D̄ × Lead time (days) + Safety stock.
  • Safety stock (simple, constant LT) = z × σ_daily_demand × sqrt(Lead time in days). Use z corresponding to desired service level (e.g., z≈1.28 for 90%, 1.65 for 95%).

  For variable lead time, use the more general variance-aware formula as a refinement: Safety stock = z × sqrt((LeadTime × σ_d^2) + (D̄^2 × σ_LT^2)). If you do not have good variance data, use conservative safety stock for critical spares and improve data collection over time.

  Example: If average daily usage is 0.2 units/day, lead time = 30 days, σ_daily = 0.15, and target service level 95% (z=1.65): ROP = 0.2×30 + 1.65×0.15×sqrt(30) ≈ 6 + 1.35 ≈ 7.35 → round to 8 units.

• Reorder guidance for slow-moving parts

  Slow movers often require a different approach than high-turn spares. Options:

  • Move to periodic review (Q,R) or min/max rather than continuous replenishment.
  • Consider safety stock bands (0–2 units for low criticality, 3–6 for medium) or use a reorder point of 1 plus lead-time demand for very low usage parts.
  • Assess alternatives: pooling across plants, local scrap/repair options, vendor consignment, or strategic agreements (long-term blanket orders).
• Obsolescence tracker

  Suggested fields: Part number, description, OEM part number, BOM links, last usage date, last purchase date, lifecycle status (active, at risk, obsolete), replacement candidate, replacement lead time, shelf life (if applicable), and recommended disposition action. Review annually and flag parts for engineering review if they’re obsolete or at risk.

• CMMS tagging & failure-mode linkage procedure

  Essential CMMS fields to add or standardize: criticality score, priority flag (A/B/C), linked failure mode(s), mean time between failures (MTBF estimate), preferred supplier, lead time, storage location, minimum shelf life, and replenishment method (PO, Kanban, consignment).

  Process: When a part is approved for stocking, attach a short failure-mode note explaining how the part is used in the repair and the consequence of unavailability. This makes spares decisions traceable to reliability goals.

Priority mapping (example)

Use the summed criticality score to assign priorities that drive stocking policy:

• Critical (Top tier): Keep on-site; safety stock sized to 99%+ service level; consider consignment/VMI or dual-sourcing.
• Important: Keep minimum on-site; monitor usage monthly; reorder with expedited option available.
• Routine: Keep small buffer; reorder with normal PO process; allow longer lead times.
• Low: Do not stock locally unless history changes; central pool or make-to-order.

Common pitfalls & how to avoid them

• Hoarding: Avoid using an across-the-board safety-factor increase — score and differentiate by criticality.
• Poor data: Validate usage and lead-time inputs before changing policy; run a 6–12 month pilot and measure stockouts and emergency buys.
• Disconnected decisions: Ensure maintenance, stores, procurement, and engineering agree on criticality criteria and CMMS fields.

How to pilot this toolkit

1. Select 50–200 parts that account for most downtime events or purchase spend.
2. Score parts with a cross-functional team (maintenance, operations, procurement, reliability).
3. Calculate ROP and safety stock and implement changes for the top two priority bands only.
4. Track outcomes for 3–6 months: stockouts avoided, emergency PO frequency, carrying cost change, downtime prevented.
5. Refine scoring weights and safety stock methods based on pilot results.

Ready-to-copy fields & tables

Copy these column headings into a spreadsheet or directly into your CMMS:

• Plant | Location | Part Number | Description | OEM PN | Criticality Score | Priority Band | Avg Daily Usage | σ_daily | Lead Time (days) | ROP | Safety Stock | On-hand | Reorder Qty | Supplier | Replenishment Method | Last Used | Lifecycle Status

Next steps & recommended improvements

1. Implement the criticality scoring template and tag parts in CMMS for the pilot scope.
2. Create the calculators in a spreadsheet or, for repeated use, convert them into an interactive form or calculator in the platform so users can save and compare results between locations.
3. Run periodic obsolescence reviews and integrate findings with engineering change control.

Where interactive capability would help (capability notes)

Turning the calculators and the scoring template into interactive forms improves consistency and makes it easy to save results to organizational memory. Suggested platform capabilities to add:

• Interactive scoring form and calculator (rendered inputs, saved submissions) so teams can score parts and store the JSON results.
• Simple dashboard or export of scored parts and calculated ROPs to CSV for CMMS import.
• Automated alerts for parts whose obsolescence status or usage changes significantly.

Final note

This toolkit is designed to be practical and iterative. Preserve traceability between a part’s criticality, failure mode, and stocking policy. Start with a focused pilot, measure results, and extend policies after validating assumptions about lead times, demand variability, and supplier reliability.