Fleet Management KPI Dashboard

Vehicle Utilization & Asset Optimization — MetroServe Field Services (285 Assets, 3 Depots)

Last Updated: January 15, 2025 08:42 AM

Revenue-Gen Utilization

74.2%

↑ 3.1% vs Q4

Active Days / Asset / Mo

21.3

↑ 1.8 days

Idle Time %

19.4%

↓ 2.2% target

Empty Mile Ratio

13.7%

↓ 1.3% vs avg

Surplus Asset Count

Class 4 Vans

Load Factor per Trip

67.8%

↑ 4.2%

Deadhead Cost / Week

$8.2K

↑ $1.1K

Peak vs Off-Peak Spread

26%

18% target

Lease vs Own Util Gap

-8.3%

Lease underused

Right-Sizing Index

0.89

11% overcapacity

Revenue-Generating Utilization Trend (12 Weeks, by Asset Class)

Idle Time Pareto by Depot & Shift

Empty Mile Ratio by Route Cluster

Asset Utilization Detail (Top 24 Assets by Idle %)

Asset ID	Class	Depot	Util %	Active Days	Idle %	Empty Mi %	Status
VAN-2041	Class 4	West	48.2%	16	34.1%	18.7%	Surplus
VAN-2038	Class 4	West	51.3%	17	32.8%	17.2%	Surplus
TRK-1142	Class 5	North	55.9%	18	29.4%	16.3%	Review
VAN-2055	Class 4	Central	58.1%	19	27.9%	15.8%	Review
VAN-2047	Class 4	West	54.7%	18	27.3%	19.1%	Surplus
TRK-1156	Class 5	West	62.4%	20	25.6%	14.2%	Review
VAN-2029	Class 4	Central	59.8%	19	24.8%	13.9%	Review
VAN-2063	Class 4	North	66.2%	21	22.1%	12.4%	Review
TRK-1189	Class 5	Central	71.5%	22	19.8%	11.7%	Active
VAN-2071	Class 4	North	73.9%	23	18.3%	10.9%	Active

Load Factor by Route (Top 10)

Peak vs Off-Peak Utilization

Deadhead Cost Trend (8 Wks)

Lease vs Own Utilization

Surplus Assets by Class

Surplus Van Cluster Heatmap (Depot × Shift)

West

Central

North

Night

Red: ≥6 surplus | Yellow: 2-5 | Green: 0-1

Right-Sizing Index

Class 4 Vans 0.82

Class 5 Trucks 0.91

Class 6 Flatbeds 0.96

Portfolio 0.89

Target: ≥0.95 (5% buffer capacity)

Data Sources

Telematics: Geotab (last ping 08:37 AM)

Dispatch: RouteSync TMS

Lease Register: AssetTrack

Goals (Q3 2025)

Portfolio Utilization: ≥78%

Surplus Class 4 Vans: ≤6

Idle Time: ≤17%

Cost Impact

14 Surplus Vans: $186K/quarter

Target Savings: $124K/quarter

Depot West Idle: $38K/month waste