Instructions 1. Do all your Excel activities in one workbook. Use Sheet1 for Question 1(a), Sheet 2 for Question 2(a), and Sheet 3 for Question2 Submit your Excel file to Canvas. 2. 3. Answer the questions for parts 1(a), 1(b), (c), 2(a), and 2(b) in WORD. Submit your Word document to Canvas. 1. [31 POINTS) Bayville has built a new elementary school, increasing the town's total to four schools - Addison, Becks, Canfield, and Daley. Each school has a capacity of 400 students. The school board wants to assign children to schools so that their travel time by bus is as short as possible. The school board has partitioned the town into five districts conforming to population density-north, south, east, west, and central. The average bus travel time from each district to each school is shown as follows: District North South East West Central Addison 12 26 18 29 15 Travel Time (minutes) Beeks Canfield Daley 23 35 17 15 21 27 20 22 31 24 35 10 10 23 16 Student Population 250 340 310 210 290 a b. Determine the number of children that should be assigned from each district to each school to minimize total student travel time. Calculate the average travel time per student. Note that all students must be assigned. [9 points) The school board determined that it does not want any of the schools to be overly crowded compared with the other schools. It would like to assign students from each district to each school so that enrollments are evenly balanced between the four schools. In other words, each school will have the same number of students. However, the school board is concerned that this might significantly increase travel time. Determine the number of students to be assigned from each district to each school such that school enrollments are evenly balanced. Calculate the average travel time per student. [9 points) Does this new solution appear to significantly increase travel time per student? Discuss. [5 points) C