Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
19
Total Travel Cost
$6,615
9,873 miles
Avoidable Cost
$5,264
7,857 excess miles
Optimal Cost
$1,351
If closest tech always used
Avg Excess / WO
413.5 mi
$277.06 per WO
Median Excess
490.9 mi
Outlier Rate (>50mi)
68.4%
13 WOs

Actual Travel Expenses

From 5 WOs with expense data
Total Expenses
$6,604
Labor - Travel
$3,975
Mileage
$0
Lodging
$1,076
Airfare
$885
Car Rental
$158
Per Diem
$75
Meals
$0
Other
$435

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)
$6,604
5 WOs with expenses
Billed to Client
$5,199
78.7% recovery rate
Margin Gap (Unbilled)
$1,406
Cost absorbed internally
Avg Expense / WO
$1,321
Avg billed: $1,040
Internal Cost
$6,604
Billed
$5,199

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) 10 7 $3,975 $3,680 $295 92.6%
Lodging 3 2 $1,076 $233 $843 21.6%
Airfare 1 1 $885 $1,018 $133 ✓ 115%
Other Expenses 8 3 $435 $121 $314 27.9%
Car Rental 3 1 $158 $147 $12 92.6%
Per Diem 2 1 $75 $0 $75 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 7 $6,604 $5,199 $1,406 78.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 4 $6,592 $5,199 $1,394 78.9%
Preventive Maintenance 3 $12 $0 $12 0%

Monthly Expense Trend — Internal Cost vs Billed