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 | Andrew Przybyla | 20 | 28,436 | $19,052 | 1421.8 mi | 1330.1 mi | 26,603 | $17,824 | 1421.8 |
94% excess
|
| 2 | Mike Huffman | 76 | 23,758 | $15,918 | 312.6 mi | 214.0 mi | 16,261 | $10,895 | 312.6 |
68% excess
|
| 3 | Chris Galasso | 11 | 7,478 | $5,010 | 679.8 mi | 465.1 mi | 5,117 | $3,428 | 679.8 |
68% excess
|
| 4 | Tyler Bollman | 4 | 5,782 | $3,874 | 1445.6 mi | 1330.6 mi | 5,322 | $3,566 | 1445.5 |
92% excess
|
| 5 | Kevin Cox | 49 | 4,703 | $3,151 | 96.0 mi | 4.8 mi | 235 | $157 | 96 |
5% excess
|
| 6 | Franco Jackson | 17 | 4,262 | $2,856 | 250.7 mi | 129.2 mi | 2,197 | $1,472 | 250.7 |
52% excess
|
| 7 | Jon Kuehl | 28 | 3,950 | $2,647 | 141.1 mi | 54.2 mi | 1,517 | $1,016 | 141.1 |
38% excess
|
| 8 | Emmanuel Morales | 2 | 3,361 | $2,252 | 1680.3 mi | 1599.2 mi | 3,198 | $2,143 | 1680.5 |
95% excess
|
| 9 | Natosha Beierschmitt | 4 | 3,173 | $2,126 | 793.1 mi | 554.0 mi | 2,216 | $1,485 | 793.3 |
70% excess
|
| 10 | Vincent Nyathi | 18 | 2,815 | $1,886 | 156.4 mi | 91.2 mi | 1,642 | $1,100 | 156.4 |
58% excess
|
| 11 | Blake Ward | 28 | 2,514 | $1,684 | 89.8 mi | 18.4 mi | 516 | $346 | 89.8 |
21% excess
|
| 12 | Dustin Antolin | 6 | 2,336 | $1,565 | 389.3 mi | 256.4 mi | 1,538 | $1,030 | 389.3 |
66% excess
|
| 13 | Nicole Floyd | 8 | 2,095 | $1,404 | 261.9 mi | 257.8 mi | 2,062 | $1,382 | 261.9 |
98% excess
|
| 14 | Ronnie Salone | 6 | 2,016 | $1,351 | 336.0 mi | 311.7 mi | 1,870 | $1,253 | 336 |
93% excess
|
| 15 | Ed Danek | 1 | 1,779 | $1,192 | 1779.2 mi | 1775.9 mi | 1,776 | $1,190 | 1779 |
100% excess
|
| 16 | Israel Martell | 2 | 1,736 | $1,163 | 867.9 mi | 762.9 mi | 1,526 | $1,022 | 868 |
88% excess
|
| 17 | Minh Huynh | 2 | 1,723 | $1,154 | 861.3 mi | 850.7 mi | 1,701 | $1,140 | 861.5 |
99% excess
|
| 18 | Brandon Green | 4 | 1,530 | $1,025 | 382.4 mi | 200.5 mi | 802 | $537 | 382.5 |
52% excess
|
| 19 | Michah Brackett | 1 | 1,435 | $961 | 1434.5 mi | 1203.4 mi | 1,203 | $806 | 1435 |
84% excess
|
| 20 | Shawn Kelley | 1 | 878 | $588 | 878.1 mi | 769.9 mi | 770 | $516 | 878 |
88% excess
|
| 21 | Konstantin Barskiy | 1 | 734 | $492 | 734.2 mi | 167.8 mi | 168 | $113 | 734 |
23% excess
|
| 22 | Jackson Reeves | 4 | 559 | $375 | 139.7 mi | 133.3 mi | 533 | $357 | 139.8 |
95% excess
|
| 23 | Christopher Ables | 1 | 530 | $355 | 530.0 mi | 429.7 mi | 430 | $288 | 530 |
81% excess
|
| 24 | Bennet O Dartey | 15 | 378 | $253 | 25.2 mi | 8.2 mi | 123 | $82 | 25.2 |
33% excess
|
| 25 | Mark Stelter | 1 | 124 | $83 | 124.3 mi | 13.7 mi | 14 | $9 | 124 |
11% excess
|
| 26 | Ben McClerklin | 3 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|