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 | 88 | 7,407 | $4,963 | 84.2 mi | 54.3 mi | 4,781 | $3,203 | 84.2 |
65% excess
|
| 2 | Joseph Anderson | 54 | 3,525 | $2,362 | 65.3 mi | 38.7 mi | 2,090 | $1,400 | 65.3 |
59% excess
|
| 3 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 4 | Yves Dessin | 24 | 2,682 | $1,797 | 111.7 mi | 85.5 mi | 2,052 | $1,375 | 111.8 |
77% excess
|
| 5 | Elkin Barahona | 58 | 1,821 | $1,220 | 31.4 mi | 17.5 mi | 1,018 | $682 | 31.4 |
56% excess
|
| 6 | Dylan Ingraham | 8 | 1,726 | $1,156 | 215.8 mi | 133.6 mi | 1,069 | $716 | 215.8 |
62% excess
|
| 7 | Megan Allen | 1 | 1,030 | $690 | 1029.7 mi | 991.3 mi | 991 | $664 | 1030 |
96% excess
|
| 8 | Robert Rivera | 27 | 873 | $585 | 32.3 mi | 11.5 mi | 311 | $208 | 32.3 |
36% excess
|
| 9 | Craig Walker | 1 | 146 | $98 | 145.9 mi | 8.4 mi | 8 | $5 | 146 |
5% excess
|
| 10 | Ray Andreu | 2 | 54 | $36 | 27 mi | 17.6 mi | 35 | $23 | 27 |
65% excess
|