Business

Reorder level for a small shop: when to buy an item again

Work out the reorder level for a small shop: daily sales times delivery days plus a cushion, with an item that sells 6 a day and a 3-day delivery.

Editorial illustration for Reorder level for a small shop: when to buy an item again

The reorder level is the stock count at which you should place the next order so the new lot arrives before the shelf is empty. Multiply daily sales by the supplier's delivery days to cover the wait, then add a cushion for busy days. For a made-up item that sells 6 a day with a 3-day delivery, a reorder level of 30 units works.

  • Lead time demand = average daily sales × delivery days
  • Cushion = (busiest day's sales − average daily sales) × delivery days
  • Reorder level = lead time demand + cushion

Delivery days, or lead time, is the gap between placing an order and the goods being on your shelf. Include the supplier's own cut-off and your own time to place the order.

How does it work for one item?

Say a packet item sells 6 a day on average, and the supplier delivers 3 days after you order. In the busiest recent days it sold 10 in a day.

  • Lead time demand: 6 × 3 = 18 units
  • Cushion: (10 − 6) × 3 = 12 units
  • Reorder level: 18 + 12 = 30 units

When the count reaches 30, place the order. Over the next three days you will probably sell 18 and could sell as many as 30, so the shelf should not run empty before the delivery comes. Notice that the sum equals the busiest day times the delivery days, 10 × 3 = 30. You can use that shortcut once you have the busiest day.

How do different items compare?

Item (made up)Average a dayBusiest dayDelivery daysReorder level
Packet item A610330
Milk-based item B, supplied daily2414
Staple C from a wholesaler1520240

Item B sells slowly but delivery is next day, so a small reorder level of 4 is enough. Item C sells fast, with a two-day delivery, so 40 must be on the shelf when you order. The longer the delivery and the busier the item, the higher the level.

How much should I order each time?

The reorder level tells you when. The order quantity tells you how much. A simple method is to cover a fixed number of days. If you want each order to last 7 days for item A, order 6 × 7 = 42 units. By the time the delivery arrives, you will have used 18 of the 30 that were left, so the shelf will have about 12 + 42 = 54 units. Order more if the supplier has a minimum quantity, but check how long the extra will take to sell.

What if sales or delivery are uneven?

  1. Add a day to the delivery time if the supplier is often late.
  2. Raise the level before a festival or a wedding week, when the busiest day is higher.
  3. For items that spoil fast, keep the level low and order more often.
  4. For items that are hard to get, hold a higher level.

Can I set it up in a sheet?

List daily sales of an item for the last 28 days in B2 to B29. Put delivery days in E1. Then:

  • Average a day: =AVERAGE(B2:B29)
  • Busiest day: =MAX(B2:B29)
  • Reorder level: =ROUNDUP(MAX(B2:B29)*E1,0)

ROUNDUP with 0 rounds up to a whole number. These work in Excel and Google Sheets. Redo the figures every month, or each season for items whose sales swing.

Recording what you order

Supplier payments are easy to scatter between UPI, cash and cheque. If you import bank statements into SpendixAI and keep a category for stock purchases, you can see how often and how much you paid each supplier, which helps you check whether your order pattern matches your levels.

Checklist

  • Write down the average, busiest day and delivery days for your top ten items.
  • Work out each reorder level and note it on the shelf or in a list.
  • Review the levels before every festival or season.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports