Inventory Intelligence
Demand-to-supply ratios and aging alerts across your lot
Purpose
Inventory Intelligence replaces gut-instinct stocking decisions with demand-to-supply ratios, aging alerts, turn-rate benchmarks, and optimal new-vs-used mix targets. It pulls sold market data and live supply counts to surface exactly which models are under-supplied (stocking opportunities) and which are over-supplied (avoid buying more).
The aging inventory workflow uses multi-agent orchestration — the lot-scanner agent paginates through all aged units, then the lot-pricer agent prices each against the market — while the market demand snapshot runs in parallel. The result is a complete picture of lot health and acquisition opportunity in a single report.
How It Works
Execution flow. MCP tool calls are shown inline on each step.
get_sold_summaryPull top 20 models by sold count for the prior month in the dealer's state. Also pull body type breakdown to reveal segment-level demand patterns.
search_active_carsPull active inventory facets by make and model for the same state to get supply counts without fetching individual listings.
Calculate Demand-to-Supply ratio = monthly sold count / active supply count. Ratio >1.5 = under-supplied, 0.8-1.5 = balanced, <0.8 = over-supplied.
Spawn lot-scanner agent to paginate through all units exceeding the aging threshold (default 60 DOM), sorted by DOM descending.
predict_price_with_comparablesSpawn lot-pricer agent to price each aged unit against predicted market price and calculate price gap, floor plan burn, and recommended action.
MCP Tool Calls
| Tool | Calls | Purpose |
|---|---|---|
get_sold_summary | 2-3 | Sold demand by make/model and body type for the prior month in dealer's state |
search_active_cars | 2-4 | Active supply facets by make/model/body type; lot-level inventory scan |
predict_price_with_comparables | 1 per aged unit | Market price prediction for each aged unit via lot-pricer agent |
Example Output
INVENTORY INTELLIGENCE REPORT — February 2026 Dallas-Fort Worth Market | Franchise Dealer | Used Focus ══════════════════════════════════════════════════════ DEMAND-TO-SUPPLY RATIOS (Top Under-Supplied Models) Make/Model Monthly Sold Active Supply D/S Ratio Signal Toyota Tacoma 847 312 2.71 UNDER-SUPPLIED ★ Honda CR-V 1,204 521 2.31 UNDER-SUPPLIED ★ Ford F-150 2,108 943 2.24 UNDER-SUPPLIED ★ Chevrolet Equinox 763 398 1.92 UNDER-SUPPLIED Toyota RAV4 1,891 1,042 1.81 UNDER-SUPPLIED Toyota Camry 1,122 781 1.44 BALANCED Nissan Altima 644 712 0.90 BALANCED Chevrolet Malibu 281 498 0.56 OVER-SUPPLIED ✗ TOP BODY TYPES BY DEMAND Body Type Sold Count Share Active Supply D/S Pickup 4,820 28% 2,108 2.29 UNDER-SUPPLIED SUV 5,614 33% 3,402 1.65 UNDER-SUPPLIED Sedan 3,201 19% 2,890 1.11 BALANCED Crossover 2,108 12% 1,782 1.18 BALANCED AGING INVENTORY ALERT (Units > 60 DOM) VIN Vehicle DOM Your Price Mkt Price Gap Action ...4521 2021 Chevy Malibu 94 $18,900 $16,200 +$2,700 Reduce -$2,700 ...7832 2020 Nissan Altima 78 $17,500 $16,900 +$600 Reduce -$600 ...1144 2022 Ford Edge 67 $28,200 $28,800 -$600 Below mkt FLOOR PLAN BURN: 2 units x avg $35/day x 20 days avg over threshold = $1,400/month
Cost Estimate
4 weekly runs/month ≈ $1.50 – $5.60/month
Limitations
- US market only for demand analysis — get_sold_summary is US-only. UK dealers receive only the aging inventory alert workflow.
- Aging inventory alert requires dealer_id in profile. Without it, the lot-scanner agent cannot pull dealer-specific inventory.
- D/S ratio accuracy depends on state-level sold data — high-radius dealers near state borders may see demand misattributed to one state.
- Lot-pricer prediction cost scales linearly with aged unit count — large lots with many aged units will incur higher API costs.
- New vs used mix analysis separates data cleanly but requires two separate sold summary calls per make.
More in the Dealer Plugin
Auction buying intelligence with BUY/CAUTION/PASS verdicts
View details →Brand and segment market share from real sold transaction data
View details →Morning operational health check: aging alerts and competitor price drops
View details →Quick market demand snapshot for any state or region
View details →Same Capability, Different Plugin
These skills share the same underlying methodology but are tuned for a different audience.