EOQ : drive supply chain performance with the wilson formula

Managing inventory is a balancing act.

Order too much, and inventory carrying costs increase. Order too little, and stockouts can disrupt operations, impact customer service, and reduce revenue.

According to industry benchmarks, inventory carrying costs often represent between 20% and 30% of total inventory value each year. Finding the right balance is therefore essential for both operational performance and profitability.

This is exactly what the Economic Order Quantity (EOQ) model was designed to achieve.

Also known as Wilson's Formula, EOQ helps businesses determine the optimal order quantity that minimizes total inventory costs while maintaining product availability.

In this guide, you'll learn how EOQ works, how to calculate it, its limitations, and how modern supply chain tools can improve inventory decisions.

What is economic order quantity (EOQ)?

Economic Order Quantity (EOQ) is an inventory management formula used to determine the optimal order quantity that minimizes the combined costs of ordering and holding inventory.

The concept is simple:

• Every purchase order generates administrative and logistics costs.
• Every item stored in inventory generates carrying costs.

Ordering too frequently increases purchasing and replenishment costs.

Ordering too much increases inventory carrying costs.

EOQ identifies the quantity that creates the best balance between these two cost categories.

Why EOQ remains important in modern supply chains

Although EOQ was developed more than a century ago, it remains one of the most widely used inventory optimization methods.

Its impact extends far beyond inventory management.

A well-calculated EOQ influences:

• Working capital requirements
• Cash flow
• Inventory turnover
• Warehouse utilization
• Transportation efficiency
• Procurement planning

For supply chain leaders, EOQ provides a structured framework for balancing operational efficiency and financial performance.

Organizations seeking to improve inventory performance often combine EOQ calculations with broader supply chain optimization initiatives and real-time visibility tools.

The origins of Wilson's formula

The Economic Order Quantity model was first developed in 1913 by American engineer Ford Whitman Harris.

The objective was straightforward: determine the ideal quantity to order or produce in order to minimize total inventory costs.

The model was later popularized by consultant R.H. Wilson, which explains why it is commonly referred to as Wilson's Formula.

Despite today's more volatile supply chains, EOQ remains a valuable decision-support tool because of its simplicity and effectiveness.

Economic order quantity formula

The EOQ formula is:

EOQ = √((2DS)/H)

Where:

• D = Annual demand (units)
• S = Cost per order
• H = Annual inventory holding cost per unit

The result identifies the order quantity that minimizes total inventory costs.

Understanding the variables

Annual demand (D)

Annual demand represents the total quantity expected to be consumed or sold during a year.

This figure is usually based on:

• Historical sales data
• Demand forecasts
• Production plans

The more accurate the demand forecast, the more reliable the EOQ calculation.

Ordering cost (S)

Ordering cost includes every expense associated with placing and processing an order:

• Administrative work
• Supplier management
• Inbound transportation
• Receiving operations
• Quality inspections
• Invoice processing

Many companies underestimate this variable, which often leads to inaccurate calculations.

Strong inbound logistics processes help organizations better evaluate and control these costs.

Holding cost (H)

Holding cost represents the annual cost of keeping one unit in inventory.

Typical components include:

• Warehousing
• Insurance
• Obsolescence
• Inventory depreciation
• Capital tied up in stock

For many businesses, inventory carrying costs represent between 20% and 30% of inventory value annually.

Modern warehouse management software can help companies gain greater visibility into these expenses and improve inventory control.

EOQ calculation example

Consider the following scenario:

• Annual demand: 10,000 units
• Ordering cost: $150 per order
• Holding cost: $8 per unit per year

Applying Wilson's Formula:

EOQ = √((2 × 10,000 × 150) ÷ 8)

EOQ = √375,000

EOQ ≈ 612 units

The optimal order quantity is therefore approximately 612 units per order.

Ordering significantly less would increase purchasing frequency and administrative costs.

Ordering significantly more would increase inventory carrying costs and working capital requirements.

How EOQ impacts supply chain performance

Working capital and cash flow

Inventory ties up cash.

Because average inventory is approximately equal to EOQ divided by two, larger order quantities generally increase working capital requirements.

Reducing inventory levels can free up capital for:

• Growth investments
• Equipment purchases
• Debt reduction
• Business expansion

Inventory turnover

EOQ directly influences inventory turnover.

Well-calibrated order quantities help companies:

• Reduce excess inventory
• Improve stock rotation
• Minimize obsolete inventory

Higher inventory turnover is often associated with stronger supply chain performance and better supply chain KPIs.

Warehouse utilization

Larger order quantities require more storage space.

An EOQ that is disconnected from warehouse capacity can create:

• Congestion
• Lower picking productivity
• Reduced operational efficiency

Inventory decisions should therefore be aligned with warehouse constraints.

Companies frequently rely on WMS software to maintain this alignment.

Transportation optimization

EOQ should not be viewed exclusively as an inventory management tool.

Transportation costs must also be considered.

In practice, companies often face a trade-off between:

• Theoretical economic order quantities
• Full truckload (FTL) optimization
• Container utilization
• Supplier minimum order quantities

The best decision balances both inventory and transportation costs.

This is where a freight management system and strong transportation spend management capabilities become valuable.

EOQ assumptions and limitations

EOQ is based on several assumptions:

• Stable demand
• Fixed lead times
• Constant ordering costs
• Constant holding costs
• No stockouts
• No supplier discounts

In reality, supply chains rarely operate under these conditions.

Companies often face:

• Demand fluctuations
• Seasonal peaks
• Supplier constraints
• Transportation disruptions
• Volume discounts
• Minimum order quantities (MOQs)

For this reason, EOQ should be viewed as a decision-support model rather than an absolute rule.

How to calculate EOQ in Excel

EOQ can easily be calculated in Excel.

Create columns for:

• Annual demand
• Ordering cost
• Holding cost
• EOQ result

The formula is:

=SQRT((2DS)/H)

Where D, S, and H reference the appropriate cells.

While Excel works well for small product portfolios, larger organizations often require automated calculations within ERP, WMS, or TMS platforms.

Companies evaluating inventory tools often compare ERP and WMS systems to determine where EOQ calculations should be managed.

Six steps to implement EOQ successfully

1. Improve demand forecasting

Use reliable historical data and accurate forecasts.

2. Calculate real costs

Include all logistics and administrative expenses.

3. Segment products

Apply EOQ prioritization to high-value and high-volume products first.

4. Run multiple scenarios

Test changes in:

• Demand
• Transportation costs
• Supplier pricing
• Inventory carrying costs

5. Integrate calculations into business systems

Avoid relying solely on disconnected spreadsheets.

6. Recalculate regularly

EOQ should evolve as demand patterns and costs change.

Annual reviews are the minimum.

Quarterly reviews are often preferable.

Adapting EOQ to real-world operations

Most companies need to adjust EOQ calculations.

Safety stock

EOQ determines order quantity but does not protect against uncertainty.

Safety stock should be added separately to protect service levels.

Supplier discounts

When volume discounts exist, total landed cost should be evaluated rather than focusing exclusively on EOQ.

Seasonal demand

Companies with strong seasonality often calculate EOQ by quarter or by season rather than annually.

Multi-site networks

Organizations operating multiple warehouses must balance inventory pooling and local availability.

Why digital tools improve EOQ decisions

Calculating EOQ in Excel works for basic inventory management.

However, modern supply chains require continuous updates and dynamic cost calculations.

Integrated supply chain software offers several advantages:

• Automated data updates
• Real-time transportation costs
• Inventory visibility
• Scenario modeling
• Demand forecasting integration

This transforms EOQ from a static calculation into a dynamic planning tool.

Organizations increasingly combine EOQ calculations with supply chain dashboards to gain real-time visibility into inventory and procurement performance.

How Shiptify supports inventory and transportation optimization

Inventory decisions and transportation decisions are closely connected.

A transportation management system helps companies align procurement planning with logistics realities.

Shiptify enables supply chain teams to:

• Integrate transportation costs into planning decisions
• Optimize shipment frequency
• Improve load utilization
• Monitor transportation KPIs
• Increase supply chain visibility

Teams can also leverage freight quotation tools to compare transportation scenarios and improve purchasing decisions.

For companies operating international supply chains, visibility into container transport, sea freight, and multimodal transport costs becomes increasingly important when determining the most profitable order quantities.

Rather than treating inventory and transportation separately, organizations can make more informed decisions based on total logistics costs.

Conclusion

Economic Order Quantity remains one of the most valuable inventory management tools available.

By balancing ordering costs and inventory carrying costs, EOQ helps companies reduce waste, improve cash flow, and optimize inventory performance.

However, successful implementation requires more than a formula.

Supply chain leaders must also consider transportation constraints, warehouse capacity, supplier requirements, and demand variability.

When combined with modern digital tools and real-time logistics data, EOQ becomes a powerful decision-making framework capable of improving both operational performance and financial results.

Organizations that combine EOQ analysis with modern logistics technologies such as warehouse management software, freight management systems, and advanced transportation management system features gain a significant competitive advantage through lower costs, better inventory control, and stronger supply chain performance.