Economic Order Quantity Calculator

What is Economic Order Quantity (EOQ)?

In supply chain management and retail operations, the Economic Order Quantity (EOQ) is the mathematically optimal order size that minimizes a company's total annual inventory costs. These costs consist primarily of two competing forces: ordering costs (setup, freight, and procurement administration) and holding costs (warehouse storage, capital opportunity costs, insurance, and risk of obsolescence).

First developed in 1913 by Ford Whitman Harris and later popularized by consultant R. H. Wilson, the EOQ model remains a core pillar of operational logistics. By calculating your EOQ, you avoid the cash flow squeeze of overstocking (tying up capital in warehouse boxes) while preventing the sales disruption of understocking (stockouts and rush delivery charges).

The Balancing Act: Ordering vs. Holding Costs

To understand why the EOQ model is necessary, you must understand how inventory costs behave:

• Ordering Costs (Setup Costs): Every time you place an order with a supplier, you incur a cost. This includes factory setup fees, logistics management time, customs duties, and fixed shipping charges. If you order in small batches to keep stock levels low, you will have to place orders frequently, causing your annual ordering costs to spike.
• Holding Costs (Carrying Costs): The longer inventory sits on your shelves, the more it costs. Holding costs include warehouse rent, utilities, staff labor, inventory insurance, product degradation, and the opportunity cost of tying up capital that could be invested elsewhere. If you order in massive batches to minimize orders, your warehouse stock levels will remain high, causing your annual holding costs to skyrocket.

The EOQ formula identifies the exact inflection point where the sum of these two opposing costs is minimized. At the EOQ level, annual ordering costs are exactly equal to annual holding costs.

The Harris-Wilson EOQ Formula

The classic mathematical formula to determine the Economic Order Quantity is structured as follows:

\(\text{EOQ} = \sqrt{\frac{2 \times D \times S}{H}}\)

Where:

• D is the Annual Demand: The total number of units your business sells or expects to sell over the course of a year.
• S is the Setup or Ordering Cost: The fixed cost associated with placing a single order with a supplier, independent of the order size (e.g., a flat $150 freight fee).
• H is the Holding Cost per Unit per Year: The cost to store one unit of stock for a full year. This is typically calculated as:
  Holding Cost (H) = Cost Per Unit × Carrying Cost Rate % (e.g., if a unit costs $10.00 and your annual holding rate is 20%, then H = $2.00).

Step-by-Step: Evaluating Supplier Quantity Discounts

Suppliers frequently offer volume discounts—for example, reducing the price per unit by 10% if you place an order of 3,000 units instead of your standard EOQ. While a lower purchase price sounds appealing, buying in bulk forces you to hold excess inventory, which increases carrying costs.

To evaluate if a bulk discount is financially beneficial, follow this step-by-step process:

1. Calculate the Standard EOQ: Find your optimal order size using the standard formula.
2. Compute Total Cost at EOQ: Calculate the sum of annual product purchase cost, annual ordering cost, and annual holding cost:
   Total Cost = (D × Unit Cost) + ((D / EOQ) × S) + ((EOQ / 2) × H)
3. Compute Total Cost at the Discount Tier: Use the discounted unit cost and the supplier's minimum discount order quantity (Q_disc):
   Total Cost (Discount) = (D × Discount Cost) + ((D / Q_disc) × S) + ((Q_disc / 2) × H_disc)
   *(Note: H_disc will be slightly lower because it is based on the discounted unit price: Discount Cost × Carrying Rate %).*
4. Compare the Totals: If the total cost at the discount quantity is lower than the total cost at EOQ, you should accept the deal. Otherwise, decline it to protect your margins. Our calculator's Quantity Discount Mode runs this entire comparison automatically.

Assumptions and Limitations of the EOQ Model

While the classic EOQ model is highly valuable, it is based on several simplifying assumptions:

• Constant Demand: Assumes consumer demand remains uniform and known throughout the year (ignoring holiday season spikes or product cycles).
• Fixed Lead Times: Assumes supplier shipping times are constant and guaranteed.
• Instant Replenishment: Assumes that the entire order quantity arrives at the warehouse in a single batch.
• No Quantity Limits: Assumes there are no storage capacity limits in your warehouse.

Despite these constraints, the EOQ provides an excellent baseline for inventory optimization.