Demo Role
EDemand Planning
Forecast → required production → BOM → stock check → procurement gap.
AI Procurement Copilot Insight
Stockout Risk
Summary
Forecasted Jumbo Hotdog demand requires additional casing and pork raw material.
Key Risk / Opportunity
Current inventory and pending POs are not enough to cover the full requirement.
Business Impact
Demand gap puts ₱847K of potential revenue at risk.
Recommended Action
Convert forecast gap into Purchase Requests immediately.
End-to-End Flow
Sales Forecast
Demand Planning
Production Requirement
BOM Calculation
WMS Stock Check
Procurement Gap
PR Creation
Supplier Sourcing
Demand Plan (9)
| Product | Forecast Sales | Req. Batches | Top Raw Material | Top Packaging | Current Stock | Pending PO | Procurement Gap | Recommended PR | Confidence | |
|---|---|---|---|---|---|---|---|---|---|---|
| Jumbo Hotdog | 13,800 | 14 | Pork raw material· 8,400 kg | Plastic packaging roll· 56 roll | 34,215 | 6,810 | 7,200 | 8,280 | High | |
| Cheese Hotdog | 10,260 | 11 | Pork raw material· 5,500 kg | Plastic packaging roll· 44 roll | 33,635 | 7,030 | 4,300 | 4,945 | High | |
| Hungarian Sausage | 7,125 | 8 | Pork raw material· 5,600 kg | Plastic packaging roll· 40 roll | 28,945 | 3,425 | 4,400 | 5,060 | Medium | |
| Chicken Nuggets | 13,420 | 14 | Chicken raw material· 11,200 kg | Plastic packaging roll· 84 roll | 33,005 | 3,745 | 3,220 | 3,703 | High | |
| Corned Beef | 8,670 | 9 | Beef trimmings· 6,300 kg | Carton box· 450 pc | 34,740 | 9,180 | 3,800 | 4,370 | Medium | |
| Meat Loaf | 4,800 | 5 | Pork raw material· 2,000 kg | Carton box· 250 pc | 39,000 | 11,500 | 800 | 920 | Low | |
| Frozen Tocino | 6,440 | 7 | Pork raw material· 5,600 kg | Plastic packaging roll· 35 roll | 28,305 | 545 | 4,400 | 5,060 | Medium | |
| Longganisa | 7,644 | 8 | Pork raw material· 4,800 kg | Plastic packaging roll· 32 roll | 28,705 | 3,345 | 3,600 | 4,140 | High | |
| Holiday Ham | 2,025 | 3 | Pork raw material· 2,700 kg | Plastic packaging roll· 18 roll | 28,545 | 625 | 1,500 | 1,725 | High |
AI Demand Planning Insight
Holiday Ham and Jumbo Hotdog generate the largest procurement gaps this month. Suggest creating consolidated PRs for pork raw material and packaging roll covering both products to reduce supplier handling cost.