Excel

Siler City has three high schools, each with a capacity of 1200 students. The school board has paritioned the city into five tranportation districts. The high schools are located in the South, West, and Central districts. Some students must be bused outside their home districts, and the school board wants to minimize the total bus distance traveled by the students. The average distance from each district to each school and the student population in each district appear at the left. Create a spreadsheet model and use Solver to determine the bus plan for the students. The objective function, decision variables, and constraints should be clearly documented in the spreadsheet model. Write a sentence to summarize the solution