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 | Christopher Carroll | 32 | 18,851 | $12,630 | 589.1 mi | 556.1 mi | 17,794 | $11,922 | 589.1 |
94% excess
|
| 2 | Patricia Gordon | 149 | 14,255 | $9,551 | 95.7 mi | 33.2 mi | 4,943 | $3,312 | 95.7 |
35% excess
|
| 3 | Praelow Cameron | 89 | 8,941 | $5,990 | 100.5 mi | 48.9 mi | 4,355 | $2,918 | 100.5 |
49% excess
|
| 4 | Christopher Morning | 125 | 7,072 | $4,738 | 56.6 mi | 25.3 mi | 3,159 | $2,117 | 56.6 |
45% excess
|
| 5 | Todd Fogiel | 97 | 6,796 | $4,553 | 70.1 mi | 5.9 mi | 574 | $385 | 70.1 |
8% excess
|
| 6 | Marvin Rivas | 6 | 6,368 | $4,267 | 1061.4 mi | 998.8 mi | 5,993 | $4,015 | 1061.3 |
94% excess
|
| 7 | Eric Colon | 50 | 5,284 | $3,540 | 105.7 mi | 62.1 mi | 3,103 | $2,079 | 105.7 |
59% excess
|
| 8 | Rozier Cole | 35 | 4,819 | $3,229 | 137.7 mi | 31.0 mi | 1,084 | $726 | 137.7 |
22% excess
|
| 9 | Bruce Ballard | 14 | 3,276 | $2,195 | 234.0 mi | 216.0 mi | 3,025 | $2,027 | 234 |
92% excess
|
| 10 | Fady Messak | 8 | 3,271 | $2,192 | 408.9 mi | 297.8 mi | 2,382 | $1,596 | 408.9 |
73% excess
|
| 11 | Michael Swingle | 10 | 2,860 | $1,916 | 286.0 mi | 253.0 mi | 2,530 | $1,695 | 286 |
88% excess
|
| 12 | Natosha Beierschmitt | 2 | 2,179 | $1,460 | 1089.3 mi | 937.0 mi | 1,874 | $1,256 | 1089.5 |
86% excess
|
| 13 | Minh Huynh | 3 | 2,009 | $1,346 | 669.6 mi | 638.6 mi | 1,916 | $1,284 | 669.7 |
95% excess
|
| 14 | Ryan Lewis | 6 | 1,374 | $921 | 229.1 mi | 130.9 mi | 785 | $526 | 229 |
57% excess
|
| 15 | Brendan Chaney | 1 | 365 | $245 | 364.8 mi | 344.2 mi | 344 | $230 | 365 |
94% excess
|