
New Vehicle Inventory Optimization for Dealership Managers
Analyze inventory performance and generate rebalancing recommendations to maximize turns and redu...
What You Can Do
You can systematically analyze your new vehicle inventory mix to identify dead stock, fast-moving configurations, and underperforming model lines. The skill generates specific rebalancing recommendations that directly impact inventory turn rates, floor plan interest expenses, and capital efficiency—enabling you to make data-driven allocation decisions that align with market demand and profitability targets.
Features
Evaluate your current SKU distribution by model, trim, color, and feature combinations against sales velocity benchmarks
Flag slow-moving units aging beyond franchise targets with specific recommendations for markdown or reallocation strategies
Compare your turn rates and days-to-sale metrics against franchise and regional performance standards
Calculate carrying cost impact by configuration and identify high-cost inventory segments draining profitability
Apply seasonal patterns, manufacturer incentive cycles, and market indicators to project future demand and guide allocation
Generate specific unit acquisition and disposition actions with expected ROI and timeline for implementation
Assess your inventory positioning relative to competing dealers in your market on popular configurations and price points
Support phaseout of outgoing model years while optimizing new model year intro allocation
Example Output
Inventory Analysis Summary:
- Current days-to-sale average: 52 days vs. franchise target of 45 days
- Dead stock identified: 8 units (3.2% of new vehicle count) with 120+ days aging, estimated floor plan cost: $4,200/month
- Top 3 fast-movers: Silver Sedan (XLE trim), Black SUV (Limited trim), Pearl Truck (SCREW crew cab) — recommend increasing allocation by 15-20%
Rebalancing Action Plan:
- Reduce luxury trim overstock by 12 units (estimated savings: $6,800 floor plan interest/month)
- Acquire 20 additional units in high-demand configurations (projected turn improvement: 7-day reduction in DSO)
- Implement markdown strategy on 8 slow units: estimated recovery of $18,000-22,000 in gross profit
- Adjust incoming orders for Q2: shift 40% allocation from slow-turning colors to proven demand drivers
Expected Impact: 8-10 day DSO improvement, $12,500/month floor plan cost reduction, 2-3% gross profit margin lift
What's Included
- SKILL.md instruction file with framework and analysis methodology:
- Inventory Analysis Template: structured worksheet for capturing current SKU data, sales metrics, and aging analysis
- Rebalancing Recommendation Worksheet: allocation adjustment planning tool with ROI calculations
- Floor Plan Cost Calculator: automated model for estimating carrying cost impact by configuration
- Benchmarking Checklist: franchise and regional performance comparison framework
- Model Year Transition Checklist: phaseout and new intro planning guide
Who It's For
- Dealership General Managers — overseeing new vehicle operations and P&L accountability
- Inventory Managers — managing SKU mix, allocation decisions, and ordering strategy
- Finance Managers — controlling floor plan costs and capital deployment efficiency
- Sales Directors — balancing inventory freshness with sales team targeting and compensation
- Multi-Store Operators — optimizing allocation across locations and managing network inventory efficiency
Best For
- Monthly or quarterly inventory performance reviews with sales and finance leadership
- Dead stock assessment and aged unit disposition planning
- Floor plan cost reduction initiatives and capital efficiency analysis
- New model year introduction planning and outgoing model year phaseout
- Responding to market condition changes (seasonality, incentive programs, economic shifts)
- Underperforming model line or trim configuration analysis







