EOQ Calculator (Economic Order Quantity)
The EOQ calculator finds the economic order quantity for a product, raw material, spare part, or supply item. Enter yearly demand, the fixed cost to place one order, and the yearly holding cost for one unit. The result is the order size that balances ordering cost and inventory carrying cost, plus orders per year, days between orders, annual ordering cost, annual holding cost, and total relevant cost.
Economic order quantity is an inventory-management model. It asks how many units should be ordered each time when demand is reasonably steady and the key trade-off is between ordering too often and holding too much stock. Small orders reduce average inventory but create many purchase orders, setup runs, receiving events, or shipment fees. Large orders reduce order frequency but raise average inventory, storage cost, insurance, shrinkage, obsolescence, and capital tied up in stock. EOQ sits at the point where those two cost pressures are balanced.
Formula
The classic EOQ formula is:
Using the common variable names:
where D is annual demand, S is cost per order, and H is annual holding cost per unit. The calculator also computes:
All three inputs must be positive. A zero or negative value makes the model invalid because the square-root expression or cost trade-off no longer represents a usable inventory decision.
Worked example using the calculator defaults
The default inputs are 500,000 units of yearly demand, $10 order cost, and $4 yearly holding cost per unit. The calculation determines
The result panel reports Economic order quantity: 1,581.14 units. It then divides demand by EOQ:
The spacing between orders is:
Annual ordering cost is:
Annual holding cost is:
Total relevant cost is therefore about $6,324.56. The near equality of ordering cost and holding cost is not a coincidence; in the basic EOQ model, the optimum occurs where those two annual costs are balanced.
What EOQ tells an inventory manager
EOQ is a baseline order quantity, not a complete replenishment policy. It tells you how large each order should be under the model’s assumptions. It does not tell you exactly when to order. Timing requires a reorder point based on lead time demand and safety stock. A business might order 1,581 units at a time, but the trigger could be when on-hand inventory falls to five days of expected demand, plus a buffer for supplier delays.
EOQ is most useful when demand is relatively stable, the cost to place an order is known, and holding cost can be estimated. It is common in purchasing, warehouse management, production planning, and small-business inventory reviews. It also helps explain why ordering the largest possible quantity is not always best. Even if a supplier offers free freight above a threshold, excess inventory may sit in storage, expire, become obsolete, or consume working capital that could be used elsewhere.
How to estimate inputs
Annual demand should be measured in the same unit you order: pieces, bottles, cases, kilograms, or components. If demand is seasonal, start with annual demand but test separate EOQ values for high and low seasons. Order cost should include the fixed cost of placing or setting up an order, such as purchasing labor, setup time, receiving, inspection, payment processing, and fixed shipping or handling fees. Do not include costs that change per unit unless they are part of holding cost or a quantity discount analysis.
Holding cost per unit per year should include the annual cost of carrying one unit in inventory. Storage, insurance, shrinkage, damage, obsolescence, spoilage, security, inventory taxes, and capital cost can all matter. If you know holding cost as a percentage of unit value, convert it to dollars per unit per year before using the calculator.
Practical tips
- Round EOQ to a usable order quantity, then compare the cost impact.
- Check supplier minimums, case packs, pallet quantities, shelf life, and warehouse capacity.
- Treat EOQ and reorder point as separate decisions: EOQ is order size, reorder point is timing.
- Recalculate when demand, order cost, holding cost, or lead-time reliability changes.
- Use the budget calculator to plan inventory cash needs, the loan calculator to evaluate financing, and the interest calculator to understand the carrying cost of tied-up cash.
For cost-accounting context, EOQ is different from the average fixed cost calculator, average variable cost calculator, and marginal cost calculator. Those tools analyze production costs per unit or per change in output. EOQ analyzes the purchase or production order size that minimizes ordering and holding costs.
Common mistakes to avoid
Do not use monthly demand with annual holding cost unless you convert one of them. Do not confuse unit purchase price with holding cost; holding cost is the annual cost to carry one unit, not the cost to buy it. Do not ignore quantity discounts after calculating EOQ. Do not assume EOQ prevents stockouts; it does not include lead-time uncertainty or safety stock. Finally, do not use EOQ blindly for highly perishable, custom, or rapidly obsolete items.
Sources
- University of North Georgia, Basic EOQ Model — economic order quantity assumptions, formula, and inventory cost trade-offs.