Reorder Trigger Point Calculator

P23-EDUby TWENTY3 Intelligence Reorder Trigger Calculator
Library
v1.0
Inventory Tool 15
Reorder
Trigger
Calculator
Calculate reorder point (ROP), safety stock, and economic order quantity (EOQ) to eliminate both stockouts and overstock. Know exactly when to reorder and how much.
1Demand & Lead Time
Daily demand standard deviation
95% = z-score 1.645
Supplier to warehouse
Standard deviation of lead time
2Cost Inputs for EOQ
Admin, processing, receiving
Storage + capital cost of stock
-
-
-
Reorder Point - units - place order when stock hits this
ROP Calculation
Avg daily demand -
× Avg lead time (days) -
= Demand during lead time -
+ Safety stock -
Reorder Point (ROP) -
Safety Stock Calculation
Service level z-score -
Demand std dev (daily) -
Lead time (days) -
Lead time variability (std dev) -
Safety Stock (SS) -
EOQ & Ordering
Economic Order Qty (EOQ) -
Orders per year -
Days between orders -
Annual ordering cost ($) -
Annual holding cost ($) -
P23-EDU · TWENTY3 IntelligenceInventory Tool 15· Reorder Trigger Calculator· ROP · Safety Stock · EOQ· Never Stockout. Never Overstock.· P23-EDU · TWENTY3 IntelligenceInventory Tool 15· Reorder Trigger Calculator· ROP · Safety Stock · EOQ·