Quantify excess travel cost and identify optimization opportunities across your field service operation
Top 30 techs by total miles driven. High total miles + high avg excess = overloaded tech being dispatched far. Low WO count + high miles = potential territory misalignment.
| # | Technician | WOs | Total Miles | Total Travel Cost | Avg Actual Dist | Avg Excess | Total Excess Miles | Avoidable Cost | Miles/WO Ratio | Travel Load |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Bennet O Dartey | 48 | 80,727 | $54,087 | 1681.8 mi | 237.5 mi | 11,401 | $7,639 | 1681.8 |
14% excess
|
| 2 | Carlos Puebla | 28 | 66,883 | $44,812 | 2388.7 mi | 967.7 mi | 27,097 | $18,155 | 2388.7 |
41% excess
|
| 3 | Marvin Rivas | 40 | 60,089 | $40,260 | 1502.2 mi | 46.5 mi | 1,861 | $1,247 | 1502.2 |
3% excess
|
| 4 | Paul Mccormish | 18 | 34,871 | $23,364 | 1937.3 mi | 414.3 mi | 7,457 | $4,996 | 1937.3 |
21% excess
|
| 5 | Ryan Lewis | 16 | 29,565 | $19,809 | 1847.8 mi | 1248.0 mi | 19,968 | $13,379 | 1847.8 |
68% excess
|
| 6 | Fady Khouzam | 10 | 22,275 | $14,924 | 2227.5 mi | 2037.5 mi | 20,375 | $13,651 | 2227.5 |
91% excess
|
| 7 | Fady Messak | 4 | 8,843 | $5,925 | 2210.7 mi | 1608.4 mi | 6,434 | $4,311 | 2210.8 |
73% excess
|
| 8 | Luis Iser | 1 | 2,179 | $1,460 | 2179.2 mi | 1576.9 mi | 1,577 | $1,057 | 2179 |
72% excess
|
| 9 | Angel Rios | 11 | 1,498 | $1,004 | 136.2 mi | 42.9 mi | 472 | $316 | 136.2 |
32% excess
|
| 10 | Omar Serrano | 5 | 1,106 | $741 | 221.1 mi | 150.4 mi | 752 | $504 | 221.2 |
68% excess
|
| 11 | Michael Russell | 85 | 1,029 | $689 | 12.1 mi | 0.0 mi | 0 | $0 | 12.1 |
0% excess
|
| 12 | Justin Armas | 7 | 736 | $493 | 105.2 mi | 0.0 mi | 0 | $0 | 105.1 |
0% excess
|
| 13 | Michah Brackett | 1 | 161 | $108 | 160.5 mi | 0.0 mi | 0 | $0 | 161 |
0% excess
|