Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Optimization And Duality A Modern Exposition

Authors: Craig A. Tovey

1st Edition

1439887462, 9781439887462

More Books

Students also viewed these General Management questions

Question

What ideas do employees have for making the review process fairer?

Answered: 1 week ago

Question

9 Countertrade. What is countertrade?

Answered: 1 week ago