Reorder point
Know when to reorder, with a buffer for uncertainty.
InventoryINVENTORY
Min Max Inventory & Replenishment Calculator
Check inventory position against your minimum and replenish toward the maximum, with whole-pack rounding.
Min/max inventory calculator
Check inventory position against your minimum and replenish toward the maximum, with whole-pack rounding.
YOUR RESULT LIVE CALCULATION
Suggested replenishment quantity
480units to order
BELOW MINIMUMOne less spreadsheet to keep open.
- Current inventory position
- 125 units
- Triggered gap to maximum
- 475 units
- Position after planned order
- 605 units
- Order-driven excess over maximum
- 5 units
Orders trigger strictly below minimum. MOQ and pack rounding apply only to a triggered order.
BEHIND THE NUMBER
How the calculation works
The trigger is strictly below the minimum; equality does not trigger an order. A triggered order first covers the gap to maximum, then applies the minimum order quantity and rounds up to the pack multiple. These constraints can push the resulting inventory position above maximum. A negative starting position represents demand exceeding usable and eligible inbound stock.
Position = on hand + inbound - backorders. If position < minimum: order = ceil(max(maximum - position, MOQ) / multiple) x multiple; otherwise 0.
When this calculation helps
A min/max policy uses an inventory-position trigger and a target level. The replenishment quantity closes the gap to that target under the selected policy, rather than automatically repeating a fixed batch.
Check the interpretation
Confirm which commitments, backlog, and incoming orders belong in inventory position. Minimum order quantities and multiples can create stock above the target. Check feasible delivery timing and shelf life before accepting the proposed quantity.
Enter only supply and demand eligible within the same planning horizon. This is a single-item policy check, not a dated availability plan. It does not calculate the minimum or maximum, split orders, or impose a maximum order size.
Oracle min-max planningGood to know
What happens exactly at the minimum?
This tool orders only when position is below the minimum. At the minimum, it reports no order. Set and communicate this boundary consistently with your planning system.
Why can the result exceed the maximum?
A supplier minimum or whole-pack multiple can increase the order above the raw gap. The result shows that excess explicitly; it does not silently cap the order and violate the entered constraints.