K L M Miles 4 A1 X fx Show your work anyplace in this spreadsheet A B D E F F G H I J 1 Show your work anyplace in this spreadsheet 2 Also-spread out solution steps - so easy for grader to follow your work 3 15 Points 4 Conventional Self-Driving 5 Input Data units NFTA Bus Waymo Van 7 Driver salary (with benefits) $ per hour 90 U 8 Average speed miles/hour 30 30 9 10 Miles per Gallon MPG 5 20 11 Fuel cost per Gallon $/gallon $ 2.50 $ 2.50 12 Maintenance cost $/mile $ 0.75 $ 0.10 13 Capital Cost (Purchase) $ $ 325,000 $ 75,000 14 Lifetime Miles 250,000 150,000 15 16 Maximum Passenger Capacity Psgrs 50 17 18 Questions 19 1) What are the costs per vehicle mile ($ /mile) of each mode? Break-out results by major category - (fill in the blue cells). 20 21 Labor 22 Fuel 23 Maintenance 24 Capital (Purchase) 25 TOTAL 26 27 28 2) For a 10 miletrip, what is the cost / passenger assuming: 29 30 a. Bus is 25% full and Waymo is 50% full 31 32 33 b. Bus is 75% full and Waymo is 50% full 34 35 36