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 | Fernando Lemos | 33 | 60,810 | $40,743 | 1842.7 mi | 1836.7 mi | 60,611 | $40,609 | 1842.7 |
100% excess
|
| 2 | Yves Dessin | 82 | 55,072 | $36,898 | 671.6 mi | 660.9 mi | 54,197 | $36,312 | 671.6 |
98% excess
|
| 3 | Praelow Cameron | 104 | 27,838 | $18,651 | 267.7 mi | 215.4 mi | 22,404 | $15,011 | 267.7 |
80% excess
|
| 4 | Side Kick Technician | 60 | 23,374 | $15,661 | 389.6 mi | 380.2 mi | 22,815 | $15,286 | 389.6 |
98% excess
|
| 5 | Michael Swingle | 41 | 22,378 | $14,993 | 545.8 mi | 504.9 mi | 20,700 | $13,869 | 545.8 |
93% excess
|
| 6 | Ryan Lewis | 76 | 22,205 | $14,877 | 292.2 mi | 230.4 mi | 17,510 | $11,732 | 292.2 |
79% excess
|
| 7 | Christopher Carroll | 31 | 21,548 | $14,437 | 695.1 mi | 640.3 mi | 19,851 | $13,300 | 695.1 |
92% excess
|
| 8 | Mark Stelter | 24 | 19,138 | $12,822 | 797.4 mi | 745.7 mi | 17,897 | $11,991 | 797.4 |
94% excess
|
| 9 | Rozier Cole | 55 | 15,445 | $10,348 | 280.8 mi | 253.4 mi | 13,940 | $9,340 | 280.8 |
90% excess
|
| 10 | Kenneth Lancara | 19 | 10,382 | $6,956 | 546.4 mi | 538.6 mi | 10,234 | $6,857 | 546.4 |
99% excess
|
| 11 | Todd Fogiel | 57 | 8,381 | $5,615 | 147.0 mi | 60.7 mi | 3,462 | $2,320 | 147 |
41% excess
|
| 12 | Allan Klus | 106 | 6,466 | $4,332 | 61.0 mi | 20.8 mi | 2,208 | $1,479 | 61 |
34% excess
|
| 13 | Torre Gifford | 10 | 4,901 | $3,284 | 490.1 mi | 483.5 mi | 4,835 | $3,239 | 490.1 |
99% excess
|
| 14 | Xiraiyah Coston | 175 | 4,728 | $3,168 | 27.0 mi | 0.0 mi | 0 | $0 | 27 |
0% excess
|
| 15 | Patricia Gordon | 29 | 4,468 | $2,994 | 154.1 mi | 30.1 mi | 873 | $585 | 154.1 |
20% excess
|
| 16 | Jeffrey Coles | 31 | 3,794 | $2,542 | 122.4 mi | 75.5 mi | 2,339 | $1,567 | 122.4 |
62% excess
|
| 17 | Christopher Morning | 25 | 3,585 | $2,402 | 143.4 mi | 116.2 mi | 2,904 | $1,946 | 143.4 |
81% excess
|
| 18 | Fady Messak | 9 | 2,617 | $1,753 | 290.7 mi | 228.4 mi | 2,056 | $1,378 | 290.8 |
79% excess
|
| 19 | Michael Harris | 19 | 2,363 | $1,583 | 124.4 mi | 93.2 mi | 1,771 | $1,187 | 124.4 |
75% excess
|
| 20 | Natosha Beierschmitt | 2 | 2,176 | $1,458 | 1087.9 mi | 967.4 mi | 1,935 | $1,296 | 1088 |
89% excess
|
| 21 | Carlos Robles | 225 | 1,990 | $1,333 | 8.8 mi | 6.6 mi | 1,496 | $1,002 | 8.8 |
75% excess
|
| 22 | Jon Sanchez | 180 | 1,679 | $1,125 | 9.3 mi | 0.0 mi | 4 | $3 | 9.3 |
0% excess
|
| 23 | Saul Morales | 1 | 1,112 | $745 | 1112.2 mi | 1067.5 mi | 1,067 | $715 | 1112 |
96% excess
|
| 24 | Joe Hudson | 11 | 1,029 | $689 | 93.5 mi | 53.5 mi | 589 | $395 | 93.5 |
57% excess
|
| 25 | David Hernandez | 71 | 992 | $665 | 14.0 mi | 0.0 mi | 0 | $0 | 14 |
0% excess
|
| 26 | Rick Charles | 5 | 985 | $660 | 196.9 mi | 181.4 mi | 907 | $608 | 197 |
92% excess
|
| 27 | Fady Khouzam | 3 | 859 | $576 | 286.4 mi | 266.4 mi | 799 | $535 | 286.3 |
93% excess
|
| 28 | Raymond Ebanks | 1 | 756 | $507 | 755.6 mi | 629.8 mi | 630 | $422 | 756 |
83% excess
|
| 29 | Solomon Young | 15 | 514 | $344 | 34.2 mi | 17.5 mi | 262 | $176 | 34.3 |
51% excess
|
| 30 | Nkosi Wilson | 1 | 497 | $333 | 497.2 mi | 488.7 mi | 489 | $328 | 497 |
98% excess
|