Inventory and Reorder Planner
Find inventory position from on-hand, inbound and reserved quantities. Compare the reorder point with the proposed full-case quantity.
Macro-free .xlsx · Includes a worked example
Results from the sample workbook
- K-01 inventory position
- 34 units
- Reorder point
- 34 units
- Suggested order
- 24 units
Who can use it, and for what?
Warehouse and retail teams
See which items reach the reorder threshold based on daily demand.
Purchasing and material planners
See how case size affects the proposed order quantity.
A worked example from the workbook
K-01 has 30 units on hand and eight inbound, with four reserved. Its position of 34 equals the reorder point. A target of 54 and a case size of 12 lead to two cases, or 24 units.

| Measure | Sample result |
|---|---|
| K-01 inventory position | 34 units |
| Reorder point | 34 units |
| Suggested order | 24 units |
How do you start with your own data?
- Use one row per item on Plan - Blank.
- Enter on-hand, inbound and reserved units, daily use, lead days, safety stock, target and case size.
- Compare the check status and suggested quantity with open purchase orders.