Delivery is the line owners most often give away — and the operation that most often runs at a loss without anyone noticing. This dashboard tracks delivery and pickup revenue against its true cost, measures on-time performance, and times how fast returned units get back to rentable, the turnaround that frees capacity for the next rental.
What this report answers
The logistics page answers the dispatch manager's questions: is our freight covering its cost, are we delivering on time, and how fast are we turning units around? Transport Cost Recovery — transport revenue over transport cost — is the make-or-break number; below 100% you're subsidizing every delivery. On-Time Delivery Rate divides on-time jobs by driven deliveries (customer yard-pickups are excluded so they can't dilute it). Avg Turnaround is the hours from return to rentable-ready — the lever that converts the same fleet into more rentals.
The metrics that matter
Transport Cost Recovery is the one most yards have never measured, and it's frequently under 100% because delivery is used as a closing concession; seeing it by branch shows who's giving freight away. On-Time Delivery Rate is the service-quality read that protects repeat business with contractors who plan around a delivery window. Avg Turnaround by asset class is the hidden capacity metric — heavy gear takes longer to inspect and ready, and a slow turnaround means a unit sits unrentable even when demand is there.
Why the data is trapped
Delivery jobs, transport charges, on-time flags and turnaround live in the rental ERP and dispatch module — Point of Rental, Wynne, Texada, Alert EasyPro — while driver labor and fuel costs land in QuickBooks. Cost recovery is the join between the freight charge and what the run actually cost, and because the two sides sit in different systems, most yards never know whether delivery makes money or quietly loses it.
How to read it
Start with Transport Cost Recovery by branch — any branch under 100% is subsidizing deliveries, and that's a pricing fix. Read On-Time Rate next to protect the service reputation that keeps contractors loyal. Then use Avg Turnaround by asset class to find capacity hiding in the yard: shaving return-to-ready hours on your busiest heavy categories is the cheapest way to add rentable supply without buying a unit.
The sample uses fully synthetic, anonymized data — no real jobs, routes, or costs.
Metrics it tracks
| Metric | What it means |
|---|---|
| Delivery & Pickup Revenue ($) | SUM(transport_revenue) across all delivery/pickup jobs — the freight line owners often give away. |
| On-Time Delivery Rate % | DIVIDE(SUM(on_time_flag), SUM(delivery_count)) — share of driven jobs delivered within the promised window (denominator excludes customer-yard pickups so they can't dilute it). |
| Transport Cost Recovery % | DIVIDE(SUM(transport_revenue), SUM(transport_cost)) — how much of driver/fuel cost the delivery charge actually recovers. |
| Avg Turnaround (hours) | DIVIDE(SUM(turnaround_hours), SUM(job_count)) — total return-to-ready hours divided by jobs (how fast returned units get back on the rentable yard). |
| Job Count | SUM(job_count) — plain count of delivery/pickup job rows (job_count is integer 1 on every row). |
Used by: Yard / dispatch manager running drivers, on-time delivery and turnaround
Frequently asked questions
What is transport cost recovery at a rental yard?
It's delivery and pickup revenue divided by the driver and fuel cost of those runs. Below 100% you're subsidizing every delivery — common when freight is thrown in to close a rental. Tracking recovery by branch shows exactly where delivery is being given away and where pricing needs to change.
How should on-time delivery rate be calculated?
On-time jobs divided by driven deliveries — and the denominator should exclude customer yard-pickups, since those have no delivery window to hit and would otherwise dilute the rate. It's a SUM-over-SUM ratio of integer flags, so it stays honest across branches and asset classes.
Why does turnaround time matter for a rental yard?
Turnaround is the hours from a unit being returned to being rentable again. Every hour it sits in inspection or cleaning is capacity you can't rent. Trimming turnaround on your busiest heavy categories effectively adds supply without buying a single new unit — the cheapest capacity you can find.
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 →