Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
108
Total Travel Cost
$6,043
9,019 miles
Avoidable Cost
$1,235
1,844 excess miles
Optimal Cost
$4,807
If closest tech always used
Avg Excess / WO
17.1 mi
$11.44 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
15.7%
17 WOs

Actual Travel Expenses

From 58 WOs with expense data
Total Expenses
$22,114
Labor - Travel
$13,823
Mileage
$5,735
Lodging
$1,350
Airfare
$0
Car Rental
$0
Per Diem
$625
Meals
$0
Other
$581

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)
$22,114
58 WOs with expenses
Billed to Client
$14,298
64.7% recovery rate
Margin Gap (Unbilled)
$7,816
Cost absorbed internally
Avg Expense / WO
$381
Avg billed: $247
Internal Cost
$22,114
Billed
$14,298

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) 73 40 $13,823 $8,980 $4,843 65%
Mileage 55 20 $5,735 $4,583 $1,153 79.9%
Lodging 7 7 $1,350 $391 $959 29%
Per Diem 15 8 $625 $75 $550 12%
Other Expenses 42 27 $581 $269 $312 46.3%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 68 $22,114 $14,298 $7,816 64.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 41 $15,642 $9,130 $6,512 58.4%
Preventive Maintenance 25 $5,886 $4,583 $1,304 77.9%
Evaluation 2 $585 $585 $0 100%

Monthly Expense Trend — Internal Cost vs Billed