Commercial Pipe Distributor — 250,000 Active SKUs, 18 Distribution Centers
Client Challenge
Midway through the second attempt at a JDE EnterpriseOne implementation — third consulting firm engaged
The prior firm buried JDE under thousands of customizations replicating legacy systems and launched with minimal training; the system was ineffective from day one
No demand planning or supply chain capability for 250K active SKUs across 18 DCs
Client Solution
Alignment: Whiteboard sessions re-aligned the implementation team and won sponsor approval for the recovery approach
Master Data: Designed a new taxonomy for generic item masters with a smart naming scheme covering customer-specific and non-stock items
Reimplementation: Demand Forecasting, Multi-Facility DRP, MRP, Receipts Routing, Advanced Pricing for Purchasing, and Lot-Controlled Inventory
SIOP Architecture: Factory Physics-based PL/SQL algorithms — demand distribution, safety stock, ABC ranking, forecast spreading, inter-DC transfer policies — running hourly through monthly cycles
Enablement: Educated the procurement team on the complete SIOP operation
Client Impact Results
Automation: Converted manual, error-prone procurement planning and purchasing to automated, exception-based management
Visibility: Management analysis and exception reporting delivering the daily business pulse
Scalability: Customer-specific and non-stock items managed without administrative burden
Client Technologies
JDE EnterpriseOne (Forecasting, Multi-Facility DRP, MRP, Advanced Pricing, Receipts Routing, Lot Control, Advanced Warehousing)
Oracle PL/SQL algorithm development
Factory Physics
SIOP/S&OP framework
DSI barcoding
APICS best practices
