Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
39
Total Travel Cost
$13,438
20,056 miles
Avoidable Cost
$7,189
10,729 excess miles
Optimal Cost
$6,249
If closest tech always used
Avg Excess / WO
275.1 mi
$184.33 per WO
Median Excess
135.0 mi
Outlier Rate (>50mi)
100%
39 WOs

Actual Travel Expenses

From 9 WOs with expense data
Total Expenses
$15,863
Labor - Travel
$9,455
Mileage
$0
Lodging
$1,678
Airfare
$2,869
Car Rental
$805
Per Diem
$575
Meals
$0
Other
$482

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)
$15,863
9 WOs with expenses
Billed to Client
$8,913
56.2% recovery rate
Margin Gap (Unbilled)
$6,950
Cost absorbed internally
Avg Expense / WO
$1,763
Avg billed: $990
Internal Cost
$15,863
Billed
$8,913

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) 14 7 $9,455 $5,735 $3,720 60.7%
Airfare 6 3 $2,869 $2,076 $793 72.4%
Lodging 10 3 $1,678 $1,033 $645 61.6%
Car Rental 8 3 $805 $0 $805 0%
Per Diem 13 3 $575 $0 $575 0%
Other Expenses 14 4 $482 $70 $412 14.5%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 9 $15,863 $8,913 $6,950 56.2%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 9 $15,863 $8,913 $6,950 56.2%

Monthly Expense Trend — Internal Cost vs Billed