I NEED THE COMPARATIVE ANALYSIS FILLED OUT PLEASE. IF YOU COULD SHOW WORK ON HOW YOU GOT THE ANSWERS THAT WOULD BE GREAT

fc Trips Avg Distance Avg Time Fuel Efficiency Tank Capacity Fuel Cost School Days Extracurricular hours needed Extracurricular Distance School Student Body Percentage of Students that use Bus 2 per day 72 miles per bus, per trip 3 hours per bus, per trip 7.5 MPG 63 gallons per bus tank 3 50 per gallon 180 days per year 750 annual hours 18,000 annual miles 500 students 55% of students use school buses Make: Maintain In-House Fleet New Sale of Used 85,000 per bus s s,000 per bus New (0-3 years) Old (4-6 years) Maintenance Staff: Cost Maintenance Staff: Size Maintenance 2,000 per year, per bus 3,500 per year, per bus $41800 per year. per person 2.00 staff members Labor Busing Supervisor Bus Drivers 59,000 per year 15.50 per hour 12.50 per hour 2.0% per year Extracurricular Labor Rate Increase* Insurance 2,000 Cost to St Peter's 3%15 .. . 50,000 per year, per bus Accident Cost Likelihood 95%, s on Minor Ma 296 $ 120,000 . . . . Total Buses (and number of drivers) Replacement Schedulet 10 YearNumber of Buses in every 6-year busing cyde, the school replaces s school buses every three years beginning at the start of year 1 (time # year O) and the end of year 3 (time year 3 "The 2% labor rate increase applies to all 3 labor categories: maintenance staff, busing supervisors and bus drivers. Buy: Contract a Busing Service Contract Cost: Number of Bus Routes Income from Selling 250 per day per bus 10 Fleet Ol 5,000 New (0-3 years) Extracurricular Rate s0 per hour er year NPV Analysis Information 6 years Period Data Sheet Comparative Analysis (Make)Comparative Analysis (Buy)