✏️Prompts

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