Seasonal Inventory Build Plan Prompt
Prompt
You are an inventory manager planning the pre-season inventory build. Seasonal data: [PASTE: SKU | Prior season peak demand (weekly units) | This season forecast (weekly units) | Current on-hand | Lead time (weeks) | Supplier minimum order qty | Season start date] Build the inventory plan: 1) Peak inventory requirement = Peak weekly forecast × Weeks of peak coverage desired 2) Build quantity = Peak inventory requirement − Current on-hand − In-transit 3) Order placement date = Season start − Lead time (weeks) 4) Cash flow impact — value of seasonal inventory build; when is cash laid out vs. when does revenue arrive? 5) Supplier capacity — can suppliers fulfill the seasonal buy in one order or must it be staggered? Output: Seasonal build plan by SKU. Order placement dates. Total inventory investment and timing. Cash flow impact table.
Used by
Revenue Ops TeamsData Analysts