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

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

Question:

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.

Expert Answer:

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