Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
5,416
Total Travel Cost
$311,576
465,038 miles
Avoidable Cost
$197,895
295,366 excess miles
Optimal Cost
$113,747
If closest tech always used
Avg Excess / WO
54.5 mi
$36.53 per WO
Median Excess
11.2 mi
Outlier Rate (>50mi)
23.7%
1,282 WOs

Actual Travel Expenses

From 3,655 WOs with expense data
Total Expenses
$1,354,472
Labor - Travel
$1,158,630
Mileage
$631
Lodging
$78,337
Airfare
$33,320
Car Rental
$23,850
Per Diem
$28,475
Meals
$0
Other
$31,228

Billable vs Internal Cost — Margin Gap

Compares what was billed to clients against what we actually paid for travel expenses. The gap represents unbilled internal cost.

Internal Cost (What We Paid)
$1,354,471
3,655 WOs with expenses
Billed to Client
$316,423
23.4% recovery rate
Margin Gap (Unbilled)
$1,038,048
Cost absorbed internally
Avg Expense / WO
$371
Avg billed: $87
Internal Cost
$1,354,471
Billed
$316,423

Expense Breakdown by Category

Internal cost vs billed amount by expense type. Negative margin = we paid more than we billed.

Category Lines WOs Internal Cost Billed to Client Margin Gap Recovery % Gap Distribution
Labor - Travel (Hours) 6,767 3,341 $1,158,630 $298,685 $859,945 25.8%
Lodging 237 207 $78,337 $8,890 $69,447 11.3%
Airfare 65 53 $33,320 $2,550 $30,770 7.7%
Other Expenses 1,685 1,073 $31,228 $4,917 $26,311 15.7%
Per Diem 671 400 $28,475 $525 $27,950 1.8%
Car Rental 205 114 $23,850 $0 $23,850 0%
Mileage 13 7 $631 $857 $226 ✓ 135.8%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 3,746 $1,354,471 $316,423 $1,038,048 23.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 2,348 $838,215 $151,730 $686,485 18.1%
Inspection 469 $161,574 $13,208 $148,366 8.2%
Misc. Inspection 333 $85,893 $64,992 $20,901 75.7%
Delivery 123 $77,575 $46,562 $31,014 60%
Cross-Training 52 $68,069 $1,664 $66,405 2.4%
Preventive Maintenance 232 $53,078 $4,350 $48,728 8.2%
Evaluation 76 $23,885 $15,696 $8,188 65.7%
Installation 50 $23,558 $9,902 $13,656 42%
Calibration 34 $13,713 $5,480 $8,233 40%
Repair/PM 2 $2,736 $1,079 $1,656 39.5%
COMPLAINT 1 $2,597 $0 $2,597 0%
Removal 7 $1,657 $1,157 $500 69.8%
New Hire Training 1 $651 $0 $651 0%
Relocation 1 $484 $484 $0 100%
Support 14 $361 $0 $361 0%
Warranty 1 $232 $0 $232 0%
SWAPOUT 1 $119 $119 $0 100%
Asset Tagging 1 $75 $0 $75 0%

Monthly Expense Trend — Internal Cost vs Billed