Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
266
Total Travel Cost
$9,648
14,401 miles
Avoidable Cost
$3,905
5,828 excess miles
Optimal Cost
$5,744
If closest tech always used
Avg Excess / WO
21.9 mi
$14.68 per WO
Median Excess
14.0 mi
Outlier Rate (>50mi)
11.3%
30 WOs

Actual Travel Expenses

From 158 WOs with expense data
Total Expenses
$69,710
Labor - Travel
$55,735
Mileage
$0
Lodging
$5,738
Airfare
$858
Car Rental
$1,431
Per Diem
$1,650
Meals
$0
Other
$4,298

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)
$69,710
158 WOs with expenses
Billed to Client
$13,358
19.2% recovery rate
Margin Gap (Unbilled)
$56,352
Cost absorbed internally
Avg Expense / WO
$441
Avg billed: $85
Internal Cost
$69,710
Billed
$13,358

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) 305 134 $55,735 $12,138 $43,597 21.8%
Lodging 18 17 $5,738 $701 $5,037 12.2%
Other Expenses 72 50 $4,298 $494 $3,804 11.5%
Per Diem 37 23 $1,650 $25 $1,625 1.5%
Car Rental 14 7 $1,431 $0 $1,431 0%
Airfare 1 1 $858 $0 $858 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 161 $69,710 $13,358 $56,352 19.2%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 95 $36,770 $5,883 $30,887 16%
Inspection 36 $18,676 $1,248 $17,429 6.7%
Cross-Training 2 $5,215 $0 $5,215 0%
Misc. Inspection 15 $5,002 $3,332 $1,670 66.6%
Evaluation 3 $1,387 $1,296 $91 93.4%
Preventive Maintenance 5 $1,060 $0 $1,060 0%
Calibration 3 $1,049 $1,049 $0 100%
Delivery 1 $551 $551 $0 100%
Installation 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed