Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
78
Total Travel Cost
$7,278
10,863 miles
Avoidable Cost
$2,766
4,129 excess miles
Optimal Cost
$4,512
If closest tech always used
Avg Excess / WO
52.9 mi
$35.47 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
11.5%
9 WOs

Actual Travel Expenses

From 33 WOs with expense data
Total Expenses
$9,931
Labor - Travel
$2,181
Mileage
$5,034
Lodging
$2,394
Airfare
$0
Car Rental
$0
Per Diem
$25
Meals
$0
Other
$298

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)
$9,931
33 WOs with expenses
Billed to Client
$3,045
30.7% recovery rate
Margin Gap (Unbilled)
$6,886
Cost absorbed internally
Avg Expense / WO
$301
Avg billed: $92
Internal Cost
$9,931
Billed
$3,045

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
Mileage 88 20 $5,034 $1,325 $3,709 26.3%
Lodging 7 6 $2,394 $0 $2,394 0%
Labor - Travel (Hours) 37 22 $2,181 $1,683 $498 77.1%
Other Expenses 20 18 $298 $37 $260 12.6%
Per Diem 1 1 $25 $0 $25 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 45 $9,931 $3,045 $6,886 30.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 20 $7,463 $1,325 $6,138 17.8%
Repair 18 $2,086 $1,362 $723 65.3%
Evaluation 5 $358 $358 $0 100%
Inspection 2 $25 $0 $25 0%

Monthly Expense Trend — Internal Cost vs Billed