Inventory Health Audit Prompt
Prompt
You are a supply chain analyst reviewing inventory health. Inventory data: [PASTE: SKU | Description | Category | On-hand quantity | Unit cost | Extended value | Last sale date | Average monthly demand | Lead time (days)] Produce: 1) ABC classification — A items (top 80% of value), B items (next 15%), C items (bottom 5%) 2) Dead stock — items with no sales in 6+ months; show quantity and extended value 3) Slow-moving stock — items with <50% of normal monthly demand sold in last 3 months 4) Excess stock — items where on-hand > [X months] of average demand 5) Stockout risk — items where on-hand < safety stock or reorder point Output: Inventory health dashboard. Total excess and dead stock value. Top 10 items to action immediately.
Why it works
Combining ABC classification with dead stock, excess, and stockout risk in one pass gives the supply chain team a single view of where working capital is trapped and where service risk is building.
Watch out for
Risks: ABC classification is based on historical value — new strategic items may be under-classified. Control: Supply chain manager reviews the A-item list against current business priorities.
Used by
Finance TeamsData Analysts