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 | Fady Messak | 19 | 11,985 | $8,030 | 630.8 mi | 528.0 mi | 10,032 | $6,721 | 630.8 |
84% excess
|
| 2 | Bruce Ballard | 70 | 5,072 | $3,398 | 72.5 mi | 22.6 mi | 1,582 | $1,060 | 72.5 |
31% excess
|
| 3 | Marvin Rivas | 59 | 2,292 | $1,536 | 38.8 mi | 24.6 mi | 1,452 | $973 | 38.8 |
63% excess
|
| 4 | Patricia Gordon | 16 | 1,990 | $1,333 | 124.3 mi | 57.6 mi | 921 | $617 | 124.4 |
46% excess
|
| 5 | Samuel Biddie | 10 | 987 | $661 | 98.7 mi | 59.4 mi | 594 | $398 | 98.7 |
60% excess
|
| 6 | Ryan Lewis | 2 | 981 | $657 | 490.4 mi | 287.5 mi | 575 | $385 | 490.5 |
59% excess
|
| 7 | Brendan Chaney | 1 | 841 | $563 | 840.8 mi | 805.7 mi | 806 | $540 | 841 |
96% excess
|
| 8 | Fady Khouzam | 1 | 542 | $363 | 542.3 mi | 483.3 mi | 483 | $324 | 542 |
89% excess
|
| 9 | Nkosi Wilson | 13 | 431 | $289 | 33.2 mi | 9.8 mi | 127 | $85 | 33.2 |
29% excess
|
| 10 | Fanfan Siku | 1 | 116 | $78 | 115.7 mi | 0.0 mi | 0 | $0 | 116 |
0% excess
|
| 11 | Scott R Roberts | 1 | 84 | $56 | 84.3 mi | 0.0 mi | 0 | $0 | 84 |
0% excess
|
| 12 | Raymond Ebanks | 1 | 16 | $11 | 15.9 mi | 0.0 mi | 0 | $0 | 16 |
0% excess
|