CM8-07
Inventory Reorder Calculator
C
apsuleM8
· runs locally · nothing uploaded
Save
Export .json
Import .json
Print Report
Report details
Report title
Company / site
Prepared by
Closing notes
Reset
Items
0
Reorder list
0
Help & Method
Currency
CAD
USD
EUR
GBP
AUD
INR
JPY
Not saved yet
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
Editing item
Cancel edit
Item
SKU / part no.
Description
Unit cost
CAD
Demand
Avg daily usage
units/day
Average units consumed or sold per calendar day
Variability entry
Std deviation / day
High–low estimate
Usage std dev
units/day
Day-to-day scatter. Rough guess: (busy day − slow day) ÷ 4
Busy day usage
units
Slow day usage
units
σ is estimated as (busy − slow) ÷ 4
Supply
Supplier lead time
days
Order placed → goods usable on the shelf
Lead-time variability
days
Std dev of lead time. 0 = supplier always on time
Service level target
90 % (z = 1.282)
95 % (z = 1.645)
97.5 % (z = 1.960)
99 % (z = 2.326)
Chance of not stocking out during one replenishment cycle
Ordering economics & constraints
Cost per order
CAD
Admin + freight + receiving per purchase order
Holding rate
%/yr
Capital + space + insurance + shrinkage, % of unit cost per year
Supplier MOQ
units
0 = no minimum
Pack / carton size
units
Order quantities round up to a multiple of this
Current position
Stock on hand
units
Already on order
units
Open purchase orders not yet received
+ Add item
Clear form
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
Load 4 sample items to explore
Export item CSV
Save project (.json)
Load project
Reset all
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
Reorder list — purchase suggestions
Items at or below their reorder point
SKU
Description
Status
Position
Reorder pt
Qty to order
Unit cost
Line value
Lead time
Nothing needs ordering. All stocked items are above their reorder points.
Export reorder CSV
Print purchase sheet
Inventory Reorder Report
C
apsuleM8
CM8-07 · Inventory Reorder Calculator
Purchase suggestions — reorder list
Status mix — counts and share of the item list by reorder status.
Days of stock remaining at current usage; the marked line is the reorder point in days.
On-hand inventory value by item, largest first, with the cumulative share line.
Full item table
Method & assumptions
Notes
Prepared with CapsuleM8 CM8-07 · Inventory Reorder Calculator — runs locally, no data uploaded.