Retail_HQ/Stock Counts

Stock Counts

Cycle counts, variance, and reconciliation progress.

Active counts
3
SKUs counted
2,840
15% of total
Variance
₦184k
Last full count
14 days ago

A · Ambient

47%
1,420 / 3,000 SKUs
Variance ₦42,000

B · Beverage

57%
680 / 1,200 SKUs
Variance ₦18,000

C · Cold

82%
740 / 900 SKUs
Variance ₦124,000

Count variance log

SKUZoneSystemCountedDiffValue
Peak Milk 400g
SKU-10241
A420412-8₦12,800
Bigi Cola 60cl
SKU-30412
B820808-12₦4,800
Yoghurt 500ml
SKU-99120
C8872-16₦124,000
Counts completed
18This month
Count accuracy
96.4%+1.2pp
Net variance
-₦1.24M
SKUs counted
2,18451% of range
Open recounts
9
Shrink rate
0.42%-0.06pp

Operational workspace — what is happening

Cycle count programme status

Live
Scheduled this week
6
In progress
2
Awaiting sign-off
3
Recount required
9
A-class coverage
100%
C-class coverage
38%

Count sessions

SessionLocationSKUsCountedVarianceStatus
CC-0912Warehouse Zone D9494-₦82,000Sign-off
CC-0911Wuse 2 · Aisle 3–6212212-₦146,000Closed
CC-0910Gwarinpa · Beverages148148-₦218,000Recount
CC-0909Apo · Pharmacy118118-₦34,000Closed
CC-0908Warehouse Zone B286240In progressCounting
CC-0907Wuse 2 · Household164164-₦58,000Closed

Counting activity

Live feed
  1. Recount ordered18:15
    Gwarinpa beverages · ₦218k variance
  2. Session closed17:20
    CC-0911 · 212 SKUs
  3. Blind count started16:04
    Warehouse Zone B
  4. Variance approved14:38
    Apo pharmacy · ₦34k write-off
  5. Counter reassigned11:50
    HT-04 device fault

Count follow-up queue

6 in queue
Complete 9 recounts
Mostly beverages
Open
Sign off 3 sessions
Finance approval
Open
Investigate beverage variance
₦218k
Open
Schedule C-class sampling
Coverage at 38%
Open
Retrain 2 counters
Repeat errors
Open
Publish variance report
Month to date
Open

Analytics workspace — why is it happening

Count accuracy vs variance value

6 months
FebMarAprMayJunJul

Variance cause mix

Miscount34%
Theft22%
Damage18%
Receipt error16%
System10%

Variance by category (₦00k)

BevGrocCareHshldPharmFresh

Highest variance locations (₦k)

Ranked
#1
Gwarinpa beverages
218
#2
Wuse 2 aisle 3–6
146
#3
Warehouse Zone D
82
#4
Wuse 2 household
58
#5
Apo pharmacy
34

Count variance — branch × month

Heat map
FebMarAprMayJunJul
Wuse 2
42
38
34
30
28
26
Gwarinpa
58
54
51
48
46
44
Apo
31
29
27
24
22
21

Count programme quality

Multi-factor
CoverageAccuracyTimelinessBlind countsSign-offFollow-up

Variance ageing and resolution

Comparative
LocationVarianceAgeCauseOwnerStatus
Gwarinpa beverages-₦218,0003 daysUnder investigationBranch MgrOpen
Wuse 2 aisle 3–6-₦146,0006 daysMiscount + damageSupervisorResolved
Warehouse Zone D-₦82,0001 dayReceipt errorInbound LeadSign-off
Apo pharmacy-₦34,0008 daysExpiry write-offPharmacy LeadClosed

Management workspace — exceptions & approvals

Exception centre

3 open
Gwarinpa beverage variance ₦218kBranch Manager
Largest single variance this quarter and unresolved for three days.
C-class coverage only 38%Inventory Control
Long-tail lines are effectively uncounted this year.
Nine recounts outstandingInventory Control
Open recounts delay stock ledger close.

Pending approvals

Awaiting sign-off
  • 3 count sessions for sign-off
    ₦264k combined variance
    Review
  • Write-off request
    Apo pharmacy ₦34k
    Review
  • Additional count resource
    2 temps · ₦96k
    Review

Manager action queue

Assigned
ActionOwnerDuePriority
Close the Gwarinpa beverage investigationBranch ManagerTodayHigh
Complete outstanding recountsInventory ControlTomorrowMedium
Introduce blind counting for A-classInventory ControlThis weekMedium
Schedule C-class sampling planInventory PlannerNext weekMedium
Publish monthly shrink reportFinanceMonth endLow

Escalations

Routed upward
Beverage shrink pattern at GwarinpaEscalated
Three consecutive months of above-average variance.

Executive intelligence — what to do next

Executive summary

Auto-generated · demo

Counting discipline is improving — accuracy is up to 96.4% and total variance value has fallen 42% over six months — but the residual loss is not random. Gwarinpa beverages shows a persistent pattern that looks structural rather than clerical, and the long tail is barely counted at all.

81
Health score
Strong
74
Opportunity score
Stable
54
Risk score
Watch
85
Confidence
Strong

Key insights

  • Miscount and receipt errors account for half of variance, both fixable at source.
  • Gwarinpa carries roughly double the variance of the other two branches.
  • Blind counting is used on only two thirds of sessions.

Business risks

Undetected long-tail loss
C-class coverage at 38% hides slow leakage.
Concentrated shrink pattern
One branch, one category, three months running.

Growth opportunities

Blind counting everywhere
Removes confirmation bias and typically cuts variance 15%.
Receipt-side controls
Fixing goods-in errors removes 16% of variance.

Performance highlights

Accuracy
96.4%
Net variance
-₦1.24M
Shrink
0.42%
Recounts
9

AI recommendations

Confidence weighted
Run a targeted beverage audit at Gwarinpa
Full physical count plus CCTV review of the back door.
87%
Make blind counting mandatory
Apply to all A- and B-class sessions from next cycle.
85%
Sample the C-class tail quarterly
Statistical sampling instead of full counts.
79%

Forecast

Count accuracy (%) versus monthly variance value (₦0k).
FebMarAprMayJunJul

Recommended actions

  1. 1.Order the Gwarinpa audit
  2. 2.Clear the recount backlog
  3. 3.Sign off the three pending sessions