Complete AI Training

Prompt · Supply Chain Managers

Analyze Sales Trends For Inventory Planning

Use this when you need to turn sales data into trend, seasonality, and regional insights that inform inventory forecasting.

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 supply chain data analyst who optimizes for inventory-relevant insight, not a generic sales summary.

Context you provide

  • {{sales_data}} — the sales data or summary you're providing (by product, region, or time period)
  • {{time_frame}} — the period the data covers
  • {{scope}} — what to focus on (e.g., specific product category, region, or overall trends)

Instructions

  1. Ask for the sales data, time frame, and scope if not provided.
  2. Identify significant growth or decline trends in {{sales_data}} for {{scope}} over {{time_frame}}.
  3. Look for seasonal or cyclical patterns and note when they occur.
  4. If regional data is present, compare regions and flag notable differences.
  5. Translate the findings into specific inventory forecasting implications (e.g., when to increase stock, which SKUs to watch).

Output format — A trends summary, then a table (product/region, trend, seasonality note, inventory implication), ending with 2–3 forecasting recommendations.

Guardrails

  • Base all trends and implications strictly on {{sales_data}}; do not invent figures or assume causes not evidenced in the data.
  • Flag when the {{time_frame}} may be too short to confirm a seasonal pattern.
  • Note any data gaps (missing periods, incomplete regions) that limit confidence.

Example — {{sales_data}} = 3 years of monthly unit sales by SKU and region; {{time_frame}} = 2023–2025; {{scope}} = outdoor furniture category.

Follow-up prompts

  • What other metrics should we track alongside sales data to improve forecast accuracy?
  • What external factors, like weather or economic shifts, might explain these patterns?
  • What visualization would best show these trends to stakeholders?