How to Calculate Economic Order Quantity (EOQ)

Economic Order Quantity (EOQ) is an inventory management formula used to determine the order quantity that minimizes the combined cost of ordering and holding inventory. For a U.S. retailer, manufacturer, distributor, healthcare supplier, or e-commerce business, EOQ provides a practical starting point for deciding how much stock to purchase each time an item is replenished.

The standard EOQ formula is simple:

EOQ = √(2DS / H)

Here, D is annual demand in units, S is ordering cost per purchase order, and H is annual holding cost per unit. The result tells you the approximate quantity to order when the model's assumptions reasonably match your operating environment.

Quick answer: If a U.S. distributor sells 12,000 units per year, spends $75 each time it places an order, and has an annual holding cost of $3 per unit, its EOQ is approximately 775 units per order.

What Is Economic Order Quantity?

Economic Order Quantity is a quantitative inventory optimization method that balances two opposing costs: ordering costs and holding costs. Ordering too frequently increases the cost of purchasing and receiving inventory. Ordering too much at once increases the amount of inventory carried and therefore increases storage, financing, insurance, obsolescence, and related carrying costs.

EOQ seeks the order quantity where these relevant annual costs are balanced under the assumptions of the basic model.

Ordering Cost

Costs associated with placing and processing purchase orders, receiving shipments, and performing related procurement activities.

Holding Cost

The annual cost of keeping one unit in inventory, including applicable storage, capital, insurance, handling, and obsolescence costs.

EOQ

The calculated order quantity that minimizes the combined annual ordering and holding costs under the model assumptions.

EOQ is especially useful when demand and replenishment conditions are reasonably stable. It is less reliable when demand is highly seasonal, supplier lead times are unpredictable, prices change frequently, or businesses routinely purchase under complex quantity discounts.

The EOQ Formula

The standard economic order quantity formula is:

EOQ = √(2DS / H)

Each variable has a specific meaning, and the units must be consistent.

Symbol	Meaning	What to Measure
D	Annual demand	Total units expected to be used or sold per year
S	Ordering cost	Cost incurred each time an order is placed
H	Annual holding cost per unit	Annual cost of carrying one unit in inventory
EOQ	Economic order quantity	Recommended order quantity under the model

Step 1: Determine Annual Demand

The first input is annual demand. This represents how many units the business expects to sell, consume, or otherwise require during a typical year.

For a U.S. business, annual demand can usually be developed from historical sales, production consumption, point-of-sale data, inventory transactions, or a demand forecast. The correct source depends on the item and business model.

Example: Annual Demand for a U.S. Distributor

Suppose a distributor based in Dallas, Texas, sells 12,000 units of a particular packaging component during a normal year.

Therefore:

D = 12,000 units per year

If demand is strongly seasonal, using 12 months of historical data without adjustment may produce a misleading EOQ. A business serving holiday-heavy customers in New York, for example, may need a seasonal demand forecast rather than assuming that every month behaves like the annual average.

Step 2: Calculate Ordering Cost Per Order

The second input is the cost associated with placing and processing one order. Ordering cost is broader than the purchase price of the inventory itself. EOQ focuses on costs that change as the number of orders changes.

Potential ordering costs include:

Purchase order preparation and processing
Procurement employee time
Supplier communication
Receiving and inspection labor
Inbound administrative processing
Freight or delivery charges that vary by order frequency
Invoice matching and purchase-order processing
Other transaction-level procurement costs

Suppose the distributor estimates that each purchase order costs approximately $75 to process.

S = $75 per order

Do not automatically treat the entire supplier invoice as ordering cost. The $10,000 value of inventory purchased in an order is primarily inventory purchase cost, not the $10,000 ordering cost used in the standard EOQ formula.

Step 3: Calculate Annual Holding Cost Per Unit

The third input is annual holding cost per unit. This is often the most misunderstood EOQ variable because inventory carrying cost can include several components.

Holding costs can include:

Warehouse storage costs
Inventory insurance
Inventory handling
Capital tied up in inventory
Obsolescence risk
Shrinkage or deterioration
Special storage requirements

Suppose the business calculates an annual carrying cost of $3 for each unit.

H = $3 per unit per year

Holding cost can also be estimated as a percentage of unit cost. For example, if a product costs $20 and the business uses a 15% annual carrying-cost assumption, the annual holding cost would be $3 per unit.

That percentage is an internal costing assumption, not a universal U.S. regulatory rate. Businesses should use a carrying-cost methodology appropriate to their own inventory economics.

Step 4: Apply the EOQ Formula

Now insert the three values into the formula:

EOQ = √(2DS / H)

EOQ = √(2 × 12,000 × $75 / $3)

EOQ = √600,000

EOQ = 774.60 units

Because inventory is normally ordered in whole units, the practical recommendation is approximately:

EOQ = 775 units per order

The formula does not mean that the company must always order exactly 775 units. Supplier minimums, case packs, pallet quantities, transportation economics, storage constraints, promotions, and service-level requirements may require an operational adjustment.

Step 5: Verify the EOQ With Annual Cost Calculations

A useful practice is to verify the result by calculating annual ordering and holding costs at the proposed EOQ.

Annual Ordering Cost

The annual ordering cost is:

Annual Ordering Cost = (D / Q) × S

Using Q = 775:

12,000 / 775 × $75 = approximately $1,161.29

Annual Holding Cost

The basic EOQ model uses average cycle stock of approximately Q / 2.

Annual Holding Cost = (Q / 2) × H

Using Q = 775:

775 / 2 × $3 = $1,162.50

The small difference between the two amounts results from rounding EOQ to a whole unit. At the exact mathematical EOQ, ordering and holding costs are equal.

Metric	Calculation	Approximate Result
Annual demand	D	12,000 units
Ordering cost	S	$75/order
Holding cost	H	$3/unit/year
EOQ	√(2DS/H)	775 units
Orders per year	D/Q	15.48 orders
Annual ordering cost	(D/Q) × S	$1,161.29
Annual holding cost	(Q/2) × H	$1,162.50

Why EOQ Balances Ordering and Holding Costs

The logic behind EOQ becomes easier to understand when you look at what happens as order quantity changes.

If the business orders very small quantities, it needs to place more purchase orders. Ordering costs increase. If it orders very large quantities, fewer orders are required, but average inventory increases and holding costs rise.

EOQ identifies the point where the combined relevant costs are minimized under the model assumptions.

Order Quantity	Annual Ordering Cost	Annual Holding Cost	Combined Relevant Cost
400 units	$2,250	$600	$2,850
600 units	$1,500	$900	$2,400
775 units	$1,161.29	$1,162.50	$2,323.79
1,000 units	$900	$1,500	$2,400
1,400 units	$642.86	$2,100	$2,742.86

Illustrative example: The table uses the $12,000 annual demand, $75 ordering cost, and $3 annual holding cost assumptions from the worked example. It demonstrates the cost relationship rather than reporting actual market data.

The illustrative curve shows why simply ordering less or more inventory is not automatically better. The economically attractive quantity is near the point where the two cost forces balance.

How to Calculate EOQ in Excel

Microsoft Excel and Google Sheets are practical tools for calculating EOQ across many SKUs. A spreadsheet is particularly useful when you need to compare demand, ordering cost, holding cost, and calculated EOQ across a product catalog.

Basic Excel Formula

Suppose your spreadsheet contains:

Annual demand in cell B2
Ordering cost in cell C2
Annual holding cost per unit in cell D2

The EOQ formula is:

=SQRT((2*B2*C2)/D2)

For the example, B2 would contain 12000, C2 would contain 75, and D2 would contain 3.

You can then use additional formulas to calculate the number of orders, annual ordering cost, and annual holding cost.

Spreadsheet Field	Example Value	Excel Formula or Input
Annual Demand	12,000	Manual input or demand data
Ordering Cost	$75	Manual input
Holding Cost	$3	Manual input
EOQ	774.60	=SQRT((2B2C2)/D2)
Orders Per Year	15.48	=B2/E2

For a larger inventory portfolio, you can extend the model down the spreadsheet and calculate EOQ for every SKU. This can provide a useful starting point for inventory segmentation and replenishment policy design.

How to Use EOQ in a U.S. Business

EOQ is not limited to large manufacturers. Small and midsize U.S. businesses can apply it to products and supplies with relatively stable demand.

E-Commerce

A Shopify or Amazon seller can use EOQ for stable replenishment items where annual demand, supplier ordering costs, and carrying costs are reasonably measurable.

Wholesale Distribution

A distributor in Dallas, Atlanta, or Chicago can use EOQ to evaluate purchase quantities for repeat-order inventory.

Manufacturing

A manufacturer can apply EOQ to purchased components or consumable materials when usage patterns are sufficiently stable.

Healthcare Operations

Clinics and healthcare organizations can use inventory principles for appropriate non-expiring supplies, subject to their service, safety, and regulatory requirements.

A company in Los Angeles may face different freight economics from one in Columbus, Ohio. A New Jersey distributor serving the Northeast may have different warehouse and transportation conditions from a Texas company serving the Southwest. EOQ should therefore be treated as a decision model, not a universal purchasing rule.

EOQ and Reorder Point Are Not the Same

EOQ answers how much to order. Reorder point answers when to order. Businesses often need both calculations to create a practical inventory replenishment policy.

Economic Order Quantity

Determines order quantity.
Balances ordering and holding costs.
Uses demand, ordering cost, and holding cost.
Does not by itself determine the reorder date.

Reorder Point

Determines when replenishment should begin.
Uses demand during lead time.
Can incorporate safety stock.
Helps protect against stockouts during replenishment.

For example, a business may determine that its EOQ is 775 units but still reorder when available inventory reaches a specific reorder point based on supplier lead time and safety-stock policy.

EOQ, Safety Stock, and Lead Time

EOQ should not be interpreted as the total amount of inventory a business needs to keep available. Safety stock and lead-time demand serve different purposes.

Lead time is the time between placing an order and receiving usable inventory. Safety stock is additional inventory held to reduce the risk of stockouts caused by demand or supply uncertainty.

A practical replenishment system may therefore combine:

EOQ: Determines the approximate order size.
Demand forecast: Estimates future consumption.
Lead time: Determines how long replenishment takes.
Safety stock: Provides protection against uncertainty.
Reorder point: Determines when to place the next order.

This distinction is important because a business can calculate EOQ correctly and still experience stockouts if it has poor lead-time assumptions or inadequate safety stock.

EOQ Assumptions You Need to Understand

The basic EOQ model is intentionally simplified. Understanding its assumptions helps you decide when the calculation is useful and when a more advanced inventory model is needed.

Demand is reasonably stable and predictable.
Ordering cost per order is relatively stable.
Holding cost per unit is relatively stable.
Inventory arrives according to a predictable replenishment process.
Stockouts are not part of the basic model.
Purchase prices do not change with order quantity in the basic formula.
There are no quantity discounts in the basic EOQ calculation.

Real-world supply chains frequently violate one or more of these assumptions. That does not make EOQ useless. It means the calculated result should be evaluated against actual purchasing conditions before being adopted as a fixed policy.

When Basic EOQ Is Not Enough

Several situations require additional analysis.

Seasonal Demand

If demand changes sharply during the year, an annual average can hide important peaks. A retailer may need seasonal forecasting rather than one fixed EOQ.

Quantity Discounts

If a supplier offers a lower unit price at larger quantities, the standard EOQ formula does not capture the full purchasing economics. The business should compare total annual cost at each relevant price-break quantity.

Unreliable Lead Times

If suppliers frequently miss promised delivery dates, EOQ does not solve the resulting stockout risk. Lead-time variability and safety stock require separate analysis.

Perishable or Obsolescent Inventory

Food, pharmaceuticals, seasonal merchandise, electronics, and other products with expiration or obsolescence risk may require more conservative order quantities.

Capacity Constraints

If a warehouse has limited rack, cold-storage, or floor capacity, the mathematically optimal EOQ may be operationally impractical.

Very Low-Volume Items

For slow-moving items, the assumptions behind a stable annual demand estimate can become weak. A service-level or periodic-review approach may be more appropriate.

How EOQ Relates to Inventory Accounting

EOQ is primarily an operational inventory management tool. It should not be confused with the accounting method used to measure inventory on financial statements.

A U.S. business may use an inventory accounting method appropriate to its financial reporting requirements while separately using EOQ to manage purchasing quantities. EOQ does not by itself determine whether inventory should be accounted for using a particular costing convention.

Similarly, sales tax treatment, income-tax treatment, and financial reporting considerations should not simply be inserted into the EOQ formula without understanding their specific accounting effect. For example, a recoverable tax may be treated differently from a nonrecoverable acquisition cost in an internal inventory model.

The operational team, controller, CPA, or other qualified accounting professional should align inventory costing assumptions with the company's accounting policies and reporting requirements.

Common EOQ Calculation Mistakes

Using Monthly Demand With Annual Holding Cost

The formula requires consistent time units. If demand is monthly while holding cost is annual, convert the inputs to a common time basis before calculating.

Using Purchase Price as Ordering Cost

The inventory purchase price is not automatically the ordering cost. Identify the incremental cost associated with each purchase order.

Ignoring Holding Costs

Storage and capital costs can materially affect the result. Using an unrealistically low holding cost can produce an EOQ that is too large.

Assuming EOQ Is a Fixed Rule

Demand, supplier pricing, freight, storage capacity, and carrying costs change. EOQ should be reviewed when material operating conditions change.

Rounding Too Early

Calculate the mathematical EOQ first, then apply practical rounding based on supplier pack sizes, pallets, minimum order quantities, or other constraints.

Forgetting Supplier Constraints

If a supplier sells products only in cartons of 100 units, an EOQ of 775 units may need to be translated into an operational quantity such as 800 units.

Practical EOQ Implementation Checklist

Before using EOQ as a purchasing policy, validate the underlying inputs.

Confirm annual demand using reliable sales or usage data.
Separate purchase price from ordering cost.
Document how annual holding cost was calculated.
Use consistent annual units across the formula.
Calculate the mathematical EOQ before operational rounding.
Check supplier minimum order quantities.
Check carton, case, pallet, and container quantities.
Review warehouse capacity.
Consider seasonal demand.
Evaluate supplier lead-time reliability.
Determine whether safety stock is required.
Compare EOQ with actual purchasing patterns.
Review the model when demand, pricing, or carrying costs materially change.

Using EOQ With Inventory Software and ERP Systems

EOQ becomes more useful when it is connected to actual inventory data. Businesses using platforms such as ERP systems, warehouse management systems, or inventory applications can maintain demand history, supplier information, purchase orders, receipts, stock levels, and item costs in a central environment.

Microsoft Excel and Google Sheets are sufficient for smaller SKU portfolios. Larger organizations may incorporate EOQ logic into ERP or inventory planning workflows, where purchasing recommendations can be reviewed alongside reorder points, safety stock, lead times, and supplier constraints.

The technology should support the inventory policy rather than replace operational judgment. A mathematically correct EOQ is only as reliable as the demand, cost, and inventory data behind it.

Frequently Asked Questions

What is the simplest EOQ formula?

The standard EOQ formula is EOQ = √(2DS/H), where D is annual demand, S is ordering cost per order, and H is annual holding cost per unit.

What does EOQ tell a business?

EOQ estimates the order quantity that minimizes the combined annual ordering and holding costs under the assumptions of the basic model.

Can I calculate EOQ in Excel?

Yes. A basic Excel formula is =SQRT((2*D*S)/H), provided the cells containing annual demand, ordering cost, and annual holding cost are referenced correctly.

Does EOQ tell me when to reorder?

No. EOQ determines how much to order. Reorder point determines when to place an order and typically considers demand during lead time and, where appropriate, safety stock.

Is EOQ appropriate for every product?

No. EOQ works best when demand and relevant costs are reasonably stable. Seasonal, perishable, highly volatile, constrained, or quantity-discounted inventory often requires additional analysis.

Does EOQ determine inventory accounting treatment?

No. EOQ is an inventory management technique. Financial reporting and tax inventory treatment are separate accounting matters that should follow the business's applicable accounting policies and professional guidance.

Summary and Next Steps

Economic Order Quantity provides a structured way to determine an appropriate replenishment quantity by balancing ordering costs against inventory holding costs. The standard formula is EOQ = √(2DS/H), but the quality of the result depends on the quality and consistency of the inputs.

For the worked example in this guide, annual demand of 12,000 units, an ordering cost of $75 per order, and an annual holding cost of $3 per unit produce an EOQ of approximately 775 units.

The practical next step is to calculate EOQ for your highest-volume or highest-value repeat-order SKUs, then compare the result with supplier minimums, case quantities, warehouse capacity, lead times, and safety-stock requirements. For broader supply chain context, review the key pillars of supply chain management and use EOQ as one component of a broader inventory optimization strategy.

How to Calculate Economic Order Quantity (EOQ)