Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
37
Total Travel Cost
$5,720
8,537 miles
Avoidable Cost
$137
205 excess miles
Optimal Cost
$5,583
If closest tech always used
Avg Excess / WO
5.5 mi
$3.71 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
5.4%
2 WOs

Actual Travel Expenses

From 15 WOs with expense data
Total Expenses
$1,795
Labor - Travel
$155
Mileage
$0
Lodging
$968
Airfare
$0
Car Rental
$0
Per Diem
$425
Meals
$0
Other
$247

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)
$1,795
15 WOs with expenses
Billed to Client
$1,123
62.6% recovery rate
Margin Gap (Unbilled)
$672
Cost absorbed internally
Avg Expense / WO
$120
Avg billed: $75
Internal Cost
$1,795
Billed
$1,123

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
Lodging 8 4 $968 $968 $0 ✓ 100%
Per Diem 10 8 $425 $0 $425 0%
Other Expenses 20 11 $247 $0 $247 0%
Labor - Travel (Hours) 1 1 $155 $155 $0 ✓ 100%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 15 $1,795 $1,123 $672 62.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 14 $1,593 $1,015 $578 63.7%
Installation 1 $202 $108 $94 53.4%

Monthly Expense Trend — Internal Cost vs Billed