# Spare Parts Criticality Worksheet (Excel)

> Source: https://netray.co/tools/spare-parts-criticality-scoring-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Score each spare by consequence of failure, likelihood, lead time and sourcing risk to decide what to stock on site.

## Category

maintenance

## Industry

Manufacturing

## Audience

- Maintenance manager
- Storeroom supervisor
- Reliability engineer
- Buyer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part

**Key:** part

**Type:** text

#### Asset

**Key:** asset

**Type:** text

#### Consequence (1-5)

**Key:** consequence

**Type:** number

**Help:** 1 = no production impact, 5 = line down or safety/environment event.

#### Likelihood (1-5)

**Key:** likelihood

**Type:** number

**Help:** 1 = rare failure, 5 = fails often.

#### Lead time (weeks)

**Key:** lead_weeks

**Type:** number

**Unit:** weeks

#### Sourcing risk (1-5)

**Key:** sourcing

**Type:** number

**Help:** 1 = many suppliers, 3 = single source, 5 = sole OEM or obsolete.

#### Unit cost

**Key:** unit_cost

**Type:** number

**Format:** currency

#### Criticality score

**Key:** score

**Type:** number

**Expr:** consequence * (likelihood + sourcing + if(gt(lead_weeks,26),5,if(gt(lead_weeks,12),4,if(gt(lead_weeks,6),3,if(gt(lead_weeks,2),2,1))))) / 3

**Format:** decimal

#### Stock policy

**Key:** policy

**Type:** select

**Options:**

- Stock on site
- Stock min 1
- Vendor managed
- Order on demand
- Review

**Rows:**

**Part:** Servo drive 7.5 kW

**Asset:** Press 3 main drive

**Consequence:** 5

**Likelihood:** 2

**Lead weeks:** 16

**Sourcing:** 4

**Unit cost:** 4800

**Policy:** Stock on site

**Part:** Spindle bearing set

**Asset:** CNC 204

**Consequence:** 4

**Likelihood:** 3

**Lead weeks:** 10

**Sourcing:** 3

**Unit cost:** 2150

**Policy:** Stock min 1

**Part:** Proximity sensor M18

**Asset:** Packing line

**Consequence:** 2

**Likelihood:** 4

**Lead weeks:** 1

**Sourcing:** 1

**Unit cost:** 38

**Policy:** Vendor managed

**Part:** PLC CPU module

**Asset:** Furnace control

**Consequence:** 5

**Likelihood:** 1

**Lead weeks:** 30

**Sourcing:** 5

**Unit cost:** 7600

**Policy:** Stock on site

**Part:** V-belt set

**Asset:** Dust collector fan

**Consequence:** 2

**Likelihood:** 4

**Lead weeks:** 1

**Sourcing:** 1

**Unit cost:** 65

**Policy:** Order on demand

**Totals:**

#### Total unit cost of listed spares

**Key:** unit_cost

**Agg:** sum

**Format:** currency

#### Average criticality score

**Key:** score

**Agg:** avg

**Format:** decimal

#### Highest criticality score

**Key:** score

**Agg:** max

**Format:** decimal

**Summary:**

#### Value of one of each spare

**Key:** spares_value

**Expr:** sum_unit_cost

**Format:** currency

**Description:** Holding one of every listed spare.

#### Highest score on the list

**Key:** top

**Expr:** max_score

**Format:** decimal

**Primary:** true

**Notes:** Score is consequence multiplied by the average of likelihood, sourcing risk and a lead time score (1 for 2 weeks or less, up to 5 above 26 weeks). Scores range from about 1 to 25. As a starting rule, 15 and above are stock-on-site candidates, 8 to 14 are review, and below 8 are order-on-demand. Adjust the thresholds to your cost of downtime.

## Content

**Intro:** Not every spare deserves shelf space. This worksheet scores each part on what happens if it fails, how likely that is, how long it takes to get and how hard it is to source, so you can justify what to stock and what to buy when needed.

**Sections:**

#### How to use the worksheet

**Body:** List the spares for one asset or area at a time. Score consequence from 1 to 5 using your own production loss and safety scale, so a 5 means a stoppage or incident that costs more than the part ever will. Score likelihood from failure history or the maintenance team. Enter the real supplier lead time in weeks and rate sourcing risk. The sheet converts lead time to a 1 to 5 score and multiplies consequence by the average of the three risk factors. Sort by score and apply your stock policy.

#### Why these factors

**Body:** Classic criticality analysis weighs consequence against probability, and spare parts add two supply side factors. Long lead time and a single source turn a modest failure into a long outage. A cheap sensor that is in stock next door scores low even if it fails often, while a rarely failing controller with a 30 week lead time scores high. This is why insurance spares, items held because failure is unlikely but intolerable, appear at the top of the list.

**Bullets:**

- High consequence and long lead time: stock on site
- High likelihood and low cost: min and max stock
- Low consequence and short lead: order on demand
- Sole source or obsolete: review for alternates

#### Using the result

**Body:** Take the top scored items and compare the cost of holding them with the cost of downtime. If a one hour outage costs more than the part, stock it. For low scoring items, consider vendor managed inventory or consignment. Review the list annually and after any major failure. When items are in an ERP, link the score to the material master or stock policy field so replenishment logic follows the decision.

#### Common mistakes

**Body:** Scoring parts instead of failure modes, copying OEM recommended spares lists without checking your duty, ignoring parts shared across several assets, and never revisiting scores after a design change. Also check that stocked critical spares are stored correctly and not cannibalized, otherwise the safety net is gone when you need it.

**Cta:** Netray can read your stock levels, consumption and lead times from the ERP and flag critical spares that are below their policy, in a private read-only view.

**Faq:**

#### What is an insurance spare?

**Answer:** It is a part with low failure probability but high consequence and long lead time, held only to avoid a long outage. Typical examples are large motors, main drives and control modules.

#### How should I score consequence?

**Answer:** Define the scale once, for example hours of lost production or safety and environmental impact, and apply it to every item. Agree it with operations so a 5 means the same thing to everyone.

#### Can I weight the factors differently?

**Answer:** Yes. Export to Excel and change the weights, for example doubling sourcing risk for imported parts. Keep the logic documented so other planners can follow it.

#### How often should I review criticality?

**Answer:** At least yearly, and after major failures, equipment changes or supplier changes. Lead times in particular can change quickly and move parts across your thresholds.

## Search terms

spare parts criticality worksheet, spare parts criticality analysis, critical spares list template, mro criticality ranking, insurance spares identification, spare parts stocking decision, critical spare parts excel, storeroom criticality matrix

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json