Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
120
Total Travel Cost
$7,657
11,429 miles
Avoidable Cost
$3,943
5,885 excess miles
Optimal Cost
$3,715
If closest tech always used
Avg Excess / WO
49.0 mi
$32.86 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
30%
36 WOs

Actual Travel Expenses

From 69 WOs with expense data
Total Expenses
$17,461
Labor - Travel
$9,928
Mileage
$0
Lodging
$2,819
Airfare
$0
Car Rental
$0
Per Diem
$950
Meals
$0
Other
$3,764

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)
$17,461
69 WOs with expenses
Billed to Client
$6,396
36.6% recovery rate
Margin Gap (Unbilled)
$11,066
Cost absorbed internally
Avg Expense / WO
$253
Avg billed: $93
Internal Cost
$17,461
Billed
$6,396

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) 101 69 $9,928 $4,805 $5,123 48.4%
Other Expenses 148 62 $3,764 $0 $3,764 0%
Lodging 16 7 $2,819 $1,591 $1,229 56.4%
Per Diem 23 12 $950 $0 $950 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 71 $16,158 $6,396 $9,762 39.6%
Healthcare Provider 2 $785 $0 $785 0%
Kiosk 14 $519 $0 $519 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 24 $11,933 $4,736 $7,197 39.7%
Repair 12 $2,547 $930 $1,617 36.5%
Preventive Maintenance 46 $1,818 $0 $1,818 0%
Installation 2 $889 $730 $159 82.1%
Repair/PM 2 $259 $0 $259 0%
Inspection 1 $16 $0 $16 0%

Monthly Expense Trend — Internal Cost vs Billed