Inventory & Operations · Inventory & Reorder Planner
An incoming order can hide a shortage.
Compare three fixed stock positions, including a late purchase order that arrives after the lead-time cutoff.
Fixed scenario preview. Choose from fictional worked examples below. This is a separate, limited preview—not the downloadable application. It cannot open or save business data; refreshing resets the example.
40 on hand · 12 reserved · no incoming
48 unitsSuggested order
28 unitsInventory position
7 unitsProjected stock at cutoff
Available28 units
TriggerAt or below 29
Reorder48 units
| On hand / reserved | 40 / 12 |
| Incoming units | 0 |
| Inventory position: 40 − 12 + 0 | 28 |
| Raw replenishment need: 71 − 28 | 43 |
| Order rounded to packs of 6 | 48 |
Position is below the reorder point. The 43-unit shortfall rounds up to 48 units; the minimum order does not change this result.
40 on hand · 12 reserved · 10 due in 5 days
0 unitsSuggested new order
38 unitsInventory position
17 unitsProjected stock at cutoff
Available28 units
Due in time10 units
At cutoff17 units
| On hand / reserved | 40 / 12 |
| Incoming units / due | 10 / in 5 days |
| Inventory position: 40 − 12 + 10 | 38 |
| Cutoff projection: 28 + 10 − 21 | 17 |
| Reorder decision | No new order |
The incoming order covers the reorder position and arrives before the cutoff. This example does not trigger another order.
8 on hand · none reserved · 30 due in 30 days
0 unitsSuggested new order
38 unitsInventory position
-13 unitsProjected stock at cutoff
On hand8 units
Due too late30 units
Timing gap13 units
| On hand / reserved | 8 / 0 |
| Incoming units / due | 30 / in 30 days |
| Inventory position: 8 + 30 | 38 |
| Receipts due within 7 days | 0 |
| Cutoff projection: 8 − 21 | −13 |
The total position says no new order, but the late delivery leaves a projected 13-unit shortage. Timing needs attention separately from the reorder quantity.
The full downloadable tool
This preview exposes only the fixed cases shown above.
- Maintain a SKU ledger and movement history.
- Link receipts to purchase orders and fulfill reservations.
- Plan replenishment with your demand, packs, minimums and dates.