Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
84
Total Travel Cost
$8,314
12,409 miles
Avoidable Cost
$3,999
5,969 excess miles
Optimal Cost
$4,315
If closest tech always used
Avg Excess / WO
71.1 mi
$47.61 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
21.4%
18 WOs

Actual Travel Expenses

From 49 WOs with expense data
Total Expenses
$10,236
Labor - Travel
$8,025
Mileage
$1,187
Lodging
$118
Airfare
$0
Car Rental
$0
Per Diem
$125
Meals
$0
Other
$781

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)
$10,236
49 WOs with expenses
Billed to Client
$6,535
63.8% recovery rate
Margin Gap (Unbilled)
$3,702
Cost absorbed internally
Avg Expense / WO
$209
Avg billed: $133
Internal Cost
$10,236
Billed
$6,535

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) 70 41 $8,025 $5,555 $2,470 69.2%
Mileage 17 5 $1,187 $500 $687 42.1%
Other Expenses 48 37 $781 $480 $302 61.4%
Per Diem 4 4 $125 $0 $125 0%
Lodging 2 2 $118 $0 $118 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 60 $10,236 $6,535 $3,702 63.8%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 47 $7,742 $5,535 $2,208 71.5%
Evaluation 5 $1,240 $500 $740 40.3%
Preventive Maintenance 7 $1,236 $500 $736 40.4%
Part Order 1 $18 $0 $18 0%

Monthly Expense Trend — Internal Cost vs Billed