Spare Parts Reorder Point, Safety Stock & Economic Service Level

The formula

This is the expression the tool evaluates. Every term is named underneath, with the unit it must be supplied in.

How the result is derived

Step by step, from the values you type to the figure on screen.

1. The 10 inputs are read from the form on every keystroke: Units Installed in the Plant, Mean Life of the Part, Replenishment Lead Time, Order Quantity, Unit Cost, Annual Holding Rate, Downtime per Stockout, Downtime Cost, Machines Stopped per Stockout and Policy Service Level.
2. Each value is checked against the accepted range in the input table below. A value outside its range stops the calculation rather than producing a misleading figure — the results blank out and a message appears.
3. The validated values are substituted into the expression above, which resolves Reorder Point at the Policy Service Level together with every supporting figure in one pass — no value is carried over from a previous entry.
4. The supporting outputs — Economically Optimal Reorder Point, Economically Optimal Service Level, Annual Cost of Running the Policy Instead, Reorder Point the Normal Shortcut Would Give, Expected Demand in the Lead Time, Safety Stock at the Policy Level, Service Level Actually Achieved and Criticality Index — come from the same pass, so they always describe the same case as the headline figure.
5. Results are rounded for display only. The full-precision value is used throughout the chain, so reading a rounded intermediate figure back into the tool by hand can shift the last digit.

What each input means

Where to read each value on the floor, the unit it must be in, and the range the tool accepts.

What the tool returns

The headline figure and every supporting value it is built from.

Worked example

Substituting

Two things here are worth more than the headline. The economics ask for 99.2% service where the policy says 95%, and that difference is three units on a shelf against 679 a year - the policy is the expensive choice. And the normal shortcut returns 15.46, which rounds to 15, where the exact Poisson needs 16: it under-stocks by a unit in precisely the high-service region a critical spare occupies.

How to use it

1. Work through the input groups in order — Demand & Lead Time and Costs & Policy. The defaults are a realistic case, so you can change one value at a time and watch what moves.
2. There is no calculate button. Every figure recalculates as you type or drag, which is what makes this usable for a what-if sweep rather than a single answer.
3. Read Reorder Point at the Policy Service Level in the dark results panel — that is the headline figure, expressed in units.
4. Check the supporting rows underneath (Economically Optimal Reorder Point, Economically Optimal Service Level, Annual Cost of Running the Policy Instead, Reorder Point the Normal Shortcut Would Give, Expected Demand in the Lead Time, Safety Stock at the Policy Level, Service Level Actually Achieved and Criticality Index) before acting on the headline — they are where an implausible input usually shows itself first.
5. Reset to defaults returns every field to the reference case, which is the quickest way to check whether a surprising result came from the tool or from an input you had changed earlier.

Where this is used

• Process planning — establishing Reorder Point at the Policy Service Level before a trial is booked, so machine time and material in Quality Systems, Traceability, Utilities & Factory Decisions are committed against a calculated figure rather than an estimate.
• Costing and quotation — Reorder Point at the Policy Service Level is an input to the cost sheet, and quoting from a worked number rather than a remembered one is what keeps a margin intact.
• Troubleshooting — when the floor result drifts from plan, entering the measured values (starting with Units Installed in the Plant) shows how much of the gap in Reorder Point at the Policy Service Level each variable explains.
• Teaching and study — the accepted ranges bracket normal Quality Systems, Traceability, Utilities & Factory Decisions practice, so moving one variable at a time shows the shape of the relationship rather than a single answer.

Reading the result

Typical bands and what each one is telling you.

Assumptions and limits

• The Poisson model assumes replacements are independent and the installed population is large relative to the demand in a lead time, which holds for a wear-out part fitted in quantity and fails for a part with only two or three installed. It also assumes a constant failure rate over the lead time: a part with a strong wear-out characteristic has an age-dependent rate, and the preventive-maintenance interval tool is the right place to treat that. Lead time is taken as deterministic - lead-time variability raises the required stock above these figures, and on an imported part it is often the dominant uncertainty. The criticality bands are conventional and should be recalibrated to the plant before being used to rank a store.
• Every input is bounded to the range normal practice occupies (Units Installed in the Plant 1 to 100000, Mean Life of the Part 0.05 to 40 yr and Replenishment Lead Time 1 to 365 d, and so on for the rest). Those bounds are guard rails against typing errors, not a claim that the formula fails one unit outside them.
• The calculation is deterministic: the same inputs always give the same result. It carries no allowance for machine condition, operator skill, ambient conditions or lot-to-lot material variation unless an input above explicitly represents one.
• Nothing is sent anywhere. The maths runs in your browser, so the numbers you type never leave the page.

Standards and further reading

• ISO 55000 / ISO 55001 - Asset management, which frames spares holding as an asset-risk decision.
• EN 13306 - Maintenance terminology, for the mean life and lead time definitions used here.
• IEC 60300-3-11 - Dependability management, reliability centred maintenance, for criticality assessment.
• Acklam rational approximation to the inverse normal CDF, used only for the comparison figure.

Questions people ask