Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
548
Total Travel Cost
$87,956
131,277 miles
Avoidable Cost
$84,466
126,069 excess miles
Optimal Cost
$3,490
If closest tech always used
Avg Excess / WO
230.1 mi
$154.13 per WO
Median Excess
6.8 mi
Outlier Rate (>50mi)
30.7%
168 WOs

Actual Travel Expenses

From 32 WOs with expense data
Total Expenses
$15,951
Labor - Travel
$0
Mileage
$16
Lodging
$7,172
Airfare
$1,700
Car Rental
$2,463
Per Diem
$2,125
Meals
$0
Other
$2,475

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 Fernando Lemos 29 53,439 $35,804 1842.7 mi 1836.7 mi 53,265 $35,688 1842.7
100% excess
2 Yves Dessin 62 41,781 $27,993 673.9 mi 664 mi 41,170 $27,584 673.9
99% excess
3 Side Kick Technician 27 10,039 $6,726 371.8 mi 364.1 mi 9,831 $6,587 371.8
98% excess
4 Christopher Carroll 15 9,759 $6,539 650.6 mi 592.5 mi 8,888 $5,955 650.6
91% excess
5 Rozier Cole 20 6,056 $4,058 302.8 mi 300.6 mi 6,012 $4,028 302.8
99% excess
6 Xiraiyah Coston 10 2,308 $1,546 230.8 mi 207.6 mi 2,076 $1,391 230.8
90% excess
7 Joe Evans 8 1,433 $960 179.1 mi 167.6 mi 1,341 $898 179.1
94% excess
8 Kenneth Lancara 6 1,341 $898 223.5 mi 194.9 mi 1,169 $783 223.5
87% excess
9 Carlos Robles 140 1,256 $842 9 mi 6.8 mi 945 $633 9
75% excess
10 Pete Ramos 24 1,105 $740 46 mi 31 mi 745 $499 46
67% excess
11 Jon Sanchez 107 713 $478 6.7 mi 0 mi 0 $0 6.7
0% excess
12 Matthew Sebzda 27 517 $346 19.1 mi 6.3 mi 170 $114 19.1
33% excess
13 David Hernandez 33 468 $314 14.2 mi 0 mi 0 $0 14.2
0% excess
14 Ray-Anthony Alston 28 426 $285 15.2 mi 0 mi 0 $0 15.2
0% excess
15 Kevin Cogdill 1 333 $223 333.4 mi 321.3 mi 321 $215 333
96% excess
16 Torre Gifford 2 157 $105 78.6 mi 67.9 mi 136 $91 78.5
87% excess
17 Mark Stelter 2 75 $50 37.6 mi 0 mi 0 $0 37.5
0% excess
18 Franco Jackson 5 58 $39 11.6 mi 0 mi 0 $0 11.6
0% excess
19 Daniel Clark 2 14 $9 6.8 mi 0 mi 0 $0 7
0% excess