Revenue per available unit is the rental yard's RevPAR — the single productivity yardstick that lets you compare a 200-unit branch to a 60-unit branch on equal footing. This dashboard benchmarks every branch on it and breaks revenue into base rent versus the ancillary lines (damage waiver, delivery, fuel) that quietly make or break margin.
What this report answers
The productivity page answers the regional manager's benchmarking question: which branches generate the most revenue per rentable unit, and how much of that is base rent versus add-ons? Revenue per Available Unit divides total revenue by available units — a fleet-productivity read that's fair across branch sizes. Revenue per On-Rent Day is the yield per actual working day. Ancillary Revenue % of Total shows how much comes from damage waiver, delivery and pickup, fuel and consumables, and parts sales — the lines owners often under-price or give away.
The metrics that matter
Revenue per Available Unit is the headline because it normalizes for fleet size; a small branch can out-earn a large one per unit and that's the signal you want. Available Units is placed only on the base-rent rows so ancillary lines can't double-count the fleet. Ancillary Revenue % of Total is the hidden-margin metric — a branch capturing a healthy share from waiver, delivery and fuel is monetizing the whole transaction, while a low share usually means freight and waiver are being given away to win the rental.
Why the data is trapped
Base rent and ancillary lines are recorded by revenue type in the rental ERP — Point of Rental, Wynne, InTempo — while available-unit counts and the accounting roll-up live partly in the ERP and partly in QuickBooks. Splitting revenue cleanly into base versus ancillary, then dividing by a non-double-counted unit count, is exactly the kind of join that breaks in a spreadsheet, so most yards never see ancillary mix by branch at all.
How to read it
Rank branches by Revenue per Available Unit first — that's your productivity leaderboard, independent of size. Then read Ancillary Revenue % alongside it: a branch with strong per-unit revenue but thin ancillary share is leaving margin on the table in freight and waiver. The revenue-type stacked bar shows the mix at a glance, and the monthly trend line per branch surfaces seasonality and any branch sliding the wrong way.
The sample uses fully synthetic, anonymized data — no real branches, units, or revenue.
Metrics it tracks
| Metric | What it means |
|---|---|
| Revenue per Available Unit ($) | DIVIDE(SUM(total_revenue), SUM(available_units)) where total_revenue = rental_revenue + ancillary_revenue — average revenue each rentable unit generated (the rental yard's RevPAR-style productivity yardstick). |
| Total Revenue ($) | SUM(rental_revenue) + SUM(ancillary_revenue) across all branches and units. |
| Revenue per On-Rent Day ($) | DIVIDE(SUM(rental_revenue), SUM(on_rent_days)) — base-rent yield per actual day a unit was working. |
| Available Units (count) | SUM(available_units) — total rentable units in the fleet across branches (placed only on Base Rent rows to avoid double counting). |
| Ancillary Revenue % of Total | DIVIDE(SUM(ancillary_revenue), SUM(rental_revenue) + SUM(ancillary_revenue)) — share of revenue from damage waiver, delivery, fuel and consumables vs base rent. |
Used by: Regional / operations manager benchmarking branch performance and fleet productivity
Frequently asked questions
What is revenue per available unit for a rental yard?
It's total revenue (base rent plus ancillary) divided by the count of rentable units — the rental industry's equivalent of RevPAR. Because it normalizes for fleet size, it lets you fairly compare a large branch to a small one and rank locations on how hard their fleet works.
What counts as ancillary revenue at a rental yard?
Everything beyond base rent: damage waiver, delivery and pickup charges, fuel and consumables, and sales of parts. Tracking ancillary as a share of total revenue exposes how much of the full transaction each branch is monetizing — the lines that are easiest to give away to win a rental.
Why divide by available units instead of total revenue alone?
Total revenue just rewards the biggest branch. Dividing by available units measures productivity — how much each rentable unit earns — so a lean, well-run small branch can out-rank a large one. The report places the unit count only on base-rent rows so ancillary lines don't double-count the fleet.
Build this report on your own data
Clone this Rental yards template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →