Quantify excess travel cost and identify optimization opportunities across your field service operation
Compares what was billed to clients against what we actually paid for travel expenses. The gap represents unbilled internal cost.
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 |
|---|---|---|---|---|---|---|---|
| Airfare | 52 | 39 | $27,050 | $22,536 | $4,513 | 83.3% | |
| Lodging | 91 | 71 | $26,715 | $24,542 | $2,173 | 91.9% | |
| Car Rental | 122 | 49 | $12,518 | $10,676 | $1,842 | 85.3% | |
| Other Expenses | 209 | 93 | $10,943 | $9,901 | $1,042 | 90.5% | |
| Labor - Travel (Hours) | 1,204 | 514 | $10,733 | $0 | $10,733 | 0% | |
| Per Diem | 234 | 107 | $9,825 | $6,025 | $3,800 | 61.3% |
| Vertical | WOs | Internal Cost | Billed | Gap | Recovery |
|---|---|---|---|---|---|
| Lab/Power | 541 | $97,784 | $73,681 | $24,104 | 75.4% |
| Order Type | WOs | Internal Cost | Billed | Gap | Recovery |
|---|---|---|---|---|---|
| Preventive Maintenance | 316 | $28,724 | $22,043 | $6,680 | 76.7% |
| Repair/PM | 42 | $27,641 | $27,561 | $80 | 99.7% |
| IOQ | 10 | $14,891 | $3,182 | $11,710 | 21.4% |
| Overhaul | 16 | $12,920 | $12,945 | $25 | 100.2% |
| Repair | 80 | $5,295 | $2,694 | $2,601 | 50.9% |
| PM/CAL | 2 | $2,617 | $1,556 | $1,061 | 59.5% |
| Training | 1 | $1,886 | $1,096 | $790 | 58.1% |
| PQ Only | 1 | $1,554 | $494 | $1,060 | 31.8% |
| Acct. Management | 1 | $903 | $903 | $0 | 100% |
| Relocation | 2 | $731 | $900 | $169 | 123.2% |
| EOQ | 59 | $316 | $0 | $316 | 0% |
| PM-EXT | 2 | $306 | $306 | $0 | 100% |
| Installation | 2 | $0 | $0 | $0 | 0% |
| EIQ | 1 | $0 | $0 | $0 | 0% |
| Calibration | 6 | $0 | $0 | $0 | 0% |