Yearly cost today
$8,466
Yearly cost at EOQ
$6,799
Possible saving
$1,667
Economic Order Quantity (EOQ) Planner
Find the order size that keeps ordering and holding costs lowest for each item.
SpreadsheetReordering & Stock PlanningFree
Work out when to reorder each item from its demand, lead time and how variable both are.
Shown with sample data
Work out when to reorder each item from its demand, lead time and how variable both are.
Stop guessing minimums. For each item enter average and peak daily demand and average and longest lead time; the sheet calculates safety stock, the reorder point and a suggested order quantity, and tells you which items need ordering today.
Peak daily demand times longest lead time, minus average demand times average lead time. It covers a bad week arriving at the same time as a late delivery.
Download a copy
Downloads need a free account.