# Safety Stock Calculator with Demand and Lead Time Variability

> Source: https://netray.co/tools/safety-stock-demand-and-lead-time-variability-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compute safety stock and reorder point when both demand and supplier lead time vary, and see how lead time variability inflates the buffer.

## Category

supply-chain

## Audience

- Materials planner
- Buyer
- Supply chain manager

## Tool

**Kind:** calculator

**Inputs:**

#### Average daily demand

**Key:** d

**Type:** number

**Default:** 40

**Min:** 0

**Step:** 1

**Unit:** units/day

**Help:** Mean demand per day over a recent stable period.

#### Std deviation of daily demand

**Key:** sigd

**Type:** number

**Default:** 14

**Min:** 0

**Step:** 1

**Unit:** units

**Help:** Standard deviation of daily demand.

#### Average replenishment lead time

**Key:** lt

**Type:** number

**Default:** 21

**Min:** 1

**Step:** 1

**Unit:** days

**Help:** Order release to available in stock.

#### Std deviation of lead time

**Key:** sigl

**Type:** slider

**Default:** 4

**Min:** 0

**Max:** 15

**Step:** 0.5

**Unit:** days

**Help:** Measured from actual receipts versus order dates.

#### Cycle service level

**Key:** service

**Type:** select

**Default:** 0.95

**Options:**

##### 90%

**Value:** 0.9

##### 95%

**Value:** 0.95

##### 97.5%

**Value:** 0.975

##### 99%

**Value:** 0.99

##### 99.5%

**Value:** 0.995

**Outputs:**

#### Z score

**Key:** z

**Expr:** normsinv(service)

**Format:** decimal

**Description:** Standard normal value for the chosen service level.

#### Std deviation of demand during lead time

**Key:** sigma_ltd

**Expr:** sqrt(lt * sigd * sigd + d * d * sigl * sigl)

**Format:** decimal

**Description:** Combines demand and lead time variability.

#### Safety stock

**Key:** ss

**Expr:** z * sigma_ltd

**Format:** integer

**Primary:** true

**Description:** Buffer units above expected lead time demand.

#### Expected demand during lead time

**Key:** ltd

**Expr:** d * lt

**Format:** integer

#### Reorder point

**Key:** rop

**Expr:** ltd + ss

**Format:** integer

**Primary:** true

#### Safety stock if lead time were fixed

**Key:** ss_dem

**Expr:** z * sigd * sqrt(lt)

**Format:** integer

#### Share of buffer caused by lead time variability

**Key:** lt_share

**Expr:** if(gt(ss,0), (ss - ss_dem) / ss * 100, 0)

**Format:** percent

**Chart:**

#### Safety stock vs lead time variability (days)

**Type:** line

**X:** sigl

**From:** 0

**To:** 15

**Steps:** 30

**Series:**

- ss

**Disclaimer:** Assumes demand during lead time is approximately normal and that demand and lead time are independent. Not suitable for very lumpy or intermittent items.

## Content

**Intro:** Most online safety stock calculators assume the supplier is always on time. This one adds lead time variability, which is often the larger driver. Enter your numbers, pick a service level and read safety stock and reorder point.

**Sections:**

#### How to use the calculator

**Body:** Take daily demand statistics from issue history and lead time statistics from actual receipts: receipt date minus order date, averaged across the last 12 to 24 receipts. Choose the cycle service level, which is the probability of not stocking out in a replenishment cycle. The chart sweeps lead time variability from 0 to 15 days with your other inputs fixed, so you can see what negotiating a more reliable supplier is worth in units of buffer.

#### The formula

**Body:** Safety stock = Z x sigma_LTD, where sigma_LTD = sqrt(LT x sigma_d^2 + d^2 x sigma_LT^2). The first term is demand variability accumulated across the lead time, the second is the effect of the lead time itself being uncertain, scaled by average demand. Reorder point = d x LT + safety stock. The calculator also shows the buffer you would need if lead time were fixed, so you can isolate the supplier effect.

**Bullets:**

- d: average demand per day
- sigma_d: standard deviation of demand per day
- LT and sigma_LT: lead time mean and standard deviation in days
- Z: normal score for the service level

#### Reading the result

**Body:** With the default values, the lead time term contributes a large share of the buffer even though four days of variation on 21 looks modest. When the share is high, spending effort on supplier delivery performance, shorter transit or a second source often reduces inventory more cheaply than lowering the service target. Moving from 95% to 99% raises Z from about 1.64 to 2.33, roughly 40% more buffer, so confirm the higher target is worth the carrying cost.

#### Common mistakes

**Body:** Using planned lead time from the item master instead of actual receipts is the biggest one. Another is mixing time units: demand per day with lead time in weeks. Using monthly standard deviation scaled incorrectly is the third. If you only have monthly figures, convert both mean and standard deviation to the same period, standard deviation scales with the square root of time, not linearly. Finally, do not apply this formula to sporadic demand, results will be unreliable.

**Cta:** If you want safety stock recomputed from your ERP receipts and issues and compared with what is loaded in the item master, Netray can build a read-only analysis over your ERP data.

**Faq:**

#### What is the difference between cycle service level and fill rate?

**Answer:** Cycle service level is the chance of no stockout in a replenishment cycle. Fill rate is the share of demand filled from stock. They are different numbers. See the service level and loss function table for converting between them.

#### Why is my safety stock higher than the simple formula?

**Answer:** The simple formula Z x sigma_d x sqrt(LT) ignores supplier variability. If your suppliers are late or early by several days, the extra term adds buffer, and it can dominate for fast moving items.

#### How many receipts do I need to estimate lead time variability?

**Answer:** A dozen is a workable minimum. Fewer than that and the standard deviation is noisy. Separate suppliers or ship methods if they behave differently, one blended figure can hide the real driver.

#### Does this apply to make items?

**Answer:** Yes, use the manufacturing lead time and its variability from work orders, with demand from dependent or independent usage. For items driven by MRP on firm demand, a time-phased approach may suit better than a statistical buffer.

## Search terms

safety stock formula lead time variability, safety stock calculator service level, safety stock with variable lead time, combined variability safety stock, reorder point calculator safety stock, safety stock simulation, z score safety stock, safety stock excel

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