Value Packs / Retail / Inventory & Availability Guardian / Brief 01

Inventory & Availability Guardian · Brief 01

Availability broke band · Northeast grocery

Shelf empty while the warehouse sits full

DataGenie Brief · autonomous
Northeast · fast-moving grocery · in-stock % vs target · in your cloud

The one line you configure

Which regions and stores are running in-stock % below target today, and is it a real supply shortage or a store-level restocking miss? Read it across the shelf, the warehouse and how fast it's selling.

In a nutshell

This reads as a restocking miss, not a supply shortage. In-stock % on fast-moving grocery fell to 88% against a 96% target — worst in New York (88%) and Pennsylvania (90%) — while the warehouse held 4.2 weeks of supply and the store shelf ran down to 0.6, and a +2.3-day restocking delay moved in step. Sales velocity held through the drop, so the demand is there and the shelf isn't. About $1.4M in weekly sales is exposed, concentrated in Northeast-metro grocery and beverages.

At a glance

In-Stock %88%vs 96% targetNortheast fast-moving grocery
Warehouse weeks of supply4.2healthynot a supply shortage
Store weeks of supply0.6near emptythe shelf gap
Lost sales · this wk$1.4Mrecoverableif unaddressed
Restocking delay+2.3dthe driverwarehouse → store
Overstock · Home, West9.1wkvs 4 targetmarkdown risk

Store clusters by in-stock % vs target

Stockout riskBelow targetWatchOn target
Northeast · Grocerydrifting88
Northeast · Beveragesdrifting91
Southeast94
Midwest96
West97

What moved

Store weeks of supply · Northeastshelf near empty while the warehouse is full0.6 wk
Warehouse-to-store restocking delaythe routing miss+2.3 d
Sales velocity · Northeast grocerydemand heldstrong
Overstock · Home goods, Westmarkdown risk building9.1 wk

In-stock % by state · worst two + best

NYprimary88%
PAstrong90%
CAgood98%

Two Northeast states run shortest — #1 New York at 88%, #2 Pennsylvania at 90%; California holds best at 98%.

In-stock % · store cluster × category

GroceryBeveragesHomeApparel
Northeast metro86%89%97%96%
Northeast suburban90%92%98%97%
Southeast95%94%97%96%
Midwest96%97%96%97%

It concentrates in Northeast-metro grocery and beverages — the fast movers; Home and Apparel are fine everywhere.

Connected signals — supply vs restocking

Warehouse weeks of supply4.2fullnot supply
Store weeks of supply0.6collapsingshelf empty
Sales velocity · Northeaststronghelddemand's there
Restocking delay+2.3dvs ~0.4dthe cause

The warehouse stayed full while the shelf emptied and sales velocity held — the discriminators that say restocking miss, not supply.

So what

In-stock % on fast-moving grocery fell to 88% vs a 96% target across the Northeast, but the warehouse sat full at 4.2 weeks and sales velocity held — the demand is there, the shelf isn't. It concentrates in Northeast-metro grocery and beverages; a warehouse-to-store restocking delay (+2.3 days) is the cause. A routing fix worth ~$1.4M this week, caught on the day — sent to the restocking team, not procurement.

The points that matter

What

In-stock % on fast-moving grocery fell to 88% against a 96% target — read with weeks of supply and sales velocity, sliced by region × store × category × product × warehouse.

88%vs 96% target

Why

The warehouse held 4.2 weeks of supply while the store shelf fell to 0.6 and sales velocity stayed strong — a restocking / routing miss, not a supply shortage.

4.2 vs 0.6warehouse vs shelf (wks)

What else

A warehouse-to-store restocking delay of +2.3 days moved in step; and the opposite risk — Home goods in the West overstocked at 9.1 weeks — is building a markdown the other way.

+2.3drestocking delay

Where

Northeast-metro grocery and beverages — the fast movers; Home, Apparel and every other region hold target.

NE metrogrocery & beverages

Questions it already answers

Is this a supply shortage or a restocking miss?

A restocking miss. The warehouse held 4.2 weeks of supply while the store shelf fell to 0.6 — routing, not procurement, is the fix.

What can the data not tell us here?

Not why the restocking lagged — that lives in the warehouse / logistics system. It pinpoints where (Northeast metro · grocery · fast movers) so the team can act.

Where else should we look?

Watch the warehouse-vs-shelf weeks-of-supply gap by region daily, and rebalance the West's Home-goods overstock before it forces a markdown.