
Safety stock is extra inventory you hold to cover surprise demand or late supplier deliveries. The formula looks like this: =NORM.S.INV(0.95)STDEV.S(B2:B53)SQRT(D2).
Reviewed November 2026.
To calculate safety stock in Excel, multiply three numbers.
Those are the Z-score, the standard deviation of weekly demand, and the square root of lead time.
Formulas.
Book a callSafety stock is the buffer of units that sits above your normal supply.
Picture a distributor who sells 100 cases a week.
A supplier ships 1 week late.
Without a safety stock buffer, the shelf goes empty.
A good safety stock buffer stops 3 costly problems:
A lost buyer may not come back.
A small buffer costs far less than all 3 of these.
The cost of a few extra units is steady and easy to predict.
The cost of running out can be large and hard to recover.
Excel is a fast tool for a safety stock calculation.
Most small distributors already hold sales data in accounting exports and spreadsheets.
The sheet is easy to check.
It suits a small number of SKUs. A SKU is one unique item you stock.
Tax rules already force you to count stock. IRS Publication 538 says, "To figure taxable income, you must value your inventory at the beginning and end of each tax year."
An inventory spreadsheet adds safety stock math to counts you already make.

If you would rather not compare products, describe how your operation already works and we build the system around it.
No build cost. You see it running on your own process first, and the monthly subscription starts only once it is live.
Book a callYou need 3 inputs to calculate safety stock: sales history, lead time, and a service level.
Gather them first and the rest takes minutes.
Tip: export sales by item from your accounting package into a clean spreadsheet.
A popular small-business bookkeeping program works fine.
Use one row per week and one column per item.
Delete returns and test orders before you start.

The safety stock formula comes in 2 forms.
One is simple. The other uses statistics.
Pick the one that fits how steady the item sells.
Use this method for steady items.
These are products with stable sales and stable supplier lead times.
(Max daily sales x max lead time) minus (average daily sales x average lead time)
Max means the highest value you saw in your records.
Average means the typical value.
The gap between worst case and normal case is your safety stock.
You plan for a very busy stretch plus a late delivery.
Then you hold enough stock to cover the difference.
The statistical formula fits items with big swings in demand:
Z-score x standard deviation of demand x square root of lead time
Swingy items need the statistical method.
The simple one overstates or understates the risk.

Describe how the work runs today. We map it on a call and show you what it would look like built around that, before you spend anything.
Book a callExcel needs 4 functions to calculate safety stock: AVERAGE, STDEV.S, NORM.S.INV, and SQRT.

Here is the order to use them.
Then multiply it all: =NORM.S.INV(0.95)STDEV.S(B2:B53)SQRT(D2).
Demand and lead time must share one time unit.
Weekly sales need lead time in weeks.
Daily sales need days.
The numbers in this safety stock example are made up.
They serve as an illustration only.
Average demand is 100 units a week.
Standard deviation is 20.
Lead time is 4 weeks.
Service level is 95 percent, so Z is about 1.65.
The math: 1.65 x 20 x 2 = 66 units of safety stock.
The 2 is the square root of 4 weeks.
Service level is the chance you will not run out during one restock cycle.
A higher level ties up more cash in stock.
Common Z-scores for a safety stock calculation:
Set higher levels for best sellers.
Set lower levels for slow movers.
Cash goes where a stockout hurts most.

The reorder point is the stock level that tells you to place a new order.
The formula is (average demand x lead time) + safety stock.
Continue the example: (100 x 4) + 66 = 466 units.
When on-hand stock falls to 466, you reorder.
Add a column to your safety stock sheet to make this automatic:
Red cells show you what to order today.
The same habit helps you learn how to keep stock levels week after week.
Off-the-shelf means fitting your process to the software. We do it the other way round, and the first look costs nothing.
Book a call
Five common mistakes make a safety stock calculation wrong.
Each one is easy to fix.
Clean inputs matter more than clever formulas.

Review safety stock at least every quarter, or every 3 months.
Check sooner for seasonal items and after a supplier change.
A simple routine keeps your safety stock sheet honest:
A change log tab lets the whole team see why a number moved.
Cycle stock is the part of inventory that covers normal demand.
It deserves the same review.
See how to calculate cycle stock for that side of the math.


Excel stops being enough when the sheet costs more time than the stock it protects.
The signs are easy to spot:
Mismatched counts are a warning sign.
Learn how to prevent stock discrepancies before they grow.
Learn how to resolve a stock discrepancy once one appears.
When you outgrow the sheet, look for a setup that pulls live data.
It should flag low items.
It should keep your accounting package in place instead of forcing a full replacement.

Export 52 weeks of sales so you can see a full year of demand.
Pick your top seller today.
Run the five steps for safety stock in Excel.
Compare the result with what sits on the shelf.
One item shows you quickly whether your buffer is too thin or too fat.
It gives you a clear starting point.
Then repeat the process for the rest of your catalog.
No. The simple max and average method suits steady items. The Z-score method suits items with big demand swings. Choose by how much weekly sales vary from the average.
Six to 12 months of weekly sales is a good base. Fewer than 26 weeks hides real swings. Seasonal items need a full year to show their pattern.
You need AVERAGE, STDEV.S, NORM.S.INV, and SQRT. Together they give average demand, spread, the Z-score, and the lead time adjustment in a few cells.
Excel handles dozens of SKUs well. Past a few hundred, file size, copy errors, and stale exports slow the work and raise the chance of broken formulas.
No. Skip buffers for items you can reorder in a day, items that rarely sell, and made-to-order goods. Spend buffer cash on fast sellers with long lead times.
Multiply average demand by lead time, then add safety stock. With 100 units a week, 4 weeks, and 66 units of buffer, you reorder at 466 units.
A 30 minute call, your operation mapped, and a clear picture of what we would build. No obligation and nothing to install.
Book a callMore on the same work.