Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
26
Total Travel Cost
$1,646
2,457 miles
Avoidable Cost
$1,056
1,577 excess miles
Optimal Cost
$590
If closest tech always used
Avg Excess / WO
60.6 mi
$40.63 per WO
Median Excess
8.6 mi
Outlier Rate (>50mi)
38.5%
10 WOs

Actual Travel Expenses

From 20 WOs with expense data
Total Expenses
$12,202
Labor - Travel
$9,780
Mileage
$0
Lodging
$773
Airfare
$652
Car Rental
$576
Per Diem
$325
Meals
$0
Other
$96

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)
$12,202
20 WOs with expenses
Billed to Client
$2,602
21.3% recovery rate
Margin Gap (Unbilled)
$9,600
Cost absorbed internally
Avg Expense / WO
$610
Avg billed: $130
Internal Cost
$12,202
Billed
$2,602

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) 47 20 $9,780 $2,546 $7,234 26%
Lodging 3 3 $773 $0 $773 0%
Airfare 1 1 $652 $0 $652 0%
Car Rental 2 1 $576 $0 $576 0%
Per Diem 8 3 $325 $0 $325 0%
Other Expenses 7 7 $96 $56 $40 58.5%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 20 $12,202 $2,602 $9,600 21.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Cross-Training 6 $7,184 $1,843 $5,342 25.6%
Repair 9 $3,258 $264 $2,994 8.1%
Installation 2 $1,375 $495 $880 36%
Delivery 3 $385 $0 $385 0%

Monthly Expense Trend — Internal Cost vs Billed