Free inventory planning calculator for 2026: EOQ (economic order quantity) with ordering vs. holding cost, reorder point and safety stock from demand and lead-time variability at 90–99.9% service, carrying cost by component, inventory turnover, days of inventory and the cash conversion cycle.
Order quantity (EOQ): enter annual demand in units, the cost of placing one order, and the holding cost per unit per year — either directly or as unit cost × carrying rate. You get the economic order quantity, orders per year, days between orders, the ordering and holding cost split, and a table of what five other order sizes would cost.
Reorder point and safety stock: enter average daily demand and its standard deviation, average lead time and its standard deviation, and the service level you want. The result is the reorder point, the safety stock behind it in units and days, average and maximum stock if you give an order quantity, and a table of safety stock at 90% to 99.9% service.
Carrying cost: enter average inventory value and the four components of the carrying rate — cost of capital, storage and handling, insurance and systems, shrinkage and obsolescence — to get the annual and monthly carrying cost, the cost of every extra 30 days of stock, and the per-unit figure to feed back into the EOQ tab.
Turnover and cash cycle: enter cost of goods sold with beginning and ending inventory for turnover, days of inventory and months of supply; add revenue, receivables and payables for DSO, DPO, the cash conversion cycle and the working capital it ties up, plus how much cash faster turns would release.
Links from the old EOQ, safety stock, reorder point, holding cost, inventory turnover and cash conversion cycle pages open the matching tab. Each tab keeps its own saved history.
The EOQ (Wilson) formula balances two costs that move in opposite directions as order size grows: ordering cost falls because you order less often, holding cost rises because the average stock on hand is half the order. At the optimum the two are equal. The reorder point covers the demand expected while an order is in transit plus a buffer for the demand and lead-time variability you cannot forecast; the buffer scales with the z-value of the service level you choose, so the last few points of availability cost disproportionately more stock. Carrying cost converts that stock into dollars per year, and turnover and the cash conversion cycle measure how long the cash stays tied up in it. The four tabs feed each other: the carrying rate sets H for EOQ, EOQ sets the order quantity for average stock, and turnover tells you whether the whole system is improving.
EOQ = √(2 × 12,000 × 50 ÷ 3) = 632 units. 18.97 orders a year, one every 13.18 working days. Ordering $948.68 + holding $948.68 = $1,897.37. Ordering 1,265 at a time instead would cost $2,371.81, $474.44 more.
Demand 100/day (σ 20), lead time 7 days (σ 1), 95% service (z = 1.6449). Variance = 7 × 20² + 100² × 1² = 12,800; safety stock = 1.6449 × √12,800 = 187 units (1.86 days). Reorder point = 700 + 187 = 887 units.
Set the lead-time standard deviation to 0 and the safety stock falls to 88 units, reorder point 788: a reliable supplier is worth 99 units of permanent stock on this one item.
10% cost of capital = $20,000.00; 6% storage & handling = $12,000.00; 3% inventory service = $6,000.00; 6% risk = $12,000.00. Total 25% = $50,000.00 a year ($4,166.67 a month); $3.75 per unit per year across 13,333 units.
COGS $600,000 ÷ average inventory $110,000 = 5.45 turns = 67 days. DSO = $120,000 ÷ $1,000,000 × 365 = 44 days; DPO = $50,000 ÷ $600,000 × 365 = 30 days. CCC = 67 + 44 − 30 = 80 days ≈ $132,000 tied up. Raising turnover to 8.18× would release $36,650.
| Cycle service level | z | Safety stock (units) | Reorder point (units) | Change vs. 95% |
|---|---|---|---|---|
| 90% | 1.2816 | 145 | 845 | -42 units |
| 95% | 1.6449 | 187 | 887 | — |
| 98% | 2.0537 | 233 | 933 | +46 units |
| 99% | 2.3263 | 264 | 964 | +77 units |
| 99.9% | 3.0902 | 350 | 1,050 | +163 units |
The one-sided normal z-values used: 80% → 0.8416, 85% → 1.0364, 90% → 1.2816, 95% → 1.6449, 97.5% → 1.96, 98% → 2.0537, 99% → 2.3263, 99.5% → 2.5758, 99.9% → 3.0902. Service level here is the probability of not stocking out during one replenishment cycle, not the fill rate.
| Order quantity | Orders / year | Ordering cost | Holding cost | Total | Penalty vs. EOQ |
|---|---|---|---|---|---|
| 316 | 38.0 | $1,898.73 | $474.00 | $2,372.73 | +$475.37 |
| 474 | 25.3 | $1,265.82 | $711.00 | $1,976.82 | +$79.46 |
| 632 | 19.0 | $949.37 | $948.00 | $1,897.37 | — |
| 791 | 15.2 | $758.53 | $1,186.50 | $1,945.03 | +$47.67 |
| 949 | 12.6 | $632.24 | $1,423.50 | $2,055.74 | +$158.38 |
| 1,265 | 9.5 | $474.31 | $1,897.50 | $2,371.81 | +$474.44 |
The cost curve is flat near the optimum: ordering 25% more or less than EOQ costs only a few percent extra, which is why rounding to a case, pallet or supplier minimum is usually fine.
| Component | Typical % of inventory value / year | What it covers |
|---|---|---|
| Cost of capital | 6 – 12% | Interest on the money tied up, or the return it could earn elsewhere |
| Storage & handling | 2 – 8% | Warehouse space, racking, labor, equipment, utilities |
| Inventory service | 1 – 4% | Insurance, inventory taxes, WMS and counting |
| Risk | 3 – 10% | Shrinkage, damage, spoilage, obsolescence and markdowns |
| Total carrying rate | 15 – 30% | The calculator example uses 25% |
Perishable, seasonal and technology products sit at the top of the risk range; stable commodities at the bottom. Use your own numbers where you have them.
The example sells 12,000 units a year, pays $50.00 to place an order and holds each unit for $3.00 a year ($15.00 unit cost at a 20% carrying rate). EOQ = √(2 × 12,000 × 50 ÷ 3) = 632 units: 18.97 orders a year, one every 13.18 working days, $948.68 of ordering cost and $948.68 of holding cost. The two are equal by construction; the total, $1,897.37, is the minimum.
Ordering cost is the lever most businesses underestimate. Cut it from $50.00 to $12.00 with a supplier portal or blanket purchase order and the EOQ drops to 310 units with 38.73 orders a year, total cost $929.52. The formula assumes steady demand, a fixed unit cost and instant delivery of the whole order; quantity discounts, perishable stock, seasonal demand or a supplier minimum all override it. Use the sensitivity table to see what a practical order size costs against the theoretical one.
The reorder point has two parts. Lead-time demand is the stock you expect to sell while the order is on its way: 100 units a day × 7 days = 700 units. Safety stock is the buffer for what you cannot forecast. With demand varying by 20 units a day and no lead-time variability, a 95% service level needs z = 1.6449 × 20 × √7 = 88 units and a reorder point of 788. Add a one-day standard deviation on the lead time and the buffer more than doubles to 187 units, reorder point 887 — supplier reliability is worth more than most buyers assume.
The service level table shows the price of the last few points of availability: from 95% to 99% the safety stock rises from 187 to 264 units, and 99.9% needs 350. Choose by item: A-items and anything with a high stockout cost earn 98–99%; slow C-items rarely justify more than 90%. With an order quantity of 1,400 the average stock is 886 units and the peak just after delivery 1,586, which is what the carrying cost tab should be priced on.
Inventory is not free to keep. The example holds $200,000 on average and pays 25% a year to do so — 10% cost of capital, 6% storage & handling, 3% inventory service, 6% risk — $50,000.00 a year, $4,166.67 a month, $4,109.59 for every extra 30 days a batch sits. Per unit that is $3.75 a year, the H the EOQ formula needs.
Turnover measures how long cash is locked up. $600,000 of cost of goods sold on $110,000 of average inventory is 5.45 turns, 67 days of inventory. Add 44 days to collect from customers and subtract the 30 days suppliers wait to be paid and the cash conversion cycle is 80 days: about $132,000 of working capital in transit. Tighten inventory to $75,000, collect in 31 days and pay in 40 and the cycle falls to 37 days, releasing roughly $71,000. Each day off the cycle is worth about $1,644.
Find answers to the most common questions about inventory planning calculator.
EOQ = √(2 × annual demand × cost per order ÷ holding cost per unit per year). For 12,000 units, $50.00 per order and $3.00 holding it is 632 units. It assumes steady demand, a constant unit price, the whole order arriving at once and no stockouts; quantity discounts, seasonality, shelf life and supplier minimums all justify departing from it, and the sensitivity table shows what that costs.
Multiply the unit cost by your carrying rate, or use the carrying cost tab: it adds cost of capital, storage, insurance and risk into a rate (25% in the example) and divides the annual cost by units on hand ($3.75 per unit). Carrying rates of 15–30% a year are typical; businesses that only count warehouse rent badly understate it.
Reorder point = average daily demand × lead time + safety stock. The example is 100 × 7 = 700 units of lead-time demand plus 187 units of safety stock at 95% service, 887 units. When stock on hand plus stock on order falls to that level, place the next order.
Safety stock = z × √(lead time × σ²demand + demand² × σ²lead time), where z comes from the service level (90% → 1.28, 95% → 1.64, 99% → 2.33). The example needs 187 units for 95% and 264 for 99%. Lead-time variability usually matters more than demand variability: making the supplier reliable removed 99 units here.
Choose by item value and stockout cost rather than one number for everything. Fast-moving or critical items (A-items, anything whose stockout stops production or loses the customer) justify 98–99%; ordinary items 95%; slow, low-margin C-items 85–90%. Remember this is the cycle service level (chance of not running out before the next delivery), which is stricter than the fill rate most customers experience.
The annual cost of keeping stock, expressed as a percentage of inventory value: cost of capital plus storage and handling plus insurance, taxes and systems plus shrinkage and obsolescence. The example runs 25% ($50,000.00 a year on $200,000); 15–30% is the usual planning range, higher for perishable or fashion goods.
COGS ÷ average inventory, 5.45 turns in the example (67 days of inventory). It varies enormously by industry — grocery 12–20, general retail 4–8, manufacturing 4–6, luxury and heavy equipment under 3 — so compare with your own history and direct competitors. The turnover tab shows how much cash a faster turn would release.
Days inventory outstanding + days sales outstanding − days payables outstanding: the days between paying suppliers for stock and collecting cash from customers. The example is 67 + 44 − 30 = 80 days, about $132,000 of working capital. Shorter is better and a negative cycle, common in grocery and subscription businesses, means customers finance the inventory.
They are the four tabs of this page — EOQ; reorder point and safety stock together, since one feeds the other; carrying cost; turnover with the cash conversion cycle. Their links open the right tab, and the tabs share numbers: the per-unit carrying cost feeds EOQ and the order quantity feeds average stock.
Admin, freight, receiving — per order, not per unit
Economic order quantity
632 units
18.97 orders a year · one every 13.18 working days · total ordering + holding cost $1,897.37
Annual ordering cost
$948.68
Annual holding cost
$948.68
Average cycle stock
316 units
Holding cost per unit
$3.00/yr
| Order quantity | Ordering | Holding | Total | vs EOQ |
|---|---|---|---|---|
| 316 | $1,898.73 | $474.00 | $2,372.73 | +$475.37 |
| 474 | $1,265.82 | $711.00 | $1,976.82 | +$79.46 |
| 632 | $949.37 | $948.00 | $1,897.37 | — |
| 791 | $758.53 | $1,186.50 | $1,945.03 | +$47.67 |
| 949 | $632.24 | $1,423.50 | $2,055.74 | +$158.38 |
| 1,265 | $474.31 | $1,897.50 | $2,371.81 | +$474.44 |
EOQ = √(2 × demand × order cost ÷ holding cost per unit). The curve is flat near the optimum, so rounding to a case or pallet quantity costs little; being far off on either side costs more. It assumes steady demand and no quantity discounts.