Inventory reorder calculator
Reorder point, safety stock and the order size that keeps ordering and storage costs lowest.
Sales and supplier
Costs, for the order quantity
Demand during the lead time is 280 units; safety stock covers the swings at a 95.0% in-stock target (z = 1.645). The formulas assume sales and lead times vary randomly around their averages; plan seasonal peaks and promotions separately. Estimates only.
How it’s calculated
The reorder point is the stock level at which to place the next order: the units you expect to sell while waiting for delivery, plus safety stock for the times sales run higher or the supplier runs late.
Safety stock is z × √(lead time × sales swing² + daily sales² × lead-time swing²), where the swings are standard deviations and z comes from your in-stock target: 1.28 for 90%, 1.64 for 95%, 2.33 for 99%. A higher target costs more stock for each step up.
The economic order quantity (EOQ) is √(2 × yearly units × cost per order ÷ yearly holding cost per unit). It balances the cost of placing orders against the cost of holding stock. Supplier minimums, case packs and volume discounts often move the real order size away from it.
Example
A store sells 20 units a day (swinging by 6) and waits 14 days for stock (swinging by 3). Lead-time demand is 280 units; a 95% in-stock target needs about 106 units of safety stock, so it reorders at 386 units. With $60 per order, a $12 unit cost and 25% yearly holding cost, the best order is about 541 units, roughly every 27 days.