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 | 34 | 2,478 | $1,660 | 72.9 mi | 61.8 mi | 2,101 | $1,408 | 72.9 |
85% excess
|
| 2 | Angel Rios | 14 | 1,010 | $677 | 72.2 mi | 39.8 mi | 557 | $373 | 72.1 |
55% excess
|
| 3 | Tim Holman | 13 | 614 | $411 | 47.2 mi | 8.6 mi | 111 | $74 | 47.2 |
18% excess
|
| 4 | Eric Colon | 3 | 509 | $341 | 169.5 mi | 121.9 mi | 366 | $245 | 169.7 |
72% excess
|
| 5 | Rene Yescas | 14 | 474 | $318 | 33.8 mi | 28.3 mi | 396 | $265 | 33.9 |
84% excess
|
| 6 | Michah Brackett | 1 | 440 | $295 | 440.4 mi | 0.0 mi | 0 | $0 | 440 |
0% excess
|
| 7 | Paul Bonang Jr | 3 | 413 | $277 | 137.5 mi | 46.7 mi | 140 | $94 | 137.7 |
34% excess
|
| 8 | Blake Ward | 4 | 390 | $261 | 97.5 mi | 17.7 mi | 71 | $48 | 97.5 |
18% excess
|
| 9 | Mike Huffman | 2 | 353 | $237 | 176.4 mi | 165.6 mi | 331 | $222 | 176.5 |
94% excess
|
| 10 | Omar Serrano | 4 | 320 | $214 | 80.0 mi | 15.1 mi | 60 | $40 | 80 |
19% excess
|
| 11 | Jon Kuehl | 6 | 307 | $206 | 51.1 mi | 41.6 mi | 250 | $168 | 51.2 |
81% excess
|
| 12 | Michael Swingle | 2 | 275 | $184 | 137.7 mi | 65.4 mi | 131 | $88 | 137.5 |
48% excess
|
| 13 | Michael Russell | 2 | 252 | $169 | 126.0 mi | 117.5 mi | 235 | $157 | 126 |
93% excess
|
| 14 | Anthony Wirth | 4 | 246 | $165 | 61.5 mi | 52.5 mi | 210 | $141 | 61.5 |
85% excess
|
| 15 | Anthony Wright | 2 | 238 | $159 | 119.1 mi | 112.5 mi | 225 | $151 | 119 |
95% excess
|
| 16 | Kevin Cox | 1 | 214 | $143 | 214.5 mi | 197.0 mi | 197 | $132 | 214 |
92% excess
|
| 17 | Philip Krogstad | 1 | 200 | $134 | 200.2 mi | 166.0 mi | 166 | $111 | 200 |
83% excess
|
| 18 | Darek Kirkpatrick | 2 | 184 | $123 | 91.9 mi | 10.6 mi | 21 | $14 | 92 |
11% excess
|
| 19 | Christopher Morning | 2 | 184 | $123 | 91.8 mi | 61.6 mi | 123 | $82 | 92 |
67% excess
|
| 20 | Chris Galasso | 3 | 176 | $118 | 58.5 mi | 55.5 mi | 166 | $111 | 58.7 |
94% excess
|
| 21 | Justin Armas | 2 | 175 | $117 | 87.7 mi | 69.8 mi | 140 | $94 | 87.5 |
80% excess
|
| 22 | Thomas J Langenberg Jr | 1 | 172 | $115 | 171.9 mi | 63.1 mi | 63 | $42 | 172 |
37% excess
|
| 23 | Pero Popovic | 1 | 161 | $108 | 160.7 mi | 136.0 mi | 136 | $91 | 161 |
84% excess
|
| 24 | Jordan Moceri | 1 | 148 | $99 | 147.5 mi | 137.4 mi | 137 | $92 | 148 |
93% excess
|
| 25 | Tyler Bollman | 9 | 130 | $87 | 14.5 mi | 6.6 mi | 60 | $40 | 14.4 |
46% excess
|
| 26 | Elkin Barahona | 4 | 115 | $77 | 28.8 mi | 9.4 mi | 38 | $25 | 28.8 |
33% excess
|
| 27 | Jason Morris | 3 | 104 | $70 | 34.8 mi | 25.5 mi | 77 | $52 | 34.7 |
74% excess
|
| 28 | Mark Franks | 1 | 103 | $69 | 103.0 mi | 95.4 mi | 95 | $64 | 103 |
92% excess
|
| 29 | Luis Torres | 3 | 100 | $67 | 33.3 mi | 0.0 mi | 0 | $0 | 33.3 |
0% excess
|
| 30 | Kenneth Lancara | 1 | 100 | $67 | 100.3 mi | 58.8 mi | 59 | $40 | 100 |
59% excess
|