MarCat

Reorder level formula for a retail store, with a worked supermarket example

The reorder level formula in plain words: daily sales x lead time + safety stock. A worked supermarket example, a simple Excel sheet, and how distributor visit days change it.

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

Every store runs out of something it sells every day. Not because nobody noticed, but because it was noticed too late. By the time the last pack left the shelf, the distributor's next visit was three days away.

The formula works on paper for a few items. For a whole store, stock and inventory management software keeps the sales history it needs for every item.

The reorder level fixes the "too late" part. It is one number per item that says: when stock falls to this, order now. This guide explains the formula in plain words, works it through for a supermarket item, and shows a small Excel sheet you can use today.

The formula

Reorder level = average daily sales × lead time (days) + safety stock

Three parts:

Part What it means in a store
Average daily sales How many units of this item you sell on a normal day, from your past sales
Lead time Days from deciding to order until the goods are on the shelf
Safety stock Extra units to cover a busy day or a late delivery

The first two together cover what you will sell while you wait for the order. Safety stock covers the days when things do not go to plan.

A worked example: 5 kg atta pack

Made-up numbers for a mid-size store:

  • Sold in the last 28 days: 224 packs → average 8 packs a day
  • Lead time: order today, delivered in 3 days
  • Safety stock: 2 days of sales = 2 × 8 = 16 packs

Reorder level = 8 × 3 + 16 = 40 packs

When the stock of 5 kg atta falls to 40 packs, you place the order. In the three days before it arrives you will sell about 24, so you still have about 16 on the shelf when the delivery comes. On a busier-than-usual week, those 16 are what keep the shelf from going empty.

Lead time in a real store is not just delivery days

Most supermarkets do not order any day they like. Distributors' salesmen come on fixed days. That changes the lead time.

Say the atta distributor's salesman comes every Monday and delivers two days later. If you check stock on Tuesday and it is just above the reorder level, you cannot order until next Monday. The real lead time from Tuesday is 6 days of waiting plus 2 days of delivery, not 2.

The practical rule for an item with a weekly order day:

Lead time = days until the next order day + delivery days

Or, simpler: on each order day, order enough to last until the delivery after next, plus safety stock. For a weekly visit with 2-day delivery, that is about 9 days of sales plus safety stock, minus what is on the shelf.

How much safety stock?

There are two common ways.

Days of cover (simple, good for most stores):

Type of item Suggested safety stock
Fast seller, reliable supplier 1-2 days of sales
Fast seller, supplier often late 3-4 days of sales
Slow seller A few units, or none
Item customers will switch store for (milk, bread, atta, oil) Lean higher

Max-minus-average (when you have the numbers):

Safety stock = (highest daily sales × longest lead time) − (average daily sales × average lead time)

For the atta: highest day 12 packs, longest delivery 5 days, average 8 packs, average 3 days. Safety stock = 12 × 5 − 8 × 3 = 60 − 24 = 36 packs

This gives a bigger buffer, and it ties up more money. Use it for the handful of items you can never run out of. For the rest, days of cover is enough.

A simple Excel sheet

A: Item B: Sold last 28 days C: Avg per day D: Lead days E: Safety days F: Reorder level G: In stock H: Action
Atta 5 kg 224 8 3 2 40 35 ORDER
Toor dal 1 kg 84 3 3 2 15 22
Bath soap 100 g 140 5 7 2 45 60

Formulas for row 2:

  1. C2: =B2/28
  2. F2: =ROUNDUP(C2*D2 + C2*E2, 0)
  3. H2: =IF(G2<=F2, "ORDER", "")

Update column B and G once a week from your sales and stock reports, sort by column H, and you have your order list before the salesman arrives.

When to change the numbers

The reorder level is only as good as the sales number behind it. Look at it again when:

  • A festival or wedding season is coming. Daily sales of oil, sugar, dry fruits and pooja items rise for a few weeks. Look at what sold in the same weeks last year and set the level for those weeks by hand.
  • A supplier changes. New supplier, new lead time. Recheck it.
  • An item moves to a new shelf or gets a scheme. Sales can jump for a while.
  • You keep running out anyway. Your lead time or safety stock is too low. Raise it and watch for a month.
  • Stock keeps piling up. The level is too high, or the item is slowing down. Lower it, or check whether it is turning into dead stock.

Common mistakes

  • Using one month's sales for an item that was out of stock for a week. Days with zero stock show zero sales, which makes the average too low. Count only days the item was on the shelf.
  • Ignoring the pack size. If the distributor sells only in cartons of 24, round your order up to full cartons.
  • Setting a reorder level for every item at once. Start with your top 50 sellers. That is where running out costs the most.
  • Wrong stock numbers. If purchases are entered late, the "in stock" column is wrong, and so is every order decision built on it.

Where software helps

A sheet like this works if someone updates it every week. In a store with thousands of items and sales every minute, the sales and stock numbers are already in your billing software. Software that shows suggested orders from what has actually sold saves the weekly copying, and the decision on festival weeks and new items stays with you.

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. Ordering before the shelf runs empty is a weekly job in any store. 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, and multiple counters share one view of stock.
  • Dead stock in view. Stock movement reports surface lines that stopped moving.

If you want to see reorder suggestions on your own items, message us on WhatsApp at +91 96787 65518.

Questions

What is the reorder level formula?
Reorder level = average daily sales x lead time in days + safety stock. When stock on hand falls to this number, you place the order.
What is lead time for a shop?
The number of days from the moment you decide to order until the goods are on your shelf. If your distributor only takes orders on certain days, count the wait until the next order day too.
How much safety stock should a supermarket keep?
A simple way is a few days of extra sales for each item: more for fast sellers and for suppliers who are often late, less for slow sellers. Check it against what actually happened when you ran out.
Does MarCat calculate reorder levels?
MarCat gives reorder suggestions based on what has actually sold.