✏️Prompts

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