Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
908
Total Travel Cost
$54,320
81,075 miles
Avoidable Cost
$35,380
52,805 excess miles
Optimal Cost
$18,941
If closest tech always used
Avg Excess / WO
58.2 mi
$38.96 per WO
Median Excess
2.0 mi
Outlier Rate (>50mi)
12.6%
114 WOs

Actual Travel Expenses

From 434 WOs with expense data
Total Expenses
$201,040
Labor - Travel
$141,149
Mileage
$1,280
Lodging
$19,167
Airfare
$12,695
Car Rental
$8,076
Per Diem
$6,950
Meals
$0
Other
$11,723

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 Kwame Cobb 63 11,694 $7,835 185.6 mi 159.5 mi 10,049 $6,733 185.6
86% excess
2 Minh Huynh 4 10,361 $6,942 2590.2 mi 2575.3 mi 10,301 $6,902 2590.3
99% excess
3 Omar Serrano 215 8,747 $5,860 40.7 mi 20.4 mi 4,378 $2,933 40.7
50% excess
4 Shawn Kelley 3 7,735 $5,182 2578.4 mi 2568.9 mi 7,707 $5,164 2578.3
100% excess
5 Angel Rios 103 6,139 $4,113 59.6 mi 14.8 mi 1,524 $1,021 59.6
25% excess
6 Justin Armas 80 5,413 $3,627 67.7 mi 9.1 mi 727 $487 67.7
13% excess
7 Fady Messak 2 5,085 $3,407 2542.5 mi 310.6 mi 621 $416 2542.5
12% excess
8 Rene Yescas 133 4,107 $2,752 30.9 mi 8.3 mi 1,107 $742 30.9
27% excess
9 Larry Alberty 109 2,775 $1,859 25.5 mi 8.9 mi 965 $647 25.5
35% excess
10 Charles Sellon 1 2,668 $1,788 2667.6 mi 2652.6 mi 2,653 $1,778 2668
99% excess
11 Michael Russell 11 2,632 $1,763 239.3 mi 233.6 mi 2,569 $1,721 239.3
98% excess
12 Natosha Beierschmitt 2 2,431 $1,629 1215.4 mi 1166.6 mi 2,333 $1,563 1215.5
96% excess
13 Michah Brackett 5 2,415 $1,618 483.1 mi 264.5 mi 1,323 $886 483
55% excess
14 Hermilo Solano 64 1,937 $1,298 30.3 mi 19.4 mi 1,240 $831 30.3
64% excess
15 Brendan Chaney 1 1,926 $1,290 1925.9 mi 1922.1 mi 1,922 $1,288 1926
100% excess
16 Robert Butler 1 1,603 $1,074 1603.4 mi 1575.1 mi 1,575 $1,055 1603
98% excess
17 Saul Morales 1 1,565 $1,049 1565.2 mi 1560.9 mi 1,561 $1,046 1565
100% excess
18 Jared Rappaport 100 1,504 $1,008 15.0 mi 0.0 mi 0 $0 15
0% excess
19 Jeffrey Pastor 10 338 $226 33.8 mi 25.0 mi 250 $168 33.8
74% excess