Hotspot Report
The twenty places the cooler is losing the most money today, each with the one action that pays for itself. Expand a hotspot, deploy it, or skip it.
Today's stack
0 of 20 worked. Drive it to zero.
Deployed today
$0 committed from this period's budget
Recoverable, in the stack
Sales the captures say come back once these shelves are corrected
Period 8 execution budget
$24K of $42K spent · $18K remaining
Hotspots, ranked by return
Click a hotspot to open it. Arrow keys move through the stack; right deploys, left skips.
Monster 16oz out of stock every weekend
Store 118820 · Mobile, AL · Gulf Coast 1900 · Energy · Door 6
High confidence
Weekly Tuesday delivery does not carry the store to Sunday. This is an order size problem, not a shelf problem. Sales are running at 100% of deliveries, so backroom inventory is unlikely to cover the gap.
Recoverable sales
$1,880If the shelf holds through the period
Cost to act
$26Modify vendor order
ROI
72.31xClears the bar — deploy
Modify vendor order
RecommendedRep outreach to change the upcoming Energy order — quantity and cadence, ahead of the next delivery.
$26 · 72.31x ROI
Prompt store to investigate backroom
Weighed againstAsk the store manager to check the backroom for Energy stock before the next order or shift is placed.
$8 · 235.00x ROI
Modify vendor order returns 72.31x against prompt store to investigate backroom at 235.00x, so it is the one to deploy.
BodyArmor sells out within 24 hours of delivery
Store 192274 · Baton Rouge, LA · Gulf Coast 1900 · Sports Drink · Door 8
High confidence
Store sells through the whole delivery in 24 hours. The order is undersized.
Recoverable sales
$1,440If the shelf holds through the period
Cost to act
$26Modify vendor order
ROI
55.38xClears the bar — deploy
Modify vendor order
RecommendedRep outreach to change the upcoming Sports Drink order — quantity and cadence, ahead of the next delivery.
$26 · 55.38x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 12 facings across door 8, precision picklist attached.
$148 · 9.73x ROI
Modify vendor order returns 55.38x against deploy shift at 9.73x, so it is the one to deploy.
Energy planogram compliance at 61% across three doors
Store 352218 · Boise, ID · Frontier 3500 · Energy · Doors 4, 5 and 6
High confidence
The set drifted far enough that slot-level correction will not hold. It needs a rebuild.
Recoverable sales
$3,120If the shelf holds through the period
Cost to act
$148Deploy shift
ROI
21.08xClears the bar — deploy
Deploy shift
RecommendedTwo hour merchandising shift, 42 facings across doors 4, 5 and 6, precision picklist attached.
$148 · 21.08x ROI
Deploy planogram reset shift
Weighed againstFull reset shift for doors 4, 5 and 6 against the current plan version, 42 facings touched.
$196 · 15.92x ROI
A shift returns 21.08x its cost here, so it clears the bar. Sending a picklist is cheaper but leaves the recovery to the next stocking round.
Summer promo end cap not built, week two
Store 410562 · Naperville, IL · Midwest 4100 · CSD · Door 2
Medium confidence
Promotion is live in the system and absent from the cooler.
Recoverable sales
$640If the shelf holds through the period
Cost to act
$9Prompt compliance fix
ROI
71.11xClears the bar — deploy
Prompt compliance fix
RecommendedPrompts the store manager to correct the promotion and planogram breaks on door 2.
$9 · 71.11x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 8 facings across door 2, precision picklist attached.
$148 · 4.32x ROI
Prompt compliance fix returns 71.11x against deploy shift at 4.32x, so it is the one to deploy.
Celsius Sparkling Orange under-spaced against its rate
Store 168903 · Myrtle Beach, SC · Coastal Carolina 1600 · Innovation · Door 5
Medium confidence
Sell-through is 2.1x the set average on two facings. The space is the constraint.
Recoverable sales
$2,460If the shelf holds through the period
Cost to act
$148Deploy shift
ROI
16.62xClears the bar — deploy
Deploy shift
RecommendedTwo hour merchandising shift, 6 facings across door 5, precision picklist attached.
$148 · 16.62x ROI
Deploy assortment modification
Weighed againstReallocates Innovation facings to the items earning them, balanced against a named donor.
$240 · 10.25x ROI
A shift returns 16.62x its cost here, so it clears the bar. Sending a picklist is cheaper but leaves the recovery to the next stocking round.
Water door rebuilt against last quarter's plan
Store 441780 · Toledo, OH · Great Lakes 4200 · Water · Door 4
High confidence
The whole door is off. Correcting slot by slot costs more than resetting it once.
Recoverable sales
$2,280If the shelf holds through the period
Cost to act
$148Deploy shift
ROI
15.41xClears the bar — deploy
Deploy shift
RecommendedTwo hour merchandising shift, 36 facings across door 4, precision picklist attached.
$148 · 15.41x ROI
Deploy planogram reset shift
Weighed againstFull reset shift for door 4 against the current plan version, 36 facings touched.
$196 · 11.63x ROI
A shift returns 15.41x its cost here, so it clears the bar. Sending a picklist is cheaper but leaves the recovery to the next stocking round.
Energy doors 5 and 6 running 62% fill through peak
Store 311101 · Tempe, AZ · Grand Canyon 3100 · Energy · Doors 5 and 6
High confidence
Same eye-level slots empty on four straight captures. Volume is there, replenishment is not.
Recoverable sales
$2,140If the shelf holds through the period
Cost to act
$148Deploy shift
ROI
14.46xClears the bar — deploy
Deploy shift
RecommendedTwo hour merchandising shift, 14 facings across doors 5 and 6, precision picklist attached.
$148 · 14.46x ROI
Send picklist
Weighed againstSlot-by-slot picklist to the store manager for doors 5 and 6, worked on the next stocking round.
$12 · 178.33x ROI
A shift returns 14.46x its cost here, so it clears the bar. Sending a picklist is cheaper but leaves the recovery to the next stocking round.
Water set 71% fill, backroom shows stock on hand
Store 290734 · Charlotte, NC · South Atlantic 2900 · Water · Doors 3 and 4
Medium confidence
Inventory says the store has it. The wall says it never made the door.
Recoverable sales
$1,290If the shelf holds through the period
Cost to act
$64Backroom investigation
ROI
20.16xClears the bar — deploy
Backroom investigation
RecommendedBackroom sweep and cleanup workflow — find the Water stock the shelf is missing, then refill it.
$64 · 20.16x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 18 facings across doors 3 and 4, precision picklist attached.
$148 · 8.72x ROI
Backroom investigation returns 20.16x against deploy shift at 8.72x, so it is the one to deploy.
Two-liter set blocking single-serve facings
Store 426611 · Grand Rapids, MI · Great Lakes 4200 · CSD · Door 2
High confidence
Crew rebuilt the door off an old plan version. Wrong pack size in nine slots.
Recoverable sales
$520If the shelf holds through the period
Cost to act
$12Send picklist
ROI
43.33xClears the bar — deploy
Send picklist
RecommendedSlot-by-slot picklist to the store manager for door 2, worked on the next stocking round.
$12 · 43.33x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 9 facings across door 2, precision picklist attached.
$148 · 3.51x ROI
The recoverable sales do not cover a shift — it would run at 3.51x. A picklist to the store manager returns 43.33x for the same fix.
Three innovation SKUs never reached the door
Store 263308 · Fresno, CA · West Coast 2600 · Innovation · Door 9
Medium confidence
Distribution problem, not demand. The items are authorized and absent.
Recoverable sales
$760If the shelf holds through the period
Cost to act
$26Modify vendor order
ROI
29.23xClears the bar — deploy
Modify vendor order
RecommendedRep outreach to change the upcoming Innovation order — quantity and cadence, ahead of the next delivery.
$26 · 29.23x ROI
Send picklist
Weighed againstSlot-by-slot picklist to the store manager for door 9, worked on the next stocking round.
$12 · 63.33x ROI
Modify vendor order returns 29.23x against send picklist at 63.33x, so it is the one to deploy.
Red Bull 12oz at 48% fill on the top two shelves
Store 281145 · San Antonio, TX · Texas 2800 · Energy · Door 6
High confidence
Eye level is where it happens. Two shelves carry most of the loss here.
Recoverable sales
$1,620If the shelf holds through the period
Cost to act
$148Deploy shift
ROI
10.95xClears the bar — deploy
Deploy shift
RecommendedTwo hour merchandising shift, 11 facings across door 6, precision picklist attached.
$148 · 10.95x ROI
Send picklist
Weighed againstSlot-by-slot picklist to the store manager for door 6, worked on the next stocking round.
$12 · 135.00x ROI
A shift returns 10.95x its cost here, so it clears the bar. Sending a picklist is cheaper but leaves the recovery to the next stocking round.
7 of 9 doors last captured more than 8 hours ago
Store 142207 · Orlando, FL · Florida 1400 · Sports Drink · Doors 1-9
High confidence
Every number for this store is reading a stale shelf until the wall is re-shot.
Recoverable sales
$260If the shelf holds through the period
Cost to act
$4Prompt cooler photos
ROI
65.00xClears the bar — deploy
Prompt cooler photos
RecommendedPrompts the store manager to re-shoot the wall so every downstream number reads a current shelf.
$4 · 65.00x ROI
Send picklist
Weighed againstSlot-by-slot picklist to the store manager for doors 1-9, worked on the next stocking round.
$12 · 21.67x ROI
Prompt cooler photos returns 65.00x against send picklist at 21.67x, so it is the one to deploy.
Backroom holding 6 cases the shelf never saw
Store 310927 · Mesa, AZ · Grand Canyon 3100 · Energy · Doors 5 and 6
Medium confidence
Stock is on site and mis-shelved in the backroom. A sweep finds it faster than a resupply.
Recoverable sales
$980If the shelf holds through the period
Cost to act
$64Backroom investigation
ROI
15.31xClears the bar — deploy
Backroom investigation
RecommendedBackroom sweep and cleanup workflow — find the Energy stock the shelf is missing, then refill it.
$64 · 15.31x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 16 facings across doors 5 and 6, precision picklist attached.
$148 · 6.62x ROI
Backroom investigation returns 15.31x against deploy shift at 6.62x, so it is the one to deploy.
CSD door 1 holding 5 slots off plan
Store 204418 · Katy, TX · Texas 2800 · CSD · Door 1
High confidence
Wrong item in five eye-level slots since the last plan version landed.
Recoverable sales
$410If the shelf holds through the period
Cost to act
$12Send picklist
ROI
34.17xClears the bar — deploy
Send picklist
RecommendedSlot-by-slot picklist to the store manager for door 1, worked on the next stocking round.
$12 · 34.17x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 5 facings across door 1, precision picklist attached.
$148 · 2.77x ROI
The recoverable sales do not cover a shift — it would run at 2.77x. A picklist to the store manager returns 34.17x for the same fix.
Energy door 5 at 69% fill every afternoon
Store 148836 · Jacksonville, FL · Florida 1400 · Energy · Door 5
High confidence
Morning fill holds until 2pm, then goes. One correctly timed shift covers the peak.
Recoverable sales
$1,360If the shelf holds through the period
Cost to act
$148Deploy shift
ROI
9.19xClears the bar — deploy
Deploy shift
RecommendedTwo hour merchandising shift, 13 facings across door 5, precision picklist attached.
$148 · 9.19x ROI
Send picklist
Weighed againstSlot-by-slot picklist to the store manager for door 5, worked on the next stocking round.
$12 · 113.33x ROI
A shift returns 9.19x its cost here, so it clears the bar. Sending a picklist is cheaper but leaves the recovery to the next stocking round.
Four slow SKUs holding a third of the tea set
Store 355409 · Billings, MT · Frontier 3500 · Tea & Juice · Door 7
Medium confidence
Space is sitting with items that do not turn while two performers are capped.
Recoverable sales
$1,180If the shelf holds through the period
Cost to act
$240Deploy assortment modification
ROI
4.92xClears the bar — deploy
Deploy assortment modification
RecommendedReallocates Tea & Juice facings to the items earning them, balanced against a named donor.
$240 · 4.92x ROI
Send picklist
Weighed againstSlot-by-slot picklist to the store manager for door 7, worked on the next stocking round.
$12 · 98.33x ROI
Deploy assortment modification returns 4.92x against send picklist at 98.33x, so it is the one to deploy.
Private label water short on 6 of 7 captures
Store 173316 · Savannah, GA · Southeast 1700 · Water · Door 3
Low confidence
A recurring shortfall worth raising with the rep before the next order is placed, not worth a shift today.
Recoverable sales
$210If the shelf holds through the period
Cost to act
$8Add to vendor conversation
ROI
26.25xClears the bar — deploy
Add to vendor conversation
RecommendedAdds the Water shortfall and its capture evidence as a talking point on the next scheduled rep call.
$8 · 26.25x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 7 facings across door 3, precision picklist attached.
$148 · 1.42x ROI
Add to vendor conversation returns 26.25x against deploy shift at 1.42x, so it is the one to deploy.
Sports drink shelf tags missing after reset
Store 167452 · Wilmington, NC · Coastal Carolina 1600 · Sports Drink · Door 8
Medium confidence
Reset finished without tags. Crew cannot hold the plan without them.
Recoverable sales
$190If the shelf holds through the period
Cost to act
$12Send picklist
ROI
15.83xClears the bar — deploy
Send picklist
RecommendedSlot-by-slot picklist to the store manager for door 8, worked on the next stocking round.
$12 · 15.83x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 5 facings across door 8, precision picklist attached.
$148 · 1.28x ROI
The recoverable sales do not cover a shift — it would run at 1.28x. A picklist to the store manager returns 15.83x for the same fix.
Tea set losing two slots a week to CSD creep
Store 185540 · Colorado Springs, CO · Rocky Mountain 1800 · Tea & Juice · Door 7
Medium confidence
Crew is filling the easy gap. Small, repeated, and cheap to correct in-store.
Recoverable sales
$180If the shelf holds through the period
Cost to act
$12Send picklist
ROI
15.00xClears the bar — deploy
Send picklist
RecommendedSlot-by-slot picklist to the store manager for door 7, worked on the next stocking round.
$12 · 15.00x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 4 facings across door 7, precision picklist attached.
$148 · 1.22x ROI
The recoverable sales do not cover a shift — it would run at 1.22x. A picklist to the store manager returns 15.00x for the same fix.
Price card mismatch on the promo shelf
Store 295012 · Raleigh, NC · South Atlantic 2900 · CSD · Door 1
Low confidence
Shelf is right, signage is not. A prompt fixes it in minutes.
Recoverable sales
$140If the shelf holds through the period
Cost to act
$9Prompt compliance fix
ROI
15.56xClears the bar — deploy
Prompt compliance fix
RecommendedPrompts the store manager to correct the promotion and planogram breaks on door 1.
$9 · 15.56x ROI
Deploy shift
Weighed againstTwo hour merchandising shift, 3 facings across door 1, precision picklist attached.
$148 · 0.95x ROI
Prompt compliance fix returns 15.56x against deploy shift at 0.95x, so it is the one to deploy.
ROI is recoverable sales over the cost of the action. Anything above 1.00 is worth deploying. Where a shift and a picklist both fix the same shelf, the shift is only recommended when its own ROI clears 1.00; below that the picklist goes to the store manager instead.