Expiry Control
Pharmacy and grocery expiry exposure with discount-to-clear suggestions.
Total exposure
₦680k
High risk
3 SKUs
Pharmacy
₦420k
Grocery
₦260k
Expiry calendar
Next 90 days High Medium Low
Exposure trend
JulAugSepOctNov
Values in ₦k
Pharmacy risk (Apo)
Paracetamol 500mghigh
240 units · expires 2026-07-18
Amoxicillin 250mghigh
180 units · expires 2026-07-30
Grocery risk
Peak Milk Powdermed
Wuse 2 · 60 units · 2026-08-12
Bigi Cola 60cllow
Gwarinpa · 320 units · 2026-09-04
Yoghurt 500mlhigh
Wuse 2 · 44 units · 2026-07-10
Discount-to-clear
- -25%Yoghurt 500ml72 units
- -15%Paracetamol 500mg (batch A)180 units
- -20%Amoxicillin 250mg (batch C)120 units
- -10%Peak Milk (near date)60 units
Expiring < 30d
142 units
Expiring < 90d
864 units
Value at risk
₦6.8M
Written off MTD
₦1.42M-18%
FEFO compliance
91.2%+2.4pp
Batches tracked
1,286
Operational workspace — what is happening
Expiry risk board
LiveExpired — quarantine
18 units
0–30 days
142
31–60 days
386
61–90 days
336
Markdown active
42 SKUs
Supplier returns
6 pending
Near-expiry batch register
| Batch | Product | Branch | Units | Expiry | Action |
|---|---|---|---|---|---|
| AMX-114 | Amoxicillin 500mg | Apo | 48 | 21 Aug | Return to supplier |
| PMK-882 | Peak Milk 400g | Wuse 2 | 126 | 04 Sep | Markdown 15% |
| YOG-201 | Hollandia Yoghurt 1L | Gwarinpa | 62 | 12 Aug | Markdown 30% |
| BRD-556 | Fresh Bread 600g | Wuse 2 | 38 | 31 Jul | Same-day clearance |
| PCM-338 | Paracetamol 500mg | Apo | 94 | 18 Sep | Rotate to Wuse 2 |
| CHZ-119 | Cheese Block 500g | Gwarinpa | 22 | 09 Aug | Markdown 25% |
Expiry control log
Live feed- Markdown applied18:24Hollandia Yoghurt · 30%
- Batch quarantined17:3618 units expired at Gwarinpa
- Supplier return raised16:12Emzor · AMX-114
- FEFO violation14:50Newer batch picked at Wuse 2
- Write-off approved12:05₦86k fresh bakery
Expiry action queue
6 in queueClear 18 expired units
Quarantine disposal
Apply markdowns to 12 batches
₦1.9M retail
Raise 6 supplier returns
₦840k recoverable
Rotate Apo pharma to Wuse 2
94 units
Retrain on FEFO picking
Wuse 2 team
Review shelf-life on 24 SKUs
Buying
Analytics workspace — why is it happening
Write-off value vs FEFO compliance
6 monthsFebMarAprMayJunJul
Value at risk by category
Fresh34%
Pharmacy28%
Dairy22%
Beverages10%
Other6%
Units by expiry window
<7d7–3031–6061–9091–180
Value at risk by branch (₦00k)
Ranked#1
Apo Pharmacy
28
#2
Gwarinpa
24
#3
Wuse 2
16
Expiry pressure — branch × window
Heat map| <7d | 7–30 | 31–60 | 61–90 | 91+ | Total | |
|---|---|---|---|---|---|---|
| Wuse 2 | 8 | 32 | 104 | 88 | 142 | 62 |
| Gwarinpa | 14 | 44 | 148 | 126 | 186 | 78 |
| Apo | 16 | 28 | 134 | 122 | 184 | 74 |
Shelf-life control maturity
Multi-factorWrite-off and recovery summary
Comparative| Category | At risk | Marked down | Returned | Written off | Recovery % |
|---|---|---|---|---|---|
| Fresh & bakery | ₦2.3M | ₦1.4M | ₦0 | ₦0.62M | 61% |
| Pharmacy | ₦1.9M | ₦0.2M | ₦0.84M | ₦0.31M | 84% |
| Dairy | ₦1.5M | ₦0.9M | ₦0.1M | ₦0.34M | 77% |
| Beverages | ₦0.7M | ₦0.3M | ₦0.2M | ₦0.15M | 79% |
Management workspace — exceptions & approvals
Exception centre
3 open18 units already expiredBranch Manager
Stock remained on shelf past expiry at Gwarinpa.
FEFO violation at Wuse 2Floor Supervisor
Newer batch picked ahead of older stock for the second time this week.
Fresh recovery rate lowest at 61%Category Lead
Markdowns are applied too late in the shelf-life curve.
Pending approvals
Awaiting sign-off- ReviewMarkdown ladder for 12 batches₦1.9M retail
- ReviewSupplier return claims₦840k
- ReviewWrite-off of expired units₦142k
Manager action queue
Assigned| Action | Owner | Due | Priority |
|---|---|---|---|
| Dispose of quarantined expired stock | Branch Manager | Today | High |
| Apply the automated markdown ladder | Pricing | Today | Medium |
| Raise all six supplier return claims | Procurement | Tomorrow | Medium |
| Re-run FEFO training at Wuse 2 | Ops Trainer | This week | Medium |
| Review order quantities on fresh lines | Category Lead | Next week | Low |
Escalations
Routed upwardExpired stock reaching the shelfEscalated
Compliance exposure in pharmacy and food categories.
Executive intelligence — what to do next
Executive summary
Auto-generated · demoWrite-offs have fallen 43% over six months as FEFO discipline improved, but ₦6.8M of value still sits inside a 90-day expiry window and fresh categories recover only 61% of at-risk value. The remaining loss is a timing problem: markdowns start too late to clear stock at a sensible price.
Health score
Stable
Opportunity score
Strong
Risk score
Watch
Confidence
Strong
Key insights
- Pharmacy achieves the best recovery because supplier returns are contractually available.
- Fresh carries the largest absolute exposure and the weakest recovery mechanism.
- Two FEFO violations in one week at the same branch indicate a training gap, not a system gap.
Business risks
Compliance exposure
Expired pharmacy or food stock on shelf is a regulatory matter.
Late markdown cost
Discount depth rises sharply inside the final 14 days.
Growth opportunities
Automated markdown ladder
Triggering at 45 days lifts recovery an estimated 12pp.
Extend supplier return terms
Negotiating dairy returns mirrors the pharmacy model.
Performance highlights
Value at risk
₦6.8M
FEFO
91.2%
Write-offs MTD
₦1.42M
Recovery
74%
AI recommendations
Confidence weightedAutomate the markdown ladder at 45/30/14 days
Removes reliance on manual branch judgement.
90%
Negotiate dairy supplier returns
Replicates the pharmacy recovery model on the next largest exposure.
77%
Enforce FEFO scanning at pick
Blocks newer batches until older ones are cleared.
83%
Forecast
Monthly write-off value (₦0k) versus FEFO compliance (%).FebMarAprMayJunJul
Recommended actions
- 1.Dispose of the expired quarantine today
- 2.Approve the markdown ladder
- 3.File the supplier return claims