Spot inventory turnover bottlenecks from stock reports

Scan raw stock exports to identify slow-moving SKUs tying up capital and get clearing recommendations.

You getTop Capital Bottlenecks, risk Categorization and next Steps for Purchasing

Prompt

Prompt
Act as an inventory control analyst. Review the pasted stock report to surface turnover bottlenecks and stagnant inventory.

Rules:
- Pinpoint items with excessive days of inventory on hand (DOH) relative to their sales rate.
- Calculate or estimate the estimated capital tied up in dormant stock.
- Categorize identified bottlenecks into dead stock, slow-movers, or over-ordered lines.
- Suggest practical liquidation or rebalancing strategies for the worst offenders.

Output format:
- Top Capital Bottlenecks (Numbered list of worst SKUs with tied-up capital and runout rates)
- Risk Categorization (Table with columns: SKU/Item, Stock Category, Estimated Trapped Capital, Recommended Action)
- Next Steps for Purchasing

Here is the inventory data:

Example output

Example for: warehouse stock export showing on-hand units and 90-day movement

Top Capital Bottlenecks
  1. SKU-4402 (Winter Outerwear Coat - L): 420 units on hand, 3 sold in past 90 days. Represents $18,900 in working capital with over 10 years of supply at current velocity.
  2. SKU-9912 (Standard Leather Boots - 10): 280 units on hand, 14 sold in past 90 days. Represents $11,200 tied up with roughly 5 years of supply.
  3. SKU-1088 (Ceramic Travel Mug): 1,200 units on hand, 40 sold in past 90 days. Represents $4,800 tied up with 7.5 years of supply.
Risk Categorization
SKU/ItemStock CategoryEstimated Trapped CapitalRecommended Action
SKU-4402Dead Stock$18,900Bundle with active products or sell off-price to liquidator
SKU-9912Slow-Mover$11,200Mark down 25% on digital channels to clear during seasonal window
SKU-1088Over-Ordered$4,800Pause all purchase orders and convert to promotional giveaway gift
Next Steps for Purchasing
  • Freeze automated replenishment triggers for all outerwear variants immediately.
  • Recalibrate safety stock parameters for footwear based on 30-day velocity instead of annual averages.
Written by AI from this prompt. Your results will vary.

Paste your inventory balance report or export table into ChatGPT, Claude, or Gemini directly following the prompt. For deeper analysis, follow up by asking for warehouse space optimization suggestions based on the identified items.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis