Reorder point formula: worked examples for variable demand

Elie Dufeu, CTO and Co-Founder of Metreecs
Jean Jass
Head of communication
Share

By Elie Dufeu, CTO & Co-Founder, Metreecs. Published 17 November 2026.

The reorder point formula is: reorder point = (average daily demand x lead time in days) + safety stock. When the stock you hold plus the stock you have on order falls to that number, you place the next order, and the delivery should land just as you start drawing on the safety stock.

The formula fits on a sticky note, which hides how sensitive it is. For the product used throughout this guide, the same demand and the same supplier give a reorder point of 549 units or 690 units, depending on whether you count supplier delays. When a reorder point disappoints, the arithmetic is rarely at fault and one of the inputs usually is.

This guide works through the reorder point formula in three versions, each with the same worked example: fixed inputs, variable demand, then variable demand and lead time. It then covers reorder point vs safety stock and the situations where a correct calculation still sends the wrong signal. If you would rather test it on your own products, you can review your reorder points with our team.

Key Takeaways

  • Reorder point = (average daily demand x lead time) + safety stock. A product selling 40 units a day with a 12-day lead time and 150 units of safety stock has a reorder point of 630 units.
  • When demand and lead time both vary, safety stock = Z x √(lead time x demand variance + average demand squared x lead time variance). In our worked example, a lead time deviation of 3 days accounts for 89% of the uncertainty.
  • Global container schedule reliability stood at 50.6% in September 2026, and late vessels arrived 6.65 days behind schedule on average, according to Sea-Intelligence's Global Liner Performance report.
  • A study of nearly 370,000 inventory records in 37 stores of one retailer found 65% of them inaccurate (DeHoratius and Raman, Management Science, 2008). A reorder point compared with a wrong stock figure fires at the wrong time.
  • Moving from a 95% to a 99% service level in the same example adds 86 units of safety stock, 41% more.

What is the reorder point formula?

The reorder point formula calculates the stock level at which a new purchase order should be placed. It adds the demand expected during the supplier lead time to a safety stock buffer: reorder point = (average daily demand x lead time) + safety stock. Ordering at that level means the delivery arrives before the product runs out.

The first term is called lead-time demand. It is the quantity you expect to sell between the day you order and the day the goods are available to sell, so lead time has to include order processing, production, transit, and receiving. The second term, safety stock, covers the days when sales run above average or the delivery runs late.

The reorder point (ROP, also called the reorder level) tells you when to order and says nothing about how much. Quantity is a separate decision, shaped by order costs, pack sizes, and supplier minimum order quantities. Keeping the two apart avoids a frequent confusion, where a planner raises the reorder point to "buy more" and ends up ordering earlier instead.

The formula belongs to continuous review, where stock is checked every day and an order goes out as soon as the level is crossed. Our guide to inventory replenishment methods compares that approach with calendar-based ordering, which needs a slightly different calculation (covered further down).

The basic reorder point formula, with a worked example

Take a home fragrance brand and its best-selling scented candle (an illustrative example with our own arithmetic, reused in every section). The candle sells 40 units a day on average, the supplier delivers 12 days after the order, and the team holds 150 units of safety stock.

  1. Calculate lead-time demand: 40 units x 12 days = 480 units.
  2. Add safety stock: 480 + 150 = 630 units.
  3. The reorder point is 630 units. When stock falls to that level, the next order goes out.

If sales and the supplier both behave exactly as planned, the delivery arrives with 150 units left. If you only need this arithmetic for a handful of products, our reorder point calculator for retail runs it from the same three inputs.

Keep demand and lead time in the same unit

Demand per day needs lead time in days, and demand per week needs lead time in weeks. With weekly demand of 280 units, the 12-day lead time becomes 1.71 weeks, and 280 x 1.71 gives the same 480 units.

Here is an illustrative case. Maya plans replenishment for a pet supplies retailer whose system stores demand in weekly buckets and lead time in days. For one bag of dry dog food it multiplied 280 by 12 and added the buffer, which produced a reorder point of 3,510 units, close to three months of sales.

Nothing looked broken, because the product never ran out. The error only surfaced when she reviewed slow-turning stock and found a bestseller on the list. Converting the lead time to weeks brought the reorder point back to 630 units.

The basic version has one weakness: the 150 units of safety stock came from nowhere. The next two sections replace that guess with a calculation.

Reorder point formula with variable demand

Daily sales are never exactly 40. When demand varies and the lead time is dependable, safety stock is calculated as:

Safety stock = Z x σd x √LT

Z is the factor for your target service level, σd is the standard deviation of daily demand, and LT is the lead time in days. The service level here is the probability of not running out during one replenishment cycle. A 95% target corresponds to Z = 1.65.

Suppose the candle's daily sales have a standard deviation of 12 units.

  1. Square root of the lead time: √12 = 3.46.
  2. Safety stock: 1.65 x 12 x 3.46 = 68.6, rounded up to 69 units.
  3. Reorder point: 480 + 69 = 549 units.

That is 81 units lower than the 630 we started with, because the calculated buffer is smaller than the round number the team had picked. Many catalogues carry this kind of gap in both directions, with generous buffers on steady products and thin ones on erratic products.

Two practical points on σd. Calculate it over a recent period that resembles the weeks ahead, typically the last 60 to 90 days for a product with stable demand. Exclude the days when the product was out of stock, since zero sales on an empty shelf understate demand and its variability.

One mistake we repeatedly see is a single service level applied to the whole catalogue. A 99% target on a slow product with erratic sales ties up stock that a 90% target would release, with little effect on revenue. Segmenting the range first, for instance with an ABC-XYZ classification, lets the service level follow each product's value and predictability.

Reorder point formula with variable demand and lead time

Lead times vary too, and for imported goods they vary a lot. Sea-Intelligence's Global Liner Performance report put global container schedule reliability at 50.6% in September 2026, down from 64.5% in May. Vessels that arrived late were 6.65 days behind schedule on average.

When both inputs vary, the safety stock formula becomes:

Safety stock = Z x √(LT x σd² + d² x σLT²)

Here d is average daily demand and σLT is the standard deviation of lead time in days. The first term inside the root is demand uncertainty and the second is lead time uncertainty. The reorder point formula itself stays the same: lead-time demand plus this safety stock.

Back to the candle. The supplier's average lead time is 12 days, and receipt dates over past orders show a standard deviation of 3 days.

  1. Demand term: 12 x 12² = 12 x 144 = 1,728.
  2. Lead time term: 40² x 3² = 1,600 x 9 = 14,400.
  3. Sum and square root: √16,128 = 127.0.
  4. Safety stock: 1.65 x 127.0 = 209.5, rounded up to 210 units.
  5. Reorder point: 480 + 210 = 690 units.

The lead time term supplies 14,400 of the 16,128, which is 89% of the total. For this product, a more punctual supplier would lower the reorder point far more than a sharper forecast would.

The table shows how the service level moves the result for the same product (safety stock rounded up to the next unit).

Service levelZSafety stock, demand onlySafety stock, demand and lead timeReorder point
90%1.2854163643
95%1.6569210690
97.5%1.9682249729
99%2.3397296776

Going from 95% to 99% adds 86 units of safety stock, 41% more, to cover four extra cycles in a hundred. That trade is worth making on some products and wasteful on others, which is why the target deserves a deliberate choice. Our guide on setting safety stock product by product goes deeper into that decision.

An illustrative case shows what the missing term costs. Ines manages supply for the candle brand and had set the reorder point at 549 units, using the supplier's quoted 12 days. The product ran out twice in one quarter although daily sales stayed inside their usual range.

When she pulled the receipt dates, deliveries had taken between 8 and 19 days. Moving to 690 units meant holding 141 more units, about €846 of stock at a unit cost of €6. She judged that cheaper than two stockouts on her bestseller.

Across Metreecs' work with home and beauty retailers, the lead time stored in the ERP is usually the supplier's quoted figure, entered once and never compared with actual receipt dates. Measuring the real spread from purchase order history is often the fastest improvement available to a planning team.

Reorder point vs safety stock

Safety stock is a quantity you hold as protection. The reorder point is a stock level that triggers an order, and it contains the safety stock. In the candle example, 210 units are safety stock and 690 units is the reorder point, so the reorder point is always the larger of the two whenever demand is above zero.

The two respond to different changes. If average demand doubles and its variability stays the same, lead-time demand doubles while safety stock barely moves. A supplier that becomes erratic at unchanged sales has the opposite effect: safety stock rises and lead-time demand stays flat.

Safety stockReorder point
What it isA buffer quantityA trigger level
FormulaZ x √(LT x σd² + d² x σLT²)(d x LT) + safety stock
Driven byVariability and service levelAverage demand, lead time, and safety stock
Candle example210 units690 units

In a healthy cycle, stock dips into the safety stock from time to time. A buffer that is never touched over many cycles is probably larger than the service level requires.

Where the reorder point formula gives the wrong signal

A correct calculation can still trigger at the wrong moment. Four situations account for most of the cases we come across.

Comparing the reorder point with stock on hand

The reorder point should be compared with inventory position: stock on hand, plus stock on order, minus quantities already promised to customers. Comparing it with stock on hand alone ignores what is already on its way.

Karim's case is illustrative. He handles replenishment for an online tableware retailer, where one product has a reorder point of 690 units and an order quantity of 800. On Monday stock on hand reads 650, so he orders 800.

By Thursday stock on hand is down to 540, the report still shows the product below its reorder point, and a colleague orders another 800. The inventory position was 1,340 units, nearly twice the reorder point. The retailer ends up with 1,600 units in transit for a product that sells 40 a day.

The planners we work with often underestimate how much stock is already on order when a low-stock report lands on their desk. The longer the lead time relative to the order cycle, the more this matters, because several orders can be open at once.

Stock records that do not match the shelf

The trigger is only as good as the stock figure it reads. In a study published in Management Science in 2008, Nicole DeHoratius and Ananth Raman examined nearly 370,000 inventory records from 37 stores of one retailer and found 65% of them inaccurate.

A record that overstates stock delays the order, and one that understates it brings the order forward. Regular cycle counts on the products that matter most protect the reorder point more than any refinement of the formula.

Demand that is about to change

The formula uses average demand, and an average of the past lags behind any change. If the candle is forecast to sell 70 units a day over the next 12 days because of a seasonal peak, lead-time demand is 840 units, far above the 480 the trailing average suggests.

The fix is to feed the formula with forecast demand over the coming lead time and to recalculate as the forecast moves. This is what AI-driven inventory optimization automates: Metreecs recalculates reorder points per product and location from a daily forecast, so the trigger rises before the peak and falls after it.

Orders placed on a fixed calendar

Many retailers order from each supplier on a set day. In that case, stock has to cover the review period as well as the lead time, and the reorder point is replaced by an order-up-to level.

With a weekly order, the candle needs cover for 7 + 12 = 19 days. Expected demand is 40 x 19 = 760 units, and safety stock becomes 1.65 x √(19 x 144 + 14,400) = 216 units. The order-up-to level is 976 units, and each week you order the difference between 976 and the inventory position.

FAQ

How do I calculate a reorder point in Excel?

Put daily sales in a column, then use AVERAGE for average demand and STDEV.S for its standard deviation. NORM.S.INV(0.95) returns the Z factor for a 95% service level, and SQRT handles the root. The reorder point is average demand multiplied by lead time, plus Z multiplied by the root term.

What is the difference between reorder point and reorder quantity?

The reorder point is the stock level that tells you when to order. The reorder quantity is how much you order once that level is reached, and it depends on order costs, pack sizes, and supplier minimums. The two are set separately, and changing one does not correct an error in the other.

How often should I recalculate reorder points?

Recalculate whenever average demand, demand variability, or lead time shifts noticeably. For stable products a monthly review is usually enough. Seasonal products and products on promotion need a reorder point that follows the forecast, which in practice means weekly or daily updates.

What reorder point should I use for a product with no sales history?

Start from the forecast you used to buy the product, often built from comparable products, and apply the same formula with a cautious estimate of variability. Then replace the assumptions with actual sales as soon as a few weeks of data exist. The first reorder point is a starting value that should be revised early.

What happens if my reorder point is higher than my order quantity?

It means a single order does not lift stock back above the trigger, so you will often have more than one order open at the same time. This is normal with long lead times and small order quantities. It makes tracking inventory position essential, because stock on hand alone will always look too low.

Conclusion

The reorder point formula is simple arithmetic resting on estimates of demand, lead time, and how much each one varies. Keep the units consistent, measure lead time variability from real receipt dates, and compare the result with inventory position. To see reorder points recalculated from a daily forecast on your own catalogue, book a demo of Metreecs.

Sources

  • Sea-Intelligence, Global Liner Performance report, issue 182 (data through September 2026), as republished by FreshPlaza on 29 October 2026: global schedule reliability of 50.6% in September 2026, down from a peak of 64.5% in May, with an average delay of 6.65 days for late vessel arrivals.
  • Nicole DeHoratius and Ananth Raman, Inventory Record Inaccuracy: An Empirical Analysis, Management Science, vol. 54, no. 4, April 2008, pages 627 to 641: nearly 370,000 inventory records from 37 stores of one retailer, 65% inaccurate.
  • Z factors (1.28, 1.65, 1.96, 2.33) are rounded quantiles of the standard normal distribution. All other figures are illustrative calculations made for this article.

Our articles

Own your operations with AI Intelligence