Total SKUs tracked
142
↑ 8 new this month
Total stock value
₦2.31B
↑ well positioned
Days on hand (avg)
14.2d
↓ target 18d
SKUs below reorder
18
↑ 5 critical
Expiry alerts
5
action today
Ikeja WH fill
84%
8,820 / 10,500cs
Apapa WH fill
71%
5,680 / 8,000cs
Lekki Depot
62%
2,480 / 4,000cs
Agege Sub-depot
38%
760 / 2,000cs
Dead stock
284cs
₦1.84M tied up
Stock health by brand — % of safety stock
Warehouse utilisation
Stock value composition
Stock movement — 7 days (cases in vs out)
Critical alerts right now
AI stock intelligence
Demand surge detected
Indomie Chicken 70g velocity up 34% vs 4-week avg — driven by school resumption. At current rate, Ikeja WH hits reorder point in 4.2 days. Next Dufil delivery not until May 3. Raise emergency PO today.
Dead stock opportunity
284 cases of Omo Multi-Active 200g have been static 38+ days. Product superceded by 500g variant. Recommend trade promo (buy 2 get 1) to clear by May 15 before next shelf reset.
Transfer recommendation
Agege sub-depot at 38% — Hollandia cold stock critically low. Transfer 180 cases from Ikeja WH tonight. Transit time 42min. Cost ₦8,200. Alternative: lose ₦420K in Agege Hollandia sales this week.
Top movers — cases dispatched this week
SKU registry — 142 active products
Stock movements — all locations
Movement log — today
Movements by type — today
Stock level — Indomie Chicken 70g (14 days)
Full movement table — today
| Time | Type | SKU | Brand | Cases | From | To | Ref # | Operator | Reason |
|---|
Batch management — FEFO tracking (First Expired First Out)
Active batches
284
across all SKUs
Expiring <14d
5
critical — act now
Expiring 14–30d
18
monitor closely
Expired (unsold)
0
clean this period
Critical expiry — action required
Expiry calendar — next 60 days
Batch register — all active batches sorted FEFO
| Batch # | SKU | Brand | Mfr date | Expiry date | Days left | Cases on hand | Location | FEFO rank | Status |
|---|
FEFO pick priority — Indomie Chicken 70g
AI batch intelligence
FEFO breach risk
Batch IN-0312 (Indomie Veg 70g, 84cs) expires May 6 — 8 days. Current dispatch rate for Veg 70g is 12cs/day. At this pace, 0cs will remain at expiry. Zero action needed — but confirm no stockpile accumulation.
Clearance required
Batch MG-0218 (Maggi 4g Cubes, 144cs) expires Apr 30 — 2 days. 0 dispatch allocation this week. Needs emergency clearance: route to Mushin/Alaba open-market run tomorrow AM. Revenue ₦346K at risk of write-off.
Supplier batch issue
Hollandia Evap batch HC-0401 showing shortened shelf life — mfr date Feb 28, expiry May 28 (only 89 days vs standard 180). Batch HC-0411 normal (180d). Recommend raising quality concern with Chi Ltd before next order.
Reorder management — 18 SKUs triggered
Auto-triggered POs
5
awaiting approval
Manually raised POs
8
with suppliers
POs confirmed today
3
delivery scheduled
Total PO value pending
₦186M
4 suppliers
Reorder alerts — ranked by urgency
PO status tracker
| PO # | Supplier | SKU(s) | Cases | Value | Status | ETA |
|---|
AI reorder intelligence
Demand-adjusted reorder
Standard reorder qty for Indomie Chicken is 4,800cs. AI recommends raising to 7,200cs this cycle — construction season demand surge (↑34%) means standard qty covers only 11d vs usual 21d target. Extra cost: ₦10.8M. Stock-out risk avoided: ₦38M.
Supplier consolidation
Nestlé has 3 separate POs this week (Milo, Maggi, Knorr) totalling ₦42M. Consolidating into 1 PO unlocks Nestlé's ₦500K freight waiver and qualifies for 1.2% volume rebate. Net saving: ₦1.1M.
Supplier performance vs lead time — last 6 orders
| Supplier | Brands | Agreed lead time | Avg actual | OTIF | Last delivery | Next scheduled | Rating |
|---|
Warehouse map — Ikeja WH (main) · 84% utilised
Ikeja Warehouse — Bay A (Indomie / Noodles)
Bay B (Milo / Nestlé range)
Bay C (Maggi / Knorr / Seasonings)
Bay D (Oils / Heavy goods)
Cold store — Bay E (Hollandia / Chi products)
❄ Cold store active · Current temp: 5.2°C · Setpoint: 4°C
Bay F (Golden Penny / Omo / Detergents)
Bin legend
Full (>70%)
Mid (30–70%)
Low (<30%)
Empty
Cold store
Stock count — cycle count management
Last full count
Apr 14
14 days ago
SKUs counted today
38
of 142 total
Variance cases
-24cs
₦168K discrepancy
Accuracy rate
99.1%
vs 98% target
Count schedule — this week
| Day | Bay / Zone | SKUs | Counter | Status | Variance |
|---|
Variance report — today's count
| SKU | Brand | System qty | Physical | Variance | Value | Action |
|---|
Count accuracy trend — 8 weeks
Inbound deliveries — receiving management
Expected today
3
2 confirmed · 1 delayed
Cases expected
14,400
3 suppliers
Received today
6,840
Dufil prima arrived
Quality rejections
48cs
returned to Nestlé
Expected deliveries — today & upcoming
Receiving bay status
| Bay | Status | Supplier | ETA | Team |
|---|
Inbound QC log — today
| Supplier | SKU | Cases rcvd | Rejected | Reason | Action |
|---|
Inbound vs planned — 8 weeks
Damage & returns management
Damage this month
184cs
₦1.28M loss
Customer returns
62cs
4 credit notes raised
Supplier claims
₦840K
2 open claims
Damage rate
0.9%
↓ vs 1.4% last mo
Damage log — this month
| Date | SKU | Brand | Cases | Cause | Location | Value | Status |
|---|
Damage by cause
Customer returns tracker
| Customer | SKU | Cases | Reason | Credit |
|---|
Inventory analytics — performance & optimisation
Inventory turnover
4.8×
↑ vs 4.2 last qtr
Gross margin return
₦3.42
per ₦ invested
Avg shelf life consumed
31%
on dispatch
Stock-out incidents
7
this month
Overstock value
₦84M
tied up above target
Turnover by brand — times per month
Days on hand — trend (8 weeks)
Slow movers — >21 days no movement
| SKU | Brand | Cases | Days static | Value | Last moved | Action |
|---|
ABC analysis — stock contribution
A-class (20% SKUs): 72% of stock value — Indomie Chicken, Milo 400g, Power Oil 5L
B-class (30% SKUs): 22% of value — Maggi Cubes, Golden Penny, Omo 500g
C-class (50% SKUs): 6% of value — variants, slow-moving, niche SKUs
Batch-linked invoice generation — every invoice carries batch traceability
Invoices today
218
↑ 28 vs yesterday
Total invoiced today
₦1.84B
↑ on pace
Pending payment
₦528M
41 open invoices
Overdue (>30d)
₦142M
8 accounts
Credit notes raised
4
batch returns
🔗
Batch traceability embedded on every invoice
Each line item on every invoice carries the batch number(s), manufacture date, and expiry date pulled from FEFO stock. If a batch is recalled, every affected invoice is instantly identified. Customer can verify authenticity via batch QR.
Live invoice builder — batch auto-assigned (FEFO)
TAX INVOICE
Eko FMCG Distributors Ltd
RC 1184220 · VAT: 07384830-0001
Ikeja WH, Plot 14 Oba Akran Ave, Lagos
INV-042428-0174
Date: Apr 28 2026
Due: May 28 2026 (30d net)
Open — awaiting payment
Bill to
Shoprite Nigeria Ltd (Ikeja Mall)
RC 8821007 · VAT: 01892340-0001
Ikeja City Mall, Alausa, Lagos
Contact: Mrs Adeola Oyelaran · 0803-XXX-2210
Delivery details
Waybill: WB-042428-174
Van: V-07 · LSD 841 KA
Driver: Chidi Okafor (DRV-004)
Dispatched: 07:22 Apr 28 2026
| Line | Product | Batch # | Mfr date | Expiry | Cases | Unit price | Amount |
|---|
Subtotal₦9,936,000
VAT (7.5%)₦745,200
Discount (2.5% loyalty)−₦248,400
Total due₦10,432,800
Batch Traceability Certificate
Scan QR code on each case to verify product authenticity and batch origin. Claims ref: INV-042428-0174
Batch → invoice traceability
Search any batch number to find all invoices that contain it
Invoice → batch lookup
Enter an invoice number to see all batches it contains
Batch recall impact tool
If batch is recalled — instantly identify all affected customers
Credit notes — batch-linked returns
| Credit note # | Linked invoice | Customer | Batch ref | Brand | Cases | Reason | Value | Status |
|---|
Invoice register — all invoices with embedded batch references
Total invoiced MTD
₦4.84B
↑ +11.3% vs last mo
Collected MTD
₦4.31B
89% collection rate
Outstanding
₦528M
41 open invoices
Overdue 30d+
₦142M
8 accounts — escalate
Avg payment days
18.4d
vs 30d terms
Aged debtors — outstanding by age
Collection performance — MTD by customer tier
Payment receipt log — today
| Time | Invoice # | Customer | Amount received | Method | Bank ref | Posted by | Balance after |
|---|