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 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	Student Population
North	12	23	35	17	250
South	26	15	21	27	340
East	18	20	22	31	310
West	29	24	35	10	210
Central	15	10	23	16	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!

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

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

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

Delft House, Inc., a multinational company based in Amsterdam, organizes and coordinates art shows and auctions throughout the world. Its budgeted and actual costs for last year are as follows: Delft...

Harrison Company maintains a checking account at the First National City Bank. The bank provides a bank statement along with canceled checks on the last day of each month. The July 2011 bank...

Alt Cirl Solomon Corporation estimated its overhead costs would be $ 2 3 . 2 0 0 per month except for lanaury when it pays the $ 2 1 5 3 0 0 annual insurance premium on the manufachuring facility....

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