Idle inventory is the quietest cost a rental yard carries: units that cost real money to own, sitting on the yard earning nothing. This dashboard puts a dollar figure on idle capital, ages it, and shows which categories and branches are overstocked — the redeployment and sell-off signal in one screen.
What this report answers
The snapshot answers the question that never gets a clean number: how much of our fleet capital is idle right now, and where is it? Idle Capital is the acquisition-cost dollars of units currently available but not on rent. Idle Fleet % comes two ways — by unit count and by dollars — because ten cheap tools idle is a different problem than one idle boom lift. Down-for-Repair Capital separates units that are idle by choice from units that are stuck in the shop. The status stacked bar (On Rent / Available Idle / Down for Repair / In Transit) by asset class shows the live shape of the fleet.
The metrics that matter
Idle Fleet % by dollars is the one to watch — it weights idle units by what they cost, so a single idle aerial lift outranks a rack of idle hand tools. The idle-stock aging chart (0–7, 8–30, 31–60, 61+ days) tells you whether idle is normal between-rental churn or genuinely dead stock; capital idle past 60 days is the redeploy-or-sell list. Down-for-Repair Capital, read next to the maintenance report, shows how much earning capacity the shop is holding hostage.
Why the data is trapped
Unit status lives in the rental ERP — Point of Rental, Texada, Quipli, Alert EasyPro — and acquisition cost lives in QuickBooks. The ERP can list which units are available, but it can't tell you that the available pile represents a large slice of fleet capital, because it doesn't carry the cost. So idle drag stays invisible until year-end, when someone finally notices a category that hasn't moved.
How to read it
Lead with Idle Fleet % by dollars and the idle-by-asset-class bar to see where dead money concentrates, then go to the aging chart. Capital in the 0–30 day bands is normal turnover; the 61+ band is the action list — redeploy to a busier branch or sell. The idle-by-branch bar flags overstocked locations, the redeployment opportunity a regional manager wants. Keep Down-for-Repair Capital in view so you don't confuse a shop backlog with genuine overstock.
The sample uses fully synthetic, anonymized data — no real units, costs, or branches.
Metrics it tracks
| Metric | What it means |
|---|---|
| Idle Capital ($) | SUM(idle_acquisition_cost) — acquisition dollars of units currently sitting idle/available on the yard (column is acquisition_cost when idle else 0). |
| Idle Unit Count | SUM(idle_flag) — count of units in the 'Available Idle' state (integer 1/0 flag summed). |
| Idle Fleet % (units) | DIVIDE(SUM(idle_flag), SUM(total_units)) — share of the fleet, by unit count, sitting idle (both numerator and denominator are integer counts). |
| Idle Fleet % (dollars) | DIVIDE(SUM(idle_acquisition_cost), SUM(acquisition_cost)) — share of fleet capital that is idle, weighted by acquisition cost. |
| Down-for-Repair Capital ($) | SUM(down_acquisition_cost) — acquisition dollars of units down for repair (column is acquisition_cost when down else 0), a plain SUM. |
Used by: Yard manager managing dead stock and the regional manager spotting redeployment opportunities
Frequently asked questions
How do you measure idle inventory at a rental yard?
Two ways, and you need both: by unit count (the share of the fleet sitting available) and by dollars (idle acquisition cost over total acquisition cost). The dollar measure matters more because it weights idle units by what they cost — one idle boom lift outranks a shelf of idle hand tools.
What counts as idle versus down for repair?
Idle (Available Idle) means a unit is ready to rent but sitting on the yard — capital you could be earning on. Down for Repair means it's in the shop and can't rent at all. The report separates them so a shop backlog doesn't get mistaken for overstock, and vice versa.
How long should equipment sit idle before it's a problem?
Some idle is normal churn between rentals — the 0–30 day bands. Capital that ages past 60 days idle is the flag: it usually means that branch is overstocked in that category, and the unit is a candidate to redeploy to a busier location or 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 →