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.
Frequently Asked Questions
1. What Is the Basic Stock Replenishment Formula?
Replenishment Quantity = (Average Daily Usage × Lead Time) + Safety Stock − Current Inventory. It gives you the actual quantity to order, accounting for what you'll sell during the lead time, your safety buffer, and what's already in stock.
2. What's the Difference Between a Reorder Point and a Replenishment Quantity?
A reorder point is a threshold, the stock level at which you should place an order. A replenishment quantity is the actual amount to order once you've hit that point. The reorder point formula doesn't subtract current inventory, since it's meant to be compared against current inventory. The replenishment quantity formula does subtract it, since it's calculating the order size itself.
3. How Do Seasonality and Promotions Affect the Formula?
Both change your Average Daily Usage input, sometimes sharply. Recalculate using a shorter, more recent sales window during a promotion or seasonal peak rather than a long-term average, and consider raising safety stock temporarily if the uplift is uncertain.
4. What Should I Do If My Supplier's Lead Time Is Unreliable?
Build a buffer directly into the Lead Time input you use, rather than using the supplier's quoted best case. If delays are frequent, increasing safety stock is usually more reliable than hoping lead time improves.
5. Can This Formula Be Automated?
Yes. Once a business is managing more than a handful of SKUs across more than one location, running this calculation manually every week stops scaling. Most inventory or WMS platforms can calculate replenishment quantity automatically per SKU, factoring in current stock and lead time without manual recalculation.
6. Should I Calculate This Per SKU or Per Category?
Per SKU wherever the variants behave differently, which in retail is most of the time. A category-level average can mask a fast-selling size or colour running out while a slow one builds up. The more granular the calculation, the more the formula actually reflects reality.
