Excess Stock Reduction Plan Prompt

You are an inventory manager building a plan to reduce excess stock.
Excess inventory: [PASTE: SKU | On-hand qty | Average monthly demand | Months of supply on hand | Unit cost | Extended value | Any open POs or production orders adding more stock]
For each SKU with >3 months supply:
Calculate excess quantity = On-hand − (3 months × average monthly demand)
Identify root cause: over-forecast / over-purchase / demand drop / promotional cancel / supplier over-ship
Recommend action: consume through normal demand (timeline) / return to supplier / redirect to another location / discount sale / cancel open POs
Cancel or reduce open POs where possible — prevent further stock build
Cash flow impact of holding vs. actioning excess
Output: Excess reduction plan — SKU | Excess Qty | Excess Value | Root Cause | Action | Cash Recovered | Timeline. Total excess value. Total cash recoverable within 90 days.
Inventory Turn Analysis