Demo Role
EProduction Demand vs Stock
How current inventory and pending POs match upcoming production demand.
AI Procurement Copilot Insight
Stockout Risk
Summary
Pending POs cover only 60% of the required casing demand.
Key Risk / Opportunity
There is a 40% shortage against the production demand for June.
Business Impact
Insufficient casing will cap Jumbo Hotdog production at 60% capacity.
Recommended Action
Create an additional PR or adjust the production schedule to prioritize top SKUs.
AI Demand Insight
Production plan for next week requires 12,000 kg of pork raw material, but available stock is only 8,500 kg. Procurement should create a PR for 3,500 kg plus safety stock.
Demand vs Stock — Material Coverage
| Product | Material | Production Date | Required | Available | Gap | Pending PO | Final Shortage | Coverage | Production Impact | Recommended Action |
|---|---|---|---|---|---|---|---|---|---|---|
| Jumbo Hotdog | Pork raw material | Sep 27, 2026 | 7,200 kg | 1,200 | 6,000 | 0 | 6,000 | 17% | Jumbo Hotdog batch may be delayed by 5 day(s) | Create PR |
| Cheese Hotdog | Pork raw material | Sep 28, 2026 | 4,000 kg | 1,200 | 2,800 | 0 | 2,800 | 30% | Cheese Hotdog batch may be delayed by 4 day(s) | Create PR |
| Cheese Hotdog | Cheese powder | Sep 28, 2026 | 320 kg | 260 | 60 | 500 | — | 100% | Covered by pending PO | Expedite PO |
| Hungarian Sausage | Pork raw material | Sep 29, 2026 | 4,200 kg | 1,200 | 3,000 | 0 | 3,000 | 29% | Hungarian Sausage batch may be delayed by 4 day(s) | Create PR |
| Chicken Nuggets | Chicken raw material | Sep 26, 2026 | 8,000 kg | 5,000 | 3,000 | 3,200 | — | 100% | Covered by pending PO | Expedite PO |
| Corned Beef | Beef trimmings | Sep 30, 2026 | 3,500 kg | 1,700 | 1,800 | 800 | 1,000 | 71% | Corned Beef batch may be delayed by 2 day(s) | Expedite PO |
| Meat Loaf | Pork raw material | Oct 1, 2026 | 1,600 kg | 1,200 | 400 | 0 | 400 | 75% | Meat Loaf batch may be delayed by 2 day(s) | Expedite PO |
| Frozen Tocino | Pork raw material | Sep 25, 2026 | 5,600 kg | 1,200 | 4,400 | 0 | 4,400 | 21% | Frozen Tocino batch may be delayed by 4 day(s) | Create PR |
| Longganisa | Pork raw material | Sep 29, 2026 | 3,000 kg | 1,200 | 1,800 | 0 | 1,800 | 40% | Longganisa batch may be delayed by 3 day(s) | Create PR |
| Jumbo Hotdog | Pork raw material | Sep 24, 2026 | 3,600 kg | 1,200 | 2,400 | 0 | 2,400 | 33% | Jumbo Hotdog batch may be delayed by 4 day(s) | Create PR |
| Corned Beef | Beef trimmings | Oct 3, 2026 | 4,200 kg | 1,700 | 2,500 | 800 | 1,700 | 60% | Corned Beef batch may be delayed by 3 day(s) | Create PR |