Reorder level and safety stock: simple formulas with examples
Two formulas, worked examples, and how to handle seasonal, slow-moving and expiring items.
Running out of a best seller loses sales; overstocking ties up cash that could pay suppliers. A reorder level per item tells you when to buy, and safety stock covers the days when sales or deliveries surprise you.
The reorder level
Reorder level = average daily sales × lead time in days + safety stock
Lead time is the number of days from placing an order to having the goods on the shelf, not just the supplier’s delivery time.
Safety stock
A simple formula that works without statistics:
Safety stock = (maximum daily sales × maximum lead time) − (average daily sales × average lead time)
A worked example
A shop sells a detergent pack:
- average daily sales: 20 packs; on the busiest days, 30;
- usual lead time: 5 days; at worst, 7.
Safety stock = (30 × 7) − (20 × 5) = 210 − 100 = 110 packs.
Reorder level = 20 × 5 + 110 = 210 packs. When stock falls to 210, place the order.
How much to order
Order enough to last until the next ordering day, plus the lead time, minus what you hold above safety stock. If you order every two weeks: 20 × (14 + 5) = 380 packs, less any stock above the 110 safety level when you order. Round to the supplier’s case size.
A second example: an item with a long lead time
This is an illustration with made-up numbers. A pharmacy buys a branded cough syrup from a distributor in another city. Average sales are 6 bottles a day and 10 on the busiest days. The usual lead time is 8 days, and at worst 12 because of transport delays.
- Safety stock = (10 × 12) − (6 × 8) = 120 − 48 = 72 bottles
- Reorder level = 6 × 8 + 72 = 120 bottles
Now compare a local supplier who delivers the same day, with lead time of 1 day, or 2 at worst. Safety stock = (10 × 2) − (6 × 1) = 14 bottles, and the reorder level is 6 × 1 + 14 = 20 bottles. The same item needs six times less stock held in the shop when the supplier is close. That is why lead time deserves as much attention as sales.
What overstocking costs
Holding stock is not free. Suppose you keep 100 extra bottles that cost ₹150 each. That is ₹15,000 of cash sitting on the shelf. If the money could instead pay a supplier early or reduce an overdraft, the shop is paying interest for those bottles to sit there, and each unsold bottle edges closer to its expiry date. Safety stock is insurance, and like any insurance it should be sized deliberately, not by habit.
Sort items by importance first
You do not need the same care for every item. A simple sort is enough:
| Group | Typical share | How to manage |
|---|---|---|
| A items | The few that bring most of your sales | Calculate reorder level and safety stock carefully, and review every month or quarter. |
| B items | Steady middle sellers | Use a simple level and review a few times a year. |
| C items | The long tail of slow sellers | Keep minimal stock and order on demand. |
The exact shares differ by business, so rank your own items by sales value over the last year to find where the line falls.
Common mistakes
- Using an average that hides stock-outs. If an item was out of stock for a week, daily sales for that month look lower than demand really was. Leave out the days with no stock when you work out the average.
- Counting the supplier’s promise as lead time. Use the days it really took over the last few orders.
- Ignoring pack sizes. If a case holds 24 and your order is 210, round up to 216 and recheck.
- Setting levels once and forgetting. A new competitor, a price change or a festival season moves demand.
- Treating all stock as cash. Stock that has not sold in six months is a decision waiting to be made, not an asset to be proud of.
A monthly routine
- Print or open the low-stock list and review each item against its level.
- Check the items you sold out of last month and ask why.
- Count your top ten items on the shelf and compare with the records.
- Note supplier delays and update the lead times that moved.
- Place orders in one batch where you can, so that you meet minimum order values.
Using supplier terms in your favour
Reorder levels also interact with how your suppliers work. Some give a discount for larger orders, some have a minimum order value, and some deliver only on set days. Combine these facts with the level: if the supplier delivers only on Mondays, your effective lead time includes the wait until Monday, and the reorder level should rise to match. If a bigger order earns a discount, check that the saving is more than the cost of holding the extra stock for the weeks it takes to sell.
Making it work in a real shop
- Start with your top items. The 20% of items that bring most of your sales deserve careful levels; review the rest a few times a year.
- Seasonal items: use sales from the same weeks last year, not the last month.
- Slow movers: keep safety stock low or zero, and order on demand.
- Expiry: for medicines and food, never hold more than you can sell before the earliest expiry date; sell first-expiry-first-out.
- Review every quarter. Sales and supplier lead times change.
In Zebill’s inventory, each item can carry a reorder level, and the low-stock list shows what to buy, with batches and expiry dates for items that need them.
Questions people ask
What is the difference between reorder level and safety stock?
Safety stock is the buffer for surprises. The reorder level is the stock count at which you order: expected sales during the lead time plus the safety stock.
How often should I review reorder levels?
Every quarter for your top-selling items, and before each busy season. Slow movers can be reviewed less often.
How do I calculate the average daily sales for a new item?
Use the first few weeks of sales, and treat the figure as provisional. Review it after a month, and sooner if the item sells faster than expected.
Should safety stock be the same all year?
Not for seasonal items. Use last year’s sales for the same weeks, and raise safety stock before the busy season, then let it fall afterwards.