Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
406
Total Travel Cost
$20,967
31,294 miles
Avoidable Cost
$12,571
18,763 excess miles
Optimal Cost
$8,396
If closest tech always used
Avg Excess / WO
46.2 mi
$30.96 per WO
Median Excess
20.1 mi
Outlier Rate (>50mi)
30.5%
124 WOs

Actual Travel Expenses

From 227 WOs with expense data
Total Expenses
$86,845
Labor - Travel
$66,059
Mileage
$0
Lodging
$10,262
Airfare
$2,316
Car Rental
$2,020
Per Diem
$3,325
Meals
$0
Other
$2,862

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)
$86,845
227 WOs with expenses
Billed to Client
$18,540
21.3% recovery rate
Margin Gap (Unbilled)
$68,305
Cost absorbed internally
Avg Expense / WO
$383
Avg billed: $82
Internal Cost
$86,845
Billed
$18,540

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) 379 183 $66,059 $17,857 $48,203 27%
Lodging 27 24 $10,262 $529 $9,733 5.2%
Per Diem 78 48 $3,325 $0 $3,325 0%
Other Expenses 68 52 $2,862 $155 $2,707 5.4%
Airfare 3 3 $2,316 $0 $2,316 0%
Car Rental 18 10 $2,020 $0 $2,020 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 235 $86,845 $18,540 $68,305 21.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 118 $38,445 $6,764 $31,681 17.6%
Inspection 52 $21,682 $298 $21,384 1.4%
Misc. Inspection 37 $11,314 $7,904 $3,410 69.9%
Cross-Training 5 $9,178 $0 $9,178 0%
Delivery 4 $1,866 $1,471 $395 78.8%
Calibration 4 $1,700 $998 $702 58.7%
Evaluation 3 $1,219 $1,105 $114 90.7%
Preventive Maintenance 9 $1,091 $0 $1,091 0%
Removal 1 $351 $0 $351 0%
Installation 1 $0 $0 $0 0%
Support 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed