How to Set Reorder Points for a Multi-Location Business
A stockout does not happen suddenly, it builds quietly over days or weeks but reorder mitigate this with a system that triggers a requisition request automatically. This post explains the formula.
A stockout does not happen suddenly. It builds quietly over days or weeks — average daily sales ticking down the stock count while the reorder sits on someone's mental to-do list, or at the bottom of a WhatsApp thread, or in a spreadsheet column that nobody checked this week.
Reorder points fix this. They replace the guesswork with a system: a specific stock level, per SKU, per location, that triggers a requisition request automatically — before you run out. This post explains the formula, how to apply it in a multi-location operation, and what it looks like in practice for businesses operating across African and GCC markets.
The Reorder Point Formula
Reorder Point = (Average Daily Sales × Supplier Lead Time in Days) + Safety Stock
Three inputs. Each one matters.
Average Daily Sales (ADS)
Take the total units sold of a specific SKU over a given period — 30 or 90 days is ideal — and divide by the number of days in that period. This gives you a daily average that accounts for normal fluctuation.
Example: If you sold 300 units of a product over 30 days, your average daily sales is 10 units/day.
Important: Calculate ADS per location, not per business. A product that sells 50 units/week at your Lagos main warehouse might sell 8 units/week at your Abuja depot. One reorder point does not work for both.
Supplier Lead Time
This is the number of days between placing an order and receiving stock at your location. In African and GCC markets, lead times are often longer and less predictable than in Western supply chains. A supplier in Guangzhou serving a Nigerian importer might have a nominal 21-day lead time, but the realistic planning figure is 28–35 days once customs clearance and inland transport are included.
Use a realistic lead time, not an optimistic one. The cost of a stockout caused by underestimating lead time is always higher than the cost of holding a slightly larger buffer.
Safety Stock
Safety stock is your buffer — the units you hold specifically to absorb supply-chain variability: a delayed shipment, a demand spike, a public holiday that closes your supplier's warehouse.
Safety Stock = (Maximum Daily Sales − Average Daily Sales) × Maximum Lead Time
If your maximum observed daily sales is 15 units, your average is 10, and your maximum lead time is 35 days, your safety stock is (15 − 10) × 35 = 175 units.
For businesses just getting started with reorder points, a simpler approach is to set safety stock at 2× your average daily sales. It's not perfect, but it's far better than zero.
A Worked Example: Lagos FMCG Distributor
A beverage distributor operating three locations in Lagos — a main warehouse in Apapa, a depot in Ikeja, and a retail outlet in Victoria Island — wants to set a reorder point for one of its top-moving SKUs.
Apapa warehouse: ADS = 80 units/day · Supplier lead time = 7 days · Safety stock = 100 units
(80 × 7) + 100 = 660 units When Apapa warehouse stock hits 660 units, a purchase order should be placed.
Ikeja depot: ADS = 30 units/day · Same supplier, but 9 days due to delivery routing · Safety stock = 50 units
(30 × 9) + 50 = 320 units Ikeja and Apapa have different reorder points for the same SKU. This is correct.
A Worked Example: UAE Trading Company
A Dubai-based trading company importing electronics from Asia and distributing across the UAE operates a main warehouse in Jebel Ali and satellite stock points in Abu Dhabi and Sharjah.
For a high-moving consumer electronics SKU: ADS at Jebel Ali = 25 units/day · Import lead time = 21 days (planned), 30 days (maximum) · Safety stock = (35 − 25) × 30 = 300 units.
(25 × 21) + 300 = 825 units The 21-day nominal lead time is used in the formula, but the safety stock calculation uses the maximum lead time of 30 days. This is deliberate — the buffer absorbs the uncertainty.
Managing Reorder Points Across Multiple Locations
The operational challenge for multi-location businesses is not calculating reorder points — it's maintaining them as demand patterns shift. A reorder point set in January may be wrong by April if seasonal factors change your average daily sales.
Best practices for multi-location reorder management:
- Review ADS every 30–90 days and update reorder points accordingly.
- Set reorder points at the location level, not the business level.
- For high-value SKUs, review lead time assumptions against actual recent delivery data — not vendor promises.
- Log every reorder and fulfilment against the triggering reorder point so you can verify whether your safety stock assumptions are holding.
- Use an inventory system that triggers automatic purchase requisitions when stock hits the reorder point — removing the human memory dependency entirely.
The Cost of Not Having Reorder Points
Businesses that operate without reorder points manage inventory reactively — someone notices a shelf is almost empty, or a customer order triggers a scramble to check if the stock is there. In high-volume operations, this reaction time is consistently too slow.
The financial impact is not just the lost sale. It includes emergency procurement costs (expedited shipping, premium pricing from alternative suppliers), customer trust damage, and the operational hours your team spends managing a crisis that a system could have prevented.
In markets where supply chains are less reliable and lead times are longer, the cost of a missed reorder point is structurally higher than in markets with next-day fulfilment. This is precisely why reorder points matter more in African and GCC operations, not less.
Ready to take control of your inventory?
Ceazr gives African and GCC businesses real-time stock visibility across every location — no spreadsheets, no guesswork.