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 | Praelow Cameron | 123 | 16,625 | $11,139 | 135.2 mi | 64.9 mi | 7,977 | $5,345 | 135.2 |
48% excess
|
| 2 | Rozier Cole | 66 | 14,754 | $9,885 | 223.5 mi | 160.9 mi | 10,619 | $7,115 | 223.5 |
72% excess
|
| 3 | Michael Swingle | 63 | 12,837 | $8,601 | 203.8 mi | 166 mi | 10,456 | $7,006 | 203.8 |
81% excess
|
| 4 | Todd Fogiel | 84 | 8,457 | $5,666 | 100.7 mi | 29.8 mi | 2,499 | $1,674 | 100.7 |
30% excess
|
| 5 | Christopher Carroll | 22 | 7,727 | $5,177 | 351.2 mi | 318.6 mi | 7,009 | $4,696 | 351.2 |
91% excess
|
| 6 | Christopher Morning | 82 | 6,681 | $4,476 | 81.5 mi | 49.6 mi | 4,065 | $2,724 | 81.5 |
61% excess
|
| 7 | Joe Evans | 38 | 6,565 | $4,399 | 172.8 mi | 164 mi | 6,230 | $4,174 | 172.8 |
95% excess
|
| 8 | Eric Colon | 53 | 4,736 | $3,173 | 89.4 mi | 46.2 mi | 2,449 | $1,641 | 89.4 |
52% excess
|
| 9 | Xiraiyah Coston | 134 | 4,222 | $2,829 | 31.5 mi | 2.7 mi | 365 | $245 | 31.5 |
9% excess
|
| 10 | Philip Krogstad | 95 | 3,978 | $2,665 | 41.9 mi | 22.9 mi | 2,178 | $1,459 | 41.9 |
55% excess
|
| 11 | Michael Harris | 65 | 3,695 | $2,476 | 56.8 mi | 20.8 mi | 1,351 | $905 | 56.8 |
37% excess
|
| 12 | Chris Galasso | 77 | 2,855 | $1,913 | 37.1 mi | 7.8 mi | 602 | $403 | 37.1 |
21% excess
|
| 13 | Maximilian Tucker | 57 | 2,851 | $1,910 | 50 mi | 19.3 mi | 1,099 | $736 | 50 |
39% excess
|
| 14 | Side Kick Technician | 5 | 2,222 | $1,489 | 444.4 mi | 433.6 mi | 2,168 | $1,453 | 444.4 |
98% excess
|
| 15 | Pero Popovic | 37 | 2,024 | $1,356 | 54.7 mi | 40.6 mi | 1,502 | $1,006 | 54.7 |
74% excess
|
| 16 | Kevin Cogdill | 6 | 2,001 | $1,341 | 333.5 mi | 322.8 mi | 1,937 | $1,298 | 333.5 |
97% excess
|
| 17 | Ronnie Salone | 2 | 1,920 | $1,286 | 960.2 mi | 0 mi | 0 | $0 | 960 |
0% excess
|
| 18 | James Duff | 19 | 1,504 | $1,008 | 79.2 mi | 41.4 mi | 787 | $527 | 79.2 |
52% excess
|
| 19 | David Hernandez | 3 | 1,213 | $813 | 404.4 mi | 401.1 mi | 1,203 | $806 | 404.3 |
99% excess
|
| 20 | Yves Dessin | 2 | 1,014 | $679 | 507.2 mi | 498 mi | 996 | $667 | 507 |
98% excess
|
| 21 | Brandon Green | 12 | 592 | $397 | 49.3 mi | 0 mi | 0 | $0 | 49.3 |
0% excess
|
| 22 | Angel Rios | 1 | 393 | $263 | 393 mi | 373.7 mi | 374 | $251 | 393 |
95% excess
|
| 23 | Dustin Antolin | 4 | 389 | $261 | 97.2 mi | 23.7 mi | 95 | $64 | 97.3 |
24% excess
|
| 24 | Darrell Hope | 4 | 360 | $241 | 89.9 mi | 54.9 mi | 220 | $147 | 90 |
61% excess
|
| 25 | Curtis Allen | 8 | 343 | $230 | 42.8 mi | 7.3 mi | 58 | $39 | 42.9 |
17% excess
|
| 26 | Christopher Womack | 1 | 327 | $219 | 327.2 mi | 260.4 mi | 260 | $174 | 327 |
80% excess
|
| 27 | Matthew Sebzda | 4 | 237 | $159 | 59.2 mi | 49.4 mi | 198 | $133 | 59.3 |
84% excess
|
| 28 | David Trost | 1 | 161 | $108 | 161.5 mi | 57.4 mi | 57 | $38 | 161 |
35% excess
|
| 29 | Carlos Robles | 9 | 63 | $42 | 7 mi | 5.3 mi | 48 | $32 | 7 |
76% excess
|
| 30 | Mohamed Shareed | 1 | 41 | $27 | 41.1 mi | 3.8 mi | 4 | $3 | 41 |
10% excess
|