CM8-07

Inventory Reorder Calculator

CapsuleM8 · runs locally · nothing uploaded
On-hand inventory value
—
Items needing reorder
—
Projected annual holding cost
—
Projected annual ordering cost
—

Add item

Demand, supply and cost parameters for one SKU
Item
CAD
Demand
units/day
Average units consumed or sold per calendar day
units/day
Day-to-day scatter. Rough guess: (busy day − slow day) ÷ 4
Supply
days
Order placed → goods usable on the shelf
days
Std dev of lead time. 0 = supplier always on time
Chance of not stocking out during one replenishment cycle
Ordering economics & constraints
CAD
Admin + freight + receiving per purchase order
%/yr
Capital + space + insurance + shrinkage, % of unit cost per year
units
0 = no minimum
units
Order quantities round up to a multiple of this
Current position
units
units
Open purchase orders not yet received

Item table

Click a column heading to sort — action items float to the top by default
No items yet. Add your first SKU above, or

Executive visuals

Status mix, value concentration and cover in days — redrawn whenever the data changes
Status mix — all items
Days of stock remaining — action items
On-hand inventory value — Pareto with cumulative share