Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
2,293
Total Travel Cost
$114,493
170,885 miles
Avoidable Cost
$74,174
110,707 excess miles
Optimal Cost
$40,336
If closest tech always used
Avg Excess / WO
48.3 mi
$32.34 per WO
Median Excess
8.6 mi
Outlier Rate (>50mi)
17.4%
400 WOs

Actual Travel Expenses

From 1,364 WOs with expense data
Total Expenses
$333,164
Labor - Travel
$251,802
Mileage
$13,545
Lodging
$23,255
Airfare
$6,972
Car Rental
$9,529
Per Diem
$7,050
Meals
$0
Other
$21,010

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 28 23,849 $15,979 851.7 mi 837.2 mi 23,440 $15,705 851.8
98% excess
2 Paul Bonang Jr 202 12,056 $8,078 59.7 mi 6.2 mi 1,243 $833 59.7
10% excess
3 Luis Torres 222 11,374 $7,621 51.2 mi 17.0 mi 3,784 $2,535 51.2
33% excess
4 Christopher Carroll 11 10,711 $7,176 973.8 mi 942.1 mi 10,363 $6,943 973.7
97% excess
5 David Trost 208 9,585 $6,422 46.1 mi 25.2 mi 5,252 $3,519 46.1
55% excess
6 Mohamed Shareed 163 8,944 $5,992 54.9 mi 36.1 mi 5,892 $3,948 54.9
66% excess
7 Bernard Thompson 139 8,788 $5,888 63.2 mi 8.2 mi 1,141 $764 63.2
13% excess
8 Edward Arias 165 8,672 $5,810 52.6 mi 34.1 mi 5,623 $3,767 52.6
65% excess
9 Pete Ramos 214 8,295 $5,558 38.8 mi 17.3 mi 3,695 $2,476 38.8
45% excess
10 Erwin Forster 142 7,912 $5,301 55.7 mi 21.8 mi 3,090 $2,070 55.7
39% excess
11 Joseph Anderson 6 7,753 $5,195 1292.1 mi 1216.0 mi 7,296 $4,888 1292.2
94% excess
12 Yves Dessin 7 7,734 $5,182 1104.8 mi 1097.9 mi 7,685 $5,149 1104.9
99% excess
13 David Cavaco 186 7,657 $5,130 41.2 mi 27.4 mi 5,097 $3,415 41.2
67% excess
14 Michael Swingle 9 6,572 $4,403 730.2 mi 710.3 mi 6,393 $4,283 730.2
97% excess
15 Nick O'Neill 113 5,431 $3,639 48.1 mi 39.7 mi 4,489 $3,008 48.1
83% excess
16 Jason Cunningham 3 4,230 $2,834 1410.1 mi 1400.2 mi 4,201 $2,815 1410
99% excess
17 Taylor Duda 72 4,213 $2,823 58.5 mi 42.3 mi 3,042 $2,038 58.5
72% excess
18 Curtis Allen 154 4,110 $2,754 26.7 mi 9.3 mi 1,429 $957 26.7
35% excess
19 Darrell Hope 144 3,868 $2,592 26.9 mi 8.7 mi 1,258 $843 26.9
33% excess
20 Arturo Diaz 2 3,189 $2,137 1594.3 mi 1589.8 mi 3,180 $2,131 1594.5
100% excess
21 Darek Kirkpatrick 65 1,880 $1,260 28.9 mi 9.8 mi 636 $426 28.9
34% excess
22 Mike Huffman 9 1,532 $1,026 170.3 mi 118.4 mi 1,065 $714 170.2
70% excess
23 Jon Kuehl 3 728 $488 242.6 mi 0.0 mi 0 $0 242.7
0% excess
24 Hector Castaneda 7 718 $481 102.5 mi 102.5 mi 718 $481 102.6
100% excess
25 Maximilian Tucker 2 290 $194 145.2 mi 119.0 mi 238 $159 145
82% excess
26 Chris Galasso 4 222 $149 55.5 mi 43.3 mi 173 $116 55.5
78% excess
27 Jim Kingery 4 220 $147 55.0 mi 54.4 mi 217 $145 55
99% excess
28 Shawn Rogers 2 205 $137 102.3 mi -12.6 mi 0 $0 102.5
0% excess
29 Philip Krogstad 2 71 $48 35.6 mi 9.6 mi 19 $13 35.5
27% excess
30 Minh Huynh 1 52 $35 51.9 mi 43.6 mi 44 $29 52
85% excess