A useful first step. No signup.

Free Safety Stock Calculator

Work out how much buffer stock to hold, based on how much your demand and delivery times vary. Paste your sales history if you don't know the standard deviation.

Free to useNo email requiredYour entries stay in this page

Calculate your safety stock

Don't know the standard deviation? Paste your sales history

Your figures stay in this page. Export them from your sales report; at least 8 periods gives a steadier estimate.

Example values are shown. Replace them with your own demand and lead-time figures.

The safety stock formula

The statistical method covers both things that can go wrong while you wait for a delivery: customers buying more than usual, and the supplier arriving late.

Safety stock = Z × √(L × σd² + d² × σL²)

Here Z is the score for your service level, L is average lead time, σd is the standard deviation of daily demand, d is average daily demand and σL is the standard deviation of lead time. The calculator rounds the answer up to a whole unit.

If your supplier is reliable and σL is zero, the formula reduces to the version many guides show: Z × σd × √L.

A worked example

A product sells 20 units a day with a standard deviation of 5. Delivery takes 9 days on average, give or take 2 days. You want a 95% service level, so Z is 1.645.

  1. Demand variation over the lead time: 9 × 5² = 225
  2. Lead-time variation: 20² × 2² = 1,600
  3. Combined: √(225 + 1,600) = 42.72
  4. Safety stock: 1.645 × 42.72 = 70.27, so hold 71 units

The reorder point is the demand you expect during the lead time plus that buffer: 20 × 9 + 71 = 251 units. You can test it with the reorder point calculator.

Which method should you use?

Use the statistical method when you have sales history. It lets you choose how much risk to accept, and it treats lead-time variation separately. Lead time is often the larger driver: in the example above it contributes far more than demand does.

Use max-average when you have little data. Safety stock = (highest daily sales × longest lead time) − (average daily sales × average lead time). In the example that is 32 × 13 − 20 × 9 = 236 units, over three times the statistical answer, because it assumes the worst day and the worst delivery happen together.

What service level means

This is the cycle service level: the chance of not running out during one replenishment cycle. At 95%, you expect a stockout in about 1 cycle out of 20. It is not the share of orders you can fill, which is usually higher, because a stockout late in a cycle affects only some of the orders.

Raising the level gets more expensive as you go. In the example, moving from 90% to 95% adds about 16 units, while moving from 99% to 99.9% adds about 33. Consider using higher levels for your best sellers and lower ones for products that are easy to substitute.

When this formula will mislead you

  • Slow movers. It assumes demand roughly follows a normal curve. A product that sells nothing for weeks and then 3 units does not.
  • Seasonal products. A year of data mixes peak and quiet months, which overstates the variation in both. Use a period that looks like the one you are planning for.
  • Stockouts in your history. Days when you had nothing to sell record zero demand, not real demand. Remove them first.
  • Promotions. Plan for a known promotion separately instead of letting it inflate the standard deviation.

Frequently asked questions

What is the formula for safety stock?

The usual statistical formula is Z × √(L × σd² + d² × σL²), where Z is the score for your service level, L is average lead time, d is average daily demand, σd is the standard deviation of daily demand and σL is the standard deviation of lead time. A simpler alternative is (highest daily sales × longest lead time) − (average daily sales × average lead time).

What service level should I choose?

95% is a common starting point. Consider higher levels for best sellers where a stockout loses customers, and lower levels for products that are cheap to run out of or easy to substitute. Each step up costs more stock than the last.

How do I calculate safety stock in Excel?

Use AVERAGE and STDEV.S on your daily sales to get d and σd, and the same on your delivery times to get L and σL. Get Z with NORM.S.INV(0.95) for a 95% service level. Then enter =Z*SQRT(L*σd^2+d^2*σL^2), using cell references for each value.

What is the difference between safety stock and a reorder point?

Safety stock is the buffer you hold for surprises. The reorder point is the stock level that tells you to order, and it equals expected demand during the lead time plus safety stock.

Can I use weekly or monthly sales instead of daily?

Yes, as long as everything uses one time unit. To convert, divide the weekly average by 7 and the weekly standard deviation by √7. The paste box does this for you. It assumes each day's sales are independent, which is a simplification.

Take the next step

Do this inside WooCommerce with PurchaseDesk.

Keep suppliers, purchase orders and goods received next to your WooCommerce stock. Record what arrived, what it cost and what is still on order.

Explore Free and Pro →Read the step-by-step guide

More free tools

Free browser tool

Inventory count sheet

Open a WooCommerce stock CSV, count products in a browser worksheet, or download a printable inventory count sheet PDF. Review differences and export your count record.

Open tool →
Free browser tool

EOQ calculator

Find the cheapest order size, rounded to your pack size and supplier minimum, and compare it with what you order now.

Open tool →
Free browser tool

SKU generator

Turn product names and attributes into readable, unique SKUs, with a list or a WooCommerce import file to download.

Open tool →