Retail_HQ
/Cold Chain

Cold Chain Control

Temperature integrity across warehouse, branches and transport.

Monitored units
18
3 branches + WH
Sensors online
22 / 24
Excursions 24h
2
Monitored units
183 branches + WH
Sensors online
22 / 24
Excursions 24h
2
Compliance
98.4%+0.6pp
Value protected
₦34.2M
Avg temp deviation
0.6°C-0.2°C

Operational workspace — what is happening

Cold chain asset status

Live
Warehouse Zone E
-18.2°C
Target -18°C
Wuse 2 chillers
3.8°C
Target 2–5°C
Gwarinpa chillers
6.4°C
Above range
Apo pharmacy fridge
4.1°C
Target 2–8°C
Transport units
2 active
Sensors offline
2

Temperature excursion register

AssetLocationReadingRangeDurationStatus
CH-02Warehouse Zone E-14.6°C-18 to -16°C38 minOpen
CH-11Gwarinpa chiller 26.4°C2 to 5°C1h 12mOpen
CH-07Wuse 2 chiller 15.4°C2 to 5°C22 minResolved
CH-14Apo pharmacy fridge8.6°C2 to 8°C14 minResolved
TR-02Transport unit 24.8°C2 to 6°CNormal
CH-09Gwarinpa freezer-17.4°C-18 to -16°CNormal

Cold chain monitoring feed

Live feed
  1. Excursion started18:46
    CH-02 Zone E · -14.6°C
  2. Excursion ongoing17:34
    CH-11 Gwarinpa · 6.4°C
  3. Sensor offline16:12
    CH-16 no signal 40 min
  4. Excursion resolved15:02
    CH-07 back in range
  5. Maintenance completed12:20
    Apo fridge gasket replaced

Cold chain action queue

6 in queue
Restore CH-02 to range
Zone E · ₦8.4M stock
Open
Service Gwarinpa chiller 2
Third excursion this week
Open
Replace 2 offline sensors
CH-16, CH-19
Open
Quarantine affected batches
Pending assessment
Open
Review transport unit logs
2 vehicles
Open
Renew calibration certificates
6 sensors due
Open

Analytics workspace — why is it happening

Compliance vs excursion count

7 days
MonTueWedThuFriSatSun

Excursion cause mix

Door left open38%
Compressor fault26%
Power dip18%
Overloading12%
Sensor fault6%

Excursions by hour

060912151821

Assets by excursion count (30d)

Ranked
#1
Gwarinpa chiller 2
9
#2
Warehouse Zone E
5
#3
Wuse 2 chiller 1
4
#4
Apo pharmacy fridge
2
#5
Transport unit 2
1

Temperature stability — asset × shift

Heat map
000408121620
WH Zone E
96
97
94
88
84
92
Wuse 2
98
98
95
90
86
94
Gwarinpa
92
90
84
76
70
82
Apo
99
99
97
95
93
97

Cold chain programme

Multi-factor
CoverageUptimeResponseMaintenanceCalibrationDocumentation

Asset maintenance register

Comparative
AssetTypeLast serviceNext dueExcursions 30dCondition
CH-02Blast freezer12 Apr12 Oct5Fair
CH-11Display chiller02 FebOverdue9Poor
CH-07Display chiller18 May18 Nov4Good
CH-14Pharmacy fridge30 Jul30 Jan2Good
TR-02Transport unit22 Jun22 Dec1Good

Management workspace — exceptions & approvals

Exception centre

3 open
Gwarinpa chiller 2 overdue for serviceFacilities
Nine excursions in 30 days on an asset last serviced in February.
Zone E excursion running 38 minutesWarehouse Mgr
₦8.4M of frozen stock exposed if it continues past one hour.
Two sensors offlineIT
Blind spots in the monitoring network at Gwarinpa.

Pending approvals

Awaiting sign-off
  • Emergency chiller repair
    ₦620k · Gwarinpa
    Review
  • Sensor replacement batch
    ₦180k
    Review
  • Preventive maintenance contract
    ₦1.4M annual
    Review

Manager action queue

Assigned
ActionOwnerDuePriority
Restore Zone E temperature nowWarehouse MgrImmediateHigh
Call out engineer for Gwarinpa chillerFacilitiesTodayHigh
Assess and quarantine affected batchesQualityTodayMedium
Replace the offline sensorsITTomorrowMedium
Move to preventive maintenance schedulingFacilitiesThis monthLow

Escalations

Routed upward
Pharmacy cold chain complianceEscalated
Repeat excursions create regulatory and product safety exposure.

Executive intelligence — what to do next

Executive summary

Auto-generated · demo

Cold chain compliance sits at 98.4%, but the failures are concentrated in one ageing asset and cluster around the busiest trading hours. Gwarinpa chiller 2 alone accounts for nearly half of all excursions and is five months overdue for service — a maintenance problem presenting as a compliance problem.

79
Health score
Stable
84
Opportunity score
Strong
62
Risk score
Stable
87
Confidence
Strong

Key insights

  • Door-open events cause 38% of excursions, peaking at 18:00 during restocking.
  • Reactive maintenance is costing more than the annual preventive contract would.
  • Pharmacy assets are the best performing thanks to a stricter service regime.

Business risks

Product safety
₦34.2M of temperature-sensitive stock depends on this network.
Regulatory exposure
Pharmacy excursions must be documented and justified.

Growth opportunities

Preventive maintenance
Would eliminate an estimated 70% of current excursions.
Door alarms at peak hours
Cheapest fix for the largest single cause.

Performance highlights

Compliance
98.4%
Excursions 24h
2
Value protected
₦34.2M
Sensors online
22/24

AI recommendations

Confidence weighted
Replace or overhaul Gwarinpa chiller 2
Nine excursions in a month justifies capital replacement.
92%
Sign the preventive maintenance contract
Cheaper than the current reactive call-out pattern.
86%
Fit door-open alarms on display chillers
Addresses the largest single excursion cause.
88%

Forecast

Compliance (%) versus daily excursion count after maintenance intervention.
MonTueWedThuFriSatSun

Recommended actions

  1. 1.Escalate the Zone E excursion now
  2. 2.Book the Gwarinpa engineer today
  3. 3.Approve sensor replacement