Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
2,224
Total Travel Cost
$169,090
252,373 miles
Avoidable Cost
$144,968
216,370 excess miles
Optimal Cost
$24,122
If closest tech always used
Avg Excess / WO
97.3 mi
$65.18 per WO
Median Excess
4.3 mi
Outlier Rate (>50mi)
18.5%
411 WOs

Actual Travel Expenses

From 145 WOs with expense data
Total Expenses
$97,784
Labor - Travel
$10,733
Mileage
$0
Lodging
$26,715
Airfare
$27,050
Car Rental
$12,518
Per Diem
$9,825
Meals
$0
Other
$10,943

Cost by Vertical

VerticalWOsAvg ExcessTotal ExcessAvoidable Cost
Lab/Power 2,224 97.3 mi 216,370 $144,968

Cost by Order Type

Order TypeWOsAvg ExcessTotal ExcessAvoidable Cost
Overhaul P 73 951.6 mi 69,467 $46,543
Repair/PM R 68 567.9 mi 38,618 $25,874
Repair R 1,429 21.6 mi 30,908 $20,708
PM/CAL P 71 356.8 mi 25,334 $16,974
Monthly Annuity P 24 859.5 mi 20,628 $13,821
Preventive Maintenance P 341 51.5 mi 17,577 $11,777
IOQ P 22 276.2 mi 6,076 $4,071
Acct. Management P 72 29.1 mi 2,096 $1,404
EOQ P 69 28.4 mi 1,957 $1,311
PM-EXT P 2 677.0 mi 1,354 $907
Training P 1 840.4 mi 840 $563
PQ Only P 1 329.2 mi 329 $220
EIQ P 4 79.6 mi 318 $213
Part Order P 2 156.4 mi 313 $210
Relocation P 3 79.6 mi 239 $160
Installation P 5 46.5 mi 232 $155
Site Prep P 2 39.8 mi 80 $54
Inventory P 1 4.3 mi 4 $3
Cross-Training P 28 0.0 mi 0 $0
Calibration P 6 0.0 mi 0 $0

Cost by State

States with high avg actual distance may indicate coverage gaps requiring territory realignment or new hires.

StateWOsAvg ActualAvg ExcessTotal Excess MilesAvoidable CostOutliers (>50mi)Cost Distribution
TX 196 233.9 mi 212.2 mi 41,600 $27,872 149 (76%)
CA 322 117.3 mi 100.7 mi 32,440 $21,735 50 (15.5%)
CO 19 1368.0 mi 1349.3 mi 25,637 $17,177 18 (94.7%)
NM 71 362.4 mi 356.8 mi 25,334 $16,974 71 (100%)
OR 10 1797.1 mi 1579.2 mi 15,792 $10,581 9 (90%)
MI 14 658.2 mi 609.3 mi 8,530 $5,715 14 (100%)
MA 1,388 5.8 mi 5.5 mi 7,590 $5,085 1 (0.1%)
MN 8 833.0 mi 816.8 mi 6,535 $4,378 6 (75%)
WA 6 1276.2 mi 891.8 mi 5,351 $3,585 5 (83.3%)
PA 17 460.7 mi 310.8 mi 5,284 $3,540 14 (82.4%)
AL 7 736.7 mi 566.0 mi 3,962 $2,655 4 (57.1%)
OK 17 220.5 mi 203.6 mi 3,462 $2,320 17 (100%)
IL 6 589.0 mi 466.8 mi 2,801 $1,877 4 (66.7%)
GA 7 614.9 mi 384.5 mi 2,692 $1,804 3 (42.9%)
HI 1 5056.8 mi 2644.7 mi 2,645 $1,772 1 (100%)
NY 10 267.5 mi 246.1 mi 2,461 $1,649 9 (90%)
FL 2 1141.3 mi 1137.8 mi 2,276 $1,525 2 (100%)
AZ 1 2255.3 mi 2244.9 mi 2,245 $1,504 1 (100%)
NC 9 315.6 mi 212.9 mi 1,916 $1,284 3 (33.3%)
WI 2 902.8 mi 854.7 mi 1,709 $1,145 2 (100%)
SC 11 353.9 mi 138.2 mi 1,520 $1,018 2 (18.2%)
MS 2 880.5 mi 755.2 mi 1,510 $1,012 2 (100%)
KS 2 1017.7 mi 739.8 mi 1,480 $992 2 (100%)
DE 23 142.4 mi 64.0 mi 1,473 $987 1 (4.3%)
IN 4 544.5 mi 366.9 mi 1,468 $984 2 (50%)
LA 1 1338.9 mi 1325.0 mi 1,325 $888 1 (100%)
VA 4 327.7 mi 299.7 mi 1,199 $803 3 (75%)
NE 1 1296.6 mi 1156.9 mi 1,157 $775 1 (100%)
IA 1 879.9 mi 840.4 mi 840 $563 1 (100%)
KY 1 749.2 mi 693.3 mi 693 $464 1 (100%)
OH 10 121.4 mi 50.2 mi 502 $336 1 (10%)
ON 1 503.1 mi 435.5 mi 436 $292 1 (100%)
DC 1 384.5 mi 362.6 mi 363 $243 1 (100%)
MO 1 862.9 mi 351.4 mi 351 $235 1 (100%)
MD 1 345.1 mi 335.3 mi 335 $224 1 (100%)
MT 1 867.1 mi 306.5 mi 307 $206 1 (100%)
ID 2 674.8 mi 151.3 mi 303 $203 2 (100%)
NJ 2 145.2 mi 129.4 mi 259 $174 1 (50%)
NH 5 58.4 mi 45.9 mi 230 $154 2 (40%)
AR 6 114.3 mi 37.3 mi 224 $150 0 (0%)
CT 5 93.2 mi 27.7 mi 138 $92 1 (20%)
UT 26 0.0 mi 0.0 mi 0 $0 0 (0%)