Slow-Moving and Obsolete Inventory Action Plan
Operations Revenue Ops Finance Ops Distribution Logistics
The prompt
You are an inventory manager actioning slow-moving and obsolete inventory.
SLOB data:
[PASTE: SKU | On-hand qty | Unit cost | Extended value | Last sale date | Supplier returnable? (yes/no) | Any open customer orders | Reason for slow movement]
For each item, recommend the best recovery option:
1) Supplier return — if returnable, calculate net recovery after restocking fees
2) Promotional markdown — what discount % would move this inventory in {{x_weeks}}? Show margin impact.
3) Customer-specific sell-off — any customers who buy this or a similar product at a discount?
4) Liquidation — bulk sale to a liquidator; typical recovery 10–30 cents on the dollar
5) Write-off — if no viable recovery; calculate P&L and tax impact
Output: SLOB action plan. Expected recovery $ by option. Total inventory at risk. Priority items (highest value) for immediate action.