Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,419
Total Travel Cost
$261,829
390,789 miles
Avoidable Cost
$205,360
306,508 excess miles
Optimal Cost
$56,526
If closest tech always used
Avg Excess / WO
215.9 mi
$144.68 per WO
Median Excess
20.5 mi
Outlier Rate (>50mi)
38.6%
548 WOs

Actual Travel Expenses

From 635 WOs with expense data
Total Expenses
$200,369
Labor - Travel
$138,884
Mileage
$2,602
Lodging
$21,627
Airfare
$7,600
Car Rental
$2,175
Per Diem
$12,675
Meals
$0
Other
$14,805

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 Philmon Mehari 62 93,377 $62,563 1506.1 mi 1367.7 mi 84,797 $56,814 1506.1
91% excess
2 Eric Mancerella 38 43,966 $29,457 1157.0 mi 1007.8 mi 38,295 $25,658 1157
87% excess
3 Davon Cox 24 35,536 $23,809 1480.7 mi 1351.3 mi 32,431 $21,729 1480.7
91% excess
4 Marvin Rivas 174 28,177 $18,879 161.9 mi 62.4 mi 10,861 $7,277 161.9
39% excess
5 Fady Messak 14 21,675 $14,522 1548.2 mi 1407.1 mi 19,699 $13,198 1548.2
91% excess
6 Chris Bakkemo 24 20,798 $13,935 866.6 mi 859.5 mi 20,628 $13,821 866.6
99% excess
7 Chane Lacy 196 16,897 $11,321 86.2 mi 49.1 mi 9,628 $6,451 86.2
57% excess
8 Patricia Gordon 8 12,031 $8,061 1503.9 mi 1018.0 mi 8,144 $5,456 1503.9
68% excess
9 Derick Velazquez 13 11,103 $7,439 854.1 mi 839.3 mi 10,911 $7,310 854.1
98% excess
10 Anthony Wirth 141 9,604 $6,435 68.1 mi 34.5 mi 4,864 $3,259 68.1
51% excess
11 Christopher Womack 187 9,327 $6,249 49.9 mi 13.6 mi 2,544 $1,704 49.9
27% excess
12 Maria Davis 75 9,208 $6,169 122.8 mi 107.6 mi 8,072 $5,408 122.8
88% excess
13 Arturo Diaz 96 8,552 $5,730 89.1 mi 60.4 mi 5,798 $3,885 89.1
68% excess
14 Curtis Sprague 62 6,989 $4,683 112.7 mi 32.0 mi 1,983 $1,329 112.7
28% excess
15 Fady Khouzam 5 6,885 $4,613 1376.9 mi 1326.1 mi 6,630 $4,442 1377
96% excess
16 Minh Huynh 4 6,632 $4,443 1658.0 mi 1632.2 mi 6,529 $4,374 1658
98% excess
17 Zachary Stieben 152 6,520 $4,368 42.9 mi 11.4 mi 1,738 $1,164 42.9
27% excess
18 Bruce Ballard 5 6,388 $4,280 1277.6 mi 788.6 mi 3,943 $2,642 1277.6
62% excess
19 Jose Gutierrez 82 5,716 $3,830 69.7 mi 57.4 mi 4,705 $3,152 69.7
82% excess
20 Shady Messak 2 3,742 $2,507 1870.8 mi 1381.8 mi 2,764 $1,852 1871
74% excess
21 April Nuovo 2 3,443 $2,307 1721.5 mi 1576.6 mi 3,153 $2,113 1721.5
92% excess
22 Luis Iser 2 3,271 $2,192 1635.7 mi 1146.8 mi 2,294 $1,537 1635.5
70% excess
23 Israel Martell 2 2,789 $1,869 1394.5 mi 1348.1 mi 2,696 $1,806 1394.5
97% excess
24 Emmanuel Morales 2 2,429 $1,627 1214.5 mi 1198.8 mi 2,398 $1,607 1214.5
99% excess
25 Darrell Hendrix 12 2,377 $1,593 198.1 mi 43.6 mi 523 $350 198.1
22% excess
26 Samuel Biddie 2 2,268 $1,520 1134.0 mi 645.0 mi 1,290 $864 1134
57% excess
27 Rick Charles 1 1,824 $1,222 1823.6 mi 1334.7 mi 1,335 $894 1824
73% excess
28 Shawn Kelley 1 1,673 $1,121 1673.0 mi 1665.8 mi 1,666 $1,116 1673
100% excess
29 Nicole Floyd 1 1,078 $722 1077.9 mi 1074.8 mi 1,075 $720 1078
100% excess
30 Christopher Carroll 4 1,074 $720 268.5 mi 268.5 mi 1,074 $720 268.5
100% excess