Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
828
Total Travel Cost
$139,277
207,876 miles
Avoidable Cost
$130,893
195,363 excess miles
Optimal Cost
$8,383
If closest tech always used
Avg Excess / WO
235.9 mi
$158.08 per WO
Median Excess
6.8 mi
Outlier Rate (>50mi)
36.5%
302 WOs

Actual Travel Expenses

From 40 WOs with expense data
Total Expenses
$19,214
Labor - Travel
$0
Mileage
$0
Lodging
$6,965
Airfare
$3,765
Car Rental
$2,673
Per Diem
$1,925
Meals
$0
Other
$3,887

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)
$19,214
40 WOs with expenses
Billed to Client
$200
1% recovery rate
Margin Gap (Unbilled)
$19,014
Cost absorbed internally
Avg Expense / WO
$480
Avg billed: $5
Internal Cost
$19,214
Billed
$200

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
Lodging 8 8 $6,965 $0 $6,965 0%
Other Expenses 56 44 $3,887 $0 $3,887 0%
Airfare 6 5 $3,765 $0 $3,765 0%
Car Rental 11 6 $2,673 $0 $2,673 0%
Per Diem 39 11 $1,925 $200 $1,725 10.4%
Labor - Travel (Hours) 167 148 $0 $0 $0 ✓ 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Bed Services 175 $19,214 $200 $19,014 1%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 127 $15,498 $200 $15,298 1.3%
Repair 46 $3,716 $0 $3,716 0%
Evaluation 2 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed