This inventory calculator tells you how much to order and when. Enter annual demand, the cost of placing an order, unit cost and holding cost, lead time and how variable demand and lead time are, and choose a service level, and it gives the economic order quantity, safety stock and reorder point, plus orders per year and the yearly ordering and holding costs. Paste your SKU list to set reorder levels for everything. It runs in your browser.
| Service level | z | Safety stock | Reorder point |
|---|---|---|---|
| 90% | 1.282 | 11.5 | 101.5 |
| 95% | 1.645 | 14.8 | 104.8 |
| 98% | 2.054 | 18.5 | 108.5 |
| 99% | 2.326 | 20.9 | 110.9 |
The order size that minimises total ordering and holding cost: √(2 × annual demand × order cost ÷ holding cost).
z × √(lead time × demand SD² + daily demand² × lead-time SD²), with z from the service level.
The stock level at which to reorder: demand during the lead time plus safety stock.
95% is common; critical items may justify 98–99%, at the cost of more stock.
No. Everything runs in your browser.
Economic order quantity EOQ = √(2DS ÷ H), with annual demand D, cost per order S and holding cost per unit per year H. Safety stock = z × √(L × σd² + d² × σL²), combining daily demand variability σd over lead time L with lead-time variability σL; z is the inverse normal of the service level (1.645 at 95%). Reorder point = average daily demand × lead time + safety stock. Annual ordering and holding costs and orders per year are reported. Batch mode reads one SKU per row.