Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
98
Total Travel Cost
$20,375
30,411 miles
Avoidable Cost
$12,489
18,640 excess miles
Optimal Cost
$7,886
If closest tech always used
Avg Excess / WO
190.2 mi
$127.44 per WO
Median Excess
271.4 mi
Outlier Rate (>50mi)
79.6%
78 WOs

Actual Travel Expenses

From 77 WOs with expense data
Total Expenses
$22,616
Labor - Travel
$15,868
Mileage
$0
Lodging
$3,938
Airfare
$732
Car Rental
$221
Per Diem
$1,525
Meals
$0
Other
$333

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)
$22,616
77 WOs with expenses
Billed to Client
$14,631
64.7% recovery rate
Margin Gap (Unbilled)
$7,985
Cost absorbed internally
Avg Expense / WO
$294
Avg billed: $190
Internal Cost
$22,616
Billed
$14,631

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) 70 57 $15,868 $10,985 $4,883 69.2%
Lodging 27 20 $3,938 $2,397 $1,541 60.9%
Per Diem 35 23 $1,525 $220 $1,305 14.4%
Airfare 1 1 $732 $732 $0 ✓ 100%
Other Expenses 28 22 $333 $76 $257 22.8%
Car Rental 1 1 $221 $221 $0 ✓ 100%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 77 $22,616 $14,631 $7,985 64.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 66 $17,048 $9,653 $7,395 56.6%
Installation 9 $5,395 $4,860 $535 90.1%
FMI 32097 2 $173 $118 $55 68.1%

Monthly Expense Trend — Internal Cost vs Billed