Skip to content
Feb 26

EOQ Model and Inventory Optimization

MT
Mindli Team

AI-Generated Content

EOQ Model and Inventory Optimization

Inventory represents a massive financial commitment for most businesses, tying up capital and space. Getting it wrong means either bleeding money through excess stock or losing sales due to shortages. The Economic Order Quantity (EOQ) model provides a foundational, quantitative framework to strike this balance, minimizing the total cost of ordering and holding inventory. Mastering EOQ and its extensions is not an academic exercise—it’s a direct lever for improving cash flow and operational efficiency.

The Foundational EOQ Model: Balancing Two Key Costs

At its heart, the EOQ model seeks to find the optimal order quantity that minimizes the sum of two opposing cost forces: ordering costs and holding costs.

Ordering costs are the expenses incurred each time you place an order, regardless of the order size. This includes administrative labor, purchase order processing, transportation fees, and receiving/inspection costs. If you order frequently in small batches, these costs accumulate quickly.

Holding (or carrying) costs are the expenses of keeping inventory in stock over a period. This includes capital cost (the opportunity cost of money tied up in inventory), warehousing, insurance, taxes, obsolescence, and pilferage. These costs rise directly in proportion to the average amount of inventory you hold.

The EOQ formula finds the precise order quantity where the annual total of these two costs is at its lowest point. It is derived by expressing total annual cost (TC) as a function of order quantity (Q), then using calculus to find the minimum. The standard assumptions are: demand is known, constant, and continuous; lead time is known and constant; the order is received all at once; no shortages (backorders) are allowed; and the unit price is constant.

The derivation starts with the total cost equation: Where:

  • = Annual demand (units)
  • = Order quantity (units)
  • = Ordering cost per order ($/order)
  • = Holding cost per unit per year ($/unit/year)

Taking the derivative with respect to , setting it equal to zero, and solving for yields the classic EOQ formula:

Example: A distributor has an annual demand () of 10,000 units, an ordering cost () of H5 per unit per year. The optimal policy is to order approximately 632 units each time. The associated number of orders per year is , and the total annual cost at this point is: TC = \frac{10,000}{632.46} \times 100 + \frac{632.46}{2} \times 5 \approx $1,581.14 + $1,581.15 = $3,162.29

Determining When to Order: Reorder Point and Safety Stock

The EOQ tells you how much to order, but not when. The reorder point (ROP) determines this timing. It is the inventory level at which a new order must be placed to account for demand during the lead time. Under the basic model's assumption of constant demand () and constant lead time (), the calculation is simple: If daily demand is 40 units and lead time is 5 days, the ROP is 200 units. You place a new order when stock drops to this level.

However, the real world is uncertain. Demand can fluctuate, and suppliers can be late. This is where safety stock comes in. Safety stock is extra inventory held as a buffer against this variability to maintain a target service level (the probability of not having a stockout during a lead time period). The reorder point formula adjusts to: Where is safety stock.

Calculating safety stock requires understanding demand and lead time variability. A common method uses the standard deviation of demand during lead time () and a Z-score corresponding to the desired service level from the standard normal distribution. For instance, if is 30 units and a 95% service level (Z ≈ 1.65) is desired, safety stock is units. The ROP becomes the expected demand during lead time plus these 50 units.

Extending the Basic Model: Quantity Discounts and Planned Backorders

The basic EOQ assumes a constant unit price. Suppliers, however, often offer quantity discounts for larger orders. This introduces a third major cost: the annual purchasing cost (, where is unit price). The total cost equation expands to: Since price now depends on the order quantity , the solution process changes. You must calculate the EOQ for each price bracket (using the corresponding , though is often a percentage of ). The calculated EOQ may not be feasible in its price bracket. The procedure is:

  1. Calculate the EOQ for the lowest price. If it is feasible (falls within the required quantity range), it is the candidate.
  2. If not, calculate EOQs for successively higher price brackets until a feasible EOQ is found.
  3. Calculate the total annual cost (including purchase cost) for all feasible EOQs and at the minimum quantity required for each price discount.
  4. Select the order quantity that yields the lowest total cost.

Another extension allows for planned backorders, where shortages are permitted and customers wait for their orders. The model balances holding costs against the cost of backordering (e.g., lost goodwill, administrative expense). The optimal order quantity becomes larger than the standard EOQ, and a defined number of backorders are planned at the cycle's end, reducing average inventory held. This can be optimal when the cost of holding inventory is very high relative to the cost of a short-term shortage.

Assumptions, Limitations, and Strategic Application

The power of the EOQ model lies in its clarity, but its limitations must be understood to apply it wisely. Its core assumptions are often violated:

  • Constant, known demand: Real demand is often stochastic (variable).
  • Constant lead time: Supplier reliability varies.
  • Instantaneous receipt: Production or shipment may take time.
  • Constant unit price: Discounts exist.
  • No interactions between products: In reality, items share warehouse space and ordering resources.

Therefore, the basic EOQ is best seen as a robust starting point and a benchmark, not a final answer. It is remarkably insensitive to small errors in estimating or —the total cost curve is flat near the optimum—which makes it pragmatically useful even with imperfect data. Its primary value is in framing the fundamental trade-off and providing a defensible, quantitative basis for order sizing, especially for B and C category items in an ABC inventory classification.

Common Pitfalls

  1. Misclassifying costs as holding or ordering: A frequent error is including irrelevant costs or misallocating them. For example, the cost of the inventory item itself is not a holding cost; the opportunity cost of the capital used to buy it is. Similarly, a fixed warehouse manager's salary is likely not a variable holding cost that changes with inventory levels. Always ask: "Does this cost increase if I hold one more unit for a year?" or "Does this cost incur every time I place one more order?"
  1. Ignoring quantity discounts: Using the basic EOQ when discounts are available can lead to significant overspending. You might save a few hundred dollars on holding costs by ordering the basic EOQ but forfeit tens of thousands in purchase price discounts. Always perform the full total cost comparison across price breakpoints.
  1. Applying EOQ to the wrong items: EOQ is computationally efficient but may be overkill for very low-value (C-class) items or entirely inappropriate for items with highly lumpy, unpredictable, or dependent demand (e.g., components for a final assembly). For such items, simpler periodic review systems or Material Requirements Planning (MRP) may be better suited.
  1. Forgetting to update parameters: Demand, supplier lead times, and costs change. An EOQ calculated five years ago is almost certainly wrong today. The model must be part of a living process, with key parameters reviewed and updated regularly—at least annually for stable items, and more frequently for volatile ones.

Summary

  • The Economic Order Quantity (EOQ) model mathematically finds the order size that minimizes the sum of annual ordering costs and holding costs, formalizing a fundamental operations trade-off.
  • The reorder point signals when to place an order, calculated as expected demand during lead time. Safety stock is added to this point as a buffer against demand and supply uncertainty to achieve a target service level.
  • The model must be adjusted for real-world complexities like quantity discounts, requiring a total cost comparison across price breaks, and can be extended to allow for planned backorders.
  • While based on restrictive assumptions (constant demand/lead time, no shortages), EOQ is a robust and invaluable benchmark due to the flatness of the total cost curve around the optimum. Its primary limitation is misapplication to items with highly variable or dependent demand.
  • Successful implementation depends on accurately classifying variable costs, regularly updating input parameters, and using EOQ as a component of a broader, segmented inventory management strategy.

Write better notes with AI

Mindli helps you capture, organize, and master any subject with AI-powered summaries and flashcards.