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 | 351 | 331,300 | $221,971 | 943.9 mi | 929.5 mi | 326,268 | $218,600 | 943.9 |
98% excess
|
| 2 | Luis Iser | 460 | 85,717 | $57,430 | 186.3 mi | 164.2 mi | 75,553 | $50,621 | 186.3 |
88% excess
|
| 3 | Raymond Ebanks | 398 | 59,680 | $39,986 | 149.9 mi | 131.7 mi | 52,411 | $35,115 | 149.9 |
88% excess
|
| 4 | Fady Messak | 25 | 22,713 | $15,218 | 908.5 mi | 864.7 mi | 21,618 | $14,484 | 908.5 |
95% excess
|
| 5 | Robert Lewis | 539 | 18,260 | $12,234 | 33.9 mi | 7.9 mi | 4,255 | $2,851 | 33.9 |
23% excess
|
| 6 | Derick Velazquez | 602 | 15,031 | $10,071 | 25.0 mi | 9.9 mi | 5,953 | $3,989 | 25 |
40% excess
|
| 7 | Robert Rivera | 299 | 14,833 | $9,938 | 49.6 mi | 17.8 mi | 5,315 | $3,561 | 49.6 |
36% excess
|
| 8 | Philmon Mehari | 15 | 14,671 | $9,830 | 978.1 mi | 938.0 mi | 14,070 | $9,427 | 978.1 |
96% excess
|
| 9 | Kevin Cogdill | 47 | 13,913 | $9,322 | 296.0 mi | 272.2 mi | 12,793 | $8,571 | 296 |
92% excess
|
| 10 | Anthony Wright | 164 | 13,389 | $8,971 | 81.6 mi | 51.1 mi | 8,380 | $5,615 | 81.6 |
63% excess
|
| 11 | Horace Barnes | 197 | 12,589 | $8,435 | 63.9 mi | 53.4 mi | 10,526 | $7,052 | 63.9 |
84% excess
|
| 12 | Ryan Lewis | 27 | 11,864 | $7,949 | 439.4 mi | 433.2 mi | 11,696 | $7,836 | 439.4 |
99% excess
|
| 13 | Jared Heisler | 135 | 8,541 | $5,722 | 63.3 mi | 13.8 mi | 1,864 | $1,249 | 63.3 |
22% excess
|
| 14 | Joseph Anderson | 168 | 8,404 | $5,631 | 50.0 mi | 16.6 mi | 2,782 | $1,864 | 50 |
33% excess
|
| 15 | Yves Dessin | 66 | 7,895 | $5,290 | 119.6 mi | 89.0 mi | 5,876 | $3,937 | 119.6 |
74% excess
|
| 16 | Craig Walker | 217 | 5,865 | $3,930 | 27.0 mi | 2.8 mi | 611 | $409 | 27 |
10% excess
|
| 17 | Kenneth Lancara | 46 | 5,495 | $3,682 | 119.5 mi | 13.6 mi | 628 | $421 | 119.5 |
11% excess
|
| 18 | Marvin Rivas | 8 | 5,269 | $3,530 | 658.6 mi | 645.9 mi | 5,168 | $3,463 | 658.6 |
98% excess
|
| 19 | Rozier Cole | 13 | 4,522 | $3,030 | 347.8 mi | 121.6 mi | 1,580 | $1,059 | 347.8 |
35% excess
|
| 20 | Fady Khouzam | 4 | 3,668 | $2,458 | 917.1 mi | 878.3 mi | 3,513 | $2,354 | 917 |
96% excess
|
| 21 | Elkin Barahona | 123 | 3,513 | $2,354 | 28.6 mi | 14.0 mi | 1,727 | $1,157 | 28.6 |
49% excess
|
| 22 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 23 | Douglas Pearce | 2 | 3,093 | $2,072 | 1546.4 mi | 1532.2 mi | 3,064 | $2,053 | 1546.5 |
99% excess
|
| 24 | Ray Andreu | 111 | 3,088 | $2,069 | 27.8 mi | 0.3 mi | 35 | $23 | 27.8 |
1% excess
|
| 25 | Shady Messak | 3 | 2,748 | $1,841 | 916.1 mi | 910.0 mi | 2,730 | $1,829 | 916 |
99% excess
|
| 26 | Minh Huynh | 2 | 2,283 | $1,530 | 1141.3 mi | 1137.8 mi | 2,276 | $1,525 | 1141.5 |
100% excess
|
| 27 | Emmanuel Morales | 1 | 2,163 | $1,449 | 2162.7 mi | 2088.5 mi | 2,088 | $1,399 | 2163 |
97% excess
|
| 28 | Megan Allen | 2 | 2,152 | $1,442 | 1076.1 mi | 1036.5 mi | 2,073 | $1,389 | 1076 |
96% excess
|
| 29 | Dylan Ingraham | 9 | 2,067 | $1,385 | 229.7 mi | 129.2 mi | 1,163 | $779 | 229.7 |
56% excess
|
| 30 | Andre Samuda | 2 | 2,036 | $1,364 | 1018.0 mi | 943.6 mi | 1,887 | $1,264 | 1018 |
93% excess
|