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 | 120 | 51,686 | $34,630 | 430.7 mi | 380.4 mi | 45,648 | $30,584 | 430.7 |
88% excess
|
| 2 | Konstantin Barskiy | 100 | 50,668 | $33,948 | 506.7 mi | 469.2 mi | 46,918 | $31,435 | 506.7 |
93% excess
|
| 3 | Fady Messak | 109 | 44,294 | $29,677 | 406.4 mi | 337.4 mi | 36,777 | $24,641 | 406.4 |
83% excess
|
| 4 | Marvin Rivas | 165 | 42,483 | $28,464 | 257.5 mi | 141.2 mi | 23,291 | $15,605 | 257.5 |
55% excess
|
| 5 | Eric Mancerella | 114 | 37,744 | $25,288 | 331.1 mi | 222.3 mi | 25,343 | $16,980 | 331.1 |
67% excess
|
| 6 | Nkosi Wilson | 72 | 34,907 | $23,388 | 484.8 mi | 464.4 mi | 33,436 | $22,402 | 484.8 |
96% excess
|
| 7 | Davon Cox | 107 | 27,589 | $18,485 | 257.8 mi | 218.4 mi | 23,370 | $15,658 | 257.8 |
85% excess
|
| 8 | Ryan Lewis | 95 | 26,607 | $17,827 | 280.1 mi | 194.5 mi | 18,478 | $12,380 | 280.1 |
69% excess
|
| 9 | Bennet O Dartey | 66 | 22,691 | $15,203 | 343.8 mi | 201.7 mi | 13,310 | $8,918 | 343.8 |
59% excess
|
| 10 | Fady Khouzam | 103 | 19,020 | $12,743 | 184.7 mi | 159.7 mi | 16,453 | $11,024 | 184.7 |
87% excess
|
| 11 | Patricia Gordon | 123 | 18,088 | $12,119 | 147.1 mi | 75.2 mi | 9,249 | $6,197 | 147.1 |
51% excess
|
| 12 | Joseph Nuovo | 181 | 17,852 | $11,961 | 98.6 mi | 22.8 mi | 4,123 | $2,762 | 98.6 |
23% excess
|
| 13 | Derick Velazquez | 77 | 14,866 | $9,960 | 193.1 mi | 168.8 mi | 12,999 | $8,709 | 193.1 |
87% excess
|
| 14 | Jackson Reeves | 103 | 14,676 | $9,833 | 142.5 mi | 66.5 mi | 6,851 | $4,590 | 142.5 |
47% excess
|
| 15 | Bruce Ballard | 131 | 13,559 | $9,085 | 103.5 mi | 40.2 mi | 5,264 | $3,527 | 103.5 |
39% excess
|
| 16 | Paul Mccormish | 94 | 12,127 | $8,125 | 129 mi | 80.5 mi | 7,562 | $5,067 | 129 |
62% excess
|
| 17 | Jared Heisler | 102 | 10,405 | $6,971 | 102 mi | 51.1 mi | 5,213 | $3,493 | 102 |
50% excess
|
| 18 | Allan Klus | 138 | 9,695 | $6,496 | 70.3 mi | 28.3 mi | 3,905 | $2,616 | 70.3 |
40% excess
|
| 19 | Luis Iser | 113 | 9,677 | $6,484 | 85.6 mi | 63.4 mi | 7,161 | $4,798 | 85.6 |
74% excess
|
| 20 | April Nuovo | 124 | 8,436 | $5,652 | 68 mi | 13.4 mi | 1,660 | $1,112 | 68 |
20% excess
|
| 21 | Bryan Rodriguez | 97 | 7,991 | $5,354 | 82.4 mi | 32.5 mi | 3,155 | $2,114 | 82.4 |
39% excess
|
| 22 | Alberto Galan | 154 | 7,974 | $5,343 | 51.8 mi | 37.3 mi | 5,747 | $3,850 | 51.8 |
72% excess
|
| 23 | Raymond Ebanks | 79 | 7,595 | $5,089 | 96.1 mi | 64.1 mi | 5,062 | $3,392 | 96.1 |
67% excess
|
| 24 | Jason Yenser | 120 | 6,347 | $4,252 | 52.9 mi | 27.3 mi | 3,272 | $2,192 | 52.9 |
52% excess
|
| 25 | Fanfan Siku | 71 | 6,259 | $4,194 | 88.2 mi | 16.1 mi | 1,143 | $766 | 88.2 |
18% excess
|
| 26 | Rick Charles | 77 | 6,112 | $4,095 | 79.4 mi | 47.7 mi | 3,675 | $2,462 | 79.4 |
60% excess
|
| 27 | Rodney Charles | 67 | 5,961 | $3,994 | 89 mi | 43.9 mi | 2,940 | $1,970 | 89 |
49% excess
|
| 28 | Jeffrey Coles | 78 | 5,787 | $3,877 | 74.2 mi | 32.3 mi | 2,519 | $1,688 | 74.2 |
44% excess
|
| 29 | Michael Steencken | 87 | 5,664 | $3,795 | 65.1 mi | 32.9 mi | 2,865 | $1,920 | 65.1 |
51% excess
|
| 30 | Horace Barnes | 32 | 4,595 | $3,079 | 143.6 mi | 107.8 mi | 3,449 | $2,311 | 143.6 |
75% excess
|