Rebuilt against your consolidated review (14 Aug). The coverage engine no longer uses a ratio + escalation heuristic — it now runs an actual day-by-day net-down simulation (on-hand, minus spike-cleansed seasonal demand, plus incoming POs exactly on their ETA), the same shape as Frank's rolling calculator. That's what fixes ETA-blindness properly rather than patching around it. Also added: real spike-cleansed averaging, a seasonality index feeding the simulation, pack-aware shortfall display (half-pack dead zone), and Product Class + $ value visibility. Still mock data — nothing wired to NetSuite or the Sheet yet.
What this rebuild doesn't settle — carried forward as open, not decided by me:
The 10x spike multiplier is provisional — your catch-up meeting hasn't locked it. It's used here to demonstrate the calc, not as an agreed final figure.
The $ threshold for lower Product Classes is informational only — items are never actually hidden by it here, since the figure and even the metric (shortfall vs unit vs on-hand value) are still TBD. Hiding real stock risk behind an unconfirmed number felt like the wrong default.
Assumes "Remaining Qty" on partial POs is already netted — worth confirming with NetSuite before this connects to real data.
Doesn't resolve whether SCOPE replaces Frank's file or runs alongside it — that's a process call, not a calculation.
Flagged Items
Stock at risk of breaching 12-month coverage — projected forward day by day, not just ratio'd.