Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
398
Total Travel Cost
$51,144
76,335 miles
Avoidable Cost
$46,957
70,085 excess miles
Optimal Cost
$4,188
If closest tech always used
Avg Excess / WO
176.1 mi
$117.98 per WO
Median Excess
6.8 mi
Outlier Rate (>50mi)
29.4%
117 WOs

Actual Travel Expenses

From 4 WOs with expense data
Total Expenses
$560
Labor - Travel
$455
Mileage
$0
Lodging
$0
Airfare
$0
Car Rental
$0
Per Diem
$50
Meals
$0
Other
$55

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 Fernando Lemos 18 31,382 $21,026 1743.4 mi 1734.7 mi 31,224 $20,920 1743.4
99% excess
2 Side Kick Technician 27 10,652 $7,137 394.5 mi 387.1 mi 10,452 $7,003 394.5
98% excess
3 Christopher Carroll 16 10,495 $7,032 656 mi 598.3 mi 9,573 $6,414 655.9
91% excess
4 Kevin Cogdill 19 4,406 $2,952 231.9 mi 217.5 mi 4,132 $2,768 231.9
94% excess
5 Rozier Cole 13 3,945 $2,643 303.4 mi 267.2 mi 3,474 $2,328 303.5
88% excess
6 Jennifer Johnson 3 3,281 $2,198 1093.8 mi 1077.3 mi 3,232 $2,165 1093.7
99% excess
7 Kenneth Lancara 33 3,274 $2,194 99.2 mi 66 mi 2,179 $1,460 99.2
67% excess
8 Yves Dessin 3 2,017 $1,351 672.2 mi 663.5 mi 1,990 $1,333 672.3
99% excess
9 David Hernandez 36 1,169 $783 32.5 mi 18.7 mi 673 $451 32.5
58% excess
10 Joe Evans 10 1,165 $781 116.5 mi 103.2 mi 1,032 $691 116.5
89% excess
11 Pete Ramos 25 1,165 $781 46.6 mi 31.9 mi 797 $534 46.6
68% excess
12 Carlos Robles 71 635 $425 8.9 mi 6.7 mi 476 $319 8.9
75% excess
13 Chane Lacy 3 570 $382 190 mi 186.3 mi 559 $375 190
98% excess
14 Jon Sanchez 44 513 $344 11.7 mi 0 mi 2 $1 11.7
0% excess
15 Mark Stelter 11 414 $277 37.6 mi 0 mi 0 $0 37.6
0% excess
16 Xiraiyah Coston 16 402 $269 25.1 mi 0 mi 0 $0 25.1
0% excess
17 Franco Jackson 22 316 $212 14.4 mi 1.8 mi 40 $27 14.4
13% excess
18 Daniel Clark 21 226 $151 10.8 mi 0 mi 0 $0 10.8
0% excess
19 Jim Kingery 3 165 $111 55 mi 54.4 mi 163 $109 55
99% excess
20 Torre Gifford 1 79 $53 78.6 mi 67.9 mi 68 $46 79
86% excess
21 Matthew Sebzda 3 64 $43 21.3 mi 6.1 mi 18 $12 21.3
28% excess