Overview
Revenue by month
Linehaul, fuel surcharge and accessorials
Key findings
Across all three years
Arrival vs scheduled time
Share of deliveries, all years
Arrivals are spread evenly from 3 hours early to 6 hours late. 44% land more than 2 hours late and average about 4 hours behind schedule.
Detention time per stop
Share of stops, all years
Trucks wait longer at delivery than at pickup. Across all stops that is about 49,800 hours beyond a standard 2 free hours.
On-time rate by month
Pickups vs deliveries
Both lines are flat for three years. Nothing has changed the result, so the cause is structural.
On-time delivery by segment
Lane economics
Click a column to sort. Net is revenue left after estimated fuel.
Trucks by model year
120 trucks in the fleet
65% of the fleet are 2015 models. Only 20 trucks are from 2018 or later.
Maintenance spend by type
Claims by incident type
Equipment damage costs the most. DOT violations have the highest preventable share, which points to hours-of-service and inspection compliance.
Drivers with repeat incidents
All years
Top 10 accounts
By revenue
Revenue by contract type
Dedicated, contract and spot customers all get the same on-time rate. Committed customers see no better service.
Data quality issues
Found while cleaning and joining the 14 tables
Method
How the figures were calculated