Stonemill School of Business

Operational Context & Perishable Inventory Bottleneck

A wholesale specialty food distributor serving 80 restaurants across Mecklenburg and surrounding counties maintained a 12,000-square-foot refrigerated and frozen warehouse. The firm was experiencing severe quarterly inventory write-downs averaging $38,000 per quarter due to expired cheeses, cured meats, and specialized dairy items.

The company's purchasing agent routinely ordered full pallet loads (40โ€“60 cases) to capture vendor volume discounts of 6% to 8%. However, the purchasing calculation completely ignored refrigerated warehouse carrying costsโ€”running at $4.80 per cubic foot per monthโ€”as well as the rigid 45-day manufacturer shelf-life window.

Baseline Operational Metrics

  • Refrigerated Facility Size: 12,000 sq ft (Sub-leased at $4.80/cu ft)
  • Quarterly Spoilage Write-Down: $38,240.00 / Qtr
  • Average Inventory Days: 64 Days (Exceeds 45-day shelf life)
  • Annual Carrying Cost Rate: 32% (Energy, refrigerant, insurance, spoilage)
  • Working Capital Tied in Stock: $240,000.00 Average

The Diagnostic Model: True Cold-Chain EOQ vs. Bulk Purchasing

Student investigator Devonte Washington extracted 12 months of SKU velocity logs across 18 core perishable product lines. By applying the standard Economic Order Quantity formula modified for temperature-controlled storage:

EOQ = โˆš ( (2 * Annual Demand * Order Setup Cost) / (Annual Unit Carrying Cost + Spoilage Risk Factor) )

The findings revealed that the 7% bulk supplier discount saved only $420 per order, while the additional 6 weeks of refrigerated holding cost and 18% spoilage risk cost the distributor $1,840 per palletโ€”a net loss of $1,420 per bulk purchase cycle.

Operational Interventions Implemented

  • Renegotiated Bi-Weekly Standing Orders: Transitioned key dairy and charcuterie vendors to smaller, bi-weekly split deliveries, trading 2% in unit price for 65% faster stock turns.
  • ABC Inventory Stratification: Segmented the 18 core SKUs into Fast-Moving Class A (order every 10 days), Medium Class B (order every 20 days), and Specialty Class C (made-to-order).
  • Automated FIFO Expiry Triggers: Configured warehouse ERP software to flag cases reaching 14 days prior to expiration, automatically discounting them to regional prep kitchens.

Quantified Operational Impact

  • Quarterly Spoilage: $6,800.00 (-82.2%)
  • Average Days in Storage: 22 Days (Well below 45-day cap)
  • Working Capital Released: $98,000.00 Liquidated
  • Stockout Incidents: Under 1.5% across all 80 accounts

Case Study Source Files & Datasets

Download the authentic case documentation and inventory SKU order ledger dataset.

Download Inventory SKU Records (.CSV) Download EOQ Analysis Brief (.TXT)

Educational Boundary Notice: Operations management instructional model. Operational metrics and supplier contract terms are simulated educational datasets.