ExcelFlux
← Workbooks

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.

Worksheet from the completed Excel sample
View from the Excel workbook. Open the image to enlarge it.
MeasureSample result
K-01 inventory position34 units
Reorder point34 units
Suggested order24 units

How do you start with your own data?

  1. Use one row per item on Plan - Blank.
  2. Enter on-hand, inbound and reserved units, daily use, lead days, safety stock, target and case size.
  3. Compare the check status and suggested quantity with open purchase orders.