Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
70
Total Travel Cost
$12,396
18,501 miles
Avoidable Cost
$8,676
12,950 excess miles
Optimal Cost
$3,720
If closest tech always used
Avg Excess / WO
185.0 mi
$123.95 per WO
Median Excess
127.1 mi
Outlier Rate (>50mi)
67.1%
47 WOs

Actual Travel Expenses

From 38 WOs with expense data
Total Expenses
$13,797
Labor - Travel
$5,813
Mileage
$0
Lodging
$4,343
Airfare
$789
Car Rental
$489
Per Diem
$1,700
Meals
$0
Other
$664

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)
$13,797
38 WOs with expenses
Billed to Client
$6,357
46.1% recovery rate
Margin Gap (Unbilled)
$7,441
Cost absorbed internally
Avg Expense / WO
$363
Avg billed: $167
Internal Cost
$13,797
Billed
$6,357

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) 9 3 $5,813 $2,325 $3,488 40%
Lodging 31 17 $4,343 $4,032 $311 92.8%
Per Diem 39 18 $1,700 $0 $1,700 0%
Airfare 1 1 $789 $0 $789 0%
Other Expenses 54 34 $664 $0 $664 0%
Car Rental 6 3 $489 $0 $489 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 38 $13,797 $6,357 $7,441 46.1%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 25 $10,411 $3,960 $6,451 38%
Installation 13 $3,386 $2,397 $989 70.8%

Monthly Expense Trend — Internal Cost vs Billed