Planners were manually reviewing 847 SKUs weekly, spending 35 hours per planner on routine order decisions. Stockouts ran at 79 per quarter and excess stock tied up €1.2M in working capital due to inconsistent safety-stock policies.
Built a Python-based AI engine combining XGBoost demand forecasts, dynamic ROP calculation, and a confidence scoring model. Orders above 85% confidence auto-approve; below that threshold, planners receive ranked recommendations with AI reasoning to review in minutes.
The system auto-approves 680 of 847 SKU replenishments weekly, cutting planner review time by 62%. Stockouts fell 71%, working capital released €284K, and service level climbed from 94.1% to 98.2% — validating the confidence-gate threshold.
Adjust parameters to see real-time AI policy recalculation. Formulas: ROP = (AvgDemand × LeadTime) + SafetyStock · EOQ = √(2DS/H) · SS = Z × σ × √LT
| SKU ID | SKU Name | Category | Supplier | Curr Stock | ROP | AI Rec Qty | Confidence | Days of Stock | Stockout Risk | AI Status |
|---|