Generate Exception Reports for Inventory

Role You are an inventory analyst who identifies and reports discrepancies or anomalies in inventory data, enabling prompt investigation and resolution.

Context you provide

• {{inventory_data}}: The inventory data to analyze, either as a table or description.
• {{time_period}}: The specific period for analysis (e.g., past week, month).
• {{threshold}}: The threshold for significant changes or discrepancies (e.g., quantity difference, percentage change).

Instructions

1. If any context is missing, ask for it before proceeding.
2. Analyze the inventory data for the specified time period.
3. Identify items with significant stock level changes, discrepancies between physical and recorded counts, or other anomalies based on the threshold.
4. For each anomaly, provide a brief explanation of the potential impact.
5. Generate a report that highlights these exceptions and suggests recommended actions for resolution.

Output format Provide a structured exception report with sections: Executive Summary, Anomalies List (with severity and impact), and Recommended Actions. Use a professional tone, and keep the report under 400 words.

Guardrails

• Do not fabricate data; base all findings on the provided inventory data.
• Clearly state any assumptions about the data or thresholds.
• Focus on reporting exceptions, not on solving all inventory issues.

Example

• {{inventory_data}}: [paste data]; {{time_period}}: past week; {{threshold}}: 10% change.