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 | Jon Kuehl | 104 | 8,571 | $5,743 | 82.4 mi | 50.5 mi | 5,252 | $3,519 | 82.4 |
61% excess
|
| 2 | VPD Bench | 13 | 8,497 | $5,693 | 653.6 mi | 612.1 mi | 7,957 | $5,331 | 653.6 |
94% excess
|
| 3 | Mike Huffman | 112 | 7,367 | $4,936 | 65.8 mi | 26.2 mi | 2,932 | $1,964 | 65.8 |
40% excess
|
| 4 | Bennet O Dartey | 32 | 5,785 | $3,876 | 180.8 mi | 91.8 mi | 2,938 | $1,968 | 180.8 |
51% excess
|
| 5 | Mark Stelter | 13 | 5,694 | $3,815 | 438.0 mi | 170.6 mi | 2,218 | $1,486 | 438 |
39% excess
|
| 6 | Shady Messak | 7 | 3,447 | $2,309 | 492.4 mi | 433.1 mi | 3,032 | $2,031 | 492.4 |
88% excess
|
| 7 | Fady Messak | 6 | 3,322 | $2,226 | 553.6 mi | 465.0 mi | 2,790 | $1,869 | 553.7 |
84% excess
|
| 8 | Jackson Reeves | 12 | 2,132 | $1,428 | 177.7 mi | 91.0 mi | 1,092 | $732 | 177.7 |
51% excess
|
| 9 | Alberto Galan | 4 | 1,975 | $1,323 | 493.7 mi | 443.2 mi | 1,773 | $1,188 | 493.8 |
90% excess
|
| 10 | Natosha Beierschmitt | 1 | 1,005 | $673 | 1005.3 mi | 988.2 mi | 988 | $662 | 1005 |
98% excess
|
| 11 | Christopher Ables | 1 | 941 | $630 | 941.1 mi | 924.6 mi | 925 | $620 | 941 |
98% excess
|
| 12 | Minh Huynh | 1 | 717 | $480 | 717.2 mi | 572.7 mi | 573 | $384 | 717 |
80% excess
|
| 13 | Paul Mccormish | 4 | 708 | $474 | 177.0 mi | 147.8 mi | 591 | $396 | 177 |
83% excess
|
| 14 | Philmon Mehari | 1 | 484 | $324 | 483.9 mi | 433.5 mi | 433 | $290 | 484 |
89% excess
|
| 15 | Lawrence Yoder | 10 | 433 | $290 | 43.3 mi | 0.0 mi | 0 | $0 | 43.3 |
0% excess
|
| 16 | Eric Mancerella | 1 | 334 | $224 | 333.7 mi | 231.9 mi | 232 | $155 | 334 |
69% excess
|
| 17 | Ben McClerklin | 2 | 256 | $172 | 128.0 mi | 128.0 mi | 256 | $172 | 128 |
100% excess
|
| 18 | Brandon Green | 1 | 165 | $111 | 164.6 mi | 148.7 mi | 149 | $100 | 165 |
90% excess
|