Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
57
Total Travel Cost
$2,431
3,629 miles
Avoidable Cost
$1,791
2,674 excess miles
Optimal Cost
$640
If closest tech always used
Avg Excess / WO
46.9 mi
$31.43 per WO
Median Excess
42.1 mi
Outlier Rate (>50mi)
28.1%
16 WOs

Actual Travel Expenses

From 52 WOs with expense data
Total Expenses
$12,164
Labor - Travel
$9,342
Mileage
$0
Lodging
$612
Airfare
$582
Car Rental
$381
Per Diem
$600
Meals
$0
Other
$646

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)
$12,164
52 WOs with expenses
Billed to Client
$5,251
43.2% recovery rate
Margin Gap (Unbilled)
$6,912
Cost absorbed internally
Avg Expense / WO
$234
Avg billed: $101
Internal Cost
$12,164
Billed
$5,251

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) 74 51 $9,342 $4,977 $4,365 53.3%
Other Expenses 36 30 $646 $274 $372 42.4%
Lodging 2 2 $612 $0 $612 0%
Per Diem 16 12 $600 $0 $600 0%
Airfare 1 1 $582 $0 $582 0%
Car Rental 2 1 $381 $0 $381 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Animal Health 53 $12,164 $5,251 $6,912 43.2%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 23 $3,622 $2,742 $879 75.7%
Repair 8 $3,594 $1,634 $1,960 45.5%
Installation 4 $3,098 $158 $2,940 5.1%
Misc. Inspection 16 $1,671 $718 $954 42.9%
Asset Tagging 1 $119 $0 $119 0%
Evaluation 1 $60 $0 $60 0%

Monthly Expense Trend — Internal Cost vs Billed