Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
9
Total Travel Cost
$1,004
1,498 miles
Avoidable Cost
$731
1,091 excess miles
Optimal Cost
$272
If closest tech always used
Avg Excess / WO
121.3 mi
$81.25 per WO
Median Excess
115.3 mi
Outlier Rate (>50mi)
88.9%
8 WOs

Actual Travel Expenses

From 7 WOs with expense data
Total Expenses
$13,724
Labor - Travel
$0
Mileage
$0
Lodging
$7,421
Airfare
$942
Car Rental
$239
Per Diem
$2,800
Meals
$0
Other
$2,322

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)
$13,724
7 WOs with expenses
Billed to Client
$900
6.6% recovery rate
Margin Gap (Unbilled)
$12,824
Cost absorbed internally
Avg Expense / WO
$1,961
Avg billed: $129
Internal Cost
$13,724
Billed
$900

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 16 6 $7,421 $0 $7,421 0%
Per Diem 66 7 $2,800 $0 $2,800 0%
Other Expenses 37 5 $2,322 $900 $1,422 38.8%
Airfare 1 1 $942 $0 $942 0%
Car Rental 2 1 $239 $0 $239 0%
Labor - Travel (Hours) 137 8 $0 $0 $0 ✓ 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Installation 8 $13,724 $900 $12,824 6.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Installation 7 $13,724 $900 $12,824 6.6%
Repair 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed