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 | 10 | 14,211 | $9,521 | 1421.1 mi | 1314.1 mi | 13,141 | $8,804 | 1421.1 |
92% excess
|
| 2 | Mike Huffman | 42 | 12,623 | $8,457 | 300.6 mi | 174.0 mi | 7,307 | $4,896 | 300.5 |
58% excess
|
| 3 | Tyler Bollman | 4 | 5,782 | $3,874 | 1445.6 mi | 1330.6 mi | 5,322 | $3,566 | 1445.5 |
92% excess
|
| 4 | Franco Jackson | 16 | 3,994 | $2,676 | 249.7 mi | 130.7 mi | 2,092 | $1,402 | 249.6 |
52% excess
|
| 5 | Jon Kuehl | 26 | 3,683 | $2,468 | 141.7 mi | 48.7 mi | 1,266 | $848 | 141.7 |
34% excess
|
| 6 | Chris Galasso | 4 | 2,780 | $1,863 | 695.0 mi | 507.5 mi | 2,030 | $1,360 | 695 |
73% excess
|
| 7 | Vincent Nyathi | 17 | 2,735 | $1,832 | 160.9 mi | 96.6 mi | 1,642 | $1,100 | 160.9 |
60% excess
|
| 8 | Ronnie Salone | 5 | 1,675 | $1,122 | 335.0 mi | 308.1 mi | 1,541 | $1,032 | 335 |
92% excess
|
| 9 | Brandon Green | 4 | 1,530 | $1,025 | 382.4 mi | 200.5 mi | 802 | $537 | 382.5 |
52% excess
|
| 10 | Michah Brackett | 1 | 1,435 | $961 | 1434.5 mi | 1203.4 mi | 1,203 | $806 | 1435 |
84% excess
|
| 11 | Dustin Antolin | 1 | 465 | $312 | 465.5 mi | 0.0 mi | 0 | $0 | 465 |
0% excess
|
| 12 | Kevin Cox | 5 | 437 | $293 | 87.5 mi | 7.8 mi | 39 | $26 | 87.4 |
9% excess
|
| 13 | Mark Stelter | 1 | 124 | $83 | 124.3 mi | 13.7 mi | 14 | $9 | 124 |
11% excess
|
| 14 | Blake Ward | 1 | 104 | $70 | 104.3 mi | 30.9 mi | 31 | $21 | 104 |
30% excess
|
| 15 | Ben McClerklin | 3 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|