CPS plants and DCs
Welcome, Alejandro
Material Planner for Ballina Plant
36active alerts · 64 registered
24 executed · 4 monitoring · As of 07 Oct 2026 · Illustrative
High
5
Value at risk
$661,900
Action window
0–7 d$416.0K
8–14 d$195.4K
15–30 d$31.5K
31+ d$19.0K
Medium
31
Value at risk
$1,399,600
Action window
0–7 d$0.0K
8–14 d$210.4K
15–30 d$643.1K
31+ d$546.1K
Low
0
Value at risk
$0
Action window
0–7 d$0.0K
8–14 d$0.0K
15–30 d$0.0K
31+ d$0.0K
MRA Value Realization Counter
WRITE-OFF AVOIDED
$974.6K
REVENUE LOSS AVOIDED
$1.14M
AI Alerts
ExceptionAge of StockShelf LifeShortage
MaterialIngredientIntermediateFinished GoodFinished Goods
Risk Register
64 of 64 alertsAs of 07 Oct 2026 · IllustrativeShelf LifeAge of StockShortageOthersIngredientIntermediateFinished Good
| Alert | Material / Plant / Batch | Checks | Persona signals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| #1 | ALRT-26-A7F1Critical | Fanta Orange Emulsion · Part B (FG)4401723 · 5040 BallinaBatch 0021091187 | MRSL breach at bottler delivery | $416,000 | 13 Oct6 d | Pull forward bottler orderCCI Istanbul · 21 Oct → 13 Oct | 68% | 5/5 |
| Needs review | Action required3 persona inputs pending | |
| #2 | ALRT-26-R1S3Critical | Sprite Lemon-Lime Base Part A4401731 · 5040 BallinaBatch 0021090103 | Shelf-life exposure before planned consumption | $182,400 | 17 Oct10 d | Reallocate to other bottlerReallocate to other bottler | 84% | 5/5 |
| Needs review | Action required | |
| #3 | ALRT-26-X021Medium | Lemon Oil Concentrate · Blend4405020 · 5039 WaterfordBatch 21092020 | Shelf-life exposure before planned consumption | $66,000 | 19 Oct12 d | Shelf-life extensionRetained-sample QA validation | 88% | 5/5 |
| Ready | All checks passed | |
| #4 | ALRT-26-X026Medium | Vitamin C Premix · Blend4405025 · 5041 DroghedaBatch 21092025 | Shelf-life exposure before planned consumption | $66,000 | 19 Oct12 d | Reallocate to other bottlerReallocate to other bottler | 88% | 5/5 |
| Ready | All checks passed | |
| #5 | ALRT-26-X031Medium | Powerade Electrolyte Base · Blend4405030 · 5040 BallinaBatch 21092030 | Supply gap against confirmed demand | $66,000 | 19 Oct12 d | Stock transfer (ST0)STO → 5041 Drogheda | 88% | 5/5 |
| Ready | All checks passed | |
| #6 | ALRT-26-X022Medium | Potassium Sorbate · Blend4405021 · 5040 BallinaBatch 21092021 | Shelf-life exposure before planned consumption | $66,000 | 26 Oct19 d | Production re-sequence (FEFO)Prioritize oldest eligible batch | 88% | 5/5 |
| Ready | All checks passed | |
| #7 | ALRT-26-X027Medium | Coca-Cola Beverage Base · Blend4405026 · 5039 WaterfordBatch 21092026 | Supply gap against confirmed demand | $66,000 | 26 Oct19 d | Shelf-life extensionRetained-sample QA validation | 88% | 5/5 |
| Ready | All checks passed | |
| #8 | ALRT-26-X032Medium | Minute Maid Tropical Base · Blend4405031 · 5041 DroghedaBatch 21092031 | Material release requires validation | $66,000 | 26 Oct19 d | Reallocate to other bottlerReallocate to other bottler | 88% | 5/5 |
| Ready | All checks passed | |
| #9 | ALRT-26-D8P6Critical | Sodium Citrate1000806 · 5040 BallinaBatch 0021090806 | Shelf-life exposure before planned consumption | $13,000 | 15 Oct8 d | Production re-sequence (FEFO)Prioritize oldest eligible batch | 88% | 5/5 |
| Needs review | Waiting on others1 persona inputs pending | |
| #10 | ALRT-26-X024Medium | Fanta Lemon Emulsion · Blend4405023 · 5039 WaterfordBatch 21092023 | Material release requires validation | $66,000 | 27 Oct20 d | Substitute material releaseSubstitute material release | 88% | 5/5 |
| Ready | All checks passed | |
| #11 | ALRT-26-X030Medium | Fanta Pineapple Emulsion · Blend4405029 · 5039 WaterfordBatch 21092029 | Shelf-life exposure before planned consumption | $66,000 | 27 Oct20 d | Substitute material releaseSubstitute material release | 88% | 5/5 |
| Ready | All checks passed | |
| #12 | ALRT-26-K7X5Medium | Xanthan Gum FCC1000705 · 5040 BallinaBatch 0021090705 | Material release requires validation | $22,000 | 22 Oct15 d | Substitute material releaseSubstitute material release | 87% | 5/5 |
| Ready | All checks passed | |
| #13 | ALRT-26-X036Medium | Natural Vanilla Flavor · Blend4405035 · 5039 WaterfordBatch 21092035 | Material release requires validation | $6,200 | 19 Oct12 d | Shelf-life extensionRetained-sample QA validation | 72% | 5/5 |
| Needs review | Action required | |
| #14 | ALRT-26-X041Medium | Gum Arabic Spray Dried · Concentrate4405040 · 5041 DroghedaBatch 21092040 | Shelf-life exposure before planned consumption | $6,200 | 19 Oct12 d | Shelf-life extensionRetained-sample QA validation | 72% | 5/5 |
| Needs review | Waiting on others1 persona inputs pending | |
| #15 | ALRT-26-X023Medium | Gum Arabic Spray Dried · Blend4405022 · 5041 DroghedaBatch 21092022 | Supply gap against confirmed demand | $66,000 | 02 Nov26 d | Expedite / alternate supplierExpedite / alternate supplier | 88% | 5/5 |
| Ready | All checks passed | |
| #16 | ALRT-26-X028Medium | Mango Pulp Concentrate · Blend4405027 · 5040 BallinaBatch 21092027 | Material release requires validation | $66,000 | 02 Nov26 d | Production re-sequence (FEFO)Prioritize oldest eligible batch | 88% | 5/5 |
| Ready | All checks passed | |
| #17 | ALRT-26-X033Medium | Grapefruit Oil · Blend4405032 · 5039 WaterfordBatch 21092032 | Shelf-life exposure before planned consumption | $66,000 | 02 Nov26 d | Shelf-life extensionRetained-sample QA validation | 88% | 5/5 |
| Ready | All checks passed | |
| #18 | ALRT-26-E3R7Medium | S8073 DI-POT H PH XF (0047 Americas)1000307 · 0047 AmericasBatch 0021090307 | Supply gap against confirmed demand | $68,000 | 03 Nov27 d | Expedite / alternate supplierExpedite / alternate supplier | 76% | 5/5 |
| Needs review | Action required | |
| #19 | ALRT-26-B2K9Critical | Aspartame Granular1000209 · 5040 BallinaBatch 0021090209 | Shelf-life exposure before planned consumption | $31,500 | 28 Oct21 d | Shelf-life extensionRetained-sample QA validation | 74% | 5/5 |
| Needs review | Action required | |
| #20 | ALRT-26-X037Medium | Citric Acid Monohydrate · Concentrate4405036 · 5040 BallinaBatch 21092036 | Shelf-life exposure before planned consumption | $6,200 | 26 Oct19 d | Shelf-life extensionRetained-sample QA validation | 72% | 4/5 |
| Needs review | Attention required | |
| #21 | ALRT-26-X042Medium | Fanta Lemon Emulsion · Concentrate4405041 · 5039 WaterfordBatch 21092041 | Shelf-life exposure before planned consumption | $6,200 | 26 Oct19 d | Shelf-life extensionRetained-sample QA validation | 72% | 5/5 |
| Needs review | Action required | |
| #22 | ALRT-26-X019Medium | Citric Acid Monohydrate · Blend4405018 · 5040 BallinaBatch 21092018 | Supply gap against confirmed demand | $66,000 | 09 Nov33 d | Stock transfer (ST0)STO → 5041 Drogheda | 88% | 5/5 |
| Ready | All checks passed | |
| #23 | ALRT-26-X029Medium | Apple Juice Concentrate · Blend4405028 · 5041 DroghedaBatch 21092028 | Shelf-life exposure before planned consumption | $66,000 | 09 Nov33 d | Expedite / alternate supplierExpedite / alternate supplier | 88% | 5/5 |
| Ready | All checks passed | |
| #24 | ALRT-26-X034Medium | Caramel Color E150d · Blend4405033 · 5040 BallinaBatch 21092033 | Shelf-life exposure before planned consumption | $66,000 | 09 Nov33 d | Production re-sequence (FEFO)Prioritize oldest eligible batch | 88% | 5/5 |
| Ready | All checks passed | |
| #25 | ALRT-26-X043Medium | Sprite Flavor Base · Concentrate4405042 · 5040 BallinaBatch 21092042 | Supply gap against confirmed demand | $6,500 | 02 Nov26 d | Shelf-life extensionRetained-sample QA validation | 72% | 4/5 |
| Needs review | Attention required |
1–25 of 64 alertsPage 1 of 3
