Term 6 Unit 1 Discussions
ceteiv
Unformatted_ProximityBusComplete.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 | 40127.64 | 40410.86 | 2.0241865358 |
| 702 | 1.88 | 16660 | 393.8 | 31320.8 | 31714.6 | 1.903637455 |
| 703 | 1.87 | 14949 | 323.2 | 27954.63 | 28277.83 | 1.8916201753 |
| 704 | 1.91 | 14905 | 476.61 | 28468.55 | 28945.16 | 1.9419765179 |
| 705 | 1.7 | 11242 | 232.79 | 19111.4 | 19344.19 | 1.7207071695 |
| 706 | 1.65 | 14662 | 497.23 | 24192.3 | 24689.53 | 1.6839128359 |
| 707 | 1.79 | 16061 | 275.32 | 28749.19 | 29024.51 | 1.8071421456 |
| 708 | 1.88 | 14777 | 281.62 | 27780.76 | 28062.38 | 1.8990579955 |
| 709 | 1.69 | 18484 | 465.94 | 31237.96 | 31703.9 | 1.7152077472 |
| Totals | 16.38 | 141704 | 3229.73 | 258943.23 | 262172.96 | 1.8501450912 |
| Average | 358.8588888889 | 28771.47 | 29130.3288888889 | 1.843049842 | ||
| Highest | 497.23 | 40127.64 | 40410.86 | 2.0241865358 | ||
| Lowest | 232.79 | 19111.4 | 19344.19 | 1.6839128359 |
Miranda Crenshaw_x000D_CSC 101
