Maintenance is where fleet ROI quietly disappears. A category can rent well and still lose money if it lives in the shop. This dashboard tracks repair spend against the revenue those units earned, so you can see which asset classes are bleeding margin and how much rentable capacity downtime is costing you.
What this report answers
The spend page answers the shop manager's and owner's shared question: how much are we spending on repairs, on what, and is it proportional to what those units earn? Total Maintenance Cost is the raw spend. Maintenance Cost % of Revenue puts it in context — repair dollars over the revenue those units generated — so a high-spend category that also earns a lot isn't unfairly flagged. Cost per Work Order is the average repair event. Downtime Days counts the rentable unit-days lost to the shop, i.e. capacity you couldn't rent.
The metrics that matter
Maintenance Cost % of Revenue is the drag metric — it's the share of earnings each category gives back in the shop, and read against fleet ROI it explains why a category with healthy utilization still underperforms. Downtime Days translates repairs into lost rentable capacity, which is the real cost of an unreliable category beyond the parts bill. The repair-type stacked bar (Scheduled PM, Hydraulics, Engine/Drivetrain, Tires & Tracks, Electrical, Damage-billable) shows whether spend is healthy preventive maintenance or reactive breakdown.
Why the data is trapped
Work orders and downtime are recorded in the rental ERP or a shop module — Point of Rental, Wynne, InTempo — while the revenue each unit earned and the parts costs reconcile in QuickBooks. Tying repair spend to the revenue the same unit produced spans both systems, so maintenance usually gets watched as a raw cost line rather than as a percentage of what the fleet earns — which is the only view that tells you whether a category is worth keeping.
How to read it
Lead with Maintenance Cost % of Revenue by asset class — the categories at the top are eating their earnings, and the worst of them belong on the sell list when you cross-check fleet ROI. Read Downtime Days next: a category with moderate spend but heavy downtime is costing you rentals you never see. The repair-type breakdown tells you the fix — heavy Scheduled PM is fine, while heavy Engine/Drivetrain or Hydraulics on older units is the signal to retire them.
The sample uses fully synthetic, anonymized data — no real units, work orders, or costs.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Maintenance Cost ($) | SUM(maintenance_cost) across all work orders in the period. |
| Maintenance Cost % of Revenue | DIVIDE(SUM(maintenance_cost), SUM(unit_rental_revenue)) — repair spend as a share of the revenue those units earned. |
| Cost per Work Order ($) | DIVIDE(SUM(maintenance_cost), SUM(work_orders)) — average dollars per repair event (work_orders is integer 1 on every row). |
| Downtime Days | SUM(downtime_days) — total unit-days lost to repair, i.e. lost rentable capacity. |
| Work Order Count | SUM(work_orders) — plain count of work order rows. |
Used by: Yard / shop manager controlling repair spend and the owner judging which categories bleed money
Frequently asked questions
What is a healthy maintenance cost percentage for rental equipment?
It's read as maintenance cost as a share of the revenue those units earned, and it varies sharply by category — heavy hydraulic and engine-driven classes run higher than hand tools. The point isn't a single benchmark but the comparison: a category whose maintenance % of revenue runs well above its peers is dragging margin and may belong on the sell list.
Why track downtime days, not just repair cost?
The parts bill is only half the cost of a breakdown. Downtime days count the rentable unit-days lost while equipment sits in the shop — capacity you couldn't rent. A category with modest repair spend but high downtime is quietly costing you rentals that never show up as an expense line.
How does maintenance connect to fleet ROI?
Directly. A unit can rent well and show positive rental ROI yet lose money once repair spend is netted out. Watching Maintenance Cost % of Revenue alongside fleet ROI explains why a high-utilization category can still underperform — and tells you which units to stop maintaining and sell.
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 →