Parsing reservation data…
Loading data…
— figures on screen are incomplete until this clears
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 % |
|---|
Action List
Forward bookings against the same weekday a year ago
How the book is running
Bookings created for the next 90 days, against the same point last year
By rental length
The row a rate code reads — rulesets scope by length, and daily and weekly business do not have to move together. A dot marks a cell with too little history behind it to lean on.
Dates worth a look
Running clear of their own location and segment trend, after allowing for how few bookings a single date carries
Every open date
Sorted by pickup date
Reading this.
Each date is compared with the same weekday 364 days earlier — 52 weeks exactly, so Friday meets Friday —
counting reservations created by the same number of days before pickup.
Creation never changes, so cancellations cannot distort either side, and the figures will sit
above what TSD shows on screen, which counts only reservations still open.
Why so few flags. A date is only listed when it runs clear of how its own location and segment are running overall. If a location is 30% behind, a date 30% behind carries no information. Dates near a holiday that falls in a different week this year are set aside rather than compared, and dates carrying only a handful of bookings are left alone — four against six is not a 33% decline, it is two bookings.
Cancellation rates. Only last year's is complete. This year's dates have not happened, so their cancellations are still arriving, and the two columns are shown side by side rather than subtracted for that reason.
Why so few flags. A date is only listed when it runs clear of how its own location and segment are running overall. If a location is 30% behind, a date 30% behind carries no information. Dates near a holiday that falls in a different week this year are set aside rather than compared, and dates carrying only a handful of bookings are left alone — four against six is not a 33% decline, it is two bookings.
Cancellation rates. Only last year's is complete. This year's dates have not happened, so their cancellations are still arriving, and the two columns are shown side by side rather than subtracted for that reason.
Pickup Curve
Share of a day's eventual rentals already booked, by days before pickup
Pickup curve
Median share of final demand on hand
Reading this.
At 10 days out, a value of 41% means four in ten of that day's eventual rentals were already booked —
so around 60% of the business was still to come, and a rate change still had volume to act on.
Above 100% means more was on hand than eventually rented: the day sheds bookings before pickup,
which is an attrition question rather than a pricing one.
The band matters. Day-level demand genuinely varies. The shaded area is the 10th to 90th percentile across individual pickup dates — a central tendency with real spread, not a prediction. A point is only drawn where at least 20 past pickup dates support it; gaps are locations or days without enough history to describe.
The band matters. Day-level demand genuinely varies. The shaded area is the 10th to 90th percentile across individual pickup dates — a central tendency with real spread, not a prediction. A point is only drawn where at least 20 past pickup dates support it; gaps are locations or days without enough history to describe.
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 and average rate, by pickup date
Reservations booked on the selected day (bars) against average T&M rate per rental day (line) · click a bar to see the underlying bookings
New Bookings Detail by Pickup Date
| Pickup Date | New Bookings | Avg Rate | Avg LOR | Total Open Resv |
|---|
Raw Bookings
| Confirmation | Pickup Date | Return Date | Rate Code | Avg Rate | Referral Agency |
|---|
⦿
Pickup Actuals Required
No Show / Cancellations and Show Factor can only be calculated from the Pickup Actuals file — it's the only source with confirmed, final reservation outcomes.
The Bookings file includes future/unresolved reservations and isn't reliable for this report. Load your Pickup Actuals file to see this data.
Pickup dates
–
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)
What-if: Target Utilization
Drives every Target Fleet figure below
85%
Based on trailing 3 months of actuals for the selected location(s). Higher target = leaner fleet, more revenue risk on peak days.
Current vs. Target Fleet by Location
Bars sorted by variance — biggest gaps (over or under) surface first
Target Fleet by Location
Trailing 3-month avg fleet & demand vs. target at selected utilization — Facility Min overrides demand when higher (e.g. Minimum Annual Guarantee commitments)
| Location | Current Avg Fleet | Avg Daily Demand | Current Utilization | Demand Target | Facility Min | Target Fleet | Variance | Flag | Est. Monthly $ Impact |
|---|
Vehicle Class Mix — All Locations
Current fleet snapshot vs. target mix, allocated by each class's share of rental-day demand
Load a Fleet file (Fleet Valuation tab) to see current class-level counts.
| Class | Current Units | Demand Share | Target Units | Variance | Flag |
|---|
Methodology: Avg Daily Demand = trailing 3-month average of (Closed Rev Days ÷ days in month), i.e. average vehicles on rent per day.
Demand Target = Avg Daily Demand ÷ Target Utilization. Target Fleet = max(Demand Target, Facility Min) — Facility Min is a manual
per-location input for cases like a consolidated airport facility's Minimum Annual Guarantee, where the contractual fleet floor can
exceed what demand alone would justify; edit it directly in the table and it's saved for next time. Class-level Target Units allocate
each location's Target Fleet in proportion to that class's share of rental-day demand from bookings history. $ Impact uses a placeholder
holding cost of $12/unit/day for over-fleeted units and an estimated average daily rate for under-fleeted (lost-opportunity) units —
both are adjustable assumptions, not final figures.
Availability by Location
Snapshot as of each location's most recent Daily Activity read (typically last night's close) — not all locations may share the same latest date
| Location | As Of | Useable Fleet | On Rent | Available | Utilization |
|---|
Idle Units Trend — Year over Year
Daily units sitting (not on rent), aligned by ISO week + day of week so weekdays line up year to year — prior year clipped to the same point in the calendar
Fleet Status Mix — All Locations
Snapshot from yesterday's fleet file load
Load a Fleet file (Fleet Valuation tab) to see current class-level availability.
Class Availability
Bubble size = fleet size for that class · hover for details
This page is built from two different snapshots, each timestamped independently: the Location table and Idle Units Trend come from
the Daily Activity report (a midnight read, refreshed daily); the Fleet Status Mix and Class Availability charts come from the
FleetCast file (also a daily snapshot, loaded separately in Fleet Valuation). Neither is real-time within the day — both reflect
the most recent load. Class charts group unit-level Status as On Rent / AVAILABLE / everything else (maintenance, hold for sale,
at auction, etc.) as Down/Other.
Rebalance Against
Recent actuals, or the forecast peak ahead
Target Utilization
How Cars Move
Drives how transfer cost scales
Drive-away $/mile per car
Driver time, fuel, return travel, revenue lost in transit
Cars per load
Capacity of one carrier
$/mile per load
Carrier's line-haul rate for the whole truck
Flat fee per load
Pickup/drop, minimums, broker fee
Fleet Position by Location
Units above (surplus) or below (deficit) target — bars right of zero can give, bars left need to receive
Recommended Moves
Nearest viable surplus is matched to each deficit first · payback = transfer cost ÷ monthly revenue gain
✓ No moves recommended — every location is within 2 units of target.
| From | To | Units | Distance | Loads | Transfer Cost | $/Unit | Monthly Gain | Payback |
|---|
Position Before & After
What each location looks like if every recommended move is executed
| Location | Current Fleet | Target | Variance | Out | In | After | Status |
|---|
Matching: each deficit location is filled from the nearest surplus location that still has units to give,
falling back to the largest available surplus when distance can't be determined. A location only offers units above its own target, so
Facility Min floors are respected automatically — a location held up by a contractual minimum will never be asked to give those units away.
Positions within 2 units of target are treated as on target and left alone.
Distance is great-circle mileage between recognized airport codes; other location codes show "—" and are
matched by surplus size instead. Real driving distance will be somewhat higher.
Transfer cost follows the costing mode. Drive-away is linear — distance × $/mile × cars, since each car
needs its own driver. Transporter is a step function — cars are packed into loads, and each load costs (distance × $/mile per load) + the
flat fee, whether it's full or not. That's why the $/Unit column matters: a partial load carries the same truck cost as a full one, so a
move of 9 cars on 8-car carriers is far more expensive per unit than a move of 8 or 16. Partial loads are flagged.
Monthly Gain is the receiving location's average revenue per day × target utilization × 30, i.e. what an
additional unit there could reasonably earn. Holding cost isn't credited, since the unit incurs it at either location. Payback is the
months to recover the transfer cost. These are planning estimates, not carrier quotes.
Forecast Horizon
Weeks projected forward from the last complete week
Target Utilization
Converts forecast demand into an implied fleet requirement
Weekly Demand — Actual & Forecast
Avg daily units on rent by ISO week · solid = actual, dashed = forecast, faded = same weeks last year
Weekly Forecast Detail
Implied fleet = forecast demand ÷ target utilization · gap compares against your current average fleet
| ISO Week | Week Of | Last Year | Forecast Demand | Implied Fleet | Current Fleet | Gap | Basis |
|---|
Forecast Demand by Vehicle Class
Peak-week forecast allocated by each class's share of recent rental-day demand
No class-level booking data loaded for this scope.
| Class | Demand Share | Peak-Week Demand | Implied Fleet |
|---|
Method: seasonal-naive with trend. Each future week is forecast as last year's actual demand for the
SAME ISO week, multiplied by a trend factor measured as this year's last 8 matched weeks ÷ the same 8 weeks last year (clamped to
0.5–2.0 so one anomalous week can't distort the whole horizon). Weeks with no prior-year match fall back to a trailing 4-week average,
and the Basis column says which rule produced each row.
Accuracy: the headline figure is a real backtest — the most recent complete weeks are held out, forecast
using only data that predates them, and compared against what actually happened. It is measured on your data, not a generic claim.
This forecast is intentionally transparent and instant rather than AI-driven; the AI Fleet & Utilization Forecast page under AI
Forecasts remains the richer model-based view.
Hourly Inventory Snapshot
TSD Inventory export — delivered hourly to SFTP
⚡
Live Inventory
Hit Refresh to pull the latest hourly Inventory snapshot, or load a file manually.
This is the only feed carrying an expected return date per rented unit, so it's the only one that can
answer "how many cars will I actually have free tomorrow".
Forward Availability — Next 14 Days
Bars are units scheduled back each day (reported). The line is the running total if nothing new went out — a ceiling, not a forecast.
Availability by Location
Right now, plus what's scheduled back inside 24 and 48 hours
| Location | Fleet | Available | On Rent | Off-Road | Util % | Back ≤24h | Back ≤48h | Away |
|---|
Availability by Class
Where you're thin right now — a class at zero available is a walk risk
| Class | Body | Fleet | Available | On Rent | Util % | Back ≤24h | Avg Odometer |
|---|
Units Away From Home
Current location differs from owning location — one-ways, transfers, and anything that drifted
✓ Every unit is at its owning location.
| Home | Currently At | Units | Avg Days Since Move | Dominant Status |
|---|
⚙
Replacement Policy
A unit is due when it hits EITHER threshold — saved for this company
Mileage limit
Age limit (months on fleet)
Miles accrued / month
Replacement cost / unit
Net of expected resale on the outgoing unit
Load a Fleet file on the Fleet Valuation tab to build a replacement schedule.
Replacement Schedule & Capital Requirement
Units crossing a replacement threshold by month, with the capital that implies — next 24 months
Fleet Mileage Distribution
How the fleet is spread across mileage bands — a flat profile replaces smoothly, a spike means a cliff
Replacement Profile by Location
Where the capital lands and how concentrated the timing is
| Location | Units | Avg Odometer | Overdue | Due ≤6 mo | Due ≤12 mo | % of Fleet ≤12 mo | Capital ≤12 mo |
|---|
Model Year Cohorts
Buying pattern in reverse — heavy cohorts replace together unless staggered
| Model Year | Units | % of Fleet | Avg Odometer | Median Months to Replace | Capital |
|---|
This is the capital layer, not the disposition queue. Fleet Intelligence scores individual units for
"should this car go now". This one answers the planning question instead — how many units cross a threshold, in which months, and what
that costs — so it stays aggregate and forward-looking rather than per-unit.
Method: each unit's months-to-replacement is the sooner of two paths — miles remaining ÷ the monthly
accrual rate, and age limit minus months already on fleet. Units past either threshold are Overdue and shown in month zero.
Where the numbers come from: odometer and model year are read from the fleet file. Months on fleet uses
Days on Fleet where the file provides it and falls back to model year otherwise, which is coarser — a unit bought used looks younger than
it is. The monthly mileage rate is measured from your own fleet when Days on Fleet is available, and is an editable assumption when it
isn't; the note above the schedule says which is in play. Replacement cost is always your input, since no feed carries it.
Scenario Levers
Applied to every location's trailing 3-month baseline
Fleet driven by
Demand change
0%
Fleet size change
0%
Target utilization
85%
Rate change
0%
Contribution — Baseline vs. Scenario
Monthly estimated contribution by location, sorted by the size of the change
Scenario by Location
Unserved = demand above what the fleet can physically cover · monthly figures
| Location | Fleet | Demand | Served | Unserved | Util % | Revenue | RPU | Est. Cost | Contribution | Contrib/Unit | Δ vs Base |
|---|
Served demand is capped at fleet size. That single constraint is what makes this more than arithmetic: cut
the fleet far enough and demand stops being fully servable, so revenue falls even though your cost base shrank. The Unserved column is
where that shows up — it's demand you'd have to turn away. A scenario that looks profitable while stacking up unserved demand is usually
one that's quietly shrinking the business.
Two ways to drive fleet. "Fleet size change" nudges it by a percentage. "Target utilization" works backwards —
you name the utilization you want to run at and the model solves for the fleet that delivers it against the scenario's demand, then reports
what that implies in units. The second is usually the more useful question. Note that in target-utilization mode nothing is ever turned
away — the fleet is sized to exactly meet demand, so Unserved is zero by construction. The constraint that binds there is the Facility Min:
a high target can size a location below a contractual floor, which is what the warning banner is for. Unserved demand only appears when you
drive fleet by percentage and cut past what demand needs.
RPU is monthly revenue ÷ fleet units — the fleet-productivity read. A fleet cut that holds revenue raises RPU,
which is precisely the efficiency claim such a cut is making; if RPU rises while unserved demand also rises, you're not getting more
efficient, you're getting smaller. The portfolio RPU in the KPI strip is total revenue over total fleet, not an average of per-location
RPUs, so a 20-unit site doesn't count the same as a 400-unit one.
Baseline is each location's trailing 3-month average fleet, average daily demand and revenue per day, all
reported. Costs use the same three assumptions as the Cost & Profitability tab, so changing them there
changes these results too. Demand and fleet levers scale the baseline directly; the rate lever moves revenue per day only, and deliberately
does not feed back into demand — real price elasticity isn't in this data, and inventing an elasticity curve would make the output look
more authoritative than it deserves. Read a rate change here as "if we held volume", and treat the volume response as your judgement call.
Count As Down
Which units to treat as out of service
What's Actually In Non-Useable
Cross-referenced from the current FleetCast snapshot — today's composition, not June's
Load a Fleet file (Fleet Valuation tab) to break the non-useable total into incoming, disposal and service.
| Category | Statuses | Units | % of Off-Road | Counted as Idle |
|---|
Downtime Trend
Daily units in maintenance and total non-useable — trailing 90 reporting days for the selected scope
Down Rate by Location
Share of total fleet out of service — sorted worst first
Downtime by Location
Trailing 3 months · lost days are discounted by each location's utilization, since an idle-market unit wasn't going to rent anyway
| Location | Total Fleet | Useable | In Maint | Non-Useable | Incoming | Idle | Idle % | Util % | Lost Days/mo | Revenue Impact/mo |
|---|
Out-of-Service Units by Status
From the current fleet snapshot — what's actually holding units off the road right now
Load a Fleet file (Fleet Valuation tab) to see unit-level out-of-service reasons.
| Status | Units | % of Out of Service | % of Fleet | Avg Odometer |
|---|
The core limitation: the Daily Activity report publishes Non-Useable as a single blended total —
incoming fleet, disposal units and service units all land in the same number, with no breakdown by reason. Splitting it requires
cross-referencing the FleetCast report's unit-level statuses, and only the current FleetCast snapshot is retained. So the composition
above is today's, and it cannot be reconstructed for a past month. That's why an elevated reading in June can't be attributed to a
cause from this data alone. Retaining a dated FleetCast copy each day would fix this going forward.
Categories: Incoming is Non-Active (fleet type 40) — units entered in the system but not yet delivered,
so they're excluded from idle fleet by default; they aren't yours to earn on yet. Disposal (hold for sale, auction, turnback) IS counted
as idle, since that's capital sitting still regardless of the reason. Service covers maintenance, cleaning, claims and damage.
Revenue impact is discounted by utilization on purpose. Lost rental days = avg units idle × 30 × that
location's utilization, then valued at its revenue per day. An idle unit at a location running 90% was almost certainly a lost rental; the
same unit at 55% mostly wasn't. Multiplying every idle unit by a full day's rate would produce a much larger and much less defensible
number. Treat this as the recoverable opportunity, not a headline loss.
⚙
Cost Assumptions
Not available in any TSD feed — set them here and they're saved for this company
Depreciation $/unit/month
Fixed holding $/unit/day
Storage, insurance, registration — charged on every unit, rented or not
Variable $/rental day
Cleaning, fuel, per-turn maintenance — charged only on days a unit is on rent
Revenue vs. Estimated Cost by Location
Trailing 3 months · sorted by estimated contribution
Unit Economics by Location
Trailing 3 months · RevPAC = revenue per available car day, the fleet-level yield metric
| Location | Revenue | Rental Days | RPD | Util % | RevPAC | Est. Cost | Est. Contribution | Margin % |
|---|
Revenue by Vehicle Class
From bookings history over the same trailing 3 months — all figures reported, no cost allocation applied
No class-level booking data loaded for this scope.
| Class | Revenue | Rental Days | RPD | % of Revenue |
|---|
Reported (from your data): Revenue, Rental Days, RPD, Utilization and RevPAC all come straight from the
Daily Activity report and bookings history — no modeling.
Estimated (from the assumptions above): Est. Cost = (avg fleet × depreciation × months) + (fleet days ×
fixed holding) + (rental days × variable). Contribution and Margin follow from that. TSD sends no cost or depreciation feed, so these
three inputs are the entire cost model — change them and every estimated figure updates. Treat contribution as directionally useful for
comparing locations against each other, not as a substitute for the general ledger.
Exception Feed
Fleet size vs. target (85% baseline utilization), utilization vs. same week last year, and fleet age/mileage concentration — sorted by severity
| Severity | Location | Category | Alert |
|---|
Fleet Size alerts use a fixed 85% target (independent of the what-if slider on the Optimization tab) so this feed stays stable as a monitoring
baseline. Utilization Trend alerts compare the most recent week with data against the same ISO week last year, flagging swings of 10+
percentage points. Fleet Age/Mileage alerts flag locations where 30%+ of the loaded fleet snapshot is at 30k+ miles.
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 % |
|---|