XLSlides/Free Tools/EOQ & Batch Size Calculator
All Tools
Supply Chain & Operations FinanceWorking Capital OptimizationHarris Classical Model + EPQ

Economic Order Quantity (EOQ) & Total Cost Optimization Calculator

Find the exact mathematical order batch size that minimizes total inventory costs. Balance purchase order setup expenses against annual holding carry, evaluate supplier volume price breaks, calculate safety stock and reorder points (ROP), and quantify working capital cash liberated from legacy batching.

Select Institutional Business Scenario
Active Context: A precision industrial components manufacturer consuming 24,000 machined castings per year ($185/unit). Arbitrary monthly ordering (2,000 units/order) ties up $185k in average cycle inventory. High machine setup and changeover calibration costs ($1,450/order) and a 24.0% carrying cost create substantial lot-sizing friction. Switching to mathematical EOQ (1,251 units) cuts order cycle size by 37.5%, liberating $69.3k in working capital and saving $21.8k annually in variable inventory costs.

Procurement & Demand Parameters

Harris Economic Model

Instantaneous batch delivery from external supplier.

units/yr
$
$/order

Admin PO, QA check, freight setup

%

H = $44.40/unit/yr

12.0 orders/yr
units/batch

Arbitrary monthly or quarterly batch size currently utilized before EOQ optimization.

Lead Time & Service Level Buffer

ROP Engine
%
x
Optimal Order Quantity (EOQ)Q*
1,252 units/order
Frequency: 19.2 orders/yrCycle Interval: 19.0 days
Total Annual Variable Cost (TVC)Hold = Order
$55.6k/year
Ordering: $27.8kHolding: $27.8k
Working Capital Liberation vs. Legacy Batching
Disciplined Lot-Size Efficiency
Balance Sheet Cash Freed
$69.2k
Cycle stock drops 15.2d → 9.5d
Annual P&L Savings
$6.2k
Ordering + holding cost delta
Revolver Interest Saved
$5.9k
@ 8.5% borrowing rate
Capitalized EV Created
$96.7k
@ 8.0x EV/EBITDA

Reorder Point (ROP) & Buffer Stock Trigger

95% Service Level (Z = 1.65)
Lead Time Demand (LTD)
1,644 units
65.8 units/day × 25 days
Safety Stock Buffer (SS)
148 units
$27.4k buffer capital
Reorder Trigger (ROP)
1,792 units
Cut PO when inventory hits this level
Total Average Inventory: 774 units (11.8 days coverage)Total Capital Deployed: $143.2k

Total Cost Curve & Convex Parabola Analysis

Order vs. Holding Trade-Off
Batch FactorOrder Qty (Q)Orders/YrOrdering CostHolding CostTotal Variable Cost
0.4x50147.9$69.5k$11.1k$80.6k
0.6x75132.0$46.3k$16.7k$63.0k
0.8x1,00224.0$34.7k$22.2k$57.0k
1.0x (EOQ)1,25219.2$27.8k$27.8k$55.6k
1.25x1,56515.3$22.2k$34.7k$57.0k
1.5x1,87812.8$18.5k$41.7k$60.2k
2x2,5049.6$13.9k$55.6k$69.5k

Notice that at 1.0x (EOQ), Annual Ordering Cost ($27.8k) precisely equals Annual Holding Cost ($27.8k), validating the first-derivative cost minimum.

Quantity Break & Volume Discount Arbitration

Evaluating Supplier MOQs: Genuine Savings vs. Working Capital Trap

Optimal Tier: Container Lot (7% discount)

Suppliers often offer 2% to 8% price discounts on condition of purchasing in large batch sizes (MOQs). While purchase spend falls, inventory holding costs surge as average cycle inventory balloons. This arbitration engine evaluates the net bottom-line impact.

Tier NameMOQ (Units)Discount %Unit PriceAnnual SpendHolding CostAll-In CostNet Dollar Impact
Standard (Base)1,2500.0%$185.00$4.44M$27.8k$4.50M-$0/yr
Volume Break A2,5002.0%$181.30$4.35M$54.4k$4.42M+$76.1k/yr
Volume Break B5,0004.5%$176.67$4.24M$106.0k$4.35M+$142.4k/yr
Container LotBest ROI8,0007.0%$172.05$4.13M$165.2k$4.30M+$196.9k/yr
Procurement Recommendation: Taking "Container Lot" at 8,000 units yields $196.9k in net annual profit after absorbing $137.4k in additional inventory carrying costs.
Executive Deliverables & Memoranda

1-Click Institutional Governance & Presentation Outlines

BOARD OF DIRECTORS & OPERATIONS COMMITTEE RESOLUTION
SUBJECT: ECONOMIC ORDER QUANTITY (EOQ) & PROCUREMENT LOT-SIZE GOVERNANCE
DATE: November 2, 2026

1. EXECUTIVE SUMMARY & PROCUREMENT DIAGNOSTIC
- Annual Demand Volume: 24,000 units ($4.44M annual spend)
- Unit Purchase Cost: $185.00 per unit
- Order Admin & Changeover Setup Expense: $1,450 per order
- Annual Inventory Carrying Cost Rate: 24.0% ($44.40/unit/year)
- Optimal Mathematical Order Quantity (EOQ): 1,252 units per batch
- Recommended Order Frequency: 19.2 orders/year (every 19.0 calendar days)

2. WORKING CAPITAL LIBERATION (LEGACY BATCHING VS. EOQ)
- In-Place Legacy Batch Size: 2,000 units (15.2 days cycle coverage)
- Current Cycle Capital Locked in Inventory: $185.0k
- Optimized EOQ Cycle Stock Capital: $115.8k (9.5 days cycle coverage)
- Net Balance Sheet Cash Liberated: $69.2k
- Annual P&L Variable Cost Savings: $6.2k/year
- Senior Revolver Interest Saved (@ 8.5%): $5.9k/year
- Total Annual Recurring Benefit: $12.1k/year
- Capitalized Enterprise Value Created (@ 8.0x Multiple): $96.7k

3. REORDER POINT (ROP) & SERVICE LEVEL GOVERNANCE
- Supplier Replenishment Lead Time: 25 business days
- Lead Time Baseline Demand: 1,644 units
- Target Customer Service Level: 95% (Z-factor = 1.65)
- Required Safety Stock Buffer: 148 units ($27.4k reserve capital)
- Automated Reorder Trigger (ROP): 1,792 units
- Total Inventory Position (Cycle + Safety Buffer): 774 units ($143.2k total capital)

BOARD DIRECTIVE:
Management is authorized to transition ERP replenishment rules from arbitrary legacy calendars to dynamic EOQ algorithms. Capital liberated ($69.2k) shall be deployed immediately to pay down floating-rate debt lines.

Ready to turn this lot-sizing analysis into an executive presentation for your operations review?

Methodology & Foundation

The Mathematics of Ford W. Harris: Why Ordering and Holding Costs Form a U-Shaped Parabola

In 1913, production engineer Ford Whitman Harris published the seminal paper "How Many Parts to Make at Once" in the journal Factory: The Magazine of Management. Harris discovered the fundamental economic tension governing all physical enterprise procurement:

Total Annual Variable Cost (TVC) = Annual Ordering Cost + Annual Carrying Cost
TVC(Q) = (D / Q) × S + (Q / 2) × H
Where: D = Annual Demand, S = Order/Setup Cost, H = Annual Holding Cost per unit (C × h%), Q = Order Batch Size.

When a company orders in tiny, frequent batches, Annual Ordering Cost explodes because of administrative purchase order creation, EDI billing fees, dock receiving logistics, and freight minimum charges. Conversely, when a company orders in massive batches to minimize order paperwork, Annual Holding Cost balloons because warehouse space, insurance, financing capital, and obsolescence risks scale directly with average cycle inventory (Q / 2).

By taking the first derivative of the Total Variable Cost function with respect to Q and setting it to zero (d(TVC)/dQ = -D·S/Q² + H/2 = 0), Harris solved for the absolute minimum cost point:

EOQ (Q*) = √[ (2 × D × S) / H ]

At this exact inflection point, Annual Ordering Cost precisely equals Annual Holding Cost. Ordering any quantity higher or lower than Q* unnecessarily destroys shareholder capital.

Manufacturing Operations

Classical EOQ vs. Economic Production Quantity (EPQ): Accounting for Simultaneous Production

Classical EOQ assumes instantaneous receipt—the entire batch Q arrives on the loading dock at once. While appropriate for wholesale distributors and purchased raw components, internal manufacturers produce parts gradually over time while daily customer demand continues to draw inventory down.

This dynamic is captured by the Economic Production Quantity (EPQ) model (also known as Production Order Quantity / POQ). If annual manufacturing production capacity is P and annual demand is D, inventory only accumulates at the net rate of (P - D) during the production run. Peak maximum inventory is never Q, but rather:

Imax = Q × [ 1 - (D / P) ]   |   EPQ = √[ (2 × D × S) / (H × (1 - D/P)) ]

Because peak and average inventory are lower during concurrent production, the holding cost penalty is mitigated. Consequently, the optimal economic production run size (EPQ) is always larger than classical EOQ.

Commercial Strategy

The Quantity Discount Trap: When Supplier Volume Breaks Destroy Working Capital

One of the most dangerous blind spots in corporate procurement is the uncritical acceptance of supplier quantity discounts. An overseas vendor offering a 4% discount on condition of ordering 10,000 units (instead of your calculated EOQ of 2,500 units) appears to save $40,000 on a $1M purchase budget.

However, quadrupling the order quantity quadruples your average cycle inventory from 1,250 units to 5,000 units. If your corporate carrying cost is 25% annually, the additional holding cost over the extended cycle can exceed $50,000, creating a net $10,000 annual loss while trapping hundreds of thousands in non-dilutive liquidity.

Institutional procurement executives never evaluate unit price in isolation. Every volume tier must be subjected to an All-In Total Cost Test (Purchase Spend + Ordering Cost + Holding Cost) to verify that net dollar profit increases before authorizing elevated MOQs.

Industry Intelligence

Cross-Sector Benchmark Matrix: Lot Sizing & Carrying Costs Across 5 Industries

Industry SectorCarrying Cost %Primary Carrying DriverOrder/Setup ProfileTypical Replenishment
Precision OEM & Machining22% – 26%Cost of capital & specialized tooling fixturesHigh ($1,000–$2,500) setup & calibrationBi-weekly / Monthly EOQ batches
High-Tech & Semiconductors28% – 35%Severe component revision obsolescenceModerate ($500–$1,200) QA & ESD stagingHigh-velocity weekly blanket POs
Wholesale Distribution18% – 24%Warehouse footprint, racking & yard storageLow-to-Moderate ($150–$400) freight logisticsFull truckload (FTL) / railcar MOQ breaks
CPG & Packaging18% – 22%Volumetric bulk space & handling damageLow ($100–$300) automated EDI triggersVendor Managed Inventory (VMI) pull
Pharma & Medical Devices25% – 32%Cold-chain storage, lot tracking & expirationHigh ($800–$2,000) FDA sterilization releaseGated regulatory compliance lot sizes
Executive Communication

5 Fatal Mistakes Corporate Teams Make in Board Procurement & Lot-Sizing Decks

1. Treating Carrying Cost as Just Bank Interest

Management teams frequently understate inventory holding drag by using only their borrowing rate (e.g., 7.0%), ignoring warehousing rent, material handling labor, insurance, shrink, and obsolescence. Real all-in corporate carrying cost is almost universally 20% to 30%.

2. Ignoring the Working Capital Impact of Volume Discounts

Presenting a $50k purchase discount to the board without revealing that it requires tying up $400k in additional cycle stock for 9 months destroys credibility with audit and finance committees.

3. Setting Arbitrary Calendar-Based Batch Sizes

Ordering monthly simply because "the accounting cycle is monthly" is a classic operational failure. Fast-moving SKUs should be ordered weekly; slow-moving high-setup SKUs should be ordered quarterly.

4. Conflating Cycle Stock with Safety Stock

EOQ dictates the batch size of cycle stock (Q / 2), whereas Safety Stock is determined strictly by lead time volatility and service level requirements. Presenting them as an undifferentiated aggregate prevents targeted operational triage.

Real-World Case Study

Case Study: How an $85M Industrial Manufacturer Liberated $1.15M in Working Capital via EOQ

The Situation: An Ohio-based precision manufacturing firm acquired by a middle-market private equity sponsor had $18.5M in annual inventory. Purchasing managers ordered raw aluminum castings and specialized fasteners in arbitrary 60-day batches to minimize invoice handling.

The Diagnostic: The sponsor’s operations team conducted an ABC inventory audit and computed Harris EOQ for the top 50 spending components. The analysis revealed that large 60-day batch sizes created $3.8M in average cycle stock, generating an annual carrying cost penalty of $912,000 at the firm's 24.0% holding rate.

The Transformation: The company reconfigured ERP replenishment rules to execute smaller, higher-frequency EOQ deliveries. To offset higher ordering frequency, procurement established electronic blanket purchase orders with primary suppliers.

Working Capital Released
$1,150,000
Deployed to prepay senior credit line
Net Annual Holding Savings
$276,000 / yr
Slashing warehouse overflow leases
Enterprise Value Created
$2,208,000
At 8.0x sponsor exit multiple
Frequently Asked Questions

Institutional FAQs: Economic Order Quantity & Total Cost Management

What is Economic Order Quantity (EOQ) and how is it calculated?

Economic Order Quantity (EOQ) is the ideal order quantity a company should purchase to minimize total inventory costs, including annual ordering costs and annual carrying/holding costs. The classical Ford W. Harris formula is EOQ = √((2 × D × S) / H), where D is annual demand in units, S is fixed order/setup cost per order, and H is annual holding cost per unit per year (Unit Cost × Carrying Cost Rate %).

Why do ordering costs and holding costs equal each other at EOQ?

In the total inventory cost equation, Annual Ordering Cost (D/Q × S) decreases hyperbolically as order quantity increases, while Annual Holding Cost (Q/2 × H) increases linearly. The mathematical minimum of this convex U-shaped curve occurs at the exact first-derivative inflection point where the slopes balance and Annual Ordering Cost precisely equals Annual Holding Cost.

How should companies evaluate supplier quantity discounts?

To evaluate a quantity discount, compute Total Annual Inventory Cost (Annual Purchase Spend + Annual Ordering Cost + Annual Holding Cost) at each minimum order quantity (MOQ) tier. Taking a volume discount is only economically justified if the purchase price savings exceed the incremental holding costs of storing larger average cycle inventory.

What is the difference between EOQ and EPQ (Economic Production Quantity)?

EOQ assumes instantaneous replenishment where an entire order arrives at once from an external supplier. Economic Production Quantity (EPQ), also known as Production Order Quantity (POQ), accounts for internal manufacturing where units are produced and consumed simultaneously at a daily production rate P exceeding daily demand rate D, reducing peak cycle inventory.

How is the Reorder Point (ROP) determined with safety stock?

Reorder Point (ROP) is calculated as Lead Time Demand plus Safety Stock: ROP = (Daily Demand × Supplier Lead Time) + (Z × Daily Demand Std Dev × √Lead Time). When physical on-hand plus on-order inventory falls to the ROP, a new purchase order must be placed immediately to prevent stockouts during supplier lead time.

What costs should be included in the Annual Carrying Cost Rate (h%)?

An institutional carrying cost rate encompasses five distinct components: (1) Cost of Capital / Financing Rate (8%–12%), (2) Warehouse Racking & Storage Space (4%–6%), (3) Material Handling Labor & Equipment (3%–5%), (4) Obsolescence, Spoilage & Scrap (3%–8%), and (5) Property Taxes & Inventory Insurance (1%–2%). Total carrying cost typically totals 20% to 32% of unit cost annually.

Integrated Working Capital Cluster

Complementary Supply Chain & Treasury Analyzers