Input Files
Sales History
Drop or click — 10-week sales data
Balance Stock
Drop or click — current warehouse stock
—
Warehouses
—
Pairs Sold (10wk)
—
Transfer Lines
—
Pairs Transferred
—
Transfer / Sales Ratio
—
Flags
// System Logic
01 // FILTER
Only RT*, RD*, RC*, RJ* warehouses processed. All others ignored.
02 // ENTITLEMENT
Entitlement = 10-week sales. Free Stock = Current − Entitlement.
03 // PRIORITY
Dead stock → same region → largest surplus → cross-region.
04 // CONSTRAINT
No warehouse ever drops below its entitlement. Exactly fills shortage.
05 // FLAGS
High concentration flagged when transfers exceed 60% of original stock.
06 // EXPORT
Download as Excel (4 sheets) or CSV (active tab). All processing is local.