Spares Classification & Reorder Policy Template

Purpose

Use this template to decide which spares to hold, how much to hold, and how often to review them. The goal is to reduce downtime risk while minimizing working capital tied in MRO inventory. Treat this as a practical starting point—validate inputs with your CMMS/ERP, supplier lead times, and reliability data before changing policies.

How to use this template

1. Export parts and usage history from your CMMS/ERP for the candidate spares list.
2. Score each part using the Criticality Scoring rubric below.
3. Calculate average demand, lead time, safety stock, reorder point, and min/max using the examples provided.
4. Flag obsolete or slow-moving items using the Obsolescence Checklist.
5. Set review cadences and assign owners for ongoing maintenance and audits.

Required spreadsheet columns / data fields

• Part Number
• Description
• Equipment / Location
• Criticality Score (total)
• Avg Monthly Usage (or avg daily)
• Usage Variability (standard deviation or max observed)
• Supplier Lead Time (days)
• Lead Time Variability (days)
• Current On-hand Qty
• Safety Stock
• Reorder Point
• Min / Max
• Status (Active / Obsolete / Bought on demand)
• Alternate Part Available (Y/N)
• Last Review Date
• Owner / Approver

Criticality scoring (practical rubric)

Score each factor 0–5 (0 = no impact, 5 = highest impact). Sum the scores to get a total criticality value. Adjust weights to match your business priorities.

• Production impact: How quickly would production stop if this part failed? (0–5)
• Safety/regulatory impact: Could failure cause injury, environmental harm, or regulatory non-compliance? (0–5)
• Repair time / downtime: How long does a repair take without this part? (0–5)
• Uniqueness / single source: Is this part single-sourced or hard to substitute? (0–5)
• Lead time length: Long lead times increase score. (0–5)
• Historic failure frequency: How often does this part fail for similar equipment? (0–5)

Suggested classification by total score (example):

• Critical (A): total 20–30 — keep on-hand; review monthly
• Important (B): total 11–19 — limited stock; review quarterly
• Non-critical (C): total 0–10 — buy-as-needed or one-off stocking; review annually

Reorder point and safety stock (practical formulas and example)

Use simple, auditable calculations and document assumptions. Two common approaches are shown: a straightforward deterministic method and a variability-aware method.

Deterministic method (easy to explain)

Reorder Point (ROP) = Average daily usage × Lead time (days) + Safety stock

Safety stock (simple) = Max daily usage × Max lead time − Average daily usage × Average lead time
Use this when you have observed worst-case values and need a conservative stock level.

Variability-aware method (more rigorous)

When you know demand and lead-time variability, a common safety stock approximation is:

Safety stock ≈ Z × sqrt( (LeadTimeAvg × σd^2) + (AvgDemand^2 × σLT^2) )

Where Z is the service-factor (e.g., Z≈1.28 for ~90% service, 1.65 for ~95%). Use this only if you can justify demand/lead-time variability with data.

Example (deterministic)

Avg daily usage = 2 units, Average lead time = 10 days → expected demand during lead time = 20 units. If you choose safety stock = 10 units, then ROP = 30 units. Set Min = ROP − (average usage × review period), Max = ROP + buffer (or define Max as economic order quantity or storage constraint).

Min/Max guidance

• Min (reorder point) should trigger procurement or production of replacement stock before you run out under normal conditions.
• Max should reflect storage limits, capital limits, and consumption rate — avoid excessive max that encourages hoarding.
• For critical parts with long lead times, set review cadence and safety stock higher; document the business justification.

Demand review cadence

Recommended cadences by classification (adjust to fit your operations):

• Critical (A): monthly review; reconcile with reliability team and procurement.
• Important (B): quarterly review; verify lead times and usage trends.
• Non-critical (C): annual review or on major changes in demand or suppliers.

Obsolete parts checklist

• Has the associated equipment been retired or modified?
• Has the OEM declared the part obsolete or changed the part number?
• Are there no recent usages (e.g., zero consumption in 24 months)?
• Are replacement parts readily available or is a retrofit planned?
• Is there a technical or safety reason to retain a small emergency stock even if usage is nil?

If answers indicate obsolescence, mark the part Obsolete and route to procurement for disposition or cannibalization review.

Supplier lead-time table (columns to maintain)

• Supplier name
• Part number (supplier)
• Typical lead time (days)
• Lead-time variability / percentile (e.g., 90th percentile days)
• Minimum order quantity
• Alternative supplier available (Y/N)
• Last verified date

MRO audit checklist (periodic tasks)

• Verify critical spares availability against critical equipment list.
• Reconcile physical counts with CMMS on-hand quantities for a sample of parts.
• Validate lead times with suppliers for top 20 long-lead items.
• Review parts flagged as obsolete and confirm disposition.
• Confirm alternate parts and cross-references are current.
• Review and approve any changes to min/max for Critical (A) items.

Governance & roles

• Owner: maintenance or reliability engineer—responsible for part scoring and reviews.
• Inventory custodian: stores and counts physical stock.
• Procurement: negotiates lead times and alternate suppliers.
• Approver: operations or plant manager—approves changes to criticality and stocking policies.
• Document a clear approval threshold: e.g., changes to A-class stocking require Owner + Procurement + Approver sign-off.

Implementation checklist (first 90 days)

1. Extract parts and usage history; prioritize top-impact parts (by criticality and value).
2. Score top 100 parts and calculate ROP and safety stock using this template.
3. Run a pilot with a subset of equipment for one business unit.
4. Measure stockouts, emergency purchases, and MRO carrying cost for 3 months and adjust rules.
5. Document the process in your operating procedures and schedule recurring reviews.

Notes, caveats and best practice

• Do not change stocking policies based solely on a spreadsheet—validate with field experience and failure logic.
• Link this template to CMMS failure codes and equipment criticality to avoid disconnecting parts decisions from reliability strategy.
• For high-value assets, consider engineered spares strategies and involve reliability engineering for mission-critical items.
• When demand is very low or intermittent, consider vendor-managed inventory, consignment, or rapid procurement agreements instead of carrying large safety stock.

Suggested next steps to extend this template

• Copy the fields above into a spreadsheet or CMMS custom view for bulk editing and scoring.
• Create an automated report for parts below Min or flagged Obsolete.
• Integrate supplier lead-time changes into your review cadence.

Quick reference: example template row

Part: P-12345 | Avg monthly usage: 60 | Avg daily usage: 2 | Lead time: 10 days | Criticality: 24 (A) | Safety stock: 10 | ROP: 30 | Min: 30 | Max: 90 | Status: Active | Owner: Reliability Team

Where this template fits in your reliability strategy

This template is a practical operational tool to align MRO stocking with your reliability goals. It does not replace capital planning or certified reliability engineering assessments. Use it to: reduce emergency procurement, lower carrying cost, and improve uptime by keeping the right parts available when they're needed.