Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
331
Total Travel Cost
$16,967
25,324 miles
Avoidable Cost
$10,431
15,568 excess miles
Optimal Cost
$6,536
If closest tech always used
Avg Excess / WO
47.0 mi
$31.51 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
23.9%
79 WOs

Actual Travel Expenses

From 115 WOs with expense data
Total Expenses
$8,104
Labor - Travel
$68
Mileage
$0
Lodging
$486
Airfare
$0
Car Rental
$71
Per Diem
$200
Meals
$0
Other
$7,278

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 Christopher Carroll 5 5,476 $3,669 1095.2 mi 1067.3 mi 5,337 $3,576 1095.2
97% excess
2 David Trost 47 4,883 $3,272 103.9 mi 70.5 mi 3,315 $2,221 103.9
68% excess
3 Luis Torres 105 4,101 $2,748 39.1 mi 15.8 mi 1,655 $1,109 39.1
40% excess
4 Joseph Anderson 2 2,703 $1,811 1351.6 mi 1175.1 mi 2,350 $1,575 1351.5
87% excess
5 Curtis Allen 43 1,825 $1,223 42.4 mi 24.7 mi 1,064 $713 42.4
58% excess
6 Mike Huffman 9 1,532 $1,026 170.3 mi 118.4 mi 1,065 $714 170.2
70% excess
7 Erwin Forster 34 1,219 $817 35.8 mi 1.0 mi 32 $21 35.9
3% excess
8 Pete Ramos 34 916 $614 27.0 mi 5.2 mi 178 $119 26.9
19% excess
9 Bernard Thompson 15 891 $597 59.4 mi 10.3 mi 154 $103 59.4
17% excess
10 Jon Kuehl 3 728 $488 242.6 mi 0.0 mi 0 $0 242.7
0% excess
11 Edward Arias 15 527 $353 35.1 mi 14.1 mi 211 $141 35.1
40% excess
12 Mohamed Shareed 9 362 $243 40.2 mi 21.5 mi 194 $130 40.2
54% excess
13 Chris Galasso 2 54 $36 26.9 mi 6.4 mi 13 $9 27
24% excess
14 Darek Kirkpatrick 5 47 $31 9.4 mi 0.0 mi 0 $0 9.4
0% excess
15 Maximilian Tucker 1 27 $18 27.2 mi 0.0 mi 0 $0 27
0% excess
16 Philip Krogstad 1 27 $18 26.8 mi 0.0 mi 0 $0 27
0% excess
17 Brandon Green 1 6 $4 5.7 mi 0.0 mi 0 $0 6
0% excess