Inventory & SKU
18,420 SKUs across 3 branches + warehouse.
| SKU | Category | Stock level | Wuse 2 | Gwarinpa | Apo | Velocity |
|---|---|---|---|---|---|---|
Peak Milk Powder 400g SKU-10241 | Dairy | 180 | 160 | 80 | fast | |
Paracetamol 500mg SKU-77410 | Pharma | 0 | 0 | 240 | fast | |
Indomie Chicken 70g SKU-88120 | Noodles | 480 | 520 | 240 | fast | |
Bigi Cola 60cl SKU-30412 | Beverage | 340 | 380 | 100 | fast | |
Dettol Antiseptic 250ml SKU-55210 | Personal Care | 60 | 48 | 40 | med | |
Golden Penny Semovita 5kg SKU-19800 | Grocery | 40 | 32 | 20 | med | |
Baby Wipes Multipack SKU-44112 | Baby | 12 | 14 | 6 | slow | |
Yoghurt 500ml SKU-99120 | Dairy | 40 | 30 | 18 | med |
Fast-moving products
- Peak Milk 400gFast
- Indomie ChickenFast
- Paracetamol 500mgFast
- Bigi Cola 60clFast
- Semovita 5kgFast
Dead stock
- ₦4.2MChristmas Hamper Basket (2025)148 days idle
- ₦840kSun Umbrella (off-season)92 days idle
- ₦180kDiscontinued shampoo 100ml61 days idle
Active SKUs
4,286+62
New SKUs (30d)
84+18
Delisted
31-6
Data completeness
97.4%+0.8pp
Duplicate risk
12
Avg unit cost
₦2,480+4.1%
Operational workspace — what is happening
SKU master status board
LiveA-class SKUs
418
72% of value
B-class
912
C-class
2,956
Missing images
146
No barcode
38
Pending approval
22
SKU register — attention list
Filtered| SKU | Product | Class | On hand | Cost | Issue |
|---|---|---|---|---|---|
| SKU-10241 | Peak Milk 400g | A | 1,840 | ₦4,200 | Cost variance |
| SKU-10388 | Indomie Chicken 70g | A | 9,420 | ₦280 | Duplicate risk |
| SKU-11204 | Dettol Soap 175g | B | 620 | ₦1,150 | No image |
| SKU-11890 | Amoxicillin 500mg | A | 412 | ₦3,800 | Batch tracking |
| SKU-12455 | Bigi Cola 60cl | B | 3,180 | ₦210 | Pack size |
| SKU-13012 | Semovita 5kg | C | 184 | ₦6,900 | Slow mover |
Master data change log
Live feed- SKU created18:20Hollandia Yoghurt 1L
- Cost updated17:44Peak Milk 400g ₦4,050 → ₦4,200
- SKU delisted16:58Legacy 250ml pack
- Category remapped15:3012 SKUs moved to Personal Care
- Barcode attached14:12SKU-13990
Master data cleanup queue
6 in queueResolve 12 duplicate candidates
Fuzzy name match
Attach 38 missing barcodes
Mostly C-class
Upload 146 product images
Merchandising
Approve 22 new SKUs
Buying team
Review 31 delist candidates
No sales 120d
Standardise pack descriptors
284 SKUs
Analytics workspace — why is it happening
Active SKU count vs data quality
6 monthsFebMarAprMayJunJul
SKU count by class
A10%
B21%
C69%
SKUs by category
GrocPharmBevHshldCareFresh
Top SKUs by contribution (₦M)
Ranked#1
Peak Milk 400g
24.6
#2
Indomie Chicken
21.2
#3
Golden Penny 5kg
18.4
#4
Bigi Cola 60cl
14.8
#5
Amoxicillin 500mg
12.1
SKU coverage — branch × class
Heat map| A | B | C1 | C2 | C3 | New | |
|---|---|---|---|---|---|---|
| Wuse 2 | 99 | 96 | 88 | 74 | 62 | 80 |
| Gwarinpa | 98 | 94 | 84 | 70 | 55 | 72 |
| Apo | 97 | 91 | 79 | 62 | 46 | 64 |
Unit cost vs velocity
CorrelationCatalogue quality
Multi-factorABC/XYZ classification matrix
Comparative| Class | SKUs | % of value | % of units | Policy | Review |
|---|---|---|---|---|---|
| AX — fast, stable | 268 | 48% | 31% | Auto-reorder | Weekly |
| AY — fast, variable | 150 | 24% | 18% | Buffer +15% | Weekly |
| BX | 410 | 12% | 16% | Auto-reorder | Fortnightly |
| BY/BZ | 502 | 9% | 14% | Manual review | Monthly |
| CZ — slow, erratic | 1,842 | 4% | 12% | Order on demand | Quarterly |
Management workspace — exceptions & approvals
Exception centre
3 open12 probable duplicate SKUsMaster Data
Same barcode prefix and near-identical descriptions inflate stock counts.
Cost variance above 5% on 24 SKUsBuying
Supplier price changes not reflected in retail pricing.
1,842 CZ SKUs carry only 4% of valueCategory Lead
Long tail consumes shelf space and count effort.
Pending approvals
Awaiting sign-off- Review22 new SKU listingsBuying team submission
- Review31 delist candidatesNo movement 120 days
- ReviewCost update batch24 SKUs · avg +4.1%
Manager action queue
Assigned| Action | Owner | Due | Priority |
|---|---|---|---|
| Merge duplicate SKU records | Master Data | Today | High |
| Re-price the 24 cost-variance SKUs | Pricing | Tomorrow | Medium |
| Complete missing product imagery | Merchandising | This week | Medium |
| Run long-tail rationalisation review | Category Lead | Next week | Medium |
| Publish catalogue quality scorecard | Analytics | Friday | Low |
Escalations
Routed upwardDuplicates distort availability metricsEscalated
Reported OOS counts are overstated until merged.
Executive intelligence — what to do next
Executive summary
Auto-generated · demoThe catalogue is growing faster than it is being curated. 418 A-class SKUs carry 72% of value while nearly 1,900 long-tail lines contribute 4%, and master data defects — duplicates, missing barcodes, stale costs — are now distorting availability and margin reporting.
Health score
Stable
Opportunity score
Stable
Risk score
Critical
Confidence
Strong
Key insights
- Ten percent of SKUs produce almost three quarters of inventory value.
- Data completeness has improved four points in six months but imagery lags badly.
- Cost updates trail supplier price changes by an average of eleven days.
- Long-tail lines consume disproportionate counting and shelf effort.
Business risks
Duplicate records
Stock counts and reorder points are computed twice for 12 items.
Stale cost basis
Margin reporting overstates profit on 24 fast movers.
Growth opportunities
Rationalise the long tail
Delisting 400 CZ lines frees shelf space and count hours.
Automate cost sync
Supplier price feeds could cut update lag to under two days.
Performance highlights
A-class value
72%
Data quality
97.4%
Duplicates
12
New SKUs
84
AI recommendations
Confidence weightedFreeze long-tail listings for one quarter
Require a delist for every new CZ listing added.
79%
Automate supplier cost ingestion
Pull price files weekly and flag variances above 3%.
85%
Complete the imagery backlog
146 missing images block online and shelf-label workflows.
90%
Forecast
SKU count trending down as rationalisation lands while data quality climbs toward 99%.FebMarAprMayJunJul
Recommended actions
- 1.Merge duplicates before the next count
- 2.Approve the pending 22 listings
- 3.Start the delist review for 31 candidates