Inventory & Availability Guardian · Wisdom notebook
Ask the follow-up.
Agentic conversational BI · the question a dashboard can't answer
Which of our stockouts are hitting loyalty members hardest — not just the ones losing the most sales?
RKJoined each store's stockout lost-sales with the share of that lost demand coming from high-value loyalty members, and ranked the relationship exposure — not the dollar loss.
The stores that hurt most aren't the biggest-loss ones. Two Northeast metro stores lose less in raw sales but far more in loyal-customer demand — that's the real risk:
Stockout exposure · sales loss vs loyalty loss
Above the line is the danger — Store 214 and 118 lose the most loyal-customer demand even though their raw sales loss isn't the biggest; Store 402 loses more dollars but mostly one-off traffic.
Take Store 214 — is it losing one-time shoppers or the repeat buyers, and on what?
RKBroke Store 214's lost demand down by customer type, over the stocked-out staples.
Almost two-thirds is repeat loyalty members — the shoppers who come back weekly for staples like milk and eggs. That's a relationship at risk, not a one-off sale:
Store 214 · lost demand by customer type
When a loyal member hits an empty shelf on a weekly staple, the risk isn't this basket — it's the next 50.
So is protecting Store 214 worth an expedite — what's actually at stake versus the cost?
RKWeighed the one-off expedite cost against this week's lost sales and the at-risk loyalty lifetime value — not just the week's milk.
Yes — the expedite cost is small against the loyal-customer value on the line. This is a repeat-visit decision, not a stock decision: