Please Show Work and Use MS Excel Solver or LINDO/LINGO. I appreciate your hard work. Thank you

Transcribed Image Text:

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 bussing for all middle school students who must travel more than approximately a mile, so the school board wants plan for reassigning the students that will minimize the total bussing cost. 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 bussing for all middle school students who must travel more than approximately a mile, so the school board wants plan for reassigning the students that will minimize the total bussing cost.

Answer rating: 100% (QA)

Springfield table of information Area No of Students in 6 th grade in 7 th grade in 8 th grade Bussing Cost per Student School1 School2 School3 1 450 ... View the full answer