Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
10
Total Travel Cost
$5,664
8,454 miles
Avoidable Cost
$3,983
5,945 excess miles
Optimal Cost
$1,681
If closest tech always used
Avg Excess / WO
594.5 mi
$398.32 per WO
Median Excess
991.2 mi
Outlier Rate (>50mi)
70%
7 WOs

Actual Travel Expenses

From 9 WOs with expense data
Total Expenses
$76,169
Labor - Travel
$64,014
Mileage
$0
Lodging
$3,027
Airfare
$5,362
Car Rental
$1,521
Per Diem
$975
Meals
$28
Other
$1,243

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)
$76,169
9 WOs with expenses
Billed to Client
$46,693
61.3% recovery rate
Margin Gap (Unbilled)
$29,476
Cost absorbed internally
Avg Expense / WO
$8,463
Avg billed: $5,188
Internal Cost
$76,169
Billed
$46,693

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) 44 8 $64,014 $46,693 $17,321 72.9%
Airfare 12 6 $5,362 $0 $5,362 0%
Lodging 19 6 $3,027 $0 $3,027 0%
Car Rental 8 5 $1,521 $0 $1,521 0%
Other Expenses 18 7 $1,243 $0 $1,243 0%
Per Diem 22 7 $975 $0 $975 0%
Meals 1 1 $28 $0 $28 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 5 $73,268 $45,880 $27,388 62.6%
Healthcare Provider 5 $2,901 $813 $2,088 28%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Installation 5 $73,268 $45,880 $27,388 62.6%
Inspection 2 $2,083 $0 $2,083 0%
Repair 3 $818 $813 $5 99.4%

Monthly Expense Trend — Internal Cost vs Billed