How many students from Sector A are bussed to School 3?

Which sector(s) send(s) students to School 1?

Group of answer choices

A

B

C

D

E

What is the minimum number of student kilometres travelled by bus?

Now consider the case where the goal is to minimize the number of students who have to ride the bus, Which of the following answers best describes the situation?

Group of answer choices

The same answer remains optimal and is the unique best answer.

The same answer is still optimal, but other solutions are also possible that achieve the same objective.

The new optimal solution has fewer students riding the bus, but the number of student kilometers goes up.

The new optimal solution has more students riding the bus, but the number of student kilometers goes down.

The superintendent has funds to expand one of the schools by 100 students. The goal is still to minimize the number of student kilometers. Answer Questions 5 and 6 based on this scenario.

Flag question: Question 5Question 52 pts

Which school should be expanded?

Group of answer choices

School 1

School 2

School 3

Either School 1 or School 2 - the benefit is the same for both

None of the schools should be expanded

Flag question: Question 6Question 61 pts

By how much does the number or student kilometers go down after expansion?

Flag question: Question 7Question 71 pts

Students in which Sector(s) [if any] change schools as a result of the expansion?

Group of answer choices

A

B

C

D

E

None

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