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 | Lab/Power | 2,224 | $144,968 | 100% | 97.3 mi | 411 | ✈ 39 | $97,784 | 34 |
States with the highest total avoidable travel cost.
| # | State | WOs | Avoidable Cost | Impact | Avg Excess | Flew |
|---|---|---|---|---|---|---|
| 1 | TX | 196 | $27,872 | 212.2 mi | ✈ 2 | |
| 2 | CA | 322 | $21,735 | 100.7 mi | ✈ 8 | |
| 3 | CO | 19 | $17,177 | 1,349.3 mi | ✈ 6 | |
| 4 | NM | 71 | $16,974 | 356.8 mi | ✈ 1 | |
| 5 | OR | 10 | $10,581 | 1,579.2 mi | ✈ 3 | |
| 6 | MI | 14 | $5,715 | 609.3 mi | — | |
| 7 | MA | 1,388 | $5,085 | 5.5 mi | — | |
| 8 | MN | 8 | $4,378 | 816.8 mi | — | |
| 9 | WA | 6 | $3,585 | 891.8 mi | ✈ 2 | |
| 10 | PA | 17 | $3,540 | 310.8 mi | ✈ 4 | |
| 11 | AL | 7 | $2,655 | 566.0 mi | ✈ 3 | |
| 12 | OK | 17 | $2,320 | 203.6 mi | — | |
| 13 | IL | 6 | $1,877 | 466.8 mi | ✈ 1 | |
| 14 | GA | 7 | $1,804 | 384.5 mi | ✈ 1 | |
| 15 | NY | 10 | $1,649 | 246.1 mi | — | |
| 16 | NC | 9 | $1,284 | 212.9 mi | — | |
| 17 | SC | 11 | $1,018 | 138.2 mi | ✈ 1 | |
| 18 | DE | 23 | $987 | 64.0 mi | ✈ 1 | |
| 19 | IN | 4 | $984 | 366.9 mi | ✈ 1 | |
| 20 | VA | 4 | $803 | 299.7 mi | — |
Top cities by total avoidable cost. These are your biggest geographic hotspots.
| # | City | State | WOs | Avoidable Cost | Impact | Avg Excess | Flew |
|---|---|---|---|---|---|---|---|
| 1 | Albuquerque | NM | 71 | $16,974 | 356.8 mi | ✈ 1 | |
| 2 | Houston | TX | 26 | $13,948 | 800.7 mi | — | |
| 3 | Hillsboro | OR | 5 | $5,387 | 1,607.9 mi | ✈ 2 | |
| 4 | Golden | CO | 7 | $5,361 | 1,143.0 mi | ✈ 2 | |
| 5 | Adrian | MI | 13 | $5,331 | 612.1 mi | — | |
| 6 | Billerica | MA | 1,337 | $4,118 | 4.6 mi | — | |
| 7 | LEESPORT | PA | 11 | $3,077 | 417.4 mi | ✈ 2 | |
| 8 | Redwood City | CA | 36 | $2,372 | 98.3 mi | ✈ 2 | |
| 9 | Chanhassen | MN | 3 | $2,197 | 1,092.9 mi | — | |
| 10 | Oklahoma City | OK | 15 | $2,076 | 206.5 mi | — | |
| 11 | Longmont | CO | 3 | $1,928 | 959.1 mi | ✈ 3 | |
| 12 | Menlo Park | CA | 3 | $1,778 | 884.2 mi | — | |
| 13 | Austin | TX | 12 | $1,621 | 201.6 mi | — | |
| 14 | Dallas | TX | 22 | $1,572 | 106.7 mi | — | |
| 15 | REDWOOD CITY | CA | 8 | $1,186 | 221.3 mi | ✈ 1 | |
| 16 | Burnet | TX | 5 | $1,141 | 340.5 mi | — | |
| 17 | Round Rock | TX | 20 | $1,067 | 79.6 mi | — | |
| 18 | Irving | TX | 15 | $1,045 | 103.9 mi | — | |
| 19 | Wilmington | DE | 11 | $987 | 133.9 mi | — | |
| 20 | Waco | TX | 9 | $973 | 161.3 mi | — | |
| 21 | BISHOP | TX | 9 | $742 | 123.1 mi | — | |
| 22 | Henrietta | NY | 3 | $634 | 315.4 mi | — | |
| 23 | SUNNYVALE | CA | 3 | $572 | 284.8 mi | ✈ 2 | |
| 24 | East Taunton | MA | 23 | $526 | 34.1 mi | — | |
| 25 | Garland | TX | 8 | $517 | 96.4 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 | Kim Pearson | 1,121 | $73,748 | 98.2 mi | 86 | — | — | 6 | |
| 2 | Kaitlyn Kelch | 92 | $21,358 | 346.5 mi | 82 | ✈ 9 | $14,431 | 5 | |
| 3 | Chris Bakkemo | 24 | $13,821 | 859.5 mi | 24 | — | — | 1 | |
| 4 | Leona Coonrod | 448 | $12,828 | 42.7 mi | 143 | ✈ 2 | $8,116 | 5 | |
| 5 | Michael Burris | 80 | $9,483 | 176.9 mi | 44 | ✈ 15 | $50,645 | 8 | |
| 6 | Tami Dawe | 314 | $8,062 | 38.3 mi | 17 | — | $255 | 3 | |
| 7 | Melissa Owens | 32 | $2,919 | 136.1 mi | 10 | ✈ 7 | $10,599 | 5 | |
| 8 | Rhea Berry | 5 | $861 | 257.1 mi | 2 | ✈ 1 | $3,102 | 4 | |
| 9 | Abby Jinerson | 5 | $285 | 85.2 mi | 1 | ✈ 2 | $3,573 | 3 | |
| 10 | Kourtney Smith | 18 | $199 | 16.5 mi | 1 | — | $770 | 3 | |
| 11 | MICHAEL MCNAMARA | 5 | $15 | 4.5 mi | 0 | — | — | 2 | |
| 12 | Charles Ramen | 15 | $0 | 0.0 mi | 0 | ✈ 3 | $5,390 | 3 |
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 | Minh Huynh | 58 | $36,724 | 965 mi | 945.0 mi | 51 | — | 24 | — | |
| 2 | Shawn Kelley | 23 | $24,965 | 1,654 mi | 1,620.1 mi | 23 | — | 12 | — | |
| 3 | Ben Heinz | 73 | $16,974 | 358 mi | 347.0 mi | 71 | ✈ 2 | 3 | $4,071 | |
| 4 | Chris Bakkemo | 24 | $13,821 | 867 mi | 859.5 mi | 24 | — | 1 | — | |
| 5 | VPD Bench | 1,335 | $12,210 | 14 mi | 13.7 mi | 19 | — | 7 | $255 | |
| 6 | Charles Sellon | 12 | $7,903 | 1,195 mi | 983.0 mi | 10 | — | 8 | — | |
| 7 | Maria Davis | 98 | $7,878 | 139 mi | 120.0 mi | 90 | — | 3 | $3,567 | |
| 8 | Kwame Cobb | 48 | $7,669 | 363 mi | 238.5 mi | 42 | ✈ 14 | 5 | $47,309 | |
| 9 | Curtis Sprague | 19 | $6,845 | 739 mi | 537.7 mi | 12 | ✈ 9 | 6 | $13,870 | |
| 10 | Jose Gutierrez | 84 | $4,702 | 96 mi | 83.5 mi | 49 | ✈ 2 | 3 | $5,269 | |
| 11 | Rozier Cole | 26 | $2,928 | 294 mi | 168.1 mi | 10 | ✈ 4 | 5 | $7,248 | |
| 12 | Hermilo Solano | 64 | $831 | 30 mi | 19.4 mi | 1 | — | 1 | $208 | |
| 13 | Larry Alberty | 109 | $647 | 26 mi | 8.9 mi | 7 | — | 1 | — | |
| 14 | Mike McNamara | 26 | $355 | 21 mi | 20.4 mi | 0 | — | 1 | — | |
| 15 | Ronnie Salone | 9 | $220 | 649 mi | 36.6 mi | 1 | ✈ 5 | 6 | $7,392 | |
| 16 | Pete Ramos | 16 | $170 | 88 mi | 15.9 mi | 1 | — | 5 | $583 | |
| 17 | Steven Bionelli | 24 | $62 | 4 mi | 3.9 mi | 0 | — | 1 | — | |
| 18 | Tim Dinh | 5 | $36 | 11 mi | 10.8 mi | 0 | — | 2 | — | |
| 19 | Jermaine Hernandez | 8 | $0 | 0 mi | 0.0 mi | 0 | — | 1 | — | |
| 20 | Nidal Al-Sharif | 26 | $0 | 0 mi | 0.0 mi | 0 | — | 1 | — |