opscrunch

Safety Stock Calculator (Lead Time Variability)

Calculate safety stock when both demand and lead time vary. Uses the combined standard deviation formula sigma_L = sqrt(LT x sigma_d^2 + D^2 x sigma_LT^2), with a worked example.

Service level and demand

Safety factor for your target service level from the z-factor table, e.g. 1.65 for 95% or 2.33 for 99%.

Average units sold or consumed per day.

Variability of daily demand.

Lead time and its variability

Average days from placing a replenishment order to receiving it.

Variability of the lead time in days. Set 0 for a perfectly reliable supplier.

Safety stock
·units
Combined std deviation·

Buffer covering both demand and lead-time variability at your service level.

Overview

The basic safety stock formula assumes your lead time never moves. When suppliers quote 9 days but sometimes deliver in 14, that assumption breaks, and lead-time variability is often the bigger driver of stockouts. This calculator uses the combined form that pools demand variability and lead-time variability into one standard deviation, then sizes the buffer to your service level.

Method

How it works

Enter your service-level factor, average daily demand and its standard deviation, and average lead time and its standard deviation. The tool first computes the combined standard deviation of demand over the lead time, then multiplies it by the z-factor to get safety stock.

Formula

The formula

sigma_L = sqrt(LT * sigma_d^2 + D^2 * sigma_LT^2); SS = z * sigma_L

sigma_L = sqrt(LT x sigma_d^2 + D^2 x sigma_LT^2), then SS = z x sigma_L. The first term is demand variance accumulated across the lead time; the second scales lead-time variance by the demand rate, because a one-day slip costs you a full day of demand. With sigma_LT = 0 it collapses to the basic form z x sigma_d x sqrt(LT).

Example

Worked example

For a 95% service level (z = 1.65), demand of 250 units/day with sigma_d = 85, a 9-day lead time with sigma_LT = 5: sigma_L = sqrt(9 x 85^2 + 250^2 x 5^2) = 1,275.74, and safety stock = 1.65 x 1,275.74 = about 2,105 units.

FAQ

Frequently asked questions

When should I use this instead of the basic safety stock calculator?

Use this version whenever lead times meaningfully vary — irregular supplier performance, long import lanes, congested ports. If your lead time is effectively constant, the basic service-level safety stock calculator needs fewer inputs and gives the same answer.

How do I estimate the standard deviation of lead time?

Pull the actual lead times of your last 20-30 receipts for the item (PO date to receipt date) and compute their standard deviation in a spreadsheet with STDEV. If you lack history, a rough start is (worst case - typical case) / 3, refined as data accumulates.

Where does the z value come from?

From the standard service-level table: 1.28 for 90%, 1.65 for 95%, 2.05 for 98%, 2.33 for 99%. It converts your target cycle service level into a number of standard deviations of buffer.

Why does demand appear squared in the formula?

The lead-time term is sigma_LT scaled by the demand rate D — each extra day of delay exposes you to a full day of demand — and variances add as squares, so D^2 x sigma_LT^2 appears under the square root.

The rest of the bench

Related tools

Disclaimer

This is a planning estimate. Results depend on your inputs and assumptions; confirm against your own data before ordering.