
New Vehicle Inventory Optimization for Dealership General Managers
Optimize new vehicle inventory mix, aging, and demand to maximize dealership ROI
What You Can Do
You can input your current vehicle inventory data and sales history to receive data-driven recommendations on optimal stock levels, identify underperforming aged inventory consuming floor plan capital, forecast demand for upcoming model years, and analyze which vehicle configurations drive sales velocity. The skill addresses automotive-specific dynamics including manufacturer incentives, seasonal patterns, and floor plan interest expenses to directly improve days inventory outstanding (DIO) and gross profit per unit.
Features
compares your current stock composition against market demand and competitive benchmarks to identify gaps and overstock situations
flags vehicles at 45+ days on lot consuming excessive floor plan capital with specific recommendations for pricing or incentivizing sales
projects sales velocity by vehicle segment, model, color, and configuration based on historical patterns and seasonal trends
calculates the true carrying cost of slow-moving inventory including interest expense to justify reorder or clearance decisions
reveals which trim levels, colors, and option packages drive sales velocity versus languish on the lot
evaluates how factory incentive programs impact stocking decisions and profitability per unit
measures your inventory turn rate against dealership targets and industry standards with improvement roadmap
adjusts inventory recommendations based on historical seasonal sales patterns specific to your market and segment
Example Output
Example 1: Aged Inventory Alert
Your analysis reveals 8 vehicles aged 50+ days consuming $12,400 in monthly floor plan interest. Priority clearance recommendation: three 2024 sedans with outdated colors—suggest $1,200-$1,500 pricing adjustment. Impact: recover capital in 2-3 weeks, save $400/month financing cost.
Example 2: Inventory Mix Gap
Compared to market demand, you're 15% understocked in certified-safe AWD compact SUVs (your #2 sales driver) but 28% overstocked in luxury sedans (declining segment). Reorder recommendation: redirect next factory allocation to prioritize AWD crossovers. Projected impact: 3-4 additional units sold monthly, +$8,000-$12,000 gross profit.
Example 3: Configuration Performance
White and silver vehicles sell 22% faster than black or gray across all segments. Pearl white trim commands +$800 premium with 18-day average turn. Recommendation: increase pearl white allocation by 12% in next factory order, reduce black inventory 20%.
What's Included
- SKILL.md instruction file with automotive-specific inventory optimization framework:
- Inventory data template: Excel/CSV structure for inputting vehicle VIN, days on lot, cost, segment, configuration, and sales history
- Aging inventory analysis worksheet: identifies floor plan cost impact by vehicle and recommends pricing/incentive strategy
- Demand forecasting model: seasonal adjustment factors and velocity calculations by segment and configuration
- Inventory mix benchmarking checklist: compares your allocation against market demand and competitive set with gap analysis
Who It's For
- Dealership General Managers — optimize capital deployment and inventory turn rates
- Inventory Managers — data-driven reorder decisions and aging inventory management
- Finance Directors — reduce floor plan interest expense and improve cash flow
- Sales Directors — align inventory mix with market demand and sales team capacity
- Multi-store Dealer Groups — standardize inventory optimization across locations
Best For
- Quarterly inventory planning meetings with factory representatives
- Identifying and clearing chronically aged vehicles (45+ days) consuming capital
- Analyzing inventory gaps between current stock and market demand signals
- Forecasting optimal inventory levels for upcoming model years
- Evaluating floor plan financing cost impact of slow-moving vehicles
- Determining ideal vehicle configuration mix (color, trim, options) by segment
- Supporting budget decisions on total inventory dollar investment targets







