Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
293
Total Travel Cost
$9,356
13,964 miles
Avoidable Cost
$5,514
8,230 excess miles
Optimal Cost
$3,909
If closest tech always used
Avg Excess / WO
27.7 mi
$18.59 per WO
Median Excess
14.7 mi
Outlier Rate (>50mi)
6.8%
20 WOs

Actual Travel Expenses

From 204 WOs with expense data
Total Expenses
$70,617
Labor - Travel
$62,013
Mileage
$0
Lodging
$1,858
Airfare
$1,817
Car Rental
$3,372
Per Diem
$425
Meals
$0
Other
$1,133

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)
$70,617
204 WOs with expenses
Billed to Client
$16,435
23.3% recovery rate
Margin Gap (Unbilled)
$54,183
Cost absorbed internally
Avg Expense / WO
$346
Avg billed: $81
Internal Cost
$70,617
Billed
$16,435

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) 393 191 $62,013 $15,095 $46,917 24.3%
Car Rental 35 11 $3,372 $0 $3,372 0%
Lodging 5 5 $1,858 $385 $1,473 20.7%
Airfare 3 3 $1,817 $646 $1,171 35.5%
Other Expenses 80 58 $1,133 $308 $825 27.2%
Per Diem 9 2 $425 $0 $425 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 207 $70,617 $16,435 $54,183 23.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 132 $44,528 $10,928 $33,600 24.5%
Cross-Training 14 $12,571 $0 $12,571 0%
Misc. Inspection 26 $5,141 $4,783 $359 93%
Inspection 18 $4,625 $0 $4,625 0%
Preventive Maintenance 8 $1,912 $0 $1,912 0%
Evaluation 4 $1,257 $724 $533 57.6%
Installation 4 $474 $0 $474 0%
Delivery 1 $110 $0 $110 0%

Monthly Expense Trend — Internal Cost vs Billed