Travel & Margin Analysis

Quantify excess travel cost and identify optimization opportunities across your field service operation

Tech Placement Detail →
WOs Analyzed
4,438
Total Travel Cost
$416,212
621,212 miles
Avoidable Cost
$340,361
508,002 excess miles
Optimal Cost
$75,849
If closest tech always used
Avg Excess / WO
114.5 mi
$76.69 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
33.8%
1,502 WOs

Actual Travel Expenses

From 520 WOs with expense data
Total Expenses
$136,018
Labor - Travel
$5,098
Mileage
$58
Lodging
$51,343
Airfare
$20,733
Car Rental
$11,968
Per Diem
$16,000
Meals
$0
Other
$30,819

Technician Travel Utilization

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.

#TechnicianWOs Total MilesTotal Travel Cost Avg Actual DistAvg Excess Total Excess MilesAvoidable Cost Miles/WO Ratio Travel Load
1 Kevin Cogdill 310 91,195 $61,101 294.2 mi 280.2 mi 86,876 $58,207 294.2
95% excess
2 Yves Dessin 159 84,600 $56,682 532.1 mi 522.3 mi 83,053 $55,646 532.1
98% excess
3 Fernando Lemos 65 63,937 $42,838 983.6 mi 936.4 mi 60,864 $40,779 983.6
95% excess
4 Joe Evans 286 49,254 $33,000 172.2 mi 161.5 mi 46,196 $30,951 172.2
94% excess
5 Jim Kingery 268 41,213 $27,613 153.8 mi 112.5 mi 30,153 $20,203 153.8
73% excess
6 Christopher Carroll 63 40,399 $27,067 641.3 mi 597.5 mi 37,645 $25,222 641.3
93% excess
7 Michael Swingle 65 35,434 $23,741 545.1 mi 510.4 mi 33,173 $22,226 545.1
94% excess
8 Kenneth Lancara 494 34,042 $22,808 68.9 mi 41.4 mi 20,436 $13,692 68.9
60% excess
9 Mark Stelter 166 29,688 $19,891 178.8 mi 121.2 mi 20,115 $13,477 178.8
68% excess
10 Side Kick Technician 60 23,374 $15,661 389.6 mi 380.2 mi 22,815 $15,286 389.6
98% excess
11 Jennifer Johnson 19 20,782 $13,924 1093.8 mi 1077.3 mi 20,469 $13,714 1093.8
98% excess
12 Tyler Bollman 107 19,691 $13,193 184.0 mi 2.9 mi 305 $204 184
2% excess
13 Rozier Cole 64 16,799 $11,255 262.5 mi 241.0 mi 15,426 $10,335 262.5
92% excess
14 Justin Armas 22 11,379 $7,624 517.2 mi 461.9 mi 10,161 $6,808 517.2
89% excess
15 Torre Gifford 163 9,457 $6,336 58.0 mi 38.1 mi 6,211 $4,161 58
66% excess
16 Xiraiyah Coston 176 7,180 $4,811 40.8 mi 13.9 mi 2,440 $1,635 40.8
34% excess
17 Ray-Anthony Alston 384 6,654 $4,458 17.3 mi 2.3 mi 894 $599 17.3
13% excess
18 Bernard Thompson 69 5,071 $3,398 73.5 mi 0.0 mi 0 $0 73.5
0% excess
19 Daniel Clark 280 4,971 $3,331 17.8 mi 0.0 mi 0 $0 17.8
0% excess
20 Matthew Sebzda 146 4,168 $2,793 28.5 mi 17.2 mi 2,508 $1,680 28.5
60% excess
21 Pete Ramos 87 3,876 $2,597 44.5 mi 28.1 mi 2,441 $1,635 44.6
63% excess
22 Scott R Roberts 24 3,743 $2,508 156.0 mi 77.6 mi 1,862 $1,248 156
50% excess
23 Franco Jackson 272 3,679 $2,465 13.5 mi 0.3 mi 70 $47 13.5
2% excess
24 Craig Walker 167 2,381 $1,595 14.3 mi 0.0 mi 0 $0 14.3
0% excess
25 David Hernandez 72 2,205 $1,477 30.6 mi 16.7 mi 1,203 $806 30.6
55% excess
26 Carlos Robles 222 1,990 $1,333 9.0 mi 6.7 mi 1,496 $1,002 9
75% excess
27 Jon Sanchez 178 1,679 $1,125 9.4 mi 0.0 mi 4 $3 9.4
0% excess
28 Chane Lacy 5 950 $637 190.0 mi 186.3 mi 932 $624 190
98% excess
29 Michael Harris 10 423 $283 42.3 mi 0.0 mi 0 $0 42.3
0% excess
30 Bennet O Dartey 15 378 $253 25.2 mi 8.2 mi 123 $82 25.2
33% excess