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 | Anthony Wright | 161 | 13,151 | $8,811 | 81.7 mi | 50.7 mi | 8,155 | $5,464 | 81.7 |
62% excess
|
| 2 | Yves Dessin | 64 | 7,466 | $5,002 | 116.7 mi | 85.3 mi | 5,462 | $3,660 | 116.7 |
73% excess
|
| 3 | Joseph Anderson | 82 | 4,877 | $3,268 | 59.5 mi | 33.0 mi | 2,710 | $1,816 | 59.5 |
56% excess
|
| 4 | Elkin Barahona | 117 | 3,371 | $2,259 | 28.8 mi | 14.4 mi | 1,689 | $1,132 | 28.8 |
50% excess
|
| 5 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 6 | Dylan Ingraham | 8 | 1,726 | $1,156 | 215.8 mi | 133.6 mi | 1,069 | $716 | 215.8 |
62% excess
|
| 7 | Robert Rivera | 33 | 1,043 | $699 | 31.6 mi | 10.1 mi | 332 | $222 | 31.6 |
32% excess
|
| 8 | Megan Allen | 1 | 1,030 | $690 | 1029.7 mi | 991.3 mi | 991 | $664 | 1030 |
96% excess
|
| 9 | Craig Walker | 2 | 301 | $202 | 150.7 mi | 4.2 mi | 8 | $5 | 150.5 |
3% excess
|
| 10 | Ray Andreu | 4 | 66 | $44 | 16.6 mi | 8.8 mi | 35 | $23 | 16.5 |
53% excess
|
| 11 | Luis Iser | 2 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 12 | Derick Velazquez | 3 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|