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
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
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.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Differentiate structural null values from missing data
Identify whether null values represent expected business logic or export dropouts. Use it when auditing schema quality or preparing datasets for modeling.
Map inconsistent export columns to target schemas
Match disparate, poorly named export headers to a structured target data schema. Use it when consolidating CSV reports from multiple platforms.
Analyze employee engagement survey results by department
Break down broad survey scores into department-level trends to spot localized burnout and turnover risks.
Evaluate pricing tier performance from subscriber data
Turn raw subscription tables into clear tier-by-tier health comparisons. Identify which pricing plans drive revenue expansion, retention, or churn risk.
Evaluate SLA compliance across support queues
Review ticket response times against service level targets across priority tiers. Use this to spot staffing bottlenecks and missed breach thresholds.
Identify top customer churn drivers from exit feedback
Turn raw cancellation survey responses and notes into prioritized churn categories with actionable fixes. Use when reviewing quarterly exit data.
- Map and inspect an unfamiliar data export
- Pinpoint friction points in conversion funnels
- Reconcile conflicting metric totals between two reports
- Summarize multi-quarter financial trends without jargon
- Clean inconsistent date formats and text categories
- Compare cumulative customer lifetime value across monthly cohorts