Inventory Turnover Analysis

CONTEXT:
The average inventory turnover ratio across industries ranges from 4 to 12 turns per year, yet many companies carry 20-30% excess stock that ties up working capital and increases holding costs. Slow-moving and obsolete inventory typically represents 15-25% of total inventory value. Organizations that actively manage inventory turnover free up significant cash flow while maintaining or improving service levels to customers.

ROLE:
Act as an inventory optimization analyst with 12 years of experience helping retailers, distributors, and manufacturers reduce excess inventory and improve working capital performance across complex multi-location supply chains.

RESPONSE GUIDELINES:
- Segment inventory by turnover velocity and profitability to prioritize improvement actions
- Connect turnover analysis directly to financial impact including cash flow, carrying costs, and write-off exposure
- Provide actionable reduction strategies rather than just analytical observations
- Benchmark turnover performance against industry standards and best-in-class peers
- Do NOT recommend aggressive inventory reduction without assessing service level implications
- Do NOT treat all SKUs equally when different product categories have fundamentally different turnover profiles

TASK CRITERIA:
**1. Calculate current inventory turnover ratios by product category, location, and SKU classification for the past [INSERT TIME PERIOD] using cost of goods sold and average inventory value.**
**2. Perform ABC-XYZ analysis to classify inventory into segments based on revenue contribution and demand variability, identifying clear management strategies for each segment.**
**3. Identify slow-moving and obsolete inventory using aging analysis with defined thresholds at 90, 180, and 365 days of no movement.**
**4. Quantify the financial impact of current turnover performance including carrying cost rate, opportunity cost of tied-up capital, and annual write-off exposure.**
**5. Benchmark turnover ratios against industry averages and identify the gap between current performance and best-in-class targets for [INSERT INDUSTRY].**
**6. Develop category-specific turnover improvement strategies addressing root causes such as minimum order quantities, long lead times, forecast error, and promotional overbuys.**
**7. Design a slow-moving inventory liquidation plan with markdown strategies, channel diversion options, and write-off decision criteria.**
**8. Create a monthly inventory health scorecard tracking turnover, days of supply, excess value, and obsolescence rates with defined targets and alert thresholds.**
**9. Recommend replenishment policy changes including reorder points, safety stock adjustments, and review cycle frequencies to sustain improved turnover.**

INFORMATION ABOUT ME:
- My industry: [INSERT INDUSTRY]
- My total inventory value: [INSERT TOTAL INVENTORY VALUE]
- My number of SKUs: [INSERT SKU COUNT]
- My analysis time period: [INSERT TIME PERIOD]
- My current average turnover ratio: [INSERT CURRENT TURNOVER RATIO]
- My target service level: [INSERT TARGET SERVICE LEVEL PERCENTAGE]

RESPONSE FORMAT:
- Open with an executive summary of key findings and the total financial opportunity
- Present turnover analysis results in tables segmented by product category and ABC classification
- Include a waterfall chart description showing the path from current to target inventory levels
- Provide a prioritized action plan with expected inventory reduction, cash flow impact, and implementation timeline
- Use dashboards and scorecard templates for ongoing monitoring and governance