- Replenishment Quantity = (Average Daily Usage × Lead Time) + Safety Stock − Current Inventory. It tells you exactly how much stock to order right now.
- A reorder point tells you when to order, while the replenishment quantity tells you how much. Only the replenishment formula subtracts current inventory.
- Example: (30 units/day × 10-day lead time) + 100 units of safety stock − 120 units on hand = 280 units to reorder.
- Recalculate weekly during promotions and seasonal peaks, and run it per SKU, variant, and location. At scale, automated replenishment applies the same logic continuously.
Key Takeaway
The formula for calculating exactly how much stock to reorder, not just when, with a worked example and the reorder-point distinction explained.
Running out of stock costs you sales. Overstocking ties up cash you could use elsewhere. Both come down to the same root problem: not knowing exactly how much to reorder.
This is where the stock replenishment formula comes in. It's a straightforward calculation that tells you the actual quantity to order, based on real usage and lead times, not a gut feeling. Whether you're running a single store, a warehouse, or a chain of both, the formula works the same way.
What Is the Stock Replenishment Formula?
Replenishment Quantity = (Average Daily Usage × Lead Time) + Safety Stock − Current Inventory
Four inputs, one number out: how much to order right now.
This is worth separating clearly from a reorder point, which is a different calculation answering a different question. A reorder point tells you when to place an order, it's a threshold you compare your current stock against. The replenishment quantity formula above tells you how much to order once you've decided to reorder, since it subtracts what you already have on hand. You need both, but they're not the same number, and mixing them up leads to ordering the wrong amount even when the timing is right.
Breaking Down Each Input
1. Average Daily Usage
Average Daily Usage is how many units you sell per day, usually averaged over the last 30, 60, or 90 days depending on how your demand moves. Get this wrong low and you risk stockouts. Get it wrong high and you order more than you need.
Example: a store sold 900 units of a product over the last 30 days. Average Daily Usage = 900 ÷ 30 = 30 units/day.
2. Lead Time
Lead Time is the number of days between placing an order and having stock ready to sell, covering processing, production if applicable, shipping, and receiving. Underestimate this and new stock arrives too late.
Example: a vendor typically takes 10 days to deliver from order date.
3. Safety Stock
Safety Stock is the buffer that protects against a demand spike, a late shipment, or any other surprise. Without it, even a small delay turns into a stockout. How you calculate safety stock is its own topic, but for this formula, treat it as a known input.
Example: 100 units held as safety stock through a promotional period.
4. Current Inventory
Current Inventory is what's actually on the shelf or in the warehouse right now, verified, not assumed. Skip this step and you'll over-order, which means storage costs or markdowns on stock you didn't need yet.
Example: 120 units currently in stock.
Example of Stock Replenishment Formula
Replenishment Quantity = (30 × 10) + 100 − 120 = 280 units
Order 280 units to stay covered through the lead time without sitting on excess.
A Fuller Example: Reordering for a Seasonal Peak
Say a retail chain is heading into a seasonal spike for one of its categories, summer dresses, ahead of the season. Last year the chain sold out mid-peak because the reorder came in too conservative. This year, the buying team wants the number right.
|
Input |
Value |
Why |
|---|---|---|
|
Average Daily Usage |
20 units/day |
Based on the last 3 weeks of demand, using a 21-day average to reflect the current trend rather than the full season |
|
Lead Time |
12 days |
The vendor is reliable but slower around public holidays, so a 2-day buffer is built in |
|
Safety Stock |
80 units |
Set based on last year's unplanned demand spike during a promotional push |
|
Current Inventory |
50 units |
Verified sellable stock, returns and damaged units excluded |
Replenishment Quantity = (20 × 12) + 80 − 50 = 270 units
Order 270 units today. Here's what each part of that number is doing:
- 240 units cover expected demand across the 12-day lead time (20/day × 12 days).
- 80 units are the safety buffer against a demand spike or a delayed shipment.
- 50 units already on hand get subtracted, so the order isn't padded with stock you don't need yet.
With 50 units on hand and demand running at 20/day, that's only 2.5 days of cover left against a 12-day lead time, reordering now isn't optional. The 80-unit safety stock buys roughly 4 days of cushion (80 ÷ 20) on top of that, worth revisiting if the actual promotional uplift runs hotter than planned.
Where This Breaks Down at Scale
The formula above works cleanly for one product at one location. It gets harder once a business is running:
- Multiple SKUs. Style, size, and colour variants each need their own calculation, not one blended number for a whole category.
- Multiple locations. A reorder quantity for one store doesn't account for stock that could simply be transferred from another store or warehouse instead of freshly ordered.
- Fast-moving demand. Manually recalculating this formula weekly across hundreds of SKUs and store locations is where spreadsheets start to break down.
This is the point where automated replenishment tends to replace manual calculation, running this same logic continuously per SKU per location, and factoring in inter-store transfers before generating a fresh purchase order.
A Few Things Worth Getting Right
- Recalculate regularly, especially in high-demand periods: Average daily usage from three months ago won't reflect what's happening during a promotional push or a seasonal peak. Review weekly when demand is moving fast.
- Track promotional and seasonal calendars alongside replenishment: A marketing push can double normal sales velocity overnight, and the formula only works if the Average Daily Usage input reflects that.
- Break the formula down by SKU or variant where it matters: A blended average across sizes or colours can look fine in aggregate while individual variants run out or pile up.
Also check: Which Software Is Best for Inventory Management?
