Admin Feedback Review Settings Inventory Portal

Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
160
Total Travel Cost
$11,798
17,609 miles
Avoidable Cost
$7,662
11,436 excess miles
Optimal Cost
$4,136
If closest tech always used
Avg Excess / WO
71.5 mi
$47.89 per WO
Median Excess
48.1 mi
Outlier Rate (>50mi)
48.1%
77 WOs

Actual Travel Expenses

From 88 WOs with expense data
Total Expenses
$34,790
Labor - Travel
$23,366
Mileage
$0
Lodging
$5,251
Airfare
$0
Car Rental
$315
Per Diem
$1,950
Meals
$0
Other
$3,908
Cost Overview Actual Expenses Cost Breakdowns Coordinator Analysis Tech Utilization Quick Wins Coverage Gaps Low Hanging Fruit

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)
$34,790
88 WOs with expenses
Billed to Client
$13,120
37.7% recovery rate
Margin Gap (Unbilled)
$21,671
Cost absorbed internally
Avg Expense / WO
$395
Avg billed: $149
Internal Cost
$34,790
Billed
$13,120

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) 133 71 $23,366 $11,780 $11,586 50.4%
Lodging 33 18 $5,251 $1,340 $3,912 25.5%
Other Expenses 160 68 $3,908 $0 $3,908 0%
Per Diem 48 26 $1,950 $0 $1,950 0%
Car Rental 3 1 $315 $0 $315 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 101 $34,790 $13,120 $21,671 37.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 42 $28,988 $11,572 $17,416 39.9%
Repair 6 $2,191 $930 $1,261 42.4%
Installation 11 $1,689 $618 $1,071 36.6%
Preventive Maintenance 25 $1,382 $0 $1,382 0%
PM 17 $540 $0 $540 0%

Monthly Expense Trend — Internal Cost vs Billed