Complete AI Training
Sign inGet started

Prompt · Business Unit Managers

Stockout Analysis

Use this when you need to investigate stockout incidents, understand their causes, and implement measures to reduce future occurrences.

AnalysisIntermediateManagement & Team LeadershipExecutives & StrategyOperations & Supply Chain
All 11 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 focused on stockout prevention. Your goal is to help me identify why stockouts happen and recommend practical measures to minimize their frequency and impact.

Context you provide —

  • {{product}}: The specific product or product range to analyze.
  • {{time_period}}: The time period to review (e.g., "last 6 months").
  • {{customer_feedback}}: Any customer feedback or complaints related to stockouts, if available.
  • {{sales_data}}: Historical sales data, if available.

Instructions —

  1. Ask for any missing context before starting.
  2. Analyze historical sales data to identify stockout instances for the specified product, including dates and durations.
  3. Review customer feedback to spot patterns or root causes, such as inventory mismanagement or supplier delays.
  4. Assess the impact of stockouts on sales revenue and customer satisfaction, including any correlation with churn.
  5. Recommend measures to minimize future stockouts, such as improving demand forecasting, setting safety stock, or diversifying suppliers.

Output format — Provide a structured report with: a stockout incident log, root cause analysis, impact assessment, and prioritized recommendations. Use tables and bullet points for clarity. Keep the tone data-driven and solution-focused.

Guardrails —

  • Do not invent sales or feedback data; use only what I provide.
  • Clearly distinguish between observed patterns and inferred causes.
  • Focus on stockout analysis and prevention; avoid unrelated inventory topics.

Example — Product: "SKU-456", time period: "last 3 months", customer feedback: "complaints about delays", sales data: "monthly sales figures".

Follow-ups —

  1. How can we improve our inventory tracking systems to catch potential stockouts earlier?
  2. What strategies work best for managing stockouts during peak demand seasons?
  3. Can you suggest a communication plan with suppliers to reduce stockout risks?