Reorder Point Formula and Min Max Inventory Levels
Formulas · 8 min read
Create your account in a minute · no card required
Nothing you paste is stored.
The scan could not run.
SKUs, scroll for the rest
A live preview of Storekeeper's forecasting engine on fictional sample dataon the rows you pasted. The full product connects to your POS and store and runs this continuously.
The reorder point is the stock level at which you place the next order. Above it, wait; at or below it, order. It is the single most consequential number in day-to-day inventory work, and the formula fits on a napkin. The catch is not the arithmetic. The catch is that the inputs move and the napkin does not.
The formula
reorder point = (average daily demand × lead time in days) + safety stock
The first term is the stock you expect to sell while the replenishment order travels. The second is the buffer for non-average weeks, covered in depth in the safety stock guide. Together they answer: "if I order now, will I still be selling when it arrives?"
Worked example
A boutique sells 3 pairs of its core jeans a day. The supplier needs 21 days. Safety stock, computed at a 95 percent service level from the demand data, is 18 pairs.
reorder point = (3 × 21) + 18 = 63 + 18 = 81 pairs
When available stock (on hand plus already on order, minus reservations) touches 81, the next order goes out. How much to order is a separate question: enough to cover your planning horizon plus safety stock, minus what you will have left; our purchase order page walks the quantity math.
The three quiet failure modes
1. Stale inputs
The jeans start selling 5 a day after an influencer moment. The reorder point should now be
(5 × 21) + buffer ≈ 130, but the system still says 81, so the order goes out two
weeks late and the stockout arrives with receipts. Static
reorder points rot at the speed your demand changes. Whoever recomputes them, an analyst on a schedule or
software continuously, is your real inventory
system.
2. Counting on hand instead of available
Sixty units on the shelf, forty already promised to open orders: the honest number is twenty, and the reorder point should trigger on it. Multichannel sellers hit this hardest; it is half of what ecommerce inventory management means.
3. Believing the quoted lead time
The supplier says 14 days; the last six deliveries averaged 19. Use 19. Track quoted versus actual per supplier and feed the real number into both terms of the formula.
Min/max inventory levels
A min/max inventory system sets two numbers per SKU: a minimum that triggers the reorder and a maximum you top back up to. The minimum is the reorder point above. The order quantity is simply the maximum minus available stock at the moment you order. It answers "when" and "how much" in one rule, which is why shelf-tag, two-bin and most ERP replenishment screens are built around it.
The maximum controls your carrying cost. Set it as the minimum plus the quantity you want to bring in each cycle, usually a number of days of supply or an economic order quantity that balances ordering cost against holding cost:
maximum = minimum + reorder quantity
Take a SKU that sells 5 units a day from a supplier that delivers in 4 days, with 20 units of safety stock, and say you want 20 days of supply per order.
| Level | Formula | Example |
|---|---|---|
| Minimum (reorder point) | (Daily demand × lead time) + safety stock | (5 × 4) + 20 = 40 |
| Reorder quantity | Target days of supply × daily demand | 20 × 5 = 100 |
| Maximum | Minimum + reorder quantity | 40 + 100 = 140 |
When available stock falls to 40, you order up to 140. If a late delivery means you are at 31 when the order goes out, you order 109, not 100. That self-correcting quantity is the main advantage over a plain reorder point with a fixed order size.
Where min/max breaks
The weakness is the same as the reorder point's, doubled: two numbers per SKU that are usually typed once and left alone while demand, lead times and seasonality move. A max that made sense in spring can be twice what you need in autumn, so the fading lines overstock while the ones that took off run short. Min/max is fine for stable C items. For anything with a trend, the levels have to be recalculated from recent per-SKU sales, and that only works if the demand data feeding them is clean, so it pays to trust the numbers underneath before you automate decisions on top of them.
What is the difference between reorder point and safety stock?
Safety stock is the buffer you never plan to sell; the reorder point is the trigger level that includes that buffer plus the stock you expect to sell during the lead time. In the jeans example, safety stock is 18 pairs and the reorder point is 81. Change the service level and both move; change the lead time and only the reorder point moves.
Should the reorder point include stock on order?
Yes. Compare the reorder point with inventory position: on hand, plus open purchase orders, minus units already promised to customers. Triggering on shelf stock alone double-orders while a shipment is in transit, which is the most common reason small brands end up with two deliveries of the same SKU in one month.
Doing this for a thousand SKUs
The formula is trivial once. It is a job when it is per SKU, per location, monthly, with lead times per supplier, safety stock per service level and a min and max for every item. Storekeeper keeps those levels live: it reforecasts each SKU, resets the reorder point and order-up-to level, and drafts the order, which is what inventory replenishment software is for. That maintenance burden, not the math, is why reorder automation exists as a category. Our live stock scan shows the automated version: paste rows, get verdicts with the reasoning attached, including the reorder quantities the formula implies.
See this math run itself
The free stock scan computes cover, safety stock and verdicts per SKU on sample data or rows you paste. No signup.
Run the stock scanMore from the stockroom
- Buying guide Cin7 vs Unleashed Pricing for Wholesalers
- Buying guide Fishbowl vs QuickBooks Enterprise Pricing
- Buying guide Lightspeed POS Pricing and Lightspeed Retail Cost per Plan
- Buying guide Sumtracker Pricing and Cost per Plan
- Buying guide Ordoro Pricing and Cost per Plan for Shipping and Inventory
- Buying guide StockTrim Pricing and Cost by Revenue Band
- Buying guide Prediko Pricing and Cost by Revenue Band with Add-Ons
- Buying guide Sellbrite Pricing, Sellbrite Cost, Plans and Order Limits
- Buying guide Finale Inventory Pricing and Contract Terms
- Buying guide SOS Inventory Pricing and What Add-ons Cost
- Buying guide Veeqo Pricing and Cost per Month by Order Volume
- Buying guide inFlow Pricing and What the App Costs
- Buying guide Unleashed Pricing and Cost per Month
- Buying guide Zoho Inventory Pricing and Order Limits
- Buying guide Katana Pricing and Katana MRP Add-on Costs
- Buying guide Fishbowl Pricing and Software Add-on Costs
- Buying guide Cin7 Pricing for Core, Omni and Add-ons
- Working capital How to Value Inventory for Taxes (Methods, Rules and COGS)
- Practice Consignment Inventory and How It Works
- Practice Par Level Inventory and How to Set Par Levels
- Practice How to Reduce Supplier Lead Time (9 Practical Ways)
- Working capital What Is Landed Cost? Formula, Components and How to Calculate It
- Practice Just-in-Time Inventory (JIT) Explained
- Practice What Is a SKU? Stock Keeping Unit Meaning, Examples and How to Set One Up
- Metrics What Is a Good Inventory Turnover Ratio? (Benchmarks by Industry)
- Practice How to Reduce Inventory Carrying Cost (6 Practical Levers)
- Practice How Much Safety Stock Should You Hold? (Formula and Service Levels)
- Practice How to Sync Inventory Across Multiple Sales Channels
- Practice How to Reduce Inventory Without Causing Stockouts
- Metrics Days of Inventory on Hand (DIO) Formula, Benchmarks and How to Lower It
- Practice Inventory Optimization Techniques to Cut Stock Without Stocking Out
- Practice Perpetual vs Periodic Inventory Systems
- Working capital Inventory Shrinkage Formula, Causes and How to Reduce It
- Working capital Inventory Carrying Cost Formula, Percentage and How to Lower It
- Practice Cycle Counting Methods, What It Is and How Often to Count
- Metrics ABC Analysis in Inventory Management with XYZ Matrix and Worked Example
- Metrics Inventory Turnover Ratio Formula, Benchmarks and What Good Looks Like
- Formulas Economic Order Quantity (EOQ) Formula and When to Trust It
- Practice Inventory Management in Excel, How to Build It and When to Stop
- Working capital Dead Stock and How to Clear It
- Lost sales Stockouts and How to Avoid Them in 7 Steps