Economic order quantity (EOQ) is an inventory formula that calculates the order size that minimizes total ordering and holding costs. For small to midsize businesses managing working capital, getting order quantities right is critical. Order too much, and you tie up cash in slow-moving stock. Order too little, and you face stockouts, rush fees, and lost sales. According to IHL Group, global retail loses $1.73 trillion annually to inventory distortion, the combined cost of out-of-stocks and overstocks. EOQ offers a mathematical approach to finding the order size that balances these competing pressures, helping you reduce costs while keeping enough inventory on hand to meet demand. Here’s everything you need to know about EOQ, including how to calculate it, when it works best, and practical alternatives for when it doesn’t.
Key takeaways
- Economic order quantity (EOQ) uses a formula to find the order size that minimizes the combined cost of ordering and holding inventory.
- EOQ assumes constant demand, fixed costs, and reliable lead times. When those assumptions break down, the formula needs adjustment.
- Pairing EOQ with reorder points and safety stock calculations creates a more resilient restocking strategy.
- Modern inventory software can automate EOQ calculations and flag when conditions shift, reducing manual recalculation.
What is economic order quantity (EOQ)?
EOQ is the optimal number of units you should purchase to minimize inventory costs and avoid ordering too frequently. The formula accounts for three variables: holding costs (how much it costs to store inventory), demand rate (how many units you sell in a given period), and setup costs (the fixed expense of placing each order).
The core trade-off is straightforward. Ordering in large batches reduces the number of orders you place each year, lowering your total setup costs. But large orders also mean more inventory sitting in your warehouse, driving up storage and carrying expenses. EOQ finds the point where these two cost curves intersect, giving you the order quantity that minimizes your total inventory costs without sacrificing stock availability.
Ford Whitman Harris first published the formula in 1913. It is sometimes called the Wilson formula after R.H. Wilson, who later popularized it, though Harris published the original model.
What is the economic order quantity formula?
The EOQ formula is:
EOQ = √[(2 × S × D) / H]
Where:
- H = Holding costs per unit per year
- D = Demand rate (units sold per year)
- S = Setup costs per order (shipping, handling, receiving)
Holding costs
Holding costs (also called inventory carrying costs) include storage expenses, employee wages for warehouse staff, depreciation, insurance, and the opportunity cost of capital tied up in inventory. You can calculate them as:
Holding cost = (storage costs + employee salaries + depreciation + opportunity costs) / total value of annual inventory
The Institute for Supply Management cites 20–30% of inventory value per year as a common planning range for carrying costs. This is a planning convention, not a measured industry average, so your actual costs may vary based on warehouse efficiency, product type, and financing costs.
Demand rate
Demand rate is the number of units you expect to sell in a year. For the EOQ formula to work accurately, this number should be reasonably stable and predictable.
Setup costs
Setup costs cover everything involved in placing and receiving an order: purchase order processing, shipping fees, receiving labor, and quality inspection. These costs remain fixed regardless of order size.
EOQ example
A specialty coffee roaster sells 20,000 bags of beans per year. Their holding cost is $2 per bag per year, and each order costs $100 to place and receive.
Plugging into the formula:
- 2 × $100 × 20,000 = 4,000,000
- 4,000,000 / $2 = 2,000,000
- √2,000,000 = 1,414 units per order
The roaster should order approximately 1,414 bags at a time. At 20,000 units of annual demand, this means placing about 14 orders per year.
What are the assumptions behind the EOQ model?
EOQ relies on several simplifying assumptions. Understanding them helps you know when the formula applies and when you need to adjust your approach.
- Constant, known demand: The model assumes demand is steady and predictable throughout the year. Seasonal spikes or irregular sales patterns violate this assumption.
- Fixed ordering costs: Each order incurs the same setup cost regardless of quantity or timing. Volume discounts or variable shipping rates are not factored in.
- Fixed holding costs: Storage and carrying costs per unit remain constant. In practice, warehouse capacity constraints or financing changes can shift these costs.
- Constant, reliable lead time: The time between placing an order and receiving it stays the same. Supplier delays or shipping disruptions break this assumption.
- No stockouts allowed: The model assumes you never run out of inventory. It does not account for backorder costs or lost sales from shortages.
- Instantaneous replenishment: The entire order arrives at once, not in partial shipments over time.
Together, these assumptions produce the classic “saw-tooth” inventory pattern: stock depletes steadily, then jumps back up when a full order arrives. When real-world conditions deviate from these assumptions, EOQ provides a starting point rather than a definitive answer.
What are the benefits of EOQ?
Inventory is working capital. The money sitting in your warehouse could be funding growth, paying down debt, or covering unexpected expenses. EOQ helps you hold the right amount, neither too much nor too little, so you can put cash to better use.
1. Increase agility
Smaller, more frequent orders (within reason) keep your inventory fresh and your commitments flexible. If market conditions shift or a product line underperforms, you’re not stuck with months of unsold stock. EOQ helps you find the order frequency that balances cost efficiency with responsiveness.
2. Decrease costs
By optimizing order quantities, EOQ reduces the combined expense of placing orders and storing inventory. You avoid paying for unnecessary warehouse space while also avoiding the administrative burden of constant reordering.
3. Promote better liquidity
Less cash tied up in inventory means more cash available for operations, investments, or emergencies. KidWind Project, Inc., an education company in St. Paul, reduced on-hand inventory costs from $270,000 to between $80,000 and $100,000 at any given time using Fishbowl, freeing cash for the rest of the business. For growing businesses, that kind of liquidity can make the difference between seizing an opportunity and missing it.
4. Reduce the likelihood of spoilage
For businesses in the food and beverage sector or those handling perishable goods, excess inventory doesn’t just cost money. It can spoil, expire, or become obsolete. EOQ helps you order quantities that sell through before degradation becomes a problem.
What are the limitations of EOQ?
EOQ provides a useful baseline, but its assumptions don’t always match reality. Recognizing these limitations helps you know when to supplement or replace the formula.
1. Inventory shortages
The basic EOQ formula doesn’t include safety stock. If you order exactly 1,414 units and demand spikes unexpectedly, you’ll run out before the next shipment arrives. Most businesses need to pair EOQ with a safety stock buffer to handle variability.
2. Outdated systems
EOQ calculations are only as accurate as the data feeding them. If you’re tracking inventory in spreadsheets or disconnected systems, your holding costs, demand figures, and setup costs may be out of date before you finish calculating. Modern inventory software with real-time visibility keeps the inputs current. Fishbowl AI Insights lets you query your live data in plain language, without SQL or custom report requests, so you can spot cost changes and demand shifts as they happen.
3. Seasonality
EOQ assumes constant demand, but most businesses experience peaks and valleys. A Halloween costume supplier or a sunscreen manufacturer can’t rely on annual averages. Seasonal businesses need to adjust order quantities throughout the year or use time-phased planning approaches.
4. Inaccurate data
The “garbage in, garbage out” rule applies to all inventory management calculations, including the EOQ formula. If your holding costs are estimates from three years ago or your demand figures ignore returned units, the output won’t reflect reality. Regular data audits and automated inventory tracking help keep inputs accurate.
What are the alternatives to EOQ for optimizing inventory?
EOQ works best as one tool in a broader inventory management approach. These complementary methods address gaps the formula doesn’t cover.
1. Safety stock measurements
Safety stock is the buffer inventory you hold to protect against demand variability and supply delays. While EOQ tells you how much to order, safety stock tells you how much extra to keep on hand. Calculating both gives you a more complete picture.
2. Reorder points
A reorder point triggers a new order when inventory drops to a specific level, accounting for lead time and expected demand during that period. Combining a solid reordering strategy with EOQ ensures you order the right amount at the right time.
3. Real-time stock tracking
Continuous inventory visibility lets you see actual stock levels, not just what the system says you should have. Monitoring your inventory turnover ratio alongside EOQ calculations helps you catch discrepancies between theoretical and actual performance.
Frequently asked questions about economic order quantity
What is the difference between EOQ and MOQ?
EOQ is the order quantity that minimizes your total inventory costs, calculated based on your demand and cost structure. Minimum order quantity (MOQ) is the smallest amount a supplier will sell you in a single order. If your supplier’s MOQ is higher than your calculated EOQ, you’ll need to order more than the mathematically optimal amount. In that case, evaluate whether the volume discount offsets the extra holding costs, or consider finding a supplier with lower minimums.
How do you calculate EOQ in Excel?
Create cells for your three inputs: annual demand (D), setup cost per order (S), and holding cost per unit per year (H). Then use the formula =SQRT((2_S_D)/H) to calculate EOQ. For example, if D is in cell B2, S is in B3, and H is in B4, your formula would be =SQRT((2_B3_B2)/B4). Update the input cells whenever your costs or demand change, and the EOQ result updates automatically.
How often should you recalculate EOQ?
Recalculate EOQ whenever your underlying inputs change significantly. For most businesses, a quarterly review works well. Check it more frequently if you experience major cost fluctuations, demand shifts, or supplier changes. Businesses with stable operations and predictable demand may only need annual recalculations, while those in volatile markets might review monthly.
EOQ vs reorder point: how do they work together?
EOQ tells you how much to order. The reorder point tells you when to order. Your reorder point should be set high enough that a new shipment arrives before you run out, accounting for lead time and demand variability. When inventory hits the reorder point, you place an order for the EOQ quantity. Together, they create a systematic restocking process that balances cost efficiency with stock availability.
Is EOQ still relevant with modern inventory software?
Yes, but with less manual calculation. Modern inventory platforms can automate EOQ calculations, update them with real-time data, and alert you when conditions change. The underlying principle of balancing ordering and holding costs remains sound. Software simply makes it easier to keep the calculation current and to layer in additional factors like supplier lead times, volume discounts, and demand forecasting that the basic formula ignores.
Maximize inventory efficiency with Fishbowl
EOQ gives you a framework for smarter ordering decisions, but turning that framework into daily practice requires the right tools. Fishbowl’s inventory management platform connects stock levels, costs, and demand data in one system, making it easier to calculate optimal order quantities and act on them. With QuickBooks integration, your inventory and financial data stay aligned, so the numbers behind your EOQ calculations reflect what’s actually happening in your business.