Question: 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,

A small city has four elementary schools, each

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...

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...

Please use excel Solver to answer this question and show all constraints used. Thank you! Use the template and alter the problem based on the new constraint: The school district has determined that...

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...

In a town, there are four schools Famagusta, Nicosia, Kyrenia and Iskele. Each of these school has four hundred students as a capacity. The school board wants to assign children to schools so that...

The City of Charleston issued $3,000,000 of 8% coupon, 30 year, semiannual payment, tax-exempt muni bonds 10 years ago. The bonds had 10 years of call protection, but now the bonds can be called if...

Wyatt Corporation, an 80%-owned subsidiary, accepted a $60,000, 12%, 90-day note from a customer for services performed. On that same date, because Wyatt Corporation was in need of cash for...

Net income from the Income Statement is carried forward to the owner's equity section of the Statement of Financial Position. OTrue O False

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...