Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
34
Total Travel Cost
$12,032
17,958 miles
Avoidable Cost
$7,947
11,861 excess miles
Optimal Cost
$4,085
If closest tech always used
Avg Excess / WO
348.8 mi
$233.73 per WO
Median Excess
433.3 mi
Outlier Rate (>50mi)
61.8%
21 WOs

Actual Travel Expenses

From 20 WOs with expense data
Total Expenses
$6,608
Labor - Travel
$3,198
Mileage
$210
Lodging
$802
Airfare
$1,160
Car Rental
$352
Per Diem
$300
Meals
$0
Other
$586

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,608
20 WOs with expenses
Billed to Client
$2,813
42.6% recovery rate
Margin Gap (Unbilled)
$3,795
Cost absorbed internally
Avg Expense / WO
$330
Avg billed: $141
Internal Cost
$6,608
Billed
$2,813

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) 32 15 $3,198 $2,125 $1,073 66.5%
Airfare 1 1 $1,160 $0 $1,160 0%
Lodging 5 3 $802 $0 $802 0%
Other Expenses 23 18 $586 $188 $398 32.1%
Car Rental 2 1 $352 $0 $352 0%
Per Diem 7 2 $300 $0 $300 0%
Mileage 6 3 $210 $500 $290 ✓ 237.7%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 24 $6,608 $2,813 $3,795 42.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 8 $3,348 $1,055 $2,293 31.5%
Repair 16 $3,261 $1,758 $1,502 53.9%

Monthly Expense Trend — Internal Cost vs Billed