Time utilization tells you whether your fleet is moving; dollar utilization tells you whether it's paying. Rental yards live and die on the difference, and most owners can only see one side at a time. This dashboard puts both on one screen by asset class, so you stop guessing which categories deserve the next purchase order.
What this report answers
The overview answers the questions an owner asks before signing a fleet-buy: what share of available calendar time were our units actually on rent, and how much revenue did each dollar of fleet investment earn? Time utilization — rented days over available days — is the operational read. Dollar utilization — rental revenue over acquisition cost — is the financial read, the "which metric matters" number that owners pull into spreadsheets. The scatter of time versus dollar utilization, with bubble size set by acquisition cost, instantly separates the busy-but-cheap categories from the idle-but-expensive ones.
The metrics that matter
Fleet Time Utilization sits against the industry's 65–75% benchmark; chronic readings below that point to overstock or slow turnaround, not demand. Fleet Dollar Utilization is the profit driver — a category can run high on time and still be a poor capital deployment if the day rate is low relative to what the unit cost. Realized vs Book Rate exposes discount leakage: how much of your published rate actually survives after negotiated discounts. Every rate here is a SUM-over-SUM ratio, not an average of per-row percentages, so a light month can't distort the number.
Why the data is trapped
Rented days and available days live in the rental ERP — Point of Rental, Wynne, Texada — while acquisition cost lives in the fixed-asset records in QuickBooks. Dollar utilization is the join between them, and because no single system holds both, owners rebuild it by hand in a spreadsheet every time a fleet decision comes up. The ERP can tell you a skid steer was on rent 80% of the time; it can't tell you that, at what it cost, that category is your worst capital deployment.
How to read it
Start with the scatter. Top-right bubbles — high time, high dollar utilization — are your workhorses; protect and grow them. Bottom-right — high time, low dollar — are busy but underpriced; check the realized-vs-book rate for discount leakage. Top-left — low time, high dollar — earn well when they go out but sit too often; thin the count. Bottom-left, especially large bubbles, are expensive idle capital and the first candidates to sell. Read the asset-class matrix alongside to confirm the dollars before you act.
The sample uses fully synthetic, anonymized data — no real units, revenue, or company names.
Metrics it tracks
| Metric | What it means |
|---|---|
| Fleet Time Utilization % | DIVIDE(SUM(rented_days), SUM(available_days)) — the share of available calendar time units were actually on rent. |
| Fleet Dollar Utilization % | DIVIDE(SUM(rental_revenue), SUM(acquisition_cost)) — revenue earned per dollar of fleet invested (the 'financial utilization' owners pull into spreadsheets). |
| Total Rental Revenue ($) | SUM(rental_revenue) across all units in the period. |
| Total Available Days | SUM(available_days) — total unit-days the fleet could have been rented (excludes units down for repair). |
| Realized vs Book Rate % | DIVIDE(SUM(actual_revenue), SUM(book_revenue_at_list)) where book_revenue_at_list = units_on_rent_days * book_day_rate per row — how much of the published rate is actually captured after discounts. |
Used by: Yard owner / general manager deciding which categories are working their capital hardest
Frequently asked questions
What's the difference between time utilization and dollar utilization?
Time utilization is rented days divided by available days — the share of calendar time a unit was on rent. Dollar utilization is rental revenue divided by acquisition cost — revenue earned per dollar invested in the fleet. A category can score high on time and low on dollars (busy but underpriced or cheap to own), which is exactly why owners need both side by side.
What is a good time utilization rate for a rental yard?
Most rental KPI guides put healthy fleet time utilization around 65–75%, with the best-run categories higher. Below that range usually signals overstock, slow return-to-ready turnaround, or soft demand rather than a pricing problem — read it alongside idle capital to tell which.
Why does realized vs book rate matter?
Book rate is your published day rate; realized rate is what you actually captured after discounts. The gap is pure margin leakage. A category with strong utilization but a low realized-vs-book rate is being discounted away, and it won't show up if you only watch utilization.
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 →