Division H · Military Uniforms — Weekly Buy Planning

On hand (WH 03)

units

Inventory value @ cost

Credible inbound

units on order

Recommended buys this week

units ( style)

The Monday sheet — all styles

Rec. buy = units needed at the projected trough in months [lead, lead+3] to restore the target cover, rounded up to 100. Forward rate = blended plan over the next 3 months; flags: ⏸ over the 6-month stop-buy ceiling · ⚠ under the 2-month alarm floor · ✎ stale open PO balance to close · ◔ under 6 months of history.

Style detail

Position

on hand
+ ditty cage · inbound · on open picks

Cover

months @ forward rate
months @ trailing-12 rate

Measured lead time

days median
p75 · p90 · u over receipts

Recommended buy

units

Projected on-hand path (12 months)

Demand — shipments vs plan

Bars: invoiced shipments from A2000, all customers. Yellow: the exchanges' forecast (revised "NEW 2026" where present, else the original plan). Violet: the blend used for projection — slide the weight above to see the policy react.

Weekly order flow (the lumpiness the buffer absorbs)

Receipt lead times by vendor

Open purchase orders

Size-level position

Method & caveats
  • Data: A2000 snapshot — shipments NKW.INVOICE_LI_M (all customers, incl. the ditty/personal drip and internal TTGSHOW), position NKW.INVENTORY_LI WH 03 (D3 ditty shown separately, excluded from cover), POs NKW.PO_HD/PO_LI, receipts NKW.V_INV_LI. Forecasts and unit costs from the 5/28/26 forecast workbook (revised "NEW 2026" preferred, then original 2026 and 2027 columns).
  • Demand model: deseasonalized 6-month trailing base × program seasonal index (computed from Jul-24 → Jun-26 complete months), blended with the customer forecast by the weight slider. Current month uses plan minus month-to-date shipments.
  • Credible inbound: open PO lines (bal > 100) with a receipt in the last 180 days or entered in the last 270 days; timed by ETA (past-due → next month). Everything else is flagged stale — close those lines in A2000; they otherwise inflate "on order".
  • Recommendation: at the projected trough within [lead, lead+3] months, buy back up to the target cover at the then-current 3-month forward rate. Thresholds: 2-month alarm floor, 6-month stop-buy ceiling.
  • Known measurement caveats: receipt lead times take the PO header entry date as t₀ (blanket POs may be negotiated earlier); the ~3% receipt undercount seen in the mirrored v_inv_li does not apply here (this reads Oracle direct).