Retail_HQ
/Inventory · Supply Chain Control Room

Control Room

Stock flow, warehouse zones, suppliers, transfers, and expiry.

Operations activity feed

click any entry
SKUs
18,420
Stock value
₦612.0M
Low-stock alerts
31
Transfers in transit
24

Stock Flow Diagram

End-to-end
1
Supplier
5 active
2
Central Warehouse
78% capacity
3
Branch Stockroom
3 branches
4
Shelf
18.4k SKUs
5
POS
12 lanes

Warehouse Zone Map

Zone
A · Ambient
82%
Zone
B · Beverage
74%
Zone
C · Cold
91%
Zone
D · Pharma
68%
Zone
E · Bulk
88%
Zone
F · Dock
42%

Reorder Intelligence

Top 5
SKUBranchStockReorderDaysSupplier
Peak Milk Powder 400g
SKU-10241
Wuse 2422002dFrieslandCampina
Paracetamol 500mg
SKU-77410
Apo181501dEmzor Pharma
Indomie Chicken
SKU-88120
Gwarinpa964003dDufil Prima
Bigi Cola 60cl
SKU-30412
Wuse 22405005dRite Foods
Dettol Antiseptic
SKU-55210
Gwarinpa341202dReckitt

Supplier Board

FrieslandCampina WAMCO
Dairy · Lead 3d · ★ 4.7
₦4.8M
Outstanding
Emzor Pharmaceutical
Pharma · Lead 2d · ★ 4.9
₦2.1M
Outstanding
Dufil Prima Foods
Noodles · Lead 4d · ★ 4.6
₦3.4M
Outstanding
Rite Foods Ltd
Beverages · Lead 3d · ★ 4.4
₦1.2M
Outstanding
Reckitt Benckiser
Personal Care · Lead 5d · ★ 4.8
₦980.0k
Outstanding

Barcode Center preview

18,420
SKUs
14
Untagged
3
Duplicates
Recent scans (per minute)
12345678910

Stock Transfer Kanban (preview)

Approved
TR-3042
Gwarinpa
68 items · ₦2.1M
Picked
TR-3043
Apo
31 items · ₦890.0k
In Transit
TR-3044
Wuse 2
54 items · ₦1.8M
TR-3045
Gwarinpa
22 items · ₦640.0k

Expiry Risk Timeline

Paracetamol 500mg
Apo · 240 units
2026-07-18
high
Amoxicillin 250mg
Apo · 180 units
2026-07-30
high
Peak Milk Powder
Wuse 2 · 60 units
2026-08-12
med
Bigi Cola 60cl
Gwarinpa · 320 units
2026-09-04
low
Yoghurt 500ml
Wuse 2 · 44 units
2026-07-10
high
Total SKUs live
4,286+62 this month
Stock value
₦412.6M+3.8%
Availability
94.2%+1.1pp
Stock-out SKUs
68-9
Dead stock
₦18.4M4.5% of value
Inventory turns
8.4x+0.3x

Operational workspace — what is happening

Network inventory status board

Live
Warehouse fill
78%
Zone C at 96%
Branch replenished
3 / 3
Open transfers
14
3 in transit
Reorder triggers
31
Expiring < 30d
142 units
Cold chain
Stable
2 sensors

Stock position by category

Live
CategorySKUsOn handValueCover (days)Status
Groceries1,284182,400₦148.2M26Healthy
Beverages74296,200₦68.4M19Healthy
Pharmacy91841,800₦92.6M34Watch
Household61058,700₦42.1M22Healthy
Personal care48236,400₦38.9M31Overstock
Fresh & bakery25012,900₦22.4M6Tight

Inventory event feed

Live feed
  1. GRN posted18:44
    Nestle Distributor · 240 cartons
  2. Reorder triggered18:12
    Peak Milk 400g below min
  3. Transfer dispatched17:50
    WH → Gwarinpa · 88 units
  4. Expiry alert17:22
    Amoxicillin batch AMX-114 · 21d
  5. Cycle count closed16:40
    Zone B · variance 0.4%

Control room action queue

6 in queue
Approve 6 reorder proposals
₦18.2M committed
Open
Clear Zone C congestion
Warehouse · 96% fill
Open
Confirm 3 in-transit transfers
ETA today
Open
Review dead stock list
₦18.4M · 212 SKUs
Open
Close cycle count Zone D
Due 20:00
Open
Escalate Rite Foods delays
2 late POs
Open

Analytics workspace — why is it happening

Stock value vs availability

6 months
FebMarAprMayJunJul

Value by category

Groceries36%
Pharmacy22%
Beverages17%
Household10%
Personal care9%
Fresh6%

Days of cover by category

GrocBevPharmHshldCareFresh

Highest value SKUs (₦M)

Ranked
#1
Amoxicillin 500mg
14.2
#2
Peak Milk 400g
11.8
#3
Indomie Chicken
9.4
#4
Golden Penny 5kg
8.6
#5
Dettol 250ml
6.2

Availability heat map — branch × category

Heat map
GrocBevPharmHshldCareFresh
Wuse 2
96
94
92
95
97
88
Gwarinpa
93
90
89
92
95
82
Apo
91
88
97
90
93
78

Turns vs margin by category

Correlation
FreshGroceriesBeveragesPharmacyPersonal careInventory turnsGross margin %

Inventory health scorecard

Multi-factor
AvailabilityAccuracyTurnsFreshnessSpace useSupply

Branch inventory comparison

Comparative
BranchValueAvailabilityOOS SKUsTurnsShrink
Wuse 2₦96.4M95.1%189.1x0.38%
Gwarinpa₦72.8M93.2%268.2x0.44%
Apo₦48.2M92.4%247.4x0.51%
Warehouse₦195.2M6.8x0.22%

Management workspace — exceptions & approvals

Exception centre

3 open
Fresh category cover at 6 daysCategory Lead
Below the 9-day policy floor; weekend demand risks empty bays.
Dead stock at ₦18.4MMerchandising
212 SKUs with no movement in 90 days, concentrated in personal care.
Warehouse Zone C at 96% fillWarehouse Mgr
Putaway slowing; inbound Nestle delivery has no allocated bay.

Pending approvals

Awaiting sign-off
  • 6 automated reorder proposals
    ₦18.2M · Groceries + Pharma
    Review
  • Dead stock clearance markdown
    ₦4.1M retail value
    Review
  • Emergency Apo pharma transfer
    ₦340k
    Review

Manager action queue

Assigned
ActionOwnerDuePriority
Raise fresh cover to 9 daysCategory LeadTodayHigh
Reslot Zone C fast moversWarehouse MgrTomorrowMedium
Launch dead stock clearanceMerchandisingThis weekMedium
Re-baseline min/max for top 200 SKUsInventory PlannerFridayMedium
Publish network availability reportAnalyticsMondayLow

Escalations

Routed upward
Rite Foods reliability at 78%Escalated
Two late deliveries this month affecting beverage cover.
Pharmacy overstock at ApoEscalated
34 days of cover ties ₦9.2M of working capital.

Executive intelligence — what to do next

Executive summary

Auto-generated · demo

Network inventory is healthy in aggregate — availability is up 1.1pp and turns improved to 8.4x — but the quality of the stock mix is uneven. Fresh is running dangerously thin while pharmacy and personal care hold excess cover, and ₦18.4M sits in non-moving lines. Rebalancing cover between these poles releases working capital without hurting service.

84
Health score
Strong
78
Opportunity score
Stable
42
Risk score
Watch
86
Confidence
Strong

Key insights

  • Availability improvement came almost entirely from groceries and household replenishment discipline.
  • Pharmacy holds 34 days of cover against a 24-day policy, the single largest capital drag.
  • Fresh sells 12 turns a year but is chronically under-ordered on weekends.
  • Warehouse space utilisation, not stock volume, is now the binding constraint on inbound flow.

Business risks

Fresh stock-outs at weekend peak
Six days of cover cannot absorb Saturday demand spikes.
Working capital locked in slow lines
₦18.4M dead stock plus ₦9.2M pharmacy excess.
Single-supplier concentration
Nestle represents 28% of grocery inbound volume.

Growth opportunities

Release ₦12M of working capital
Trim pharmacy and personal care cover toward policy.
Lift availability to 96%
Fixing the top 40 recurring stock-outs closes most of the gap.
Warehouse reslotting
Velocity-based slotting could add 11% effective capacity.

Performance highlights

Availability
94.2%
Turns
8.4x
Dead stock
₦18.4M
Capital release
₦12M

AI recommendations

Confidence weighted
Rebalance cover across categories
Cut pharmacy to 26 days, lift fresh to 9 days using existing budget.
88%
Run a 6-week dead stock clearance
Markdown ladder on 212 non-moving SKUs across all branches.
81%
Velocity-slot the warehouse
Move A-movers to Zone A/B forward pick to relieve Zone C.
76%

Forecast

Stock value (₦M) versus availability (%) — capital falls while service improves as rebalancing lands.
FebMarAprMayJunJul

Recommended actions

  1. 1.Approve the six pending reorder proposals today
  2. 2.Set fresh minimum cover to nine days before the weekend
  3. 3.Start the dead stock markdown ladder on Monday
  4. 4.Commission a velocity slotting study for the warehouse