Tool

Critical Spares Classification & Stocking Matrix — Interactive Worksheet

An interactive worksheet to capture part and asset data, score criticality, record failure and supplier metrics, document safety stock rationale, and produce practical stocking and reorder guidance you can save to organizational memory.

Interactive Tool

Critical Spares Classification & Stocking Matrix

This interactive worksheet helps you classify spare parts by criticality, record failure and supplier metrics, and produce rational stocking rules and reorder points. Use it jointly with reliability engineering, maintenance, and procurement. The form captures consistent data you can save to your CMMS or inventory system later.

Scoring guidance: capture the four impact scores below (1 = low, 5 = very high). Add the scores to produce a simple Criticality Score (4–20). Use the suggested thresholds as a starting point: 15–20 = Critical, 11–14 = Important, 4–10 = Routine. Adjust thresholds to suit your operation.

Enter the manufacturer part number, internal SKU, or both.
Short description (fit, function, common alternatives).
Asset tag, location, or a URL to the CMMS asset page.
Will absence/failure of this part cause immediate or high-risk safety issues? 1 = no safety impact, 5 = potential serious injury/death.
1.0 10.0
How quickly does this part stop production? 1 = little/no impact, 5 = immediate line stop.
1.0 10.0
Does failure create environmental release, permit breach, or regulatory nonconformance?
1.0 10.0
Direct cost of downtime, quality loss, or expensive repairs caused by part failure.
1.0 10.0
Explain why the part received this score (e.g., single-point-of-failure, redundancy present).
Average number of failures per year for the asset using this part. Use your CMMS or maintenance logs.
If repaired immediately, how many units of this part are typically used per day? For spares that are only used on failure, estimate daily average usage across your fleet.
Mean time to repair when the right part is available. Useful for assessing downtime exposure.
Time from order placement to receipt under normal conditions. Verify with procurement.
Percent of deliveries on time. Low reliability increases safety stock.
Useful for working-capital and risk-cost tradeoffs.
Quantity physically available now.
Existing min or reorder point if one exists.
Existing max if one exists.
Document why safety stock is set at this level (lead time variability, criticality, supplier risk, seasonal demand).
Suggested formula: reorder_point = (avg_daily_usage * supplier_lead_time_days) + safety_stock. Use the values above to calculate. Enter your computed result here.
A starting heuristic: safety_stock = z * sigma_leadtime * avg_daily_usage. If you lack statistical data, consider safety stock = avg_daily_usage * lead_time_variability_days (e.g., 2–5 days for unreliable suppliers).
Select the stocking approach that best fits the part's criticality, lead time, and cost. For high criticality and long lead time, prefer local, consignment, or strategic pool. For low criticality and long lead time, consider emergency ordering or redesign to use common components.
Is this part at risk of becoming obsolete (EOL announced, long lead time, single-source legacy item)?
If risk = Yes, describe mitigation: cross-reference, redesign, buy long-term stock, or secure vendor agreements.
YYYY-MM-DD — when this part data was last validated. Regular reviews are recommended (annual or after supplier change).
Name or role responsible for maintaining this part's policy (e.g., Reliability Engineer, Purchasing).
Capture procurement actions, stock moves, requests for consignment, or engineering changes.
You can explore this tool now. Sign in or create an account to save your responses and return to them later.
Sign In to Save Create an Account
Make this tool part of your work

Save a personal copy, bring it to your team, or tailor the questions and workflow to fit what you are hungry to improve.

Member customization and team collaboration are coming soon.
Discuss Ask the Librarian

Discussion

Comments and conversation will live here.