Safety stock is the extra stock you keep for the day things do not go to plan: a Sunday that sells twice the usual, or a delivery that comes two days late. Too little and the shelf goes empty while customers watch. Too much and money sits in cartons in the back room.
You can work this out by hand for your fastest items. For the rest, stock and inventory management software keeps the sales history the formula needs.
Our reorder level guide shows where safety stock fits into the reorder point. This guide goes one step deeper: how to work out the safety stock number itself, item by item, with a grocery example and an Excel sheet, and where common sense should overrule the formula. All numbers are made up.
Three ways to set it, from simple to precise
| Method | Formula | Good for |
|---|---|---|
| Days of cover | Average daily sales × days of buffer | Most items in most stores |
| Max minus average | (Highest daily sales × longest lead time) − (average daily sales × average lead time) | A few items you can never run out of |
| Variation-based | Z × standard deviation of daily sales × √lead time | Fast sellers where you have a few weeks of daily sales |
Days of cover and max-minus-average are covered in the reorder level guide. The third one is worth learning for your top sellers, because it looks at how uneven sales are, not just how big they are. Two items can both sell 11 a day on average. One sells 10 to 12 every day. The other sells 3 one day and 20 the next. The second needs far more buffer.
The variation-based formula in plain words
Safety stock = Z × σ × √L
- σ (sigma) = the standard deviation of daily sales. A measure of how much sales jump around the average. Excel works it out for you.
- L = lead time in days, from placing the order to stock on the shelf.
- Z = how rarely you are willing to run out during the wait.
| You want to run out on about... | Service level | Z |
|---|---|---|
| 1 order cycle in 10 | 90% | 1.28 |
| 1 in 20 | 95% | 1.65 |
| 1 in 50 | 98% | 2.05 |
Higher Z means more stock. Going from 95% to 98% adds about a quarter more buffer, for running out less often. Save that for items customers will switch store for.
Worked example: 1 ltr oil pouch
Daily sales for the last 14 days (made up):
| Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Pouches sold | 10 | 12 | 8 | 15 | 9 | 11 | 10 | 14 | 7 | 13 | 10 | 12 | 9 | 14 |
- Total = 154, so the average is 11 a day.
- Standard deviation of these 14 numbers = about 2.42.
- Lead time: order today, on the shelf in 4 days, so √4 = 2.
- At 95%: safety stock = 1.65 × 2.42 × 2 = 7.99, round up to 8 pouches.
Reorder level = 11 × 4 + 8 = 52 pouches.
Compare it with a flat "2 days of cover" rule: 2 × 11 = 22 pouches. For this steady item, the flat rule keeps almost three times the buffer it needs. Across a few hundred items, that difference is real money on the shelf.
The same sum works the other way too. An item with uneven sales can need more than the flat rule gives it. That is the point of the formula: it puts the buffer where sales are unsteady.
The Excel sheet
Put the 14 days of sales in B2:B15 for one item, then:
- Average:
=AVERAGE(B2:B15) - Standard deviation:
=STDEV.S(B2:B15) - Z for 95%:
=NORM.S.INV(0.95)gives 1.645 - Safety stock, with lead days in E2:
=ROUNDUP(NORM.S.INV(0.95)*STDEV.S(B2:B15)*SQRT(E2),0)
For many items, keep one row per item and 14 or 28 columns of daily sales. Copy the formula down. Start with your top 30 or 50 sellers, not the whole item list.
Two things to get right in the data:
- Leave out days the item was out of stock. A zero on a day the shelf was empty is not a real zero, and it makes sales look more uneven than they are.
- Leave out one-off bulk sales. A customer buying 40 pouches for a function once is not your normal day.
When the formula needs your help
The formula assumes the delivery comes on time. In a real store it does not always.
- Supplier often late. Add a few days of cover on top: average daily sales × the usual delay. For the oil, a supplier who is often 1 day late adds 11 pouches.
- Weekly order day. If you can only order on the salesman's day, the lead time is the days until the next order day plus delivery, not just delivery. Use that L in the formula.
- Festival and wedding weeks. Daily sales of oil, sugar, ghee and dry fruit rise for a few weeks. Last year's same weeks, from your own sales, are a better guide than the last 14 days. Set those weeks by hand.
- New items. With no sales history, start with a small fixed buffer and look again after a month.
When to keep little or none
Safety stock has limits that no formula knows about:
| Limit | What it means |
|---|---|
| Shelf life | Never keep more buffer than sells well before the date. Bread, milk products and short-life snacks get little or none. |
| Shelf and storage space | If the buffer does not fit, it ends up damaged or forgotten in a corner. |
| Carton size | If the distributor sells only in cartons of 24, the order size sets your real buffer. |
| Slow sellers | An item that sells 2 a week does not need a buffer. One pack on the shelf is enough. |
| Lines on the way out | Do not protect an item you are about to stop. Let it run down. |
Check it every month
Once a month, look at two lists side by side: items that ran out, and items with too much stock. If an item ran out more than once, raise its Z or its buffer days. If an item always has a full back room, lower it. A month of real results beats any number you set at the start.
Where software helps
The formula needs daily sales for each item, and the buffer is only useful if the stock number is right. In a store with thousands of items, both already sit in the billing system. Software that keeps stock moving with every bill and purchase, and suggests orders from what has actually sold, saves the weekly copying into Excel. Deciding how much buffer an item deserves is still the owner's call.
How MarCat handles it
We have run Banjara, our own supermarket in Ahmedabad, since January 2025, and it has billed on MarCat since April 2026. Keeping the right amount on the shelf is a weekly job there. This is what MarCat does:
- Reorder suggestions based on what has actually sold.
- Stock that is up to date. Every sale and every purchase moves stock automatically, with batch, MRP and cost tracking. Multiple counters share one view of stock.
- Sales by product. Product-wise sales and sales comparison across periods, to see last year's festival weeks next to this year's.
- Dead stock in view. Stock movement reports surface lines that stopped moving, so buffer is not sitting on items nobody buys.
If you want to see reorder suggestions on your own items, message us on WhatsApp at +91 96787 65518.
