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 | 94 | 29,692 | $19,894 | 315.9 mi | 278.0 mi | 26,130 | $17,507 | 315.9 |
88% excess
|
| 2 | James Duff | 64 | 26,914 | $18,032 | 420.5 mi | 392.6 mi | 25,128 | $16,836 | 420.5 |
93% excess
|
| 3 | Yves Dessin | 71 | 15,200 | $10,184 | 214.1 mi | 185.2 mi | 13,148 | $8,809 | 214.1 |
87% excess
|
| 4 | Jason Cunningham | 97 | 15,110 | $10,124 | 155.8 mi | 111.8 mi | 10,844 | $7,265 | 155.8 |
72% excess
|
| 5 | Jon Kuehl | 126 | 14,749 | $9,882 | 117.1 mi | 64.1 mi | 8,076 | $5,411 | 117.1 |
55% excess
|
| 6 | Megan Allen | 9 | 13,206 | $8,848 | 1467.4 mi | 1442.7 mi | 12,984 | $8,699 | 1467.3 |
98% excess
|
| 7 | Anthony Wright | 161 | 13,151 | $8,811 | 81.7 mi | 50.7 mi | 8,155 | $5,464 | 81.7 |
62% excess
|
| 8 | Mike Huffman | 71 | 12,932 | $8,664 | 182.1 mi | 97.0 mi | 6,886 | $4,614 | 182.1 |
53% excess
|
| 9 | Michah Brackett | 44 | 12,803 | $8,578 | 291.0 mi | 128.5 mi | 5,653 | $3,788 | 291 |
44% excess
|
| 10 | Tyler Bollman | 89 | 11,918 | $7,985 | 133.9 mi | 99.9 mi | 8,893 | $5,958 | 133.9 |
75% excess
|
| 11 | Arturo Diaz | 96 | 11,639 | $7,798 | 121.2 mi | 91.9 mi | 8,820 | $5,909 | 121.2 |
76% excess
|
| 12 | Christopher Morning | 152 | 11,594 | $7,768 | 76.3 mi | 46.1 mi | 7,014 | $4,699 | 76.3 |
60% excess
|
| 13 | Jason Morris | 94 | 10,552 | $7,070 | 112.3 mi | 59.1 mi | 5,557 | $3,723 | 112.3 |
53% excess
|
| 14 | Omar Serrano | 189 | 9,941 | $6,660 | 52.6 mi | 33.7 mi | 6,363 | $4,263 | 52.6 |
64% excess
|
| 15 | Philip Krogstad | 169 | 9,480 | $6,352 | 56.1 mi | 39.8 mi | 6,721 | $4,503 | 56.1 |
71% excess
|
| 16 | Eric Colon | 106 | 9,246 | $6,195 | 87.2 mi | 42.5 mi | 4,506 | $3,019 | 87.2 |
49% excess
|
| 17 | Mohamed Shareed | 156 | 8,814 | $5,905 | 56.5 mi | 37.6 mi | 5,868 | $3,932 | 56.5 |
67% excess
|
| 18 | Joseph Anderson | 85 | 8,680 | $5,816 | 102.1 mi | 76.0 mi | 6,461 | $4,329 | 102.1 |
74% excess
|
| 19 | Zachary Stieben | 143 | 8,195 | $5,491 | 57.3 mi | 22.5 mi | 3,221 | $2,158 | 57.3 |
39% excess
|
| 20 | Edward Arias | 150 | 8,154 | $5,463 | 54.4 mi | 36.1 mi | 5,420 | $3,631 | 54.4 |
66% excess
|
| 21 | Chane Lacy | 101 | 7,902 | $5,294 | 78.2 mi | 46.4 mi | 4,691 | $3,143 | 78.2 |
59% excess
|
| 22 | Henry Holmes | 171 | 7,710 | $5,166 | 45.1 mi | 18.9 mi | 3,226 | $2,161 | 45.1 |
42% excess
|
| 23 | David Cavaco | 187 | 7,678 | $5,144 | 41.1 mi | 27.7 mi | 5,176 | $3,468 | 41.1 |
67% excess
|
| 24 | Anthony Wirth | 104 | 7,420 | $4,971 | 71.3 mi | 44.6 mi | 4,636 | $3,106 | 71.3 |
62% excess
|
| 25 | Dylan Ingraham | 86 | 7,346 | $4,922 | 85.4 mi | 42.3 mi | 3,639 | $2,438 | 85.4 |
50% excess
|
| 26 | Christopher Carroll | 34 | 7,336 | $4,915 | 215.8 mi | 173.2 mi | 5,888 | $3,945 | 215.8 |
80% excess
|
| 27 | Tim Holman | 144 | 7,130 | $4,777 | 49.5 mi | 20.5 mi | 2,947 | $1,974 | 49.5 |
41% excess
|
| 28 | Scott A Berry | 15 | 6,993 | $4,685 | 466.2 mi | 447.1 mi | 6,707 | $4,494 | 466.2 |
96% excess
|
| 29 | Michael Harris | 112 | 6,875 | $4,606 | 61.4 mi | 26.6 mi | 2,983 | $1,999 | 61.4 |
43% excess
|
| 30 | Vincent Nyathi | 112 | 6,862 | $4,598 | 61.3 mi | 33.3 mi | 3,731 | $2,500 | 61.3 |
54% excess
|