Parsing reservation data…
Load your reservation data
Upload a CSV export from your reservation system to unlock booking pace, demand forecasting, rate class analysis, and actuals tracking — all year-over-year.
Required columns
- Date Booked — when the reservation was made
- Status — Opened, Cancelled, Expired, etc.
- Quote/Rez Number — unique reservation ID
Optional columns (unlock more views)
- Pickup Date — booking window & pickup day analysis
- Rate Class — bookings by class section
- Rate Code — rate code filter
- Pickup Location — per-location breakdown
- Promo Code / Referral Agency — filter by channel
- Rental Days / Total T&M — extra metrics
— or load saved client data —
Year A
Year B
Metric
Status
Month
Location
Region
Rate Code
Car Class
Referral Agency
Weekly booking pace
Year A
Year B
Weekly pace by location
T&M Revenue · Rental Days · Avg Rate · DOW Pattern
Metric
Year A
Year B
Show
2024
2025
2026
Weekly detail table
All 52 weeks with YoY comparison
View
| Week | Week of (Yr A) | Week of (Yr B) | Year A | Year B | YoY Δ | YoY % |
|---|
YoY change by week
% difference vs prior year
AheadBehind
Cumulative bookings
Running total through the year
Booking window distribution
Days between booking date and pickup date — % of total
Year AYear B
Avg booking window by week
Days of advance notice — weekly trend
Year AYear B
Booking window by rate class
Avg days advance — top classes
Class mix — Year A
Share of total bookings
Class mix — Year B
Share of total bookings
Top classes — weekly trend
Bookings per week for top rate classes
Class YoY comparison
Top rate classes — volume and change
Rate class detail table
All classes — volume, YoY change, and avg booking window
| Rate Class | Category | Year A | Year B | YoY Δ | YoY % | Avg Window | Avg T&M Rate |
|---|
Weekly bookings by class
All 52 weeks with YoY comparison by rate class
View
Class
Weekly rental pace
rentals by pickup week
Year A
Year B
YoY change by pickup week
% difference vs prior year
AheadBehind
Cumulative rentals
Running total by pickup week
Weekly rental detail table
All 52 pickup weeks with YoY comparison
| Week | Pickup Week | Year A | Year B | YoY Δ | YoY % |
|---|
Forward Booking Pace
Booking pace for a future pickup month — current vs prior year
Booking pace — cumulative reservations on the books
Reservations booked each week for the selected pickup month — CY vs PY at same point in booking cycle
Booking Week × Pickup Week
Rental Days × Avg T&M RPD — by pickup week
Days (bars) and RPD (line) for the selected month — CY vs PY
CY
PY
Pickup Date From
Pickup Date To
Booking Date From
Booking Date To
Location
Reservations by Pickup Date
| Pickup Date | Bookings | Rental Days | T&M Revenue | RPD | LOR |
|---|
Reservations on the books by pickup date
Count of open/pending reservations for each future pickup date as of today
T&M Revenue by pickup date
Expected T&M revenue for each future pickup date
Avg T&M RPD by pickup date
Average revenue per rental day by pickup date
Reservation overview by pickup date
Stacked reservations by rate class — hover a segment for avg rate & LOR
Reservations by rate class
Total reservations per class — average rate shown inside each bar
Compare bookings made on
Location
New bookings by pickup date
Open reservations booked on the selected day, by future pickup date
Average rate on new bookings, by pickup date
Average T&M rate per rental day for reservations booked on the selected day
New Bookings Detail by Pickup Date
| Pickup Date | New Bookings | Avg Rate | Avg LOR | Total Open Resv |
|---|
Pickup From
Pickup To
Location
Rate Class
Rate Code
Referral Agency
Reservation status by pickup date
Daily breakdown — Opened, Cancelled, No Show, Pending
Opened
Cancelled
No Show
Pending
Location / Rate Class — by Pickup Date
⌕
Avg lift by category
Upcoming 30 days
Summary
| Event | Location | Dates ↑ | Category | Demand Lift | Attendance | Source |
|---|
AI Demand Forecast
Time-series forecast powered by NavCastiq — trained on your historical pickup actuals
✦
AI Insights
Weekly demand forecast — reservations by pickup week
Historical actuals vs AI forecast with confidence band — current on-books pace overlay
Demand Heatmap
Pickup day intensity — forecast window
Forecast vs On-Books Gap
How far ahead or behind forecast each week is tracking
Weekly Forecast Detail
— click any row for day-of-week pricing breakdown
| Pickup Week | Forecast | Low | High | On Books | Pace vs Forecast | Signal |
|---|
Day-of-Week Demand Distribution
Pickup demand by day — demand index & pricing signal
| Day | On Books (CY) | Actuals (PY) | % of Week | Demand Index | YoY vs PY | Pricing Signal |
|---|
✦
AI Demand Forecast
Load your Pickup Actuals file and click Generate Forecast to see AI-powered demand predictions for the next 8–16 weeks.
AI Revenue Forecast
T&M Revenue, RPD, Rental Days & LOR — trained on historical actuals
✦
AI Revenue Insights
T&M Revenue Forecast
Historical actuals vs AI forecast — gross & open/pending on-books
T&M RPD Forecast
Forecasted revenue per rental day by pickup week
Rental Days Forecast
Forecasted transaction days by pickup week
LOR Forecast
Forecasted average length of rental by pickup week
Weekly Revenue Forecast Detail
| Pickup Week | Fcst Revenue | Fcst RPD | Fcst Days | Fcst LOR | On Books (Open/Pending) | On Books (Gross) | Rev Gap |
|---|
✦
AI Revenue Forecast
Load your Pickup Actuals file and optionally the Daily Activity report for true historical revenue, then click Generate Revenue Forecast.
Fleet & Utilization Forecast
Units on rent, utilization & fleet efficiency — trained on daily activity history
✦
AI Fleet Insights
Utilization Forecast
Forecasted useable fleet utilization % by pickup week
Units on Rent Forecast
Forecasted avg daily units on rent vs projected on-books
Fleet Size Trend
Useable fleet vs total fleet by week
Units Sitting (Idle)
Forecasted idle units — a cost and repositioning signal
Weekly Fleet Forecast Detail
| Pickup Week | Fcst Util % | Fcst On Rent | Fcst Sitting | Useable Fleet | On Books (Res) | Fleet Signal |
|---|
✦
Fleet & Utilization Forecast
Load your Daily Activity file (Actuals Dashboard) to enable fleet and utilization forecasting.
Fleet Valuation
Unit-level fleet composition, disposition pipeline & AI fleet health analysis
🔍
VIN Resale Value Lookup
AI-powered estimate · Manheim MMR integration coming soon
✦
AI Fleet Health Analysis
Fleet Status Breakdown
Units by current status across all locations
Fleet by Location
Total units per location — on rent vs available vs other
Fleet by Model Year
Age distribution — older units flagged for disposition
Fleet by Car Class
Unit count per rate class — available vs total
Disposition Pipeline
Hold for Sale · At Auction · Reg Expiring Soon
| Unit # | Vehicle | Year | Class | Location | Status | Miles | Reg Expires | Days to Exp | Flag |
|---|
Full Fleet Inventory
| Unit # | VIN | Vehicle | Yr | Class | Own Loc | Curr Loc | Status | Miles | Reg Exp |
|---|
⬡
Fleet Valuation
Load your TSD fleet export (XLSX or CSV) to see fleet composition, disposition pipeline, and AI-powered fleet health analysis.
Fleet Intelligence
Disposition priority · timing · market optimizer · rebalancing — AI-powered
⬡
AI Fleet Intelligence
Disposition Score Distribution
Units scored by urgency — higher = sell sooner
Units by Disposition Urgency
Breakdown across urgency tiers
Disposition Priority Queue — ranked by urgency score
| # | Unit | Vehicle | Year | Class | Location | Status | Age | Miles | Reg Exp | Score | Urgency |
|---|
Optimal Sell Window
Units approaching disposal threshold vs demand forecast
Reg Expiration Timeline
Units expiring by month — plan ahead
Timing Recommendations — Next 90 Days
| Unit | Vehicle | Location | Reg Expires | Days Left | Demand Forecast | Sell Window | Recommendation |
|---|
Disposal Market Value by Location
Estimated wholesale value index by auction market — higher = better return
⬡ Market values are estimated based on historical auction patterns and location demand indices. Integration with Manheim Market Report (MMR) API will provide live wholesale values by VIN and auction location. Contact Rate Driven Solutions to enable live market data.
Fleet vs Demand Index by Location
Over/under-fleet relative to demand forecast
Recommended Transfers
Move units from over-fleet to under-fleet locations
Location Fleet Health Summary
| Location | Total Fleet | On Rent | Available | Util % | Demand Trend | Fleet Signal |
|---|
⬡
Fleet Intelligence
Load your TSD fleet file in Fleet Valuation to enable disposition scoring, timing recommendations, market optimization, and rebalancing intelligence.
Fleet Planning
Per-location demand & fleet plan, built from historical actuals
⬡
Fleet Planning
Load your Daily Activity file to see historical actuals for this location.
KPI Actuals (read-only)
Rate Evolution
Your rates vs competitor rates over time — AI-powered pricing position analysis
◈
Rate Evolution
No locations are mapped to Rate Navigator yet. Set an Airport IATA or Rate Navigator Location on a location in the admin panel to enable competitor rate tracking.
◈
AI Rate Intelligence
Rate Evolution — Your Rate vs Competitors
Daily T&M RPD over time — your rate vs Hertz, Enterprise, National, Alamo
Rate Position vs Market
Your rate as % above/below market average
Competitor Rate Spread
High/low/avg competitor rates vs your rate today
Rate Detail — Last 30 Days
| Company | Base Rate | Total Rate | vs Market Avg | Last Shopped |
|---|
Add Event
No impact modeled
Bookings by day of week booked
Which days customers actually make reservations
Year AYear B
Booking timing within month
When in the month customers book (week 1–4)
Year AYear B
Booking lead time trend — weekly
Avg days between booking and pickup date, by week booked
Year AYear B
Booking velocity — cumulative bookings for next 8 weeks
How many reservations have been made so far for upcoming pickup weeks vs same point last year
Year A (at same point)Year B (current)
Upload your Daily Activity report (.csv or .xlsx)
Filter
R/A Opened
Daily reservation openings
Average Daily Rate (Opened)
Daily opened avg rate — T&M per rental day at checkout
Fleet Utilization
Daily utilization %
T&M Revenue
Daily T&M with YoY comparison
Units on Rent vs Sitting
Daily fleet deployment — on rent and sitting units
Utilization & Avg Rate
Combined view
Daily detail table
| Date | DOW | Loc | R/A Open TY | R/A Open LY | Var % | Rev Days TY | Rev Days LY | Var % | Util% TY | Util% LY | Var % | T&M Rev TY | T&M Rev LY | Var % | Avg Rate TY | Avg Rate LY | Var % |
|---|