Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
38
Total Travel Cost
$15,516
23,158 miles
Avoidable Cost
$14,931
22,285 excess miles
Optimal Cost
$585
If closest tech always used
Avg Excess / WO
586.4 mi
$392.92 per WO
Median Excess
584.1 mi
Outlier Rate (>50mi)
94.7%
36 WOs

Actual Travel Expenses

From 25 WOs with expense data
Total Expenses
$22,020
Labor - Travel
$7,907
Mileage
$0
Lodging
$3,329
Airfare
$5,217
Car Rental
$2,061
Per Diem
$1,400
Meals
$0
Other
$2,106

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)
$22,020
25 WOs with expenses
Billed to Client
$2,488
11.3% recovery rate
Margin Gap (Unbilled)
$19,531
Cost absorbed internally
Avg Expense / WO
$881
Avg billed: $100
Internal Cost
$22,020
Billed
$2,488

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) 46 17 $7,907 $2,462 $5,445 31.1%
Airfare 13 10 $5,217 $0 $5,217 0%
Lodging 9 9 $3,329 $0 $3,329 0%
Other Expenses 30 10 $2,106 $26 $2,079 1.3%
Car Rental 15 10 $2,061 $0 $2,061 0%
Per Diem 29 13 $1,400 $0 $1,400 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 25 $22,020 $2,488 $19,531 11.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 10 $9,258 $1,768 $7,489 19.1%
Inspection 8 $7,303 $0 $7,303 0%
Cross-Training 2 $2,588 $0 $2,588 0%
Preventive Maintenance 1 $1,828 $0 $1,828 0%
Misc. Inspection 3 $894 $571 $323 63.9%
Evaluation 1 $149 $149 $0 100%

Monthly Expense Trend — Internal Cost vs Billed