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 | Fady Messak | 80 | 48,202 | $32,295 | 602.5 mi | 578.3 mi | 46,263 | $30,996 | 602.5 |
96% excess
|
| 2 | Jim Kingery | 140 | 34,173 | $22,896 | 244.1 mi | 165.7 mi | 23,197 | $15,542 | 244.1 |
68% excess
|
| 3 | Vincent Nyathi | 181 | 6,400 | $4,288 | 35.4 mi | 7.7 mi | 1,390 | $931 | 35.4 |
22% excess
|
| 4 | Scott R Roberts | 33 | 4,382 | $2,936 | 132.8 mi | 56.4 mi | 1,862 | $1,248 | 132.8 |
42% excess
|
| 5 | Phillip Castillo | 2 | 3,438 | $2,303 | 1718.8 mi | 1694.9 mi | 3,390 | $2,271 | 1719 |
99% excess
|
| 6 | Jackson Reeves | 70 | 2,975 | $1,993 | 42.5 mi | 0.2 mi | 14 | $9 | 42.5 |
0% excess
|
| 7 | Jon Kuehl | 27 | 2,431 | $1,629 | 90.0 mi | 12.8 mi | 345 | $231 | 90 |
14% excess
|
| 8 | Mike Huffman | 7 | 1,745 | $1,169 | 249.2 mi | 204.2 mi | 1,429 | $957 | 249.3 |
82% excess
|
| 9 | Minh Huynh | 2 | 1,526 | $1,022 | 762.8 mi | 733.8 mi | 1,468 | $984 | 763 |
96% excess
|
| 10 | Tyler Bollman | 1 | 1,469 | $984 | 1468.5 mi | 1339.0 mi | 1,339 | $897 | 1469 |
91% excess
|
| 11 | Luis Iser | 1 | 1,048 | $702 | 1048.5 mi | 1000.5 mi | 1,000 | $670 | 1048 |
95% excess
|
| 12 | Dustin Antolin | 2 | 653 | $438 | 326.3 mi | 0.0 mi | 0 | $0 | 326.5 |
0% excess
|
| 13 | Israel Martell | 1 | 642 | $430 | 642.2 mi | 617.8 mi | 618 | $414 | 642 |
96% excess
|
| 14 | Andre Samuda | 1 | 641 | $429 | 641.5 mi | 617.1 mi | 617 | $413 | 641 |
96% excess
|
| 15 | Philmon Mehari | 1 | 613 | $411 | 612.8 mi | 588.4 mi | 588 | $394 | 613 |
96% excess
|
| 16 | Bennet O Dartey | 4 | 499 | $334 | 124.7 mi | 86.2 mi | 345 | $231 | 124.8 |
69% excess
|
| 17 | Ryan Lewis | 1 | 403 | $270 | 403.4 mi | 379.1 mi | 379 | $254 | 403 |
94% excess
|
| 18 | Franco Jackson | 1 | 84 | $56 | 83.6 mi | 62.0 mi | 62 | $42 | 84 |
74% excess
|