Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
653
Total Travel Cost
$34,444
51,409 miles
Avoidable Cost
$27,401
40,897 excess miles
Optimal Cost
$7,043
If closest tech always used
Avg Excess / WO
62.6 mi
$41.96 per WO
Median Excess
23.2 mi
Outlier Rate (>50mi)
22.8%
149 WOs

Actual Travel Expenses

From 398 WOs with expense data
Total Expenses
$113,107
Labor - Travel
$85,096
Mileage
$760
Lodging
$9,104
Airfare
$3,952
Car Rental
$5,527
Per Diem
$3,475
Meals
$0
Other
$5,192

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 James Duff 19 16,621 $11,136 874.8 mi 865.4 mi 16,442 $11,016 874.8
99% excess
2 Mohamed Shareed 90 5,144 $3,446 57.2 mi 39.1 mi 3,518 $2,357 57.2
68% excess
3 Jason Cunningham 3 4,230 $2,834 1410.1 mi 1400.2 mi 4,201 $2,815 1410
99% excess
4 David Cavaco 95 4,032 $2,701 42.4 mi 29 mi 2,752 $1,844 42.4
68% excess
5 Edward Arias 65 3,065 $2,054 47.2 mi 32.4 mi 2,109 $1,413 47.2
69% excess
6 Nick O'Neill 60 2,832 $1,897 47.2 mi 39.9 mi 2,392 $1,603 47.2
84% excess
7 Christopher Carroll 4 2,721 $1,823 680.3 mi 680.3 mi 2,721 $1,823 680.3
100% excess
8 Erwin Forster 36 2,156 $1,445 59.9 mi 40.6 mi 1,463 $980 59.9
68% excess
9 Paul Bonang Jr 39 1,806 $1,210 46.3 mi 14.9 mi 581 $389 46.3
32% excess
10 Luis Torres 31 1,707 $1,144 55.1 mi 31 mi 960 $643 55.1
56% excess
11 Bernard Thompson 32 1,631 $1,093 51 mi 22.7 mi 727 $487 51
45% excess
12 Pete Ramos 37 1,277 $856 34.5 mi 16.6 mi 614 $411 34.5
48% excess
13 David Trost 53 1,157 $775 21.8 mi 9.9 mi 527 $353 21.8
46% excess
14 Taylor Duda 19 849 $569 44.7 mi 29.8 mi 567 $380 44.7
67% excess
15 Darek Kirkpatrick 33 747 $500 22.6 mi 8.4 mi 278 $186 22.6
37% excess
16 Hector Castaneda 5 718 $481 143.5 mi 143.5 mi 718 $481 143.6
100% excess
17 Darrell Hope 25 595 $399 23.8 mi 11.8 mi 295 $198 23.8
50% excess
18 Curtis Allen 7 120 $80 17.1 mi 4.9 mi 34 $23 17.1
28% excess