EOQ on 2,400 SKUs Is Wasting Your Team

Stagnation Slaughters. Strategy Saves. Speed Scales.

Your Procurement Team Runs EOQ on 2,400 SKUs. Ninety of Them Matter. The Other 2,310 Are Just Making Your Buyers Tired.

Your procurement team built a beautiful EOQ model in 2019. Every SKU in the catalog gets a recalculation every quarter. Annual demand, ordering cost, holding cost, quantity discounts, lead time variance — all plugged into the formula. Every SKU gets an optimal order quantity, a reorder point, and a safety stock level, calculated to three decimal places. Your buyers spend two weeks every quarter rerunning the model. The output is a spreadsheet with 2,400 rows of engineering precision. Ninety of those rows drive 64% of your working capital. The other 2,310 are running a 1913 operations-research formula on parts where the annual consumption is measured in dozens and a visual kanban bin would be more accurate, faster, and free. You are paying an engineering department to calculate optimal reorder points on a pack of washers.

Economic Order Quantity is a 1913 formula developed by Ford Whitman Harris that optimizes ordering and holding costs for inventory with stable demand and measurable carrying costs. The formula is mathematically sound and operationally expensive. Applied to every SKU in a modern portfolio, EOQ consumes buyer time and analytical capacity at a rate disproportionate to its economic value, because most portfolios contain a long tail of low-velocity SKUs where the optimization math produces trivially small dollar improvements.

The Fusion: Classical Ops Research Meets Recursive Pareto

Economic Order Quantity is one of the oldest formulas in operations research. It is elegant, mathematically rigorous, and universally taught. It is also universally misapplied, because most procurement organizations run EOQ on every SKU in the catalog rather than on the small number of SKUs where the formula’s mathematical precision is worth the analytical overhead. The result is a procurement function that is simultaneously overengineered on the low end of the portfolio and underengineered on the high end, because buyer attention is dispersed evenly across 2,400 SKUs rather than concentrated on the 90 that actually drive the business.

Welded to 80/20 Squared — the recursive Pareto that identifies the top 4% of your portfolio generating 64% of the economic activity — EOQ stops being a universal procurement exercise and becomes a targeted optimization weapon. The top 4% of SKUs, the ones carrying the most inventory dollars and the most consumption velocity, deserve full EOQ rigor with quarterly recalculation, supplier negotiation, and integration with demand forecasting. The next 16% — the remainder of the top 20% — deserve simplified EOQ with annual review. The bottom 80% deserve visual kanban, consignment arrangements, or in some cases complete outsourcing to a vendor-managed inventory program, because the analytical cost of running EOQ on a part that consumes $800 annually exceeds any improvement the formula could produce.

The comfortable delusion is that precision is always valuable, and that a SKU-level EOQ calculation is a sign of operational discipline. It is not. Precision applied uniformly across a heterogeneous portfolio is a form of discipline that masks a targeting failure. The disciplined procurement organization does not run EOQ on 2,400 SKUs. It runs EOQ on 90 SKUs, runs lighter methods on the next 400, and runs visual or automated methods on the remaining 1,900. The procurement team’s time savings go into supplier development, category strategy, and total-cost-of-ownership work that actually produces economic value.

The Procurement Simplification That Doubled the Category Team’s Effective Capacity

Industrial distribution business, 2,400-SKU catalog, six-person procurement team running quarterly EOQ recalculations across the full portfolio. Each cycle consumed approximately 480 buyer-hours across the team — roughly two weeks of every quarter dedicated to running a formula, validating inputs, and publishing the output to the MRP system. The procurement team had been requesting headcount additions for three years to handle “category strategy work” that never got done because the EOQ cycle ate their bandwidth.

I ran the 80/20 Squared analysis on the SKU portfolio in Week 4. Ninety SKUs — the top 3.75% of the catalog — accounted for 64% of annual inventory dollars and 71% of inventory turnover velocity. An additional 400 SKUs — SKUs 91 through 490 — accounted for another 28% of inventory dollars. The remaining 1,910 SKUs, aggregate, accounted for 8% of inventory dollars and generated no material cost-of-goods impact from how they were replenished. Many of them were low-consumption parts where the annual demand was under 50 units and the unit cost was under $10. EOQ on those parts was producing recommendations with a margin of error larger than the potential optimization.

The restructure took six weeks. The top 90 SKUs were moved to quarterly EOQ with senior buyer attention, full demand forecasting integration, and supplier-level negotiation built around the optimized ordering cadence. The next 400 SKUs were moved to annual EOQ with a simplified input set and junior buyer ownership. The remaining 1,910 SKUs were migrated to a visual kanban system — two-bin replenishment for most, consignment inventory for the supplier-aligned tail, and vendor-managed inventory for three specific supplier categories where the supplier had better demand visibility than we did.

Results at 12 months: procurement team hours spent on replenishment cycles dropped 58%, from approximately 480 hours per quarter to 200 hours per quarter. The freed 280 hours per quarter were reallocated to category strategy, supplier consolidation, and total-cost-of-ownership analysis on the top 90 SKUs. That reallocated capacity produced roughly $3.2 million of annualized cost reduction in the first year through supplier renegotiation and SKU rationalization on the high-value portfolio. Inventory accuracy on the visual-kanban tail improved, counter to the expected objection, because the buyers were no longer relying on stale EOQ outputs and the bins produced real-time visual signals that the previous system had not provided. The headcount request that had been on the table for three years disappeared, because the existing team suddenly had double the effective capacity on the work that mattered.

Operational precision delivers economic value in direct proportion to the consumption velocity of the item being optimized. Applying identical analytical methods across a heterogeneous portfolio is a form of discipline that creates the appearance of rigor while producing net negative value on the long tail, because the analytical cost of precision on low-velocity items consistently exceeds the optimization benefit.

The Playbook

Move 1: The 4% SKU Audit

Run 80/20 Squared on the SKU portfolio. Rank every SKU by annual inventory dollars and annual consumption velocity, then identify the top 4% on each dimension. The overlap between the two rankings is your Vital Few — typically 60 to 120 SKUs in a portfolio of 2,000 to 3,000. These are the SKUs that deserve full EOQ rigor, quarterly recalculation, supplier-level negotiation, and senior buyer ownership. Everything else is a candidate for simplified replenishment.

Document the Vital Few in a single list with annual dollars, annual consumption, current ordering pattern, and current supplier concentration. That list becomes the core of the procurement category strategy and the primary target for supplier development work. The rest of the catalog is managed, not optimized.

Move 2: EOQ Where It Counts

For the Vital Few, run quarterly EOQ with full input precision: true ordering cost decomposition, actual holding cost with working capital weighting, demand forecasting integration, and lead time variance. Recalculate with every material change in demand pattern, supplier cost structure, or carrying cost assumption. The buyers assigned to this tier should be the most senior members of the procurement team, with direct relationships to the suppliers covering these SKUs, and with authority to negotiate order quantities and supplier terms based on the optimized cadence.

For the next tier — the 400 or so SKUs representing the 20% of the portfolio outside the Vital Few — run annual EOQ with simplified inputs. Use category-average ordering cost rather than SKU-specific. Use standard holding cost assumptions. Hand the tier to junior buyers with quarterly exception reporting rather than continuous management.

Move 3: Visual Kanban for the Tail

For the bottom 80% of SKUs, migrate to a visual or automated replenishment system that requires no analytical cycle. Two-bin kanban is the default — when bin one empties, the buyer places an order equal to one bin. No calculation required. No quarterly recalibration. The bin size is set once based on historical consumption and adjusted only when consumption pattern changes materially.

For SKUs where supplier visibility exceeds internal visibility — typically commodity fasteners, consumables, and maintenance supplies — consider vendor-managed inventory or consignment arrangements. The supplier owns the inventory until consumption, manages the replenishment cadence, and absorbs the forecast variance. Your procurement team’s cost structure on those SKUs drops to near zero, and the inventory accuracy typically improves because the supplier has better demand data than your internal forecasting systems do.

Move 4: The 90-Day Question

If you only ran EOQ on the top 4% of your SKUs, what would your procurement team do with the freed time? Ask your procurement director. The answer is the work that has been deferred for years because the replenishment cycle consumes the bandwidth: supplier consolidation, category strategy, total-cost-of-ownership analysis, contract renegotiation, supplier risk management. That deferred work is worth an order of magnitude more than the marginal EOQ precision on the bottom 80% of the catalog. The 90-day question reveals exactly which strategic priorities your procurement organization has been telling you it does not have capacity for.

Monday Morning

Pull the SKU-level inventory dollars and consumption velocity for your full catalog. Sort descending. Identify the top 4%. Count them. If that number is between 50 and 150, you are in the normal range for most portfolios. If it is smaller, your portfolio is more concentrated than most. If it is larger, your portfolio is more diffuse. Either way, that is the number of SKUs where EOQ precision is worth the analytical overhead. Everything else gets simplified. Start the migration this quarter, not next fiscal year.

For the 80/20 Squared SKU audit template and the replenishment-tier design worksheet, visit toddhagopian.com/freetools. The full procurement simplification framework is in The Stagnation Assassin at toddhagopian.com/book. Operator conversations on procurement discipline, category strategy, and the economics of replenishment-method tiering are at The Stagnation Assassin Show: toddhagopian.com/podcast.

Your buyers are running a 1913 formula on parts that consume a few hundred dollars a year. The freed time is worth more than the formula’s output. The question is whether you pull them off the low-tier calculations this quarter or keep paying for precision where precision does not produce value.