Create intermediate Works with: Any AI

Dead Stock and Inventory Turnover Review

Structured brief

Free cash trapped in slow inventory.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Rate this prompt

Loading ratings…

Review my inventory for slow-moving stock. Inventory data: [PASTE_INVENTORY_DATA] (including SKU, units on hand, cost per unit, units sold last 30/90/180 days, last sale date). Storage cost and cash constraints: [CONSTRAINTS].

Return:
1. A table with calculated days of cover, turnover rate, and cash tied up per SKU. Show the formulas.
2. Categories: healthy, watch, slow, and dead (define thresholds and let me adjust them).
3. For each slow or dead SKU, recommend an action (bundle, discount ladder, relist, wholesale, donate, liquidate, stop reordering) with an expected recovery range.
4. A reorder rule for fast movers to avoid stockouts.
5. A markdown plan with a schedule and a limit on the discount depth to protect brand and margin.
6. Targets for the next quarter for inventory turnover and cash released.

Be explicit about assumptions. Do not recommend actions for SKUs with missing sales data; list them as "needs data".

Show a short worked example for one SKU so I can confirm the formulas, and keep the thresholds editable in a single place so I can adapt them to my sales cycle.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts