Min/Max Inventory: How the System Works and How to Set Levels
Practice · 8 min read
Nothing you paste is stored.
The scan could not run.
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.
A min/max inventory system sets two numbers for each product: a minimum level that triggers a reorder, and a maximum level you top back up to. When stock falls to the min, you order enough to reach the max, so the reorder quantity is simply max minus current stock. It is the simplest reliable way to keep the right amount of each SKU on hand without watching every item by hand.
Min/max is popular because it is easy to explain and easy to run: set two thresholds per item and let them drive purchasing. The trouble is that most businesses set the numbers once, guess them, and never revisit them, which is how you end up overstocked on dead lines and short on your best sellers. Here is how the system works, how to calculate the levels properly, and where it starts to break.
How a min/max inventory system works
Every SKU gets a minimum and a maximum. The minimum is your reorder point, the level at which a new order has to go out to avoid running dry before it arrives. The maximum is the ceiling you replenish back up to, sized so you are not carrying more than you need. When on-hand stock drops to or below the min, the system flags a reorder, and the quantity you order brings you back up to the max. That gap between the two is the buffer that keeps you from ordering every day while still never sitting on months of excess.
How to calculate the minimum level
The minimum is the reorder point, and it has to cover demand across your full lead time plus a safety buffer. The formula is:
Minimum = (Average Daily Demand × Lead Time in Days) + Safety Stock
Say you sell 5 units of an item a day, the supplier takes 4 days to deliver, and you hold 20 units of safety stock. Your minimum is (5 × 4) + 20 = 40 units. When stock hits 40, you reorder. The safety stock term is what absorbs a demand spike or a slow delivery, so do not set the min to bare lead-time demand unless supply and sales are both very steady.
How to calculate the maximum level
The maximum sets how much you top up to, which controls your carrying cost. A common approach is to add a target amount of coverage on top of the minimum:
Maximum = Minimum + Reorder Quantity
The reorder quantity is how much you want to bring in each cycle, often set to a sensible number of days of supply or an economic order quantity that balances ordering and holding costs. If you want, say, 20 days of coverage at 5 units a day, that is 100 units, so the max would be 40 + 100 = 140. When stock falls to 40, you order 100 to return to 140.
| 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 |
Min/max vs a plain reorder point
A plain reorder point only tells you when to order; you still have to decide how much. Min/max answers both at once: the min is the when, and the max fixes the how much. That makes it a good fit for items you want to keep on a steady shelf level, and for warehouses running two-bin or shelf-tag systems where a visual trigger says "reorder to full." The downside is that a fixed max can overstock an item whose demand has quietly fallen.
Where min/max breaks
The weakness is not the formula, it is the maintenance. Min and max are usually set once and left, but demand, lead times and seasonality all move. A max that made sense last spring can be double what you need this autumn. Set static levels across a big catalog and you drift into the worst of both worlds: overstocked on the fading lines, understocked on the ones that took off. Min/max also treats every SKU the same unless you do the work per item, which nobody does by hand past a few hundred products.
The fix is to treat the min and max as living numbers that update as demand changes. That only holds up if the demand data feeding them is clean and current, so it pays to trust the numbers underneath before you automate decisions on top of them. Recalculating levels from real, recent per-SKU sales, rather than a figure someone typed a year ago, is what keeps min/max honest.
Making min/max dynamic
The modern version of min/max is the same two-threshold idea, but with the thresholds recalculated continuously from each SKU's own demand and lead time. Instead of a person revisiting hundreds of items, the software reforecasts demand, resets the min and max, and flags what to reorder. That is the difference between a spreadsheet that stores your levels and a system that keeps them right. It is the core of what Storekeeper is being built to do: live inventory control that moves the levels for you.
Want to see whether your current min and max levels still fit your demand? Paste your stock and recent sales into the live stock scan at the top of the site. It shows which SKUs are sitting above a sensible max and which are already below a safe min, so you can fix the worst offenders first.
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
- Working capital GMROI: Formula, Benchmarks and How to Improve It
- Practice ABC vs XYZ Analysis: The Difference and How to Combine Them
- Working capital How to Value Inventory for Taxes: Methods, Rules and COGS
- Practice Consignment Inventory: How It Works, Pros and Cons, and the Accounting
- Practice Par Level Inventory: What It Is 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): How It Works and When to Use It
- Lost sales How to Avoid Stockouts: 7 Ways to Stop Running Out of Stock
- Practice What Is a SKU? Stock Keeping Unit Meaning, Examples and How to Set One Up
- Practice How to Do a Physical Inventory Count (Step by Step)
- Metrics What Is a Good Inventory Turnover Ratio? (Benchmarks by Industry)
- Practice How to Reduce Inventory Carrying Cost (6 Practical Levers)
- Practice How to Forecast Inventory Demand (Methods and a Practical Process)
- Metrics How to Calculate Inventory Turnover (Formula, Example, Days)
- Practice How Much Safety Stock Should You Hold? (Formula and Service Levels)
- Practice How to Sync Inventory Across Multiple Sales Channels
- Metrics How to Calculate Inventory Value: FIFO, LIFO and Weighted Average
- Practice How to Reduce Inventory Without Causing Stockouts
- Metrics Inventory KPIs: The 7 Metrics That Actually Matter
- 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: Which System to Use and How COGS Differs
- 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: What It Is, Methods and How Often to Count
- Metrics ABC Analysis in Inventory Management: Formula, Classes and a Worked Example
- Metrics Inventory Turnover Ratio: Formula, Benchmarks and What Good Looks Like
- Formulas Economic Order Quantity (EOQ): The Formula and When to Trust It
- Practice Inventory Management in Excel: How to Build It, and When to Stop
- Formulas Safety Stock: What It Is and How to Calculate It
- Formulas Reorder Point Formula: How to Calculate When to Reorder
- Working capital Dead Stock: Why It Happens and How to Clear It
- Lost sales Stockouts: The True Cost of Running Out