Quantify excess travel cost and identify optimization opportunities across your field service operation
Ranked by total avoidable cost across five dimensions. Focus on the top items in each category for the highest ROI improvements.
Which service verticals generate the most excess travel? Clinical Education stands out with very high per-WO excess.
| # | Vertical | WOs | Avoidable Cost | Impact | Avg Excess | Outliers | Flew | Actual Expense | Techs |
|---|---|---|---|---|---|---|---|---|---|
| 1 | FCO | 393 | $154,570 | 75.3% | 587.0 mi | 230 | ✈ 7 | $16,335 | 19 |
| 2 | Lab/Power | 196 | $27,872 | 13.6% | 212.2 mi | 149 | ✈ 2 | $5,245 | 9 |
| 3 | Healthcare Provider | 530 | $13,559 | 6.6% | 38.2 mi | 110 | ✈ 1 | $130,762 | 10 |
| 4 | EMS | 121 | $4,034 | 2% | 49.8 mi | 34 | — | $12,192 | 7 |
| 5 | Kiosk | 145 | $3,663 | 1.8% | 37.7 mi | 8 | — | $16,178 | 10 |
| 6 | Installation | 9 | $731 | 0.4% | 121.3 mi | 8 | ✈ 1 | $13,724 | 3 |
| 7 | Bed Services | 9 | $624 | 0.3% | 103.5 mi | 5 | — | $1,405 | 2 |
| 8 | Animal Health | 9 | $167 | 0.1% | 27.7 mi | 3 | — | $2,474 | 3 |
| 9 | Training/Other | 7 | $138 | 0.1% | 29.5 mi | 1 | ✈ 1 | $2,053 | 6 |
States with the highest total avoidable travel cost.
| # | State | WOs | Avoidable Cost | Impact | Avg Excess | Flew |
|---|---|---|---|---|---|---|
| 1 | TX | 1,419 | $205,360 | 216.0 mi | ✈ 12 |
Top cities by total avoidable cost. These are your biggest geographic hotspots.
| # | City | State | WOs | Avoidable Cost | Impact | Avg Excess | Flew |
|---|---|---|---|---|---|---|---|
| 1 | SAN ANTONIO | TX | 99 | $27,160 | 409.5 mi | — | |
| 2 | AUSTIN | TX | 33 | $26,499 | 1,198.5 mi | — | |
| 3 | DALLAS | TX | 27 | $19,656 | 1,086.6 mi | ✈ 1 | |
| 4 | EL PASO | TX | 34 | $19,008 | 834.4 mi | ✈ 2 | |
| 5 | Houston | TX | 104 | $15,771 | 226.3 mi | — | |
| 6 | LUBBOCK | TX | 17 | $11,453 | 1,005.6 mi | ✈ 1 | |
| 7 | HOUSTON | TX | 71 | $7,336 | 154.2 mi | ✈ 1 | |
| 8 | ROUND ROCK | TX | 6 | $5,417 | 1,347.5 mi | — | |
| 9 | Austin | TX | 47 | $4,768 | 151.4 mi | — | |
| 10 | TEMPLE | TX | 5 | $4,407 | 1,315.4 mi | — | |
| 11 | FORT WORTH | TX | 10 | $4,043 | 603.4 mi | — | |
| 12 | PLANO | TX | 5 | $3,789 | 1,131.0 mi | — | |
| 13 | San Antonio | TX | 87 | $3,491 | 59.9 mi | — | |
| 14 | EDINBURG | TX | 26 | $3,195 | 183.4 mi | ✈ 1 | |
| 15 | ARLINGTON | TX | 4 | $2,802 | 1,045.4 mi | — | |
| 16 | NORTH RICHLAND HILLS | TX | 5 | $2,726 | 813.8 mi | — | |
| 17 | FRISCO | TX | 4 | $2,667 | 995.1 mi | — | |
| 18 | Corpus Christi | TX | 30 | $2,559 | 127.3 mi | — | |
| 19 | Dallas | TX | 83 | $2,421 | 43.5 mi | — | |
| 20 | El Paso | TX | 8 | $2,104 | 392.7 mi | ✈ 1 | |
| 21 | IRVING | TX | 3 | $2,041 | 1,015.5 mi | — | |
| 22 | Irving | TX | 25 | $1,920 | 114.6 mi | — | |
| 23 | MCKINNEY | TX | 13 | $1,479 | 169.8 mi | — | |
| 24 | Burnet | TX | 6 | $1,191 | 296.3 mi | — | |
| 25 | Round Rock | TX | 23 | $1,186 | 77.0 mi | — |
Coordinators whose dispatching decisions result in the most excess travel. High avg excess suggests systematic over-dispatching; high WO count with moderate excess suggests volume-driven impact.
| # | Coordinator | WOs | Avoidable Cost | Impact | Avg Excess | Outliers | Flew | Actual Expense | Techs Used |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Fady Messak | 30 | $22,405 | 1,114.7 mi | 30 | — | — | 8 | |
| 2 | Laura Hill | 65 | $19,184 | 440.5 mi | 27 | ✈ 1 | $4,787 | 11 | |
| 3 | Kaitlyn Kelch | 774 | $17,780 | 34.3 mi | 148 | ✈ 3 | $156,041 | 14 | |
| 4 | Chris Bakkemo | 24 | $13,821 | 859.5 mi | 24 | — | — | 1 | |
| 5 | Megan Klose | 14 | $12,735 | 1,357.7 mi | 14 | — | $150 | 2 | |
| 6 | Leona Coonrod | 156 | $8,421 | 80.6 mi | 118 | ✈ 1 | $3,821 | 3 | |
| 7 | Kim Pearson | 5 | $5,491 | 1,638.9 mi | 5 | — | — | 2 | |
| 8 | Cristina Everetts | 22 | $562 | 38.2 mi | 1 | ✈ 1 | $1,522 | 2 | |
| 9 | Erin Martin | 28 | $540 | 28.8 mi | 1 | — | $328 | 2 | |
| 10 | Rhea Berry | 21 | $212 | 15.1 mi | 2 | — | $5,580 | 6 | |
| 11 | Natosha Beierschmitt | 6 | $135 | 33.7 mi | 1 | — | — | 1 | |
| 12 | Brandi Rodriguez | 14 | $0 | 0.0 mi | 0 | — | $150 | 1 |
Techs who consistently travel far beyond the closest available option. High states-served count may indicate a roaming/national tech; high avg excess with few states suggests a misplaced home base.
| # | Technician | WOs | Avoidable Cost | Impact | Avg Actual Dist | Avg Excess | Outliers | Flew | States | Actual Expense |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Philmon Mehari | 62 | $56,814 | 1,506 mi | 1,367.7 mi | 62 | — | 1 | $999 | |
| 2 | Eric Mancerella | 38 | $25,658 | 1,157 mi | 1,007.8 mi | 38 | ✈ 2 | 1 | $3,799 | |
| 3 | Davon Cox | 24 | $21,729 | 1,481 mi | 1,351.3 mi | 24 | ✈ 1 | 1 | $1,758 | |
| 4 | Chris Bakkemo | 24 | $13,821 | 867 mi | 859.5 mi | 24 | — | 1 | — | |
| 5 | Fady Messak | 14 | $13,198 | 1,548 mi | 1,407.1 mi | 14 | — | 1 | — | |
| 6 | Derick Velazquez | 13 | $7,310 | 854 mi | 839.3 mi | 13 | ✈ 1 | 1 | $1,522 | |
| 7 | Marvin Rivas | 174 | $7,277 | 162 mi | 62.4 mi | 47 | ✈ 3 | 1 | $7,892 | |
| 8 | Chane Lacy | 196 | $6,451 | 86 mi | 49.1 mi | 56 | — | 1 | $44,443 | |
| 9 | Patricia Gordon | 8 | $5,456 | 1,504 mi | 1,018.0 mi | 8 | — | 1 | — | |
| 10 | Maria Davis | 75 | $5,408 | 123 mi | 107.6 mi | 73 | — | 1 | $1,287 | |
| 11 | Fady Khouzam | 5 | $4,442 | 1,377 mi | 1,326.1 mi | 5 | — | 1 | — | |
| 12 | Arturo Diaz | 96 | $3,885 | 89 mi | 60.4 mi | 17 | ✈ 1 | 1 | $16,744 | |
| 13 | Anthony Wirth | 141 | $3,259 | 68 mi | 34.5 mi | 49 | — | 1 | $30,157 | |
| 14 | Jose Gutierrez | 82 | $3,152 | 70 mi | 57.4 mi | 47 | ✈ 1 | 1 | $2,479 | |
| 15 | Bruce Ballard | 5 | $2,642 | 1,278 mi | 788.6 mi | 5 | — | 1 | — | |
| 16 | Christopher Womack | 187 | $1,704 | 50 mi | 13.6 mi | 5 | ✈ 1 | 1 | $26,550 | |
| 17 | Curtis Sprague | 62 | $1,329 | 113 mi | 32.0 mi | 13 | — | 1 | $9,493 | |
| 18 | Zachary Stieben | 152 | $1,164 | 43 mi | 11.4 mi | 7 | — | 1 | $19,104 | |
| 19 | Scott E Yelverton | 7 | $541 | 134 mi | 115.5 mi | 5 | — | 1 | $10,826 | |
| 20 | Darrell Hendrix | 12 | $350 | 198 mi | 43.6 mi | 3 | — | 1 | $4,167 |