Answer A and B. Please do this on excel, what i need is the screenshot of how you do this on EXCEL/SPREADSHEET. If the answers are not on excel, i will just downvote. Do as it needed to be on excel

Case 3-5 Assigning Students to Schools The Springfield School Board has made the decision to close one of its middle schools (sixth, seventh, and eighth grades) at the end of this school year and reassign all of next year's middle school students to the three remaining middle schools. The school district provides busing for all middle school students who must travel more than approximately a mile, so the school Page 120 board wants a plan for reassigning the students that will minimize the total busing cost. The annual cost per student for busing from each of the six residential areas of the city to each of the schools is shown in the following table (along with other basic data for next year), where 0 indicates that busing is not needed and a dash indicates an infeasible assignment. Busing Cost per Student Number of Students Percentage Percentage Percentage in 6th in 7th in 8th Grade Grade Grade Area School 1 School 2 School 3 1 450 32 38 30 $300 $ 0 $700 2 600 37 28 35 400 500 3 550 30 32 38 600 300 200 4 350 28 40 32 200 500 5 500 39 34 27 0 400 6 450 34 28 38 500 300 0 Busing Cost per Student Number of Students Percentage Percentage Percentage in 6th in 7th in 8th Grade Grade Grade Area School 1 School 2 School 3 1 450 32 38 30 $300 $ 0 $700 2 600 37 28 35 400 500 3 550 30 32 38 600 300 200 4 350 28 40 32 200 500 5 500 39 34 27 0 400 6 450 34 28 38 500 300 0 School capacity: 900 1,100 1,000 The school board also has imposed the restriction that each grade must constitute between 30 and 36 percent of each school's population. The above table shows the percentage of each area's middle school population for next year that falls into each of the three grades. The school attendance zone boundaries can be drawn so as to split any given area among more than one school, but assume that the percentages shown in the table will continue to hold for any partial assignment of an area to a school. You have been hired as a management science consultant to assist the school board in determining how many students in each area should be assigned to each school. Page 278 Case 7-3 Assigning Students to Schools (Revisited) Reconsider Case 3-5 Q. The Springfield School Board now has made the decision to prohibit the splitting of residential areas among multiple schools. Thus, each of the six areas must be assigned to a single school. a. Formulate and solve a BIP model for this problem under the current policy of providing busing for all middle school students who must travel more than approximately a mile. b. Referring to part c of Case 3-5 @, determine how much the total busing cost increases because of the decision to prohibit the splitting of residential areas among multiple schools