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 | Tyler Bollman | 1 | 1,469 | $984 | 1468.5 mi | 1339 mi | 1,339 | $897 | 1469 |
91% excess
|
| 2 | Omar Serrano | 32 | 224 | $150 | 7 mi | 0.4 mi | 14 | $9 | 7 |
6% excess
|
| 3 | Tim Holman | 18 | 202 | $135 | 11.2 mi | 0 mi | 0 | $0 | 11.2 |
0% excess
|
| 4 | Brandon Green | 2 | 177 | $119 | 88.6 mi | 45 mi | 90 | $60 | 88.5 |
51% excess
|
| 5 | Ronnie Salone | 1 | 177 | $119 | 177.2 mi | 0 mi | 0 | $0 | 177 |
0% excess
|
| 6 | Dustin Antolin | 2 | 133 | $89 | 66.5 mi | 34.9 mi | 70 | $47 | 66.5 |
53% excess
|
| 7 | Jon Kuehl | 1 | 130 | $87 | 129.9 mi | 102.3 mi | 102 | $68 | 130 |
78% excess
|
| 8 | Justin Armas | 2 | 127 | $85 | 63.6 mi | 0 mi | 0 | $0 | 63.5 |
0% excess
|
| 9 | Paul Bonang Jr | 2 | 126 | $84 | 63.2 mi | 8.1 mi | 16 | $11 | 63 |
13% excess
|
| 10 | David Trost | 5 | 123 | $82 | 24.6 mi | 4.7 mi | 24 | $16 | 24.6 |
20% excess
|
| 11 | Anthony Wright | 1 | 121 | $81 | 121.1 mi | 101.4 mi | 101 | $68 | 121 |
83% excess
|
| 12 | Henry Holmes | 2 | 108 | $72 | 54.1 mi | 16.3 mi | 33 | $22 | 54 |
31% excess
|
| 13 | Lawrence Yoder | 2 | 105 | $70 | 52.7 mi | 0 mi | 0 | $0 | 52.5 |
0% excess
|
| 14 | Jason Morris | 2 | 99 | $66 | 49.5 mi | 0 mi | 0 | $0 | 49.5 |
0% excess
|
| 15 | Franco Jackson | 1 | 95 | $64 | 95.4 mi | 48.5 mi | 48 | $32 | 95 |
51% excess
|
| 16 | Mohamed Shareed | 2 | 80 | $54 | 39.9 mi | 6.2 mi | 12 | $8 | 40 |
15% excess
|
| 17 | Christopher Morning | 1 | 76 | $51 | 75.8 mi | 29.5 mi | 29 | $19 | 76 |
38% excess
|
| 18 | Darek Kirkpatrick | 1 | 63 | $42 | 62.8 mi | 0 mi | 0 | $0 | 63 |
0% excess
|
| 19 | Kwame Cobb | 3 | 62 | $42 | 20.8 mi | 14.1 mi | 42 | $28 | 20.7 |
68% excess
|
| 20 | Mike Huffman | 1 | 62 | $42 | 61.5 mi | 37.1 mi | 37 | $25 | 62 |
60% excess
|
| 21 | Joseph Anderson | 1 | 56 | $38 | 56 mi | 0 mi | 0 | $0 | 56 |
0% excess
|
| 22 | Elkin Barahona | 1 | 52 | $35 | 52.4 mi | 10 mi | 10 | $7 | 52 |
19% excess
|
| 23 | Jordan Moceri | 1 | 52 | $35 | 51.9 mi | 0 mi | 0 | $0 | 52 |
0% excess
|
| 24 | David Cavaco | 1 | 46 | $31 | 45.9 mi | 44.7 mi | 45 | $30 | 46 |
98% excess
|
| 25 | Nick O'Neill | 1 | 42 | $28 | 41.9 mi | 39.3 mi | 39 | $26 | 42 |
93% excess
|
| 26 | Erwin Forster | 2 | 37 | $25 | 18.4 mi | 0 mi | 0 | $0 | 18.5 |
0% excess
|
| 27 | Pete Ramos | 1 | 21 | $14 | 20.9 mi | 0 mi | 0 | $0 | 21 |
0% excess
|
| 28 | Arturo Diaz | 2 | 16 | $11 | 8.2 mi | 4.9 mi | 10 | $7 | 8 |
63% excess
|
| 29 | Vincent Nyathi | 1 | 12 | $8 | 12.4 mi | 1.5 mi | 1 | $1 | 12 |
8% excess
|
| 30 | Darrell Hope | 1 | 10 | $7 | 10.3 mi | 7.5 mi | 7 | $5 | 10 |
70% excess
|