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 | 285 | 266,035 | $178,243 | 933.5 mi | 923.1 mi | 263,073 | $176,259 | 933.5 |
99% excess
|
| 2 | Luis Iser | 275 | 58,183 | $38,983 | 211.6 mi | 194.1 mi | 53,376 | $35,762 | 211.6 |
92% excess
|
| 3 | Raymond Ebanks | 240 | 40,754 | $27,305 | 169.8 mi | 159.5 mi | 38,269 | $25,640 | 169.8 |
94% excess
|
| 4 | Yves Dessin | 32 | 18,764 | $12,572 | 586.4 mi | 543.4 mi | 17,389 | $11,651 | 586.4 |
93% excess
|
| 5 | Kenneth Lancara | 38 | 13,047 | $8,741 | 343.3 mi | 300.4 mi | 11,415 | $7,648 | 343.3 |
87% excess
|
| 6 | Ryan Lewis | 26 | 11,413 | $7,647 | 439.0 mi | 433.1 mi | 11,260 | $7,544 | 439 |
99% excess
|
| 7 | Horace Barnes | 164 | 11,357 | $7,609 | 69.3 mi | 61.2 mi | 10,044 | $6,729 | 69.3 |
88% excess
|
| 8 | Derick Velazquez | 512 | 10,837 | $7,261 | 21.2 mi | 7.5 mi | 3,833 | $2,568 | 21.2 |
35% excess
|
| 9 | Fady Messak | 2 | 5,085 | $3,407 | 2542.5 mi | 310.6 mi | 621 | $416 | 2542.5 |
12% excess
|
| 10 | Robert Lewis | 315 | 2,672 | $1,790 | 8.5 mi | 2.1 mi | 652 | $437 | 8.5 |
24% excess
|
| 11 | Christopher Carroll | 2 | 2,514 | $1,684 | 1256.9 mi | 1152.3 mi | 2,305 | $1,544 | 1257 |
92% excess
|
| 12 | Luis Torres | 6 | 514 | $344 | 85.6 mi | 0.0 mi | 0 | $0 | 85.7 |
0% excess
|
| 13 | Michael Swingle | 1 | 427 | $286 | 427.2 mi | 384.3 mi | 384 | $257 | 427 |
90% excess
|
| 14 | Brandon Green | 1 | 133 | $89 | 132.8 mi | 45.7 mi | 46 | $31 | 133 |
35% excess
|
| 15 | Jason Cunningham | 2 | 86 | $58 | 43.0 mi | 0.0 mi | 0 | $0 | 43 |
0% excess
|
| 16 | Vincent Nyathi | 1 | 63 | $42 | 62.5 mi | 0.0 mi | 0 | $0 | 63 |
0% excess
|
| 17 | Elkin Barahona | 1 | 26 | $17 | 26.4 mi | 0.0 mi | 0 | $0 | 26 |
0% excess
|
| 18 | David Cavaco | 1 | 22 | $15 | 21.6 mi | 0.0 mi | 0 | $0 | 22 |
0% excess
|