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 | Philmon Mehari | 23 | 32,986 | $22,101 | 1434.2 mi | 1303.5 mi | 29,981 | $20,087 | 1434.2 |
91% excess
|
| 2 | Eric Mancerella | 32 | 27,396 | $18,355 | 856.1 mi | 698.2 mi | 22,344 | $14,970 | 856.1 |
82% excess
|
| 3 | Davon Cox | 20 | 22,308 | $14,946 | 1115.4 mi | 1078.1 mi | 21,562 | $14,447 | 1115.4 |
97% excess
|
| 4 | Fady Messak | 37 | 14,016 | $9,391 | 378.8 mi | 295.8 mi | 10,944 | $7,332 | 378.8 |
78% excess
|
| 5 | Konstantin Barskiy | 7 | 7,281 | $4,878 | 1040.1 mi | 970.6 mi | 6,794 | $4,552 | 1040.1 |
93% excess
|
| 6 | Ryan Lewis | 27 | 5,573 | $3,734 | 206.4 mi | 69.3 mi | 1,871 | $1,254 | 206.4 |
34% excess
|
| 7 | Bennet O Dartey | 12 | 5,271 | $3,532 | 439.3 mi | 268.3 mi | 3,220 | $2,157 | 439.3 |
61% excess
|
| 8 | Jared Heisler | 11 | 4,464 | $2,991 | 405.8 mi | 339.2 mi | 3,731 | $2,500 | 405.8 |
84% excess
|
| 9 | Joseph Nuovo | 26 | 4,288 | $2,873 | 164.9 mi | 45.1 mi | 1,173 | $786 | 164.9 |
27% excess
|
| 10 | Fady Khouzam | 9 | 3,389 | $2,271 | 376.6 mi | 327.6 mi | 2,948 | $1,975 | 376.6 |
87% excess
|
| 11 | Marvin Rivas | 26 | 2,803 | $1,878 | 107.8 mi | 1.5 mi | 38 | $25 | 107.8 |
1% excess
|
| 12 | Jackson Reeves | 15 | 2,172 | $1,455 | 144.8 mi | 35.2 mi | 528 | $354 | 144.8 |
24% excess
|
| 13 | Patricia Gordon | 13 | 1,976 | $1,324 | 152 mi | 45.3 mi | 590 | $395 | 152 |
30% excess
|
| 14 | Allan Klus | 25 | 1,903 | $1,275 | 76.1 mi | 49.5 mi | 1,239 | $830 | 76.1 |
65% excess
|
| 15 | Bryan Rodriguez | 11 | 1,512 | $1,013 | 137.4 mi | 28.4 mi | 313 | $210 | 137.5 |
21% excess
|
| 16 | Rick Charles | 14 | 1,253 | $840 | 89.5 mi | 62.7 mi | 878 | $588 | 89.5 |
70% excess
|
| 17 | Bruce Ballard | 12 | 1,252 | $839 | 104.3 mi | 16.1 mi | 193 | $129 | 104.3 |
15% excess
|
| 18 | Paul Mccormish | 15 | 1,176 | $788 | 78.4 mi | 6.3 mi | 94 | $63 | 78.4 |
8% excess
|
| 19 | Darrell Hendrix | 9 | 1,082 | $725 | 120.2 mi | 90.4 mi | 814 | $545 | 120.2 |
75% excess
|
| 20 | Jeffrey Coles | 13 | 990 | $663 | 76.1 mi | 22.3 mi | 290 | $194 | 76.2 |
29% excess
|
| 21 | Michael Steencken | 11 | 979 | $656 | 89 mi | 64.2 mi | 707 | $474 | 89 |
72% excess
|
| 22 | Fanfan Siku | 6 | 900 | $603 | 150 mi | 43.4 mi | 260 | $174 | 150 |
29% excess
|
| 23 | Alberto Galan | 16 | 835 | $559 | 52.2 mi | 29.3 mi | 469 | $314 | 52.2 |
56% excess
|
| 24 | Jason Yenser | 11 | 670 | $449 | 60.9 mi | 26.3 mi | 289 | $194 | 60.9 |
43% excess
|
| 25 | Curtis Sprague | 2 | 475 | $318 | 237.6 mi | 167.3 mi | 335 | $224 | 237.5 |
71% excess
|
| 26 | Raymond Ebanks | 5 | 474 | $318 | 94.8 mi | 63.4 mi | 317 | $212 | 94.8 |
67% excess
|
| 27 | Rodney Charles | 12 | 416 | $279 | 34.7 mi | 15.1 mi | 181 | $121 | 34.7 |
44% excess
|
| 28 | Israel Martell | 17 | 404 | $271 | 23.7 mi | 11.9 mi | 203 | $136 | 23.8 |
50% excess
|
| 29 | Christopher Womack | 7 | 298 | $200 | 42.6 mi | 0 mi | 0 | $0 | 42.6 |
0% excess
|
| 30 | April Nuovo | 6 | 294 | $197 | 49 mi | 0.2 mi | 1 | $1 | 49 |
0% excess
|