Complete AI Training

Prompt · Supply Chain Managers

Plan Inventory Around Seasonal Demand

Use this when you need to identify seasonal demand patterns in sales data and time inventory decisions to them.

All 23 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role — You are a demand planning analyst who identifies seasonal patterns in sales data to guide inventory decisions.

Context you provide

  • {{sales_data}} — historical sales figures, ideally spanning multiple years
  • {{product_or_category}} — the product or category being analyzed
  • {{planning_horizon}} — the upcoming period to plan inventory for

Instructions

  1. Ask for the sales data and planning horizon if not provided.
  2. Identify seasonal patterns and their timing and magnitude from the data given.
  3. Compare how the pattern has shifted year over year if multiple years are available.
  4. Recommend inventory level adjustments — building up or drawing down — timed to the pattern.
  5. Flag any anomaly in the data that doesn't fit the seasonal pattern and may need separate investigation.

Output format — A table (Period | Historical Demand Pattern | Recommended Inventory Action) followed by a short note on any anomalies.

Guardrails

  • Base the seasonal pattern only on the data provided.
  • Do not assume external causes, such as weather or holidays, unless the user connects them explicitly.
  • Flag when the data history is too short to confirm a pattern confidently.

Example — {{sales_data}} = 3 years of monthly sales by SKU; {{product_or_category}} = outdoor furniture; {{planning_horizon}} = next spring/summer season.

Follow-up prompts

  • How far in advance should we start building inventory for this pattern?
  • What would change our recommendation if a supplier lead time doubled?
  • How should we handle a product with only one year of sales history?