MarCat

Safety stock formula for a shop: how much extra to keep, item by item

The safety stock formula in plain words, worked on a grocery item in Excel. When to keep more, when to keep none, and the limits of shelf life and space.

By Swarbhanu Gupta, who has run Banjara supermarket in Ahmedabad since January 2025 (billing on MarCat since April 2026) · 14 November 2026

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
  1. Total = 154, so the average is 11 a day.
  2. Standard deviation of these 14 numbers = about 2.42.
  3. Lead time: order today, on the shelf in 4 days, so √4 = 2.
  4. 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:

  1. Average: =AVERAGE(B2:B15)
  2. Standard deviation: =STDEV.S(B2:B15)
  3. Z for 95%: =NORM.S.INV(0.95) gives 1.645
  4. 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.

Questions

What is the safety stock formula?
The common one is: safety stock = Z x standard deviation of daily sales x square root of lead time in days. Z is set by how rarely you are willing to run out: about 1.65 for running out on roughly 1 order cycle in 20.
Is there a simpler way for a small shop?
Yes. Keep a few days of extra sales for each item: 1-2 days for steady sellers with a reliable supplier, more if the supplier is often late. It is less precise but easy to keep up.
Should every item have safety stock?
No. Slow sellers, short shelf-life items and lines you are thinking of dropping can have little or none. Put the buffer where running out costs you a customer.
What is the difference between safety stock and reorder level?
Safety stock is the extra kept for bad days. Reorder level is the point at which you order, and it includes safety stock: average daily sales x lead time + safety stock.
Does MarCat work out safety stock?
MarCat gives reorder suggestions based on what has actually sold, and every sale and purchase moves stock automatically. How much buffer to hold on each item stays your decision.