Company Type
Columbia Pipe, a commercial pipe distributor (250K active SKUs, 18 DCs); companion to SE-01 inside the JDE rescue — the Factory Physics SIOP framework that made the platform work.
What Drove the Need
No demand planning or supply chain capability existed for 250K active SKUs across 18 DCs after the prior firm's customized launch
Planners needed a daily business pulse, not spreadsheets
Business Impact
~99% of manual planning and purchasing execution eliminated (Case 21)
Systems/Data Integration
Updates JDE forecasting, DRP, and MRP planning parameters; drives exception reports for the daily business pulse
Design
Factory Physics-based algorithms for cumulative demand distribution, standard deviation and mean, safety stock, and inter-DC transfer policies
Forecast-method assignment by demand-curve class per planning family, instrumented with MAPE and tracking signal, with append-only actuals
Technology Stack
Oracle PL/SQL against the JDE EnterpriseOne Oracle schema
JDE Demand Forecasting, Multi-Facility DRP, MRP
SIOP Algorithm Suite — Demand, Lead-Time & Safety Stock
Total demand and supply lead-time calculation, inventory safety-stock calculation, inter-DC transfer policies, and forecast spreading — automated analysis, reports, and system updates on hourly, daily, weekly, and monthly cycles.
