Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,166
Total Travel Cost
$65,503
97,766 miles
Avoidable Cost
$43,276
64,590 excess miles
Optimal Cost
$22,244
If closest tech always used
Avg Excess / WO
55.4 mi
$37.10 per WO
Median Excess
7.6 mi
Outlier Rate (>50mi)
12.6%
147 WOs

Actual Travel Expenses

From 671 WOs with expense data
Total Expenses
$227,107
Labor - Travel
$150,107
Mileage
$2,649
Lodging
$27,476
Airfare
$10,372
Car Rental
$11,502
Per Diem
$10,025
Meals
$0
Other
$14,976

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 Nkosi Wilson 27 20,564 $13,778 761.6 mi 738.4 mi 19,937 $13,358 761.6
97% excess
2 Christopher Carroll 8 8,746 $5,860 1093.2 mi 1075.8 mi 8,606 $5,766 1093.3
98% excess
3 Megan Allen 3 4,526 $3,032 1508.7 mi 1480.7 mi 4,442 $2,976 1508.7
98% excess
4 Eric Mancerella 19 4,440 $2,975 233.7 mi 56 mi 1,065 $714 233.7
24% excess
5 Erwin Forster 84 4,316 $2,892 51.4 mi 20.9 mi 1,759 $1,179 51.4
41% excess
6 Andre Samuda 166 4,102 $2,748 24.7 mi 7 mi 1,165 $781 24.7
28% excess
7 Bryan Rodriguez 36 3,984 $2,669 110.7 mi 21.8 mi 785 $526 110.7
20% excess
8 James Duff 5 3,788 $2,538 757.6 mi 755.3 mi 3,776 $2,530 757.6
100% excess
9 Scott A Berry 8 3,633 $2,434 454.2 mi 433.3 mi 3,466 $2,322 454.1
95% excess
10 Horace Barnes 3 3,363 $2,253 1121 mi 989 mi 2,967 $1,988 1121
88% excess
11 Rodney Charles 13 2,658 $1,781 204.5 mi 63.6 mi 826 $553 204.5
31% excess
12 Bernard Thompson 53 2,595 $1,739 49 mi 16.5 mi 872 $584 49
34% excess
13 Vivian Hyde 135 2,457 $1,646 18.2 mi 5.9 mi 794 $532 18.2
32% excess
14 Davon Cox 27 2,041 $1,367 75.6 mi 16.2 mi 439 $294 75.6
22% excess
15 April Nuovo 11 1,677 $1,124 152.5 mi 47.4 mi 521 $349 152.5
31% excess
16 Sean Currie 1 1,625 $1,089 1625.1 mi 1492.4 mi 1,492 $1,000 1625
92% excess
17 Mohamed Shareed 46 1,586 $1,063 34.5 mi 11.8 mi 544 $364 34.5
34% excess
18 Edward Arias 41 1,438 $963 35.1 mi 16.4 mi 671 $450 35.1
47% excess
19 Fady Messak 20 1,415 $948 70.7 mi 48 mi 959 $643 70.8
68% excess
20 Joseph Nuovo 8 1,338 $896 167.2 mi 24.4 mi 195 $131 167.3
15% excess
21 David Trost 73 1,277 $856 17.5 mi 5.1 mi 370 $248 17.5
29% excess
22 Robert Butler 1 1,253 $840 1253.1 mi 1200.3 mi 1,200 $804 1253
96% excess
23 Philmon Mehari 17 1,233 $826 72.5 mi 10.8 mi 184 $123 72.5
15% excess
24 Fady Khouzam 47 1,154 $773 24.6 mi 10.7 mi 505 $338 24.6
44% excess
25 Alberto Galan 37 1,135 $760 30.7 mi 17.7 mi 654 $438 30.7
58% excess
26 Israel Martell 69 1,060 $710 15.4 mi 4.6 mi 315 $211 15.4
30% excess
27 Darek Kirkpatrick 42 1,036 $694 24.7 mi 7.1 mi 299 $200 24.7
29% excess
28 Luis Torres 10 935 $626 93.5 mi 26.2 mi 262 $176 93.5
28% excess
29 Taylor Duda 22 911 $610 41.4 mi 26.9 mi 593 $397 41.4
65% excess
30 Darrell Hope 51 900 $603 17.6 mi 3 mi 155 $104 17.6
17% excess