
The cleanest KPI is days of inventory on hand (DOH) benchmarked against operational thresholds (3, 6, 9, and 12 months) and weighted by tied-up working capital. Focus on two specific segments: first, SKUs showing excessive coverage at one location while running critical stockout risk elsewhere (prime candidates for lateral rebalancing); second, orphaned DC inventory (items stored centrally but inactive across all store assortments). Cross-referencing warehouse inventory against active store listings previously required Ravate to manually manipulate 5,800-line spreadsheets.