Question: Assignment #3 A small city has four elementary schools, each with a capacity for 400 students. Students' homes are scattered in five areas of the

Assignment #3 A small city has four elementary

Assignment #3 A small city has four elementary schools, each with a capacity for 400 students. Students' homes are scattered in five areas of the city, North, South, East, West, and Central, and students take a bus daily to one of the four schools. The table shows the average time taken (in minutes) for buses to travel from each district to each school. District School A School B School C School D North South East West Central 12 26 18 29 15 23 15 20 24 10 35 21 22 35 23 17 27 31 10 16 Student Population 250 340 310 210 290 Formulate a model to describe this situation and use Excel to determine the number of students that should be assigned to each school from each district to minimize overall total student travel time. The school board has decided that it would like the enrollments from each school to be evenly balanced to avoid overcrowding at any one school. This may have the effect of increasing total travel time since it is no longer optimized. Reformulate the model to determine the number of students traveling from each district and the total travel time

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A small city has four elementary schools, each with a capacity for 400 students. Students homes are scattered in five areas of the city, North, South, East, West, and Central, and students take a bus...

A small city has four elementary schools, each with a capacity for 400 students. Students' homes are scattered in five areas of the city, North, South, East, West, and Central, and students take a...

Maryville has built a new elementary school so that the town now has a total of four schools. Each has a capacity of 400 students. The city wants to assign children to schools so that their travel...

MSc Applied Research Project Please answer question (C) Introduction: Section A Fri 31st Jan 2020 Teams should prepare a 10 minute presentation: Venue: Safari Annexe O'Donovan's Road Time:...

QUESTION: WRITE EXECUTIVE SUMMARY FOR CUCINA LTD PROJECT 300 WORDS MSC Applied Research Project Cucina Ltd. Competitive advantage through data integrity Company History Cucina Ltd. is an Irish...

Please answer this task: > UNDERSTANDING OF REQUIREMENTS This task is highlighted in red ink on page 10. Overview of each session page. MSc Applied Research Project Cucina Ltd. Competitive advantage...

A11 X V fx Write a few sentences below to summarize your results: A B C D E F G H K L M N O P 1 Main City has four elementary schools (Addison, Beeks, Canfield, Daley) and Bus Travel Time: 2 each...

A11 A B C fx D E Write a few sentences below to summarize your results: F G H J K M N P 1 Main City has four elementary schools (Addison, Beeks, Canfield, Daley) and 2 each school has a capacity of...

MSc Applied Research Project PLEASE ANSWER QUESTION 5 (Identification of reports which would benefit Cucina) Teams should prepare a 10 minute presentation: Wed 29th Jan 2020 1. Group identity and...

Network design problem using Excel Solver (USE Simplex LP in the solver) *****HI, I HAVE ALREADY SOLVED S11.17 WITH SOLVER USING EXCEL, PLEASE REFER TO SECOND SCREENSHOT. I NEED S11.18 SOLVED (FIRST...

Big Apple Investment Bankers offers Northern Diagnostics the following options on its initial public sale of equity: (1) a best-efforts arrangement whereby Big Apple will keep 2 % of the retail sales...

On the last day of the fiscal year, Stanley Carpenter comes to you for a favor. He asks that you enter a check for $2,000 to CD Company for Miscellaneous Expense. You notice the invoice looks a...

Mutery Bostmarka Byslites 7 5 Whats Hatlp Tue Bssp PU Guavien 1 of E - Guapter 1 0 1 : x Consurt Mostant No Down Wer detion Stem nexas 1 Question 1 of 8 0 . 6 7 / Depreslationfor Year 3 $ eTextbook:...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...