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 | May 19, 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 | May 20, 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 | May 20, 2026 | 320 kg | 260 | 60 | 0 | 60 | 81% | Cheese Hotdog batch may be delayed by 1 day(s) | Expedite PO |
| Hungarian Sausage | Pork raw material | May 21, 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 | May 18, 2026 | 8,000 kg | 5,000 | 3,000 | 3,200 | — | 100% | Covered by pending PO | Expedite PO |
| Corned Beef | Beef trimmings | May 22, 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 | May 23, 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 | May 17, 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 | May 21, 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 | May 16, 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 | May 25, 2026 | 4,200 kg | 1,700 | 2,500 | 800 | 1,700 | 60% | Corned Beef batch may be delayed by 3 day(s) | Create PR |