Inventory Health Dashboard Prompt

You are an inventory manager preparing the monthly inventory health review.
Inventory data: [PASTE: SKU | Category | On-hand qty | Unit cost | Extended value | Average monthly demand | Last sale date | Reorder point | Safety stock] Produce:
Total inventory value by category — current vs. prior month
Days on hand by category — on-hand ÷ average daily demand
ABC classification — A (top 80% of value), B (next 15%), C (bottom 5%); flag movement between tiers
Stock health segmentation: healthy (within normal range) / excess (>3 months supply) / slow-moving (>6 months since last sale) / dead (>12 months since last sale)
Top 10 items to action — highest value in excess, slow, or dead categories
Output: Inventory health dashboard. Total excess and dead stock value. Recommended actions for top 10 items.
Dead Stock Action Plan