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 | Bennet O Dartey | 32 | 5,785 | $3,876 | 180.8 mi | 91.8 mi | 2,938 | $1,968 | 180.8 |
51% excess
|
| 2 | Shady Messak | 7 | 3,447 | $2,309 | 492.4 mi | 433.1 mi | 3,032 | $2,031 | 492.4 |
88% excess
|
| 3 | Fady Messak | 6 | 3,322 | $2,226 | 553.6 mi | 465.0 mi | 2,790 | $1,869 | 553.7 |
84% excess
|
| 4 | Jackson Reeves | 12 | 2,132 | $1,428 | 177.7 mi | 91.0 mi | 1,092 | $732 | 177.7 |
51% excess
|
| 5 | Alberto Galan | 4 | 1,975 | $1,323 | 493.7 mi | 443.2 mi | 1,773 | $1,188 | 493.8 |
90% excess
|
| 6 | Paul Mccormish | 4 | 708 | $474 | 177.0 mi | 147.8 mi | 591 | $396 | 177 |
83% excess
|
| 7 | Philmon Mehari | 1 | 484 | $324 | 483.9 mi | 433.5 mi | 433 | $290 | 484 |
89% excess
|
| 8 | Eric Mancerella | 1 | 334 | $224 | 333.7 mi | 231.9 mi | 232 | $155 | 334 |
69% excess
|
| 9 | Mike Huffman | 3 | 316 | $212 | 105.3 mi | 23.0 mi | 69 | $46 | 105.3 |
22% excess
|