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 | Jason Cunningham | 16 | 2,054 | $1,376 | 128.4 mi | 73.3 mi | 1,173 | $786 | 128.4 |
57% excess
|
| 2 | Tyler Bollman | 2 | 1,487 | $996 | 743.7 mi | 677.3 mi | 1,355 | $908 | 743.5 |
91% excess
|
| 3 | Blake Ward | 5 | 1,073 | $719 | 214.5 mi | 171.6 mi | 858 | $575 | 214.6 |
80% excess
|
| 4 | Anthony Wright | 5 | 546 | $366 | 109.1 mi | 81.1 mi | 406 | $272 | 109.2 |
74% excess
|
| 5 | Joseph Anderson | 8 | 412 | $276 | 51.5 mi | 24.8 mi | 199 | $133 | 51.5 |
48% excess
|
| 6 | Jordan Moceri | 4 | 395 | $265 | 98.8 mi | 72.6 mi | 290 | $194 | 98.8 |
73% excess
|
| 7 | Henry Holmes | 11 | 379 | $254 | 34.5 mi | 10.1 mi | 111 | $74 | 34.5 |
29% excess
|
| 8 | Ronnie Salone | 2 | 348 | $233 | 174.2 mi | 0.0 mi | 0 | $0 | 174 |
0% excess
|
| 9 | Chane Lacy | 4 | 292 | $196 | 72.9 mi | 0.0 mi | 0 | $0 | 73 |
0% excess
|
| 10 | Eric Colon | 3 | 256 | $172 | 85.4 mi | 30.1 mi | 90 | $60 | 85.3 |
35% excess
|
| 11 | Omar Serrano | 32 | 224 | $150 | 7.0 mi | 0.4 mi | 14 | $9 | 7 |
6% excess
|
| 12 | Arturo Diaz | 5 | 222 | $149 | 44.5 mi | 39.5 mi | 197 | $132 | 44.4 |
89% excess
|
| 13 | Christopher Morning | 4 | 206 | $138 | 51.5 mi | 8.8 mi | 35 | $23 | 51.5 |
17% excess
|
| 14 | Tim Holman | 18 | 202 | $135 | 11.2 mi | 0.0 mi | 0 | $0 | 11.2 |
0% excess
|
| 15 | Franco Jackson | 5 | 201 | $135 | 40.3 mi | 14.5 mi | 72 | $48 | 40.2 |
36% excess
|
| 16 | Praelow Cameron | 1 | 180 | $121 | 180.2 mi | 0.0 mi | 0 | $0 | 180 |
0% excess
|
| 17 | Brandon Green | 2 | 177 | $119 | 88.6 mi | 45.0 mi | 90 | $60 | 88.5 |
51% excess
|
| 18 | Todd Fogiel | 1 | 174 | $117 | 173.6 mi | 166.6 mi | 167 | $112 | 174 |
96% excess
|
| 19 | Elkin Barahona | 10 | 174 | $117 | 17.4 mi | 3.6 mi | 36 | $24 | 17.4 |
21% excess
|
| 20 | Christopher Womack | 4 | 171 | $115 | 42.9 mi | 6.7 mi | 27 | $18 | 42.8 |
16% excess
|
| 21 | Michael Harris | 4 | 166 | $111 | 41.6 mi | 0.0 mi | 0 | $0 | 41.5 |
0% excess
|
| 22 | Darek Kirkpatrick | 2 | 147 | $98 | 73.5 mi | 9.6 mi | 19 | $13 | 73.5 |
13% excess
|
| 23 | Dustin Antolin | 2 | 133 | $89 | 66.5 mi | 34.9 mi | 70 | $47 | 66.5 |
53% excess
|
| 24 | Jon Kuehl | 1 | 130 | $87 | 130.0 mi | 102.3 mi | 102 | $68 | 130 |
78% excess
|
| 25 | Justin Armas | 2 | 127 | $85 | 63.6 mi | 0.0 mi | 0 | $0 | 63.5 |
0% excess
|
| 26 | Paul Bonang Jr | 2 | 126 | $84 | 63.2 mi | 8.1 mi | 16 | $11 | 63 |
13% excess
|
| 27 | David Trost | 5 | 123 | $82 | 24.6 mi | 4.7 mi | 24 | $16 | 24.6 |
20% excess
|
| 28 | Lawrence Yoder | 2 | 105 | $70 | 52.7 mi | 0.0 mi | 0 | $0 | 52.5 |
0% excess
|
| 29 | Jason Morris | 2 | 99 | $66 | 49.5 mi | 0.0 mi | 0 | $0 | 49.5 |
0% excess
|
| 30 | Mohamed Shareed | 3 | 92 | $62 | 30.7 mi | 5.4 mi | 16 | $11 | 30.7 |
17% excess
|