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 | Nkosi Wilson | 35 | 22,067 | $14,785 | 630.5 mi | 609.7 mi | 21,338 | $14,296 | 630.5 |
97% excess
|
| 2 | Fady Khouzam | 21 | 11,665 | $7,816 | 555.5 mi | 509.5 mi | 10,699 | $7,168 | 555.5 |
92% excess
|
| 3 | Carlos Puebla | 17 | 11,011 | $7,377 | 647.7 mi | 257.3 mi | 4,374 | $2,931 | 647.7 |
40% excess
|
| 4 | Philmon Mehari | 29 | 9,878 | $6,618 | 340.6 mi | 293.5 mi | 8,512 | $5,703 | 340.6 |
86% excess
|
| 5 | Paul Mccormish | 36 | 7,179 | $4,810 | 199.4 mi | 34.5 mi | 1,243 | $833 | 199.4 |
17% excess
|
| 6 | Bennet O Dartey | 4 | 5,266 | $3,528 | 1316.5 mi | 155.2 mi | 621 | $416 | 1316.5 |
12% excess
|
| 7 | Fady Messak | 14 | 5,159 | $3,457 | 368.5 mi | 333.8 mi | 4,674 | $3,132 | 368.5 |
91% excess
|
| 8 | Rodney Charles | 14 | 3,901 | $2,614 | 278.6 mi | 205.1 mi | 2,871 | $1,924 | 278.6 |
74% excess
|
| 9 | Jared Heisler | 38 | 2,552 | $1,710 | 67.2 mi | 1.8 mi | 67 | $45 | 67.2 |
3% excess
|
| 10 | Luis Iser | 13 | 2,060 | $1,380 | 158.5 mi | 145.3 mi | 1,889 | $1,266 | 158.5 |
92% excess
|
| 11 | Rick Charles | 39 | 1,501 | $1,006 | 38.5 mi | 8.2 mi | 319 | $214 | 38.5 |
21% excess
|
| 12 | Jason Yenser | 23 | 1,498 | $1,004 | 65.1 mi | 38.8 mi | 893 | $598 | 65.1 |
60% excess
|
| 13 | Jackson Reeves | 18 | 1,476 | $989 | 82.0 mi | 48.3 mi | 870 | $583 | 82 |
59% excess
|
| 14 | Allan Klus | 20 | 1,391 | $932 | 69.6 mi | 20.5 mi | 411 | $275 | 69.6 |
30% excess
|
| 15 | Patricia Gordon | 10 | 1,382 | $926 | 138.2 mi | 38.3 mi | 383 | $257 | 138.2 |
28% excess
|
| 16 | Eric Mancerella | 10 | 1,092 | $732 | 109.2 mi | 28.4 mi | 284 | $190 | 109.2 |
26% excess
|
| 17 | Bruce Ballard | 3 | 1,050 | $704 | 350.0 mi | 209.5 mi | 628 | $421 | 350 |
60% excess
|
| 18 | Ryan Lewis | 4 | 1,037 | $695 | 259.2 mi | 163.7 mi | 655 | $439 | 259.3 |
63% excess
|
| 19 | Derick Velazquez | 4 | 977 | $655 | 244.2 mi | 210.8 mi | 843 | $565 | 244.3 |
86% excess
|
| 20 | Joseph Nuovo | 10 | 900 | $603 | 90.0 mi | 28.7 mi | 287 | $192 | 90 |
32% excess
|
| 21 | Fanfan Siku | 7 | 796 | $533 | 113.8 mi | 76.0 mi | 532 | $356 | 113.7 |
67% excess
|
| 22 | Bryan Rodriguez | 12 | 651 | $436 | 54.3 mi | 37.6 mi | 451 | $302 | 54.3 |
69% excess
|
| 23 | Shady Messak | 13 | 620 | $415 | 47.7 mi | 31.4 mi | 408 | $273 | 47.7 |
66% excess
|
| 24 | Raymond Ebanks | 5 | 589 | $395 | 117.8 mi | 34.1 mi | 170 | $114 | 117.8 |
29% excess
|
| 25 | Michael Steencken | 6 | 584 | $391 | 97.3 mi | 69.0 mi | 414 | $277 | 97.3 |
71% excess
|
| 26 | April Nuovo | 8 | 529 | $354 | 66.1 mi | 13.0 mi | 104 | $70 | 66.1 |
20% excess
|
| 27 | Jeffrey Coles | 6 | 497 | $333 | 82.9 mi | 29.3 mi | 176 | $118 | 82.8 |
35% excess
|
| 28 | Vivian Hyde | 17 | 486 | $326 | 28.6 mi | 12.7 mi | 217 | $145 | 28.6 |
45% excess
|
| 29 | Joe Hudson | 3 | 347 | $232 | 115.7 mi | 51.9 mi | 156 | $105 | 115.7 |
45% excess
|
| 30 | Marvin Rivas | 21 | 210 | $141 | 10.0 mi | 0.0 mi | 0 | $0 | 10 |
0% excess
|