Expiry & Waste Prevention Center

4
AO

Inventory at Risk

€1.3M

across 6 categories

Expiring · 7 days

412

flagged critical

Expiring · 30 days

1,148

requires planning

Expiring · 60 days

2,360

monitor & forecast

Est. Recoverable

12%

€968.4K

via action queue

Waste Reduction

4%

31.4%

vs no intervention

Financial exposure

At Risk by Category

Financial exposure

At Risk by Supplier

Glanbia Ireland€264K
Kerry Foods€198K
Dawn Farms€162K
Ballygowan Springs€124K
Largo Foods€96K

Financial exposure

At Risk by Warehouse Zone

Zone A — Chilled€498K
Zone B — Frozen€188K
Zone C — Produce€312K
Zone D — Ambient€156.6K
Zone E — Beverages€130K

Category × expiry band · €K exposure

Financial Exposure Heatmap

0-7d
8-14d
15-30d
31-60d
61-90d
Chilled & Dairy
€186K
€142K
€98K
€42K
€18K
Fresh Produce
€124K
€96K
€54K
€26K
€12K
Frozen
€22K
€34K
€58K
€48K
€26K
Beverages
€38K
€44K
€32K
€18K
€10K
Ambient Grocery
€8K
€14K
€28K
€32K
€16K

Critical & approaching items requiring intervention

Priority Action Queue

ProductQtyValueExpiryPriorityRecommended Action

Avonmore Fresh Milk 2L

DAI-14761 · Chilled & Dairy

3,840€7,6802 daysCriticalMarkdown 35% + dispatch

Irish Rooster Potatoes 10kg

PRD-30218 · Fresh Produce

1,260€9,4503 daysCriticalTransfer to high-demand stores

Kerrygold Butter 454g

DAI-14872 · Chilled & Dairy

980€3,7734 daysCriticalBundle promotion

Innocent Smoothie 750ml

BEV-22410 · Beverages

2,140€5,3506 daysApproachingMarkdown 20%

Denny Cooked Ham 2kg

CHL-18820 · Chilled & Dairy

640€4,4807 daysApproachingPrioritise dispatch

Mixed Salad Leaves 1kg

PRD-30455 · Fresh Produce

1,820€4,5505 daysOverstockSupplier return

Birds Eye Garden Peas 900g

FRZ-44120 · Frozen

4,200€8,8209 daysOverstockRedistribute to wholesale

Prioritised to recover the most value

AI Recommendations

Markdown 5 dairy lines by 25-35%

Avonmore Milk, Kerrygold Butter and 3 yoghurt SKUs are tracking 2-4 days to expiry. A staged markdown clears ~92% of units before spoilage.

Pricing+€18,400

Bundle smoothies with breakfast range

Pair 2,140 Innocent smoothies with Flahavan's oats as a 'Breakfast Saver' multibuy across 40 SuperValu stores.

Promotion+€4,100

Transfer produce to Cork & Limerick

Rooster potatoes and salad leaves have 3-5x faster turnover in metro stores. Reroute on tomorrow's RT-01 and RT-03.

Redistribution+€12,600

Prioritise dispatch of 640 ham units

Denny cooked ham can ship today to 12 stores with open chilled orders, avoiding a 7-day write-off.

Dispatch+€4,480

Initiate supplier return — Largo Foods

1,820 salad units qualify for return under the agreed 8-day clause. Submit RMA before the 16:00 cutoff.

Supplier Return+€4,550

Full traceability for at-risk batches

Lot & Batch Tracking

Batch No.Supplier BatchProductReceivedExpiryQty RemainingLocationCustomers Supplied
BCH-2026-0418GLN-44210

Avonmore Fresh Milk 2L

DAI-14761

08 Jun17 Jun3,840A-04-12SuperValu Douglas, Centra Killarney
BCH-2026-0392KRY-18802

Kerrygold Butter 454g

DAI-14872

05 Jun19 Jun980A-02-08Centra Tralee, SuperValu Ennis
BCH-2026-0455DWN-90341

Irish Rooster Potatoes 10kg

PRD-30218

11 Jun18 Jun1,260C-01-03SuperValu Limerick, Centra Mallow
BCH-2026-0407LRG-55120

Mixed Salad Leaves 1kg

PRD-30455

10 Jun20 Jun1,820C-03-07SuperValu Douglas
BCH-2026-0361BGW-22019

Innocent Smoothie 750ml

BEV-22410

04 Jun21 Jun2,140E-02-05Centra Killarney, SuperValu Ennis
BCH-2026-0288DNY-77410

Denny Cooked Ham 2kg

CHL-18820

06 Jun22 Jun640A-05-02SuperValu Limerick

Predicted expiry value · 90 days · with vs without AI intervention

Expiry Forecasting

Recovery & savings to date

Financial Impact

€142,800

Waste avoided this month

€64,200

Recovered via redistribution

€38,600

Recovered via promotions

€1.6M

Estimated annual savings