Coca-Cola

Material Risk Management Center

5040 - BALLINA
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 · Illustrative
Shelf LifeAge of StockShortageOthersIngredientIntermediateFinished Good
AlertMaterial / Plant / BatchChecksPersona signals
#1ALRT-26-A7F1CriticalFanta Orange Emulsion · Part B (FG)4401723 · 5040 BallinaBatch 0021091187MRSL breach at bottler delivery$416,00013 Oct6 dPull forward bottler orderCCI Istanbul · 21 Oct → 13 Oct68%
5/5
  • Material Planner · Approve mitigation6 d ageing · 2 esc.
  • Transportation Planner · Book transfer lane8 d ageing · 2 esc.
  • Quality · Shelf-life sign-off1 d ageing · 0 esc.
Needs reviewAction required3 persona inputs pending
#2ALRT-26-R1S3CriticalSprite Lemon-Lime Base Part A4401731 · 5040 BallinaBatch 0021090103Shelf-life exposure before planned consumption$182,40017 Oct10 dReallocate to other bottlerReallocate to other bottler84%
5/5
  • Production Planner · Confirm schedule slot3 d ageing · 1 esc.
  • CAS · Confirm bottler demand4 d ageing · 1 esc.
Needs reviewAction required
#3ALRT-26-X021MediumLemon Oil Concentrate · Blend4405020 · 5039 WaterfordBatch 21092020Shelf-life exposure before planned consumption$66,00019 Oct12 dShelf-life extensionRetained-sample QA validation88%
5/5
  • Production Planner · Confirm schedule slot3 d ageing · 1 esc.
  • CAS · Confirm bottler demand1 d ageing · 0 esc.
ReadyAll checks passed
#4ALRT-26-X026MediumVitamin C Premix · Blend4405025 · 5041 DroghedaBatch 21092025Shelf-life exposure before planned consumption$66,00019 Oct12 dReallocate to other bottlerReallocate to other bottler88%
5/5
  • Production Planner · Confirm schedule slot0 d ageing · 0 esc.
ReadyAll checks passed
#5ALRT-26-X031MediumPowerade Electrolyte Base · Blend4405030 · 5040 BallinaBatch 21092030Supply gap against confirmed demand$66,00019 Oct12 dStock transfer (ST0)STO → 5041 Drogheda88%
5/5
  • Transportation Planner · Book transfer lane6 d ageing · 2 esc.
  • Quality · Shelf-life sign-off5 d ageing · 1 esc.
  • Production Planner · Confirm schedule slot4 d ageing · 1 esc.
ReadyAll checks passed
#6ALRT-26-X022MediumPotassium Sorbate · Blend4405021 · 5040 BallinaBatch 21092021Shelf-life exposure before planned consumption$66,00026 Oct19 dProduction re-sequence (FEFO)Prioritize oldest eligible batch88%
5/5
  • Transportation Planner · Book transfer lane6 d ageing · 2 esc.
  • Quality · Shelf-life sign-off5 d ageing · 1 esc.
  • Production Planner · Confirm schedule slot4 d ageing · 1 esc.
ReadyAll checks passed
#7ALRT-26-X027MediumCoca-Cola Beverage Base · Blend4405026 · 5039 WaterfordBatch 21092026Supply gap against confirmed demand$66,00026 Oct19 dShelf-life extensionRetained-sample QA validation88%
5/5
  • Transportation Planner · Book transfer lane3 d ageing · 1 esc.
  • Quality · Shelf-life sign-off7 d ageing · 2 esc.
ReadyAll checks passed
#8ALRT-26-X032MediumMinute Maid Tropical Base · Blend4405031 · 5041 DroghedaBatch 21092031Material release requires validation$66,00026 Oct19 dReallocate to other bottlerReallocate to other bottler88%
5/5
  • CAS · Confirm bottler demand0 d ageing · 0 esc.
ReadyAll checks passed
#9ALRT-26-D8P6CriticalSodium Citrate1000806 · 5040 BallinaBatch 0021090806Shelf-life exposure before planned consumption$13,00015 Oct8 dProduction re-sequence (FEFO)Prioritize oldest eligible batch88%
5/5
  • Quality · Shelf-life sign-off0 d ageing · 0 esc.
  • Production Planner · Confirm schedule slot3 d ageing · 1 esc.
Needs reviewWaiting on others1 persona inputs pending
#10ALRT-26-X024MediumFanta Lemon Emulsion · Blend4405023 · 5039 WaterfordBatch 21092023Material release requires validation$66,00027 Oct20 dSubstitute material releaseSubstitute material release88%
5/5
  • Quality · Shelf-life sign-off3 d ageing · 1 esc.
  • Production Planner · Confirm schedule slot4 d ageing · 1 esc.
ReadyAll checks passed
#11ALRT-26-X030MediumFanta Pineapple Emulsion · Blend4405029 · 5039 WaterfordBatch 21092029Shelf-life exposure before planned consumption$66,00027 Oct20 dSubstitute material releaseSubstitute material release88%
5/5
  • Production Planner · Confirm schedule slot3 d ageing · 1 esc.
  • CAS · Confirm bottler demand1 d ageing · 0 esc.
ReadyAll checks passed
#12ALRT-26-K7X5MediumXanthan Gum FCC1000705 · 5040 BallinaBatch 0021090705Material release requires validation$22,00022 Oct15 dSubstitute material releaseSubstitute material release87%
5/5
  • Transportation Planner · Book transfer lane3 d ageing · 1 esc.
  • Quality · Shelf-life sign-off1 d ageing · 0 esc.
ReadyAll checks passed
#13ALRT-26-X036MediumNatural Vanilla Flavor · Blend4405035 · 5039 WaterfordBatch 21092035Material release requires validation$6,20019 Oct12 dShelf-life extensionRetained-sample QA validation72%
5/5
  • Transportation Planner · Book transfer lane3 d ageing · 1 esc.
  • Quality · Shelf-life sign-off7 d ageing · 2 esc.
Needs reviewAction required
#14ALRT-26-X041MediumGum Arabic Spray Dried · Concentrate4405040 · 5041 DroghedaBatch 21092040Shelf-life exposure before planned consumption$6,20019 Oct12 dShelf-life extensionRetained-sample QA validation72%
5/5
  • CAS · Confirm bottler demand0 d ageing · 0 esc.
  • Material Planner · Approve mitigation0 d ageing · 0 esc.
Needs reviewWaiting on others1 persona inputs pending
#15ALRT-26-X023MediumGum Arabic Spray Dried · Blend4405022 · 5041 DroghedaBatch 21092022Supply gap against confirmed demand$66,00002 Nov26 dExpedite / alternate supplierExpedite / alternate supplier88%
5/5
  • CAS · Confirm bottler demand0 d ageing · 0 esc.
ReadyAll checks passed
#16ALRT-26-X028MediumMango Pulp Concentrate · Blend4405027 · 5040 BallinaBatch 21092027Material release requires validation$66,00002 Nov26 dProduction re-sequence (FEFO)Prioritize oldest eligible batch88%
5/5
  • CAS · Confirm bottler demand6 d ageing · 2 esc.
  • Material Planner · Approve mitigation2 d ageing · 0 esc.
  • Transportation Planner · Book transfer lane7 d ageing · 2 esc.
ReadyAll checks passed
#17ALRT-26-X033MediumGrapefruit Oil · Blend4405032 · 5039 WaterfordBatch 21092032Shelf-life exposure before planned consumption$66,00002 Nov26 dShelf-life extensionRetained-sample QA validation88%
5/5
  • Quality · Shelf-life sign-off3 d ageing · 1 esc.
  • Production Planner · Confirm schedule slot4 d ageing · 1 esc.
ReadyAll checks passed
#18ALRT-26-E3R7MediumS8073 DI-POT H PH XF (0047 Americas)1000307 · 0047 AmericasBatch 0021090307Supply gap against confirmed demand$68,00003 Nov27 dExpedite / alternate supplierExpedite / alternate supplier76%
5/5
  • CAS · Confirm bottler demand6 d ageing · 2 esc.
  • Material Planner · Approve mitigation8 d ageing · 2 esc.
  • Transportation Planner · Book transfer lane1 d ageing · 0 esc.
Needs reviewAction required
#19ALRT-26-B2K9CriticalAspartame Granular1000209 · 5040 BallinaBatch 0021090209Shelf-life exposure before planned consumption$31,50028 Oct21 dShelf-life extensionRetained-sample QA validation74%
5/5
  • Quality · Shelf-life sign-off6 d ageing · 2 esc.
  • Production Planner · Confirm schedule slot8 d ageing · 2 esc.
  • CAS · Confirm bottler demand1 d ageing · 0 esc.
Needs reviewAction required
#20ALRT-26-X037MediumCitric Acid Monohydrate · Concentrate4405036 · 5040 BallinaBatch 21092036Shelf-life exposure before planned consumption$6,20026 Oct19 dShelf-life extensionRetained-sample QA validation72%
4/5
  • CAS · Confirm bottler demand6 d ageing · 2 esc.
  • Material Planner · Approve mitigation2 d ageing · 0 esc.
  • Transportation Planner · Book transfer lane7 d ageing · 2 esc.
Needs reviewAttention required
#21ALRT-26-X042MediumFanta Lemon Emulsion · Concentrate4405041 · 5039 WaterfordBatch 21092041Shelf-life exposure before planned consumption$6,20026 Oct19 dShelf-life extensionRetained-sample QA validation72%
5/5
  • Quality · Shelf-life sign-off3 d ageing · 1 esc.
  • Production Planner · Confirm schedule slot4 d ageing · 1 esc.
Needs reviewAction required
#22ALRT-26-X019MediumCitric Acid Monohydrate · Blend4405018 · 5040 BallinaBatch 21092018Supply gap against confirmed demand$66,00009 Nov33 dStock transfer (ST0)STO → 5041 Drogheda88%
5/5
  • CAS · Confirm bottler demand6 d ageing · 2 esc.
  • Material Planner · Approve mitigation2 d ageing · 0 esc.
  • Transportation Planner · Book transfer lane7 d ageing · 2 esc.
ReadyAll checks passed
#23ALRT-26-X029MediumApple Juice Concentrate · Blend4405028 · 5041 DroghedaBatch 21092028Shelf-life exposure before planned consumption$66,00009 Nov33 dExpedite / alternate supplierExpedite / alternate supplier88%
5/5
  • Quality · Shelf-life sign-off0 d ageing · 0 esc.
ReadyAll checks passed
#24ALRT-26-X034MediumCaramel Color E150d · Blend4405033 · 5040 BallinaBatch 21092033Shelf-life exposure before planned consumption$66,00009 Nov33 dProduction re-sequence (FEFO)Prioritize oldest eligible batch88%
5/5
  • Material Planner · Approve mitigation6 d ageing · 2 esc.
  • Transportation Planner · Book transfer lane8 d ageing · 2 esc.
  • Quality · Shelf-life sign-off1 d ageing · 0 esc.
ReadyAll checks passed
#25ALRT-26-X043MediumSprite Flavor Base · Concentrate4405042 · 5040 BallinaBatch 21092042Supply gap against confirmed demand$6,50002 Nov26 dShelf-life extensionRetained-sample QA validation72%
4/5
  • Material Planner · Approve mitigation6 d ageing · 2 esc.
  • Transportation Planner · Book transfer lane8 d ageing · 2 esc.
  • Quality · Shelf-life sign-off1 d ageing · 0 esc.
Needs reviewAttention required
1–25 of 64 alertsPage 1 of 3