Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
289
Total Travel Cost
$29,971
44,732 miles
Avoidable Cost
$19,541
29,166 excess miles
Optimal Cost
$10,429
If closest tech always used
Avg Excess / WO
100.9 mi
$67.62 per WO
Median Excess
63.6 mi
Outlier Rate (>50mi)
55.4%
160 WOs

Actual Travel Expenses

From 161 WOs with expense data
Total Expenses
$36,592
Labor - Travel
$19,724
Mileage
$2
Lodging
$9,571
Airfare
$0
Car Rental
$0
Per Diem
$4,725
Meals
$0
Other
$2,570

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)
$36,592
161 WOs with expenses
Billed to Client
$16,577
45.3% recovery rate
Margin Gap (Unbilled)
$20,015
Cost absorbed internally
Avg Expense / WO
$227
Avg billed: $103
Internal Cost
$36,592
Billed
$16,577

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) 140 91 $19,724 $9,300 $10,424 47.2%
Lodging 62 40 $9,571 $7,277 $2,294 76%
Per Diem 112 68 $4,725 $0 $4,725 0%
Other Expenses 167 102 $2,570 $0 $2,570 0%
Mileage 4 4 $2 $0 $2 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 194 $36,592 $16,577 $20,015 45.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 97 $20,852 $8,079 $12,773 38.7%
Installation 31 $11,127 $7,413 $3,714 66.6%
Preventive Maintenance 63 $4,298 $930 $3,368 21.6%
Repair 1 $161 $155 $6 96.3%
PM 2 $154 $0 $154 0%

Monthly Expense Trend — Internal Cost vs Billed