Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,107
Total Travel Cost
$171,315
255,694 miles
Avoidable Cost
$152,464
227,558 excess miles
Optimal Cost
$18,851
If closest tech always used
Avg Excess / WO
205.6 mi
$137.73 per WO
Median Excess
6.8 mi
Outlier Rate (>50mi)
44%
487 WOs

Actual Travel Expenses

From 173 WOs with expense data
Total Expenses
$48,784
Labor - Travel
$12,428
Mileage
$943
Lodging
$15,955
Airfare
$3,765
Car Rental
$2,673
Per Diem
$5,950
Meals
$0
Other
$7,070

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 33 60,810 $40,743 1842.7 mi 1836.7 mi 60,611 $40,609 1842.7
100% excess
2 Yves Dessin 81 54,475 $36,498 672.5 mi 662.4 mi 53,651 $35,946 672.5
98% excess
3 Michael Swingle 41 22,378 $14,993 545.8 mi 504.9 mi 20,700 $13,869 545.8
93% excess
4 Ryan Lewis 58 17,693 $11,854 305 mi 250.8 mi 14,547 $9,746 305.1
82% excess
5 Side Kick Technician 43 16,591 $11,116 385.8 mi 378.4 mi 16,271 $10,902 385.8
98% excess
6 Christopher Carroll 23 15,654 $10,488 680.6 mi 624.8 mi 14,369 $9,627 680.6
92% excess
7 Rozier Cole 53 14,798 $9,915 279.2 mi 256.2 mi 13,578 $9,097 279.2
92% excess
8 Kenneth Lancara 19 10,382 $6,956 546.4 mi 538.6 mi 10,234 $6,857 546.4
99% excess
9 Praelow Cameron 37 7,794 $5,222 210.6 mi 127.8 mi 4,730 $3,169 210.6
61% excess
10 Todd Fogiel 35 5,171 $3,465 147.7 mi 47.3 mi 1,657 $1,110 147.7
32% excess
11 Torre Gifford 10 4,901 $3,284 490.1 mi 483.5 mi 4,835 $3,239 490.1
99% excess
12 Xiraiyah Coston 158 4,539 $3,041 28.7 mi 0 mi 0 $0 28.7
0% excess
13 Jeffrey Coles 28 3,449 $2,311 123.2 mi 79.1 mi 2,216 $1,485 123.2
64% excess
14 Allan Klus 48 3,128 $2,096 65.2 mi 31.2 mi 1,497 $1,003 65.2
48% excess
15 Christopher Morning 20 2,953 $1,979 147.6 mi 117.3 mi 2,345 $1,571 147.7
79% excess
16 Carlos Robles 197 1,741 $1,166 8.8 mi 6.7 mi 1,312 $879 8.8
75% excess
17 Patricia Gordon 12 1,625 $1,089 135.4 mi 10.2 mi 123 $82 135.4
8% excess
18 Jon Sanchez 143 1,433 $960 10 mi 0 mi 4 $3 10
0% excess
19 Fady Messak 4 891 $597 222.7 mi 189.7 mi 759 $509 222.8
85% excess
20 Fady Khouzam 3 859 $576 286.4 mi 266.4 mi 799 $535 286.3
93% excess
21 Joe Hudson 8 800 $536 100 mi 63.7 mi 509 $341 100
64% excess
22 Raymond Ebanks 1 756 $507 755.6 mi 629.8 mi 630 $422 756
83% excess
23 Michael Harris 5 689 $462 137.8 mi 124.7 mi 624 $418 137.8
91% excess
24 Rick Charles 3 676 $453 225.2 mi 219 mi 657 $440 225.3
97% excess
25 David Hernandez 36 496 $332 13.8 mi 0 mi 0 $0 13.8
0% excess
26 Charles Sellon 1 483 $324 483.1 mi 475.1 mi 475 $318 483
98% excess
27 Shawn Kelley 1 396 $265 396.2 mi 383.9 mi 384 $257 396
97% excess
28 Solomon Young 6 135 $90 22.5 mi 7.1 mi 43 $29 22.5
32% excess