Free EOQ Calculator — Economic Order Quantity + Reorder Point + Safety Stock

EOQ Calculator Guide — Economic Order Quantity Formula, Applications & Limitations

The Economic Order Quantity (EOQ) model, developed by Ford W. Harris in 1913 and popularised by R.H. Wilson, remains one of the most widely applied formulas in inventory management, operations research, and supply chain optimisation. Despite being over a century old, the fundamental insight it encodes — that there is a mathematically optimal order size balancing two competing cost drivers — is as relevant to a modern e-commerce warehouse as it was to a 1913 manufacturer.

What is EOQ and Why Does It Matter?

EOQ is the order quantity that minimises the total annual cost of inventory management, specifically the sum of ordering costs (the cost to place and receive each purchase order) and holding costs (the cost to store each unit of inventory for a year). These two costs move in opposite directions as order quantity changes: larger orders reduce ordering costs (fewer orders needed) but increase holding costs (more average inventory on hand). Smaller orders increase ordering frequency but reduce average inventory. EOQ finds the precise quantity where the sum of both costs is lowest.

The critical mathematical property of EOQ is that at the optimal order quantity, annual ordering cost exactly equals annual holding cost. This balance point can be verified by checking your results: if ordering cost per year equals holding cost per year, you have correctly identified the EOQ. The formula sqrt(2DS/H) derives from differential calculus by setting the derivative of total cost with respect to order quantity equal to zero and solving for Q.

EOQ Formula: Understanding Each Input

Annual Demand (D) is the total number of units your business sells or consumes per year. Use historical sales data as the baseline. For new products, use your best demand forecast. EOQ assumes demand is constant throughout the year — for seasonal products, calculate EOQ separately for peak and off-peak seasons.

Ordering Cost (S) is the total cost to place one purchase order, regardless of the quantity ordered. It includes administrative time to prepare the order, purchase order processing fees, supplier communication costs, inbound shipping costs, quality inspection costs, and receiving labour. This is a per-order fixed cost — it does not change based on the number of units ordered. Calculate it by tracking how many hours your team spends processing one order and multiplying by labour cost, then adding any direct fees.

Holding Cost (H) is the annual cost to hold one unit in inventory. It encompasses: capital cost (the return you could earn by investing the cash tied up in inventory, typically 10-15% of unit cost), storage costs (warehouse rent, utilities, equipment), insurance, taxes, depreciation, and obsolescence risk. For most businesses, total holding costs are 20-30% of the unit purchase price per year. If you do not know your exact holding cost, the percentage-of-unit-cost method (15-30% of unit cost) is a reasonable estimate.

Reorder Point — Knowing When to Order

EOQ tells you how much to order; the Reorder Point (ROP) tells you when to order. The ROP is the inventory level at which you should place a new order, timed so that the new stock arrives just as you run out. ROP = (Average Daily Demand x Lead Time in Days) + Safety Stock. Lead time is the number of days from placing an order to receiving it. Safety stock is additional buffer inventory held to protect against demand spikes and delivery delays during the lead time.

When your inventory level drops to the ROP, you place an order for EOQ units. This creates a continuous replenishment cycle: order EOQ units at ROP inventory level, inventory replenishes after lead time, sell down to ROP, repeat. This two-parameter inventory policy (EOQ + ROP) is the foundation of most modern inventory management software.

Safety Stock — Protecting Against Uncertainty

The classic EOQ model assumes perfectly constant demand and instantaneous replenishment. In practice, both demand and lead time vary. Safety stock is extra inventory held to protect against these uncertainties. The formula is: Safety Stock = z x Standard Deviation of Daily Demand x Square Root of Lead Time, where z is the service level z-score (1.28 for 90%, 1.645 for 95%, 2.326 for 99% service level). Higher service levels mean higher safety stock requirements and thus higher holding costs — the trade-off between stockout risk and inventory cost is a fundamental business decision.

Limitations of the EOQ Model

EOQ makes several simplifying assumptions that rarely hold perfectly in practice. It assumes constant, known demand — but real demand is uncertain and often seasonal. It assumes fixed ordering and holding costs — but supplier pricing, freight rates, and warehouse costs change. It ignores quantity discounts — a supplier offering 10% discount on orders over 500 units might make a larger order economically superior to the EOQ despite higher holding costs. It assumes instantaneous replenishment — in reality, orders arrive in batches over time.

Despite these limitations, EOQ provides a valuable baseline. Even if the true optimal is not exactly at the EOQ quantity, the total cost function is relatively flat near the minimum — ordering 20% more or less than EOQ increases total cost by only about 2%. This robustness means EOQ calculations made with imperfect input estimates are still useful approximations. Use EOQ as a starting point for inventory decisions, then adjust for quantity discounts, storage capacity constraints, minimum order quantities, and seasonal patterns.