What is the safety stock formula this template uses?

It uses the combined variability formula: safety stock equals z times the square root of (average lead time times demand standard deviation squared) plus (average demand squared times lead time standard deviation squared). This accounts for both demand and lead time uncertainty. If lead time is perfectly stable, it simplifies to z times demand standard deviation times the square root of lead time. The z-score comes from your service level target.

What z-score matches my service level target?

The z-score is the one sided normal value for your cycle service level. 90 percent uses 1.28, 95 percent uses 1.65, 97.5 percent uses 1.96, 99 percent uses 2.33, and 99.9 percent uses 3.09. Higher service levels raise the multiplier steeply, so moving from 95 to 99 percent adds about 40 percent more safety stock. Reserve the top levels for critical or long lead parts.

How is the reorder point different from safety stock?

Safety stock is the buffer for variability. The reorder point is average demand during lead time plus safety stock. If you sell 50 units a day with a 10 day lead time, lead time demand is 500 units; add 150 units of safety stock and your reorder point is 650. You place an order when on hand plus on order hits 650, and the buffer covers demand spikes while you wait.

How do I get the demand standard deviation for a part?

Pull at least 12 months of demand in consistent daily or weekly buckets and use the sample standard deviation of those periods. Match the bucket to your lead time units. If demand is 50 per day with readings from 30 to 80, the standard deviation might land near 12. Strip out one time bulk orders and promotions first, since they inflate variability and oversize the buffer.

Does lead time variability really matter that much?

Often more than demand variability for long lead items. Because the formula multiplies lead time standard deviation by average demand, an unreliable supplier drives most of the buffer. A part with steady demand but lead time swinging from 10 to 30 days needs far more safety stock than one with a stable 20 day lead time. Reducing lead time variance is usually cheaper than carrying the extra inventory it forces.

How do I know if my safety stock is economically justified?

Compare annual carrying cost against the cost of a stockout. Carrying cost is safety stock units times unit cost times your holding rate, usually 20 to 30 percent. If 150 buffer units of a $40 part cost about $1,500 a year to hold at 25 percent, but a stockout idles a line at $500 an hour, the buffer pays for itself in three hours of avoided downtime.

Operations and Labor

Safety Stock Spreadsheet Template

Calculate safety stock levels for each part number using demand variability, lead time, and desired service level.

Overview

This template sizes safety stock per part number for inventory planners, buyers, and supply chain managers who need a buffer against demand and lead time swings without overstocking. Setting stock by gut feel either starves the line or ties up cash in dead inventory. The statistical approach here uses demand variability, lead time variability, and a service level target to compute the exact buffer that protects a chosen fill rate, so every part carries only the inventory its uncertainty justifies.

You enter average daily demand, demand standard deviation, average lead time, lead time variability, and a service level target converted to a z-score. The sheet applies the standard formula that combines demand variance over lead time with lead time variance times demand squared, then multiplies the resulting standard deviation by the z-score. It returns safety stock in units, a reorder point equal to lead time demand plus safety stock, and the annual carrying cost of that buffer.

Load your part master, pull demand history and supplier lead time performance, and set service levels by part criticality, typically 95 to 99 percent for A items. The reorder point column drops straight into your ERP min settings. Review carrying cost to catch parts where a higher service level is not worth the cash. Pair it with the live Safety Stock Calculator to test a single part quickly, then use the template to reset policy across an item class after a supplier change.

What this template includes

Part number and description
Average daily demand and standard deviation
Average lead time and lead time variability
Service level target (z-score input)
Safety stock in units calculation
Reorder point calculation
Annual carrying cost of safety stock

Suggested use case

Use this to set initial safety stock levels for a new item, review safety stock after a supplier change, or build a safety stock policy for an item class.

How to use it

Enter average demand and demand variability per part.
Enter average lead time and lead time variability.
Set service level target as a percentage.
Safety stock and reorder point calculate automatically.
Review carrying cost to ensure safety stock level is economically justified.

Frequently Asked Questions

What is the safety stock formula this template uses?: It uses the combined variability formula: safety stock equals z times the square root of (average lead time times demand standard deviation squared) plus (average demand squared times lead time standard deviation squared). This accounts for both demand and lead time uncertainty. If lead time is perfectly stable, it simplifies to z times demand standard deviation times the square root of lead time. The z-score comes from your service level target.
What z-score matches my service level target?: The z-score is the one sided normal value for your cycle service level. 90 percent uses 1.28, 95 percent uses 1.65, 97.5 percent uses 1.96, 99 percent uses 2.33, and 99.9 percent uses 3.09. Higher service levels raise the multiplier steeply, so moving from 95 to 99 percent adds about 40 percent more safety stock. Reserve the top levels for critical or long lead parts.
How is the reorder point different from safety stock?: Safety stock is the buffer for variability. The reorder point is average demand during lead time plus safety stock. If you sell 50 units a day with a 10 day lead time, lead time demand is 500 units; add 150 units of safety stock and your reorder point is 650. You place an order when on hand plus on order hits 650, and the buffer covers demand spikes while you wait.
How do I get the demand standard deviation for a part?: Pull at least 12 months of demand in consistent daily or weekly buckets and use the sample standard deviation of those periods. Match the bucket to your lead time units. If demand is 50 per day with readings from 30 to 80, the standard deviation might land near 12. Strip out one time bulk orders and promotions first, since they inflate variability and oversize the buffer.
Does lead time variability really matter that much?: Often more than demand variability for long lead items. Because the formula multiplies lead time standard deviation by average demand, an unreliable supplier drives most of the buffer. A part with steady demand but lead time swinging from 10 to 30 days needs far more safety stock than one with a stable 20 day lead time. Reducing lead time variance is usually cheaper than carrying the extra inventory it forces.
How do I know if my safety stock is economically justified?: Compare annual carrying cost against the cost of a stockout. Carrying cost is safety stock units times unit cost times your holding rate, usually 20 to 30 percent. If 150 buffer units of a $40 part cost about $1,500 a year to hold at 25 percent, but a stockout idles a line at $500 an hour, the buffer pays for itself in three hours of avoided downtime.