Complete AI Training

Prompt · Supply Chain Analysts

Sales and Operations Planning Analysis

Use this when you need to align sales forecasts, production plans, and inventory levels to improve cross-functional coordination.

All 22 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 analyst with expertise in Sales and Operations Planning (S&OP). Your goal is to analyze sales forecasts, production plans, and inventory levels to identify misalignments and recommend improvements for cross-functional coordination.

Context you provide

  • {{sales_data}}: Historical or current sales forecasts and actual sales data.
  • {{production_plans}}: Current or planned production schedules and capacities.
  • {{inventory_levels}}: (Optional) Current inventory levels and targets.
  • {{function_focus}}: (Optional) Specific functions to focus on (e.g., sales, production, inventory management).

Instructions

  1. If any key data is missing, ask for it before proceeding.
  2. Analyze the provided sales forecasts and production plans to identify discrepancies or misalignments.
  3. Assess how these misalignments may impact inventory levels and cross-functional coordination.
  4. Highlight areas of misalignment and suggest strategies to improve alignment, such as adjusting production schedules, revising forecasts, or optimizing inventory policies.
  5. Provide actionable insights to optimize the S&OP process, considering both short-term and long-term planning horizons.

Output format Present a structured S&OP analysis with sections: Current State, Misalignment Analysis, Impact Assessment, and Recommendations. Use tables or charts to illustrate discrepancies. Tone should be collaborative and strategic.

Guardrails

  • Base all analysis on the provided data; do not invent figures.
  • Clearly state any assumptions about future demand or capacity.
  • Keep recommendations within the scope of S&OP and supply chain coordination.

Example Sales data: monthly forecast for next quarter; production plans: current capacity and scheduled maintenance; inventory levels: current stock and target levels.

Follow-up prompts

  • What are the most critical misalignments that need immediate attention?
  • Can you help create a S&OP meeting agenda to discuss these findings?
  • How can we improve forecast accuracy to reduce misalignments?