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 | Konstantin Barskiy | 407 | 343,392 | $230,073 | 843.7 mi | 815.2 mi | 331,774 | $222,289 | 843.7 |
97% excess
|
| 2 | Fady Messak | 390 | 188,560 | $126,335 | 483.5 mi | 406.5 mi | 158,554 | $106,231 | 483.5 |
84% excess
|
| 3 | Marvin Rivas | 316 | 143,774 | $96,329 | 455.0 mi | 167.5 mi | 52,929 | $35,462 | 455 |
37% excess
|
| 4 | Bennet O Dartey | 159 | 119,860 | $80,306 | 753.8 mi | 221.7 mi | 35,249 | $23,617 | 753.8 |
29% excess
|
| 5 | Yves Dessin | 263 | 118,563 | $79,437 | 450.8 mi | 431.9 mi | 113,589 | $76,105 | 450.8 |
96% excess
|
| 6 | Luis Iser | 482 | 111,031 | $74,391 | 230.4 mi | 203.6 mi | 98,153 | $65,763 | 230.4 |
88% excess
|
| 7 | Philmon Mehari | 244 | 106,872 | $71,604 | 438.0 mi | 379.6 mi | 92,624 | $62,058 | 438 |
87% excess
|
| 8 | Natosha Beierschmitt | 105 | 105,497 | $70,683 | 1004.7 mi | 949.8 mi | 99,819 | $66,879 | 1004.7 |
95% excess
|
| 9 | Ryan Lewis | 221 | 101,528 | $68,024 | 459.4 mi | 312.7 mi | 69,105 | $46,300 | 459.4 |
68% excess
|
| 10 | Kevin Cogdill | 304 | 89,620 | $60,045 | 294.8 mi | 280.8 mi | 85,363 | $57,193 | 294.8 |
95% excess
|
| 11 | Praelow Cameron | 365 | 80,250 | $53,768 | 219.9 mi | 164.3 mi | 59,965 | $40,177 | 219.9 |
75% excess
|
| 12 | Nkosi Wilson | 174 | 73,969 | $49,559 | 425.1 mi | 396.1 mi | 68,916 | $46,174 | 425.1 |
93% excess
|
| 13 | Carlos Puebla | 133 | 72,250 | $48,408 | 543.2 mi | 228.9 mi | 30,448 | $20,400 | 543.2 |
42% excess
|
| 14 | Eric Mancerella | 225 | 68,541 | $45,922 | 304.6 mi | 204.0 mi | 45,901 | $30,754 | 304.6 |
67% excess
|
| 15 | Fernando Lemos | 67 | 63,940 | $42,840 | 954.3 mi | 908.4 mi | 60,864 | $40,779 | 954.3 |
95% excess
|
| 16 | Raymond Ebanks | 398 | 61,096 | $40,934 | 153.5 mi | 135.6 mi | 53,951 | $36,147 | 153.5 |
88% excess
|
| 17 | Davon Cox | 191 | 58,104 | $38,930 | 304.2 mi | 245.6 mi | 46,914 | $31,432 | 304.2 |
81% excess
|
| 18 | Christopher Carroll | 116 | 56,474 | $37,838 | 486.8 mi | 445.7 mi | 51,706 | $34,643 | 486.8 |
92% excess
|
| 19 | Minh Huynh | 58 | 55,985 | $37,510 | 965.3 mi | 945.0 mi | 54,812 | $36,724 | 965.3 |
98% excess
|
| 20 | Paul Mccormish | 217 | 55,228 | $37,003 | 254.5 mi | 80.5 mi | 17,465 | $11,702 | 254.5 |
32% excess
|
| 21 | Andrew Przybyla | 149 | 51,665 | $34,616 | 346.7 mi | 309.8 mi | 46,166 | $30,931 | 346.7 |
89% excess
|
| 22 | Joe Evans | 288 | 49,435 | $33,121 | 171.7 mi | 161.0 mi | 46,363 | $31,063 | 171.6 |
94% excess
|
| 23 | Allan Klus | 240 | 48,972 | $32,811 | 204.0 mi | 61.6 mi | 14,792 | $9,911 | 204.1 |
30% excess
|
| 24 | Fady Khouzam | 135 | 48,524 | $32,511 | 359.4 mi | 315.2 mi | 42,546 | $28,506 | 359.4 |
88% excess
|
| 25 | Kenneth Lancara | 536 | 47,219 | $31,637 | 88.1 mi | 59.5 mi | 31,909 | $21,379 | 88.1 |
68% excess
|
| 26 | Michael Swingle | 183 | 43,980 | $29,467 | 240.3 mi | 198.8 mi | 36,376 | $24,372 | 240.3 |
83% excess
|
| 27 | Joseph Nuovo | 314 | 43,506 | $29,149 | 138.6 mi | 51.8 mi | 16,274 | $10,904 | 138.6 |
37% excess
|
| 28 | Jim Kingery | 268 | 41,213 | $27,613 | 153.8 mi | 112.5 mi | 30,153 | $20,203 | 153.8 |
73% excess
|
| 29 | Patricia Gordon | 224 | 41,002 | $27,471 | 183.0 mi | 96.2 mi | 21,539 | $14,431 | 183 |
53% excess
|
| 30 | Shawn Kelley | 23 | 38,044 | $25,489 | 1654.1 mi | 1620.1 mi | 37,261 | $24,965 | 1654.1 |
98% excess
|