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 | Jim Kingery | 260 | 40,205 | $26,937 | 154.6 mi | 113.0 mi | 29,385 | $19,688 | 154.6 |
73% excess
|
| 2 | Mike Huffman | 157 | 20,875 | $13,986 | 133.0 mi | 67.9 mi | 10,656 | $7,140 | 133 |
51% excess
|
| 3 | Jon Kuehl | 157 | 16,523 | $11,070 | 105.2 mi | 55.9 mi | 8,783 | $5,885 | 105.2 |
53% excess
|
| 4 | Scott R Roberts | 201 | 16,401 | $10,989 | 81.6 mi | 14.2 mi | 2,860 | $1,916 | 81.6 |
17% excess
|
| 5 | Andrew Przybyla | 11 | 15,669 | $10,498 | 1424.5 mi | 1299.3 mi | 14,292 | $9,576 | 1424.5 |
91% excess
|
| 6 | Dustin Antolin | 159 | 11,795 | $7,903 | 74.2 mi | 14.9 mi | 2,372 | $1,589 | 74.2 |
20% excess
|
| 7 | Mark Stelter | 136 | 10,411 | $6,975 | 76.5 mi | 16.4 mi | 2,232 | $1,495 | 76.6 |
21% excess
|
| 8 | Ronnie Salone | 124 | 10,232 | $6,855 | 82.5 mi | 24.4 mi | 3,027 | $2,028 | 82.5 |
30% excess
|
| 9 | Franco Jackson | 344 | 9,968 | $6,679 | 29.0 mi | 9.4 mi | 3,219 | $2,157 | 29 |
32% excess
|
| 10 | Brandon Green | 132 | 9,939 | $6,659 | 75.3 mi | 26.7 mi | 3,522 | $2,360 | 75.3 |
35% excess
|
| 11 | Vincent Nyathi | 177 | 9,521 | $6,379 | 53.8 mi | 25.6 mi | 4,529 | $3,034 | 53.8 |
48% excess
|
| 12 | Jordan Moceri | 117 | 9,215 | $6,174 | 78.8 mi | 48.6 mi | 5,684 | $3,808 | 78.8 |
62% excess
|
| 13 | Tyler Bollman | 4 | 5,782 | $3,874 | 1445.6 mi | 1330.6 mi | 5,322 | $3,566 | 1445.5 |
92% excess
|
| 14 | Michah Brackett | 4 | 5,394 | $3,614 | 1348.5 mi | 1096.4 mi | 4,385 | $2,938 | 1348.5 |
81% excess
|
| 15 | Teddie Bracken | 129 | 4,272 | $2,862 | 33.1 mi | 10.5 mi | 1,361 | $912 | 33.1 |
32% excess
|
| 16 | Chris Galasso | 4 | 2,780 | $1,863 | 695.0 mi | 507.5 mi | 2,030 | $1,360 | 695 |
73% excess
|
| 17 | Kevin Cox | 8 | 970 | $650 | 121.3 mi | 28.8 mi | 230 | $154 | 121.3 |
24% excess
|
| 18 | Ben McClerklin | 6 | 520 | $348 | 86.7 mi | 86.4 mi | 518 | $347 | 86.7 |
100% excess
|
| 19 | Praelow Cameron | 1 | 370 | $248 | 369.6 mi | 300.6 mi | 301 | $202 | 370 |
81% excess
|
| 20 | Lawrence Yoder | 7 | 324 | $217 | 46.3 mi | 0.0 mi | 0 | $0 | 46.3 |
0% excess
|
| 21 | Thomas J Langenberg Jr | 3 | 257 | $172 | 85.7 mi | 6.4 mi | 19 | $13 | 85.7 |
7% excess
|
| 22 | Todd Fogiel | 1 | 174 | $117 | 173.6 mi | 32.4 mi | 32 | $21 | 174 |
18% excess
|
| 23 | Blake Ward | 2 | 129 | $86 | 64.5 mi | 26.9 mi | 54 | $36 | 64.5 |
42% excess
|
| 24 | Philip Krogstad | 1 | 55 | $37 | 55.2 mi | 0.0 mi | 0 | $0 | 55 |
0% excess
|