TM-203: Dangers Archive

Auto-updated on every full pillar re-run. Each danger carries severity and date first flagged.

Last updated: 2026-10-27 (Design v2 — new Danger types added)

Danger: Holiday Season Stockout at High-Traffic Sites

Severity: HIGH

First flagged: 2026-10-26

Last seen: 2026-10-26

Status: ACTIVE

Description: As of late October 2026 (peak pre-holiday season), 5 of the chain's largest-format stores each have 1,950–2,100 CRITICAL stockout items. These sites serve high-traffic markets. Running into the holiday season with this many critical gaps will directly cost sales revenue. 2,188 items are already stocked out with active demand velocity — these are confirmed lost sales.

Pillar source: Stockout Risk (SR4 — Already Stocked Out)

Data:

2,188 items at OH=0 with recent sales activity

Estimated lost revenue already accrued: $21,622 (conservative — based on avg daily sales)

Sites with highest stockout item count: 171, 237, 170, 165, 1789

Stocked out items avg 10.1 days at zero inventory

Action taken: Transfer Options generated 19,060 Stockout Risk candidates ($303,445 value to move)

Danger: $10.8M Dead Stock Entering Holiday Season

Severity: HIGH

First flagged: 2026-10-26

Last seen: 2026-10-26

Status: ACTIVE

Description: The chain is carrying $10.8M in dead stock inventory heading into Q4 holiday season. Dead inventory occupies shelf space and capital that should be occupied by high-velocity, high-demand holiday product. 188,136 items (46% of all dead stock) are 365+ days old — prime candidates for write-off. Chain-wide assortment failures account for $6.15M.

Pillar source: Dead Stocks

Data:

Total: 405,966 rows / $10,830,451

Write-off candidates (365d+): 188,136 rows

Structurally Dead: 304,263 rows / $8,155,073

Chain-wide (9+ stores) dead stock: $6,153,968

Action taken: Dead Stocks pillar feeding Transfer Options (12,760 candidates / $336,346)

Danger: 12,143 FAST/CRITICAL Quick Sellout Items with No Reorder

Severity: HIGH

First flagged: 2026-10-26

Last seen: 2026-10-26

Status: ACTIVE

Description: 12,143 items are classified CRITICAL risk tier AND FAST sellout tier — meaning they are selling quickly and inventory is near zero, with no on-order. These will stock out within days. In a holiday season context, these represent peak-demand items that will be empty during the highest-traffic weeks.

Pillar source: Stockout Risk (SR5 — Quick Sellouts)

Data:

CRITICAL + FAST: 12,143 items

CRITICAL + MODERATE: 10,601 items

Total quick sellout CRITICAL tier: 22,744 items

Action taken: Quick sellouts feeding into Transfer Options priority ranking

Danger: 8 Dual-Role Sites with Simultaneous Excess and Shortage

Severity: MEDIUM

First flagged: 2026-10-26

Last seen: 2026-10-26

Status: ACTIVE

Description: 8 sites appear simultaneously as significant donors (500+ excess SKUs) and significant recipients (1,000+ shortage SKUs). This indicates assortment imbalance at the item level — they have too much of some things and not enough of others. Sites 241 and 170 are the most pronounced. Without addressing the imbalance, these sites will continue to tie up capital in the wrong product while running out of the right product.

Pillar source: Transfer Options (combined pillars)

Data:

Site 241 Cosners Corner: donor=1,404, recipient=2,054 (also in top 5 dead stock sites at $373,918)

Site 170 Bradlee: donor=1,290, recipient=1,979 (also top 5 dead stock at $449,071)

Site 237 Monticello Williamsburg: top dead stock ($462,371) + 2,071 critical stockouts

Action taken: Transfer Options candidates address this — flagging for monitoring across runs

Danger: Site 237 Monticello Williamsburg — Dual High Danger

Severity: MEDIUM

First flagged: 2026-10-26

Last seen: 2026-10-26

Status: ACTIVE

Description: Site 237 ranks #1 in chain for dead stock value ($462,371) AND #2 for critical stockout item count (2,071 items). This indicates a serious assortment management problem — the store is simultaneously hoarding the wrong product and starving for the right product. The dead stock is likely blocking reorder of what's actually selling.

Pillar source: Dead Stocks + Stockout Risk

Data:

Dead stock value: $462,371 (highest in chain)

Critical stockout items: 2,071 (2nd highest in chain)

Also in top 5 for stocked-out lost revenue: $1,197

Action taken: Site will appear in Transfer Options as both donor (dead stock) and recipient (stockout need)

Danger Type: Seasonal Window Closing [STRUCTURAL — Design v2]

Severity: HIGH (auto-assigned when window_urgency = CRITICAL)

First flagged: 2026-10-27 (structural definition)

Status: ACTIVE — applies to all Christmas-category items at SR4/SR5 as of Oct 27

Description: A seasonal category item has reached SR4 (already stocked out) or SR5 (quick sellout — days remaining <7) while an active holiday window is within 8 weeks. This is the highest-urgency intersection in the framework: item is near or at zero, it will sell if it arrives, and the window to transfer and sell is closing.

Trigger conditions:

seasonal_category = TRUE (from Season Context layer)
SR tier = SR4 or SR5
days_to_window_close <= 56 (8 weeks)

Item cluster output (per run): top 20 UPC+site pairs by (retail_price x urgency_score), with days to window close and current OH.

Output format per item:

e.g.: ORN THE NIGHT BEFORE CHRISTM | Site 171 | OH=0 | 1.8/day | 59d | SR4 | CRITICAL

Action: These items surface at the top of Transfer Options priority queue ahead of all standard HIGH conviction candidates. Christmas window = CRITICAL tier today (59 days remaining).

Danger Type: Post-Window Dead Stock Risk [STRUCTURAL — Design v2]

Severity: MEDIUM → HIGH (escalates after 30 days past window close)

First flagged: 2026-10-27 (structural definition)

Status: PENDING — will activate for Halloween items after Oct 31

Description: A seasonal category item has passed its primary sell window with OH > 0 and no transfer or markdown executed. The item is now dead in commercial terms even if the Dead Stocks pillar has not yet aged it to 91+ days. Post-window dead stock requires different handling than structural dead stock — it should move to markdown immediately, not transfer.

Trigger conditions:

seasonal_category = TRUE
past_sell_window = TRUE (from Season Context)
current_on_hand_units > 0
no_transfer_executed = TRUE (no transfer in past 30d)
no_markdown_executed = TRUE

Item cluster output (per run): top 20 seasonal UPCs by retail value at risk with OH > 0 post-window.

Action: Flag for markdown recommendation. Do NOT route to Transfer Options as transfer candidates unless a recipient site has an open window.

Danger Type: Item-Store Affinity Mismatch [STRUCTURAL — Design v2]

Severity: LOW → MEDIUM (escalates if pattern persists across 2+ runs)

First flagged: 2026-10-27 (structural definition)

Status: STRUCTURAL — applies to all transfer candidates pending affinity validation

Description: A transfer is recommended to a recipient site with zero transaction history for that UPC in the past 180 days. The transfer is speculative — there is no evidence the recipient store's customer base wants this item. This does not block the transfer, but confidence is discounted.

Trigger conditions:

transfer candidate exists (from any pillar)
recipient_site has 0 sales of this UPC in past 180d

Item cluster output: flagged in Transfer Options as "affinity_speculative" in the Reasoning column. Not a standalone Danger entry per item — surfaces as a filter in the dashboard.

Action: Speculative transfers ranked below confirmed-affinity transfers of equal value in Transfer Options priority.