Cost Analysis Worksheet
llmagcctuth
HWWK3BIS221.xlsxVehicle Cost Analysis
| Proximity Bus Service | ||||||
| Vehicle Cost Analysis | ||||||
| Bus ID | Cost per Mile | Miles Driven | Maintenance Cost | Mileage Cost | Total Cost | Total Cost per Mile |
| 701 | 2.01 | 19964 | 283.22 | |||
| 702 | 1.88 | 16660 | 393.8 | |||
| 703 | 1.87 | 14949 | 323.2 | |||
| 704 | 1.91 | 14905 | 476.61 | |||
| 705 | 1.7 | 11242 | 232.79 | |||
| 706 | 1.65 | 14662 | 497.23 | |||
| 707 | 1.79 | 16061 | 275.32 | |||
| 708 | 1.88 | 14777 | 281.62 | |||
| 709 | 1.69 | 18484 | 465.94 | |||
| Totals | ||||||
| Average | ||||||
| Highest | ||||||
| Lowest |
