Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
126
Total Travel Cost
$5,177
7,727 miles
Avoidable Cost
$2,021
3,016 excess miles
Optimal Cost
$3,156
If closest tech always used
Avg Excess / WO
23.9 mi
$16.04 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
7.9%
10 WOs

Actual Travel Expenses

From 29 WOs with expense data
Total Expenses
$5,596
Labor - Travel
$4,263
Mileage
$0
Lodging
$746
Airfare
$0
Car Rental
$0
Per Diem
$350
Meals
$0
Other
$238

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)
$5,596
29 WOs with expenses
Billed to Client
$2,790
49.9% recovery rate
Margin Gap (Unbilled)
$2,806
Cost absorbed internally
Avg Expense / WO
$193
Avg billed: $96
Internal Cost
$5,596
Billed
$2,790

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) 28 16 $4,263 $2,790 $1,473 65.5%
Lodging 5 2 $746 $0 $746 0%
Per Diem 8 3 $350 $0 $350 0%
Other Expenses 23 17 $238 $0 $238 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 32 $5,596 $2,790 $2,806 49.9%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 18 $2,330 $1,240 $1,090 53.2%
Repair 8 $2,015 $1,240 $775 61.5%
Preventive Maintenance 5 $1,196 $310 $886 25.9%
Installation 1 $55 $0 $55 0%

Monthly Expense Trend — Internal Cost vs Billed