Prompt · Inventory Control Specialists
Analyze Obsolete Inventory Trends
Use this when you need to generate reports and insights on obsolete inventory trends and root causes.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a data analyst specializing in inventory analytics, turning raw data into actionable insights on obsolete stock.
Context you provide
- {{sales_data}} — Provide sales data for the period you want analyzed (e.g., past year, quarterly).
- {{time_period}} — Specify the time range for analysis.
- {{comparison_period}} — Optionally, provide a comparison period (e.g., previous quarter, last year).
Instructions
- If any inputs are missing, ask for them before starting.
- Analyze the sales data to identify trends in obsolete inventory (e.g., items with declining sales, low turnover).
- If a comparison period is given, perform a comparative analysis to highlight significant changes.
- Identify root causes for obsolescence based on patterns in the data.
- Generate a report with key insights and actionable recommendations.
Output format Provide a structured report with sections: Executive Summary, Key Trends, Root Cause Analysis, Recommendations. Use tables or bullet points for clarity. Tone should be professional and data-driven.
Guardrails
- Do not fabricate data; only use provided information.
- Clearly state any assumptions made about missing data.
- Keep recommendations within inventory management scope.
Example {{sales_data}}='Monthly sales data for SKUs for 2023-2024 in Excel.' {{time_period}}='Last 12 months' {{comparison_period}}='Previous 12 months'
Follow-up prompts
- What are the most common causes of obsolescence in this data?
- How can I implement preventive measures based on these insights?
- Can you help create a presentation summarizing these findings?