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