Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
23
Total Travel Cost
$8,760
13,075 miles
Avoidable Cost
$8,677
12,950 excess miles
Optimal Cost
$83
If closest tech always used
Avg Excess / WO
563.0 mi
$377.24 per WO
Median Excess
582.6 mi
Outlier Rate (>50mi)
91.3%
21 WOs

Actual Travel Expenses

From 12 WOs with expense data
Total Expenses
$6,838
Labor - Travel
$1,429
Mileage
$0
Lodging
$1,240
Airfare
$2,007
Car Rental
$831
Per Diem
$525
Meals
$0
Other
$806

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)
$6,838
12 WOs with expenses
Billed to Client
$1,124
16.4% recovery rate
Margin Gap (Unbilled)
$5,714
Cost absorbed internally
Avg Expense / WO
$570
Avg billed: $94
Internal Cost
$6,838
Billed
$1,124

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
Airfare 4 4 $2,007 $0 $2,007 0%
Labor - Travel (Hours) 12 5 $1,429 $1,124 $305 78.6%
Lodging 3 3 $1,240 $0 $1,240 0%
Car Rental 6 4 $831 $0 $831 0%
Other Expenses 14 4 $806 $0 $806 0%
Per Diem 11 6 $525 $0 $525 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 12 $6,838 $1,124 $5,714 16.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Inspection 7 $5,409 $0 $5,409 0%
Misc. Inspection 2 $666 $480 $186 72%
Cross-Training 1 $495 $495 $0 100%
Evaluation 1 $149 $149 $0 100%
Repair 1 $119 $0 $119 0%

Monthly Expense Trend — Internal Cost vs Billed