EOQ Calculator: When the Formula Helps—and When It Lies

Economic order quantity estimates the order size that balances ordering cost against annual holding cost. Use it as a baseline only when demand, unit cost, and replenishment behavior are stable enough for its assumptions.

Table of Contents

• EOQ is a baseline, not a promise
• EOQ balances ordering and holding cost
• EOQ inputs need one cost basis
• A 632-unit EOQ is a worked baseline
• EOQ fails when assumptions fail
• Sensitivity makes EOQ more useful
• EOQ answers how much, not when
• FAQ

EOQ is a baseline, not a promise

Economic order quantity is a model for deciding how many units to buy or produce in one replenishment cycle. It is useful when demand and costs can be estimated consistently.

EOQ does not tell you when to place an order, how much safety stock to hold, or what service level to target. Those are separate decisions.

The model balances two recurring costs:

• Ordering cost rises when you place many small orders.
• Holding cost rises when you carry more inventory between orders.

Larger orders reduce order frequency but increase average cycle inventory. EOQ identifies the point where those modeled costs balance. Treat the result as a benchmark to test against supplier terms, capacity, service requirements, and actual demand. Source

The classic definition and model are summarized in Economic order quantity. A supply-chain inventory tutorial provides related context for reorder decisions.

EOQ balances ordering and holding cost

The classic EOQ is the square root of twice annual demand times ordering cost, divided by annual holding cost per unit:

EOQ = √((2 × D × S) / H)

The variables are:

• D = annual demand in units
• S = ordering or setup cost per order
• H = annual holding cost per unit

The related annual cost expression is:

Annual relevant cost = (D / Q × S) + (Q / 2 × H)

Here, Q is the order quantity. The first term estimates annual ordering cost. The second estimates annual cycle-stock holding cost, assuming inventory declines steadily from the order quantity toward zero before replenishment arrives.

The basic model generally assumes stable demand, a constant unit price, known replenishment behavior, and no stockouts. It does not automatically include quantity discounts, minimum order quantities, capacity limits, expiration, or demand variability.

EOQ inputs need one cost basis

The hardest input is usually holding cost per unit per year, not demand. Source

Annual demand should match the replenishment decision and use consistent units. If the calculation covers individual units, do not mix cases, packages, and units. A seasonal or forecast-based demand figure can be used, but its uncertainty should be tested.

Ordering cost should include costs caused by placing an order, such as purchase-order processing, approval, receiving, inspection, and order-level setup. Exclude costs that vary directly with the number of units unless the model is designed to include them.

Holding cost must be expressed in currency per unit per year. It may include storage, insurance, shrinkage, handling, financing, obsolescence, expiration, and the opportunity cost of capital. One common approach is:

H = Unit value × Annual carrying-cost rate

Keep the value basis consistent. If unit value uses replacement cost, do not combine it casually with a carrying rate based on historical cost. Document what the rate includes. Inventory-costing guidance from the IRS is a useful reminder that cost treatment should be consistent and supportable.

Purchase price is separate in the basic model because the formula assumes a constant price. If price changes by quantity, compare total costs at feasible quantities instead of assuming EOQ has handled the discount.

A 632-unit EOQ is a worked baseline

With 10,000 units of annual demand, $40 per order, and $2 annual holding cost per unit, EOQ is about 632 units:

EOQ = √((2 × 10,000 × 40) / 2)

EOQ = √400,000 ≈ 632

Expected orders are approximately:

10,000 / 632 ≈ 15.8 orders per year

Average cycle stock is about half the order quantity, or approximately 316 units, before safety stock, pipeline inventory, damage, or other inventory categories.

This example shows the quantity produced by the stated assumptions; it does not prove savings. Compare modeled costs with the current process and test whether the inputs reflect reality.

Rounding may be necessary. If the supplier sells in case packs, pallets, or truckload multiples, the practical quantity could be 600, 640, or another feasible amount rather than exactly 632. Source

EOQ fails when assumptions fail

EOQ becomes misleading when demand is lumpy, lead times vary, quantity discounts dominate, items expire, or stockouts have asymmetric costs.

These conditions do not make EOQ useless. They show where it needs an adjustment, a constraint check, or a different decision model. Source

Sensitivity makes EOQ more useful

Run base, downside, and stress inputs instead of treating one result as exact.

Start with current estimates for D, S, and H. Then test plausible changes such as higher demand, changed ordering effort, increased financing or storage cost, supplier minimums, case-pack restrictions, and quantity discounts.

Because EOQ uses a square root, input changes are softened rather than passed through one-for-one. A 20% demand increase does not automatically require a 20% larger EOQ. A major change in the holding-cost basis can still materially change the result.

Use scenarios to identify a practical range. If cases cluster near the same feasible quantity, the decision is relatively stable. If they diverge widely, improve the uncertain input or set a policy range instead of presenting false precision.

Review the baseline when demand patterns, supplier terms, unit value, storage economics, or service requirements change.

EOQ answers how much, not when

EOQ answers how much to order; reorder point answers when, and safety stock answers how much uncertainty to buffer. Source

A reorder point usually combines expected demand during lead time with protection against uncertainty. Safety stock is shaped by demand variation, lead-time variation, and the desired service level. Neither should be silently added to EOQ.

Use the reorder point calculator for timing, the safety stock calculator for uncertainty protection, and the broader inventory management category for related planning decisions.

A practical workflow is to calculate an EOQ baseline, validate the cost basis, check supplier and operational constraints, set reorder timing separately, and monitor demand and service performance. If the operation disagrees with the formula, investigate the assumptions before forcing the operation to match it.