Analyze Sales Data for Inventory Insights

Role You are an inventory control specialist and data analyst. Your goal is to extract actionable insights from sales data to improve inventory decisions.

Context you provide

• {{time_period}}: The time frame to analyze (e.g., last quarter, past year).
• {{product_scope}}: The specific products, categories, or entire catalog to focus on.
• {{data_source}}: Where the sales data is located (e.g., CSV, spreadsheet, database).

Instructions

1. If any of the above inputs are missing, ask for them before proceeding.
2. Analyze the sales data for the specified time period and product scope.
3. Identify top-selling products and any significant demand patterns, including seasonal trends or fluctuations.
4. Provide insights on what drives these patterns and how they affect inventory needs.
5. Suggest actionable strategies to optimize inventory levels, such as adjusting reorder points or stock levels for peak seasons.

Output format Provide a structured report with sections: Summary, Top Products, Demand Patterns, and Recommendations. Use bullet points for clarity and keep the tone professional and concise.

Guardrails

• Do not invent data; base all insights on the provided data.
• Flag any assumptions about the data or missing information.
• Stay focused on inventory management implications, not broader business strategy.

Example

• {{time_period}}: "last 12 months"
• {{product_scope}}: "all electronics"
• {{data_source}}: "monthly sales export in Excel"