Reorder points and safety stock without software maths
A reorder point is the stock level that tells you to place the next order. Safety stock is the small extra quantity kept for normal uncertainty, such as a supplier arriving late or demand being slightly higher than usual. The purpose is to avoid both empty shelves and cash trapped in excess stock.
You can build a practical rule from three observations: average daily sales, supplier lead time and recent variation. Start with fast, important products. Do not attempt to calculate every low-value item on the first day.
Measure real daily demand
Use several weeks of sales for a normal period. Divide units sold by selling days to get average daily demand. Remove obvious data errors, but do not delete busy or quiet days simply because they make the average inconvenient.
For example, if a product sold 210 units over 30 open days, average demand is 7 units per day. Look at the range too. If most days are 5–9 units but one festival day was 30, normal safety stock should not automatically cover the festival. Plan special events separately.
Account for lost sales. If the item was out of stock for four days, recorded sales understate demand. Use nearby periods, customer requests or comparable weeks to estimate carefully and label the estimate.
Measure supplier lead time honestly
Lead time is the number of days between deciding to order and having usable stock available for sale. Include order cut-off, transport, receiving and quality checks. A supplier who promises two days but usually arrives in four has a four-day operating lead time.
Track actual lead time for each supplier. Seasonal congestion, minimum-order schedules and payment release can change it. If an item has alternative suppliers, record their price and reliability instead of assuming emergency stock is always available.
Do not hide internal delay. If the owner waits three days after the stock alert to place the order, those days are part of the practical replenishment cycle until the process improves.
Calculate a simple reorder point
Basic demand during lead time = average daily demand × lead-time days.
Reorder point = lead-time demand + safety stock.
Suppose average demand is 7 units per day and lead time is 4 days. Expected demand while waiting is 28 units. If safety stock is 10 units, reorder at 38 units.
When available stock reaches 38, place the order. The 28 units are expected to sell during normal lead time; the remaining 10 protect against ordinary variation.
Use available stock carefully: physical usable stock plus confirmed incoming stock minus committed customer orders, depending on the business process. Damaged or expired units are not available.
Worked example: biscuits with a late supplier
A kirana shop sells an average of 12 packets of a popular biscuit each day. The supplier normally delivers in 3 days, but in the last month two deliveries took 4 days. Daily sales usually range from 9 to 15 packets.
Normal lead-time demand is 12 × 3 = 36 packets. The owner chooses 18 packets of safety stock, roughly covering one extra day plus a small demand increase. Reorder point is 54 packets.
Current usable stock is 58. Four packets sell in the morning, taking available stock to 54, so the order is placed. During the next four days the shop sells 49 packets. Five remain when delivery arrives. The safety stock prevented a stockout.
If the owner had set safety stock at 60 “to be safe,” reorder point would be 96. That may tie cash in almost eight days of extra stock. For a short-expiry product, the protection could create spoilage.
After several cycles, the shop sees deliveries reliably return to 3 days and sales stay stable. It can test reducing safety stock from 18 to 15, while monitoring stockouts.
Choose safety stock from observed variation
Without advanced statistics, use one of these practical methods:
- Extra demand for one normal day
- Difference between normal and worst recent lead time
- Difference between average and high daily sales during lead time
- A combined modest buffer for important items
Document why the buffer exists. “Supplier often one day late” is actionable. “We always keep 100 extra” may be habit rather than evidence.
Use more safety stock for high-consequence, fast-moving essentials with unreliable supply. Use less for slow, replaceable, bulky or perishable items. Safety stock should differ by item importance.
Review after supplier, season or demand changes. A number calculated last year is not permanent.
Decide order quantity separately
The reorder point answers when; order quantity answers how much. Consider demand until the next possible order, minimum supplier quantity, shelf capacity, expiry, purchase discount and available cash.
A bulk discount is not a saving if stock expires or blocks money needed for faster items. Compare total landed cost and expected sell-through. If buying 10 cartons saves ₹200 but creates ₹600 of likely expiry, the discount loses money.
For regular delivery, order enough to return to a target level. Example: target 110 units, available 54, confirmed incoming none; order around 56 subject to carton size. Keep the formula visible so staff do not order from memory.
Handle seasonal and promotional demand
Festival demand should use a separate forecast from comparable days, advance orders and current local conditions. Increase reorder point or place a planned order for the event, then return to normal rules.
Promotions can increase sales and lead time simultaneously because other retailers order too. Confirm supplier capacity before advertising. Avoid using one festival spike to raise the permanent average for the entire year.
For new items without history, start with a small test quantity and review weekly. Do not assign large safety stock to an unproven product.
Track whether the rule works
Measure:
- Stockout days
- Emergency purchases
- Lost-sale reports
- Average closing stock
- Expiry or damage
- Supplier lead time
- Cash tied in slow stock
If stockouts remain high, check whether demand, lead time or ordering delay is underestimated. If average stock rises and expiry increases, reduce target or safety stock. Do not adjust only the order quantity while ignoring a wrong reorder point.
Integrate counts with cycle counting. A perfect formula using an incorrect stock quantity still places the order at the wrong time.
Practical takeaway
For each important item, calculate average daily sales, measure actual supplier lead time and choose a small evidence-based safety buffer. Reorder point equals demand during lead time plus safety stock. Review it after several cycles and around seasonal changes.
Start with ten fast-moving items. Write the demand, lead time, buffer and reorder point on one sheet or in inventory settings. Combine this with ABC inventory analysis to choose priorities and spoilage tracking so extra stock does not become waste.