Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Halton District School Board superintendent is responsible for assigning students to the three high schools in Caledon. She recognizes the need to bus a
The Halton District School Board superintendent is responsible for assigning students to the three high schools in Caledon. She recognizes the need to bus a certain number of students, because some areas of the district are beyond walking distance to a school. The superintendent partitions the district into 5 geographic sectors as she attempts to establish a plan that will minimize the total number of student kilometres travelled by bus. She recognizes that if a student happens to live in a certain sector and is assigned to the high school in that sector, there is no need to bus that student because he or she can walk to school. The 3 schools are located in sectors B, C and E. The table below reflects the number of high-school-aged students living in each sector in 2023 and the distance in kilometres from each sector to each school. Each school has a capacity of 900 students. Answer the following questions by creating and solving a model in Excel: Q1. What is the optimal solution to this problem? Q2. What is the total number of student kilometers travelled by bus at the optimal solution? Q3. Would your answers be any different if the goal was to minimize the number of students who had to ride the bus? Q4. The superintendent has funds to expand one of the schools by 100 students. Which school should she select
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started