Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
9
Total Travel Cost
$183
274 miles
Avoidable Cost
$23
34 excess miles
Optimal Cost
$161
If closest tech always used
Avg Excess / WO
3.7 mi
$2.50 per WO
Median Excess
0.5 mi
Outlier Rate (>50mi)
0%
0 WOs

Actual Travel Expenses

From 9 WOs with expense data
Total Expenses
$1,634
Labor - Travel
$1,480
Mileage
$0
Lodging
$0
Airfare
$0
Car Rental
$0
Per Diem
$0
Meals
$0
Other
$154

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,634
9 WOs with expenses
Billed to Client
$389
23.8% recovery rate
Margin Gap (Unbilled)
$1,245
Cost absorbed internally
Avg Expense / WO
$182
Avg billed: $43
Internal Cost
$1,634
Billed
$389

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) 11 8 $1,480 $296 $1,184 20%
Other Expenses 9 6 $154 $93 $61 60.6%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 9 $1,634 $389 $1,245 23.8%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 7 $1,171 $299 $872 25.5%
Installation 1 $373 $0 $373 0%
Misc. Inspection 1 $90 $90 $0 100%

Monthly Expense Trend — Internal Cost vs Billed