B. Find the optimal solution of the PL model! Use the same variable name (consistent) as you used in No. 1. The order of constraints corresponds to the order of constraints in No.1. Include evidence in the form of PL MODELS AND SOLUTIONS C. Based on the solution obtained in No. 2, write a recommendation for the City of Busville School Board! Show that your recommendation meets all the requirements and that all students in the 3 districts get a school. D. Currently the maximum number of students that can be admitted to Walt Whitman High (call it bwwmax) is 500 people. What is the allowable bwwmax value so that the current base remains optimal? Explain with evidence.
B. Find the optimal solution of the PL model! Use the same variable name (consistent) as you used in No. 1. The order of constraints corresponds to the order of constraints in No.1. Include evidence in the form of PL MODELS AND SOLUTIONS C. Based on the solution obtained in No. 2, write a recommendation for the City of Busville School Board! Show that your recommendation meets all the requirements and that all students in the 3 districts get a school. D. Currently the maximum number of students that can be admitted to Walt Whitman High (call it bwwmax) is 500 people. What is the allowable bwwmax value so that the current base remains optimal? Explain with evidence.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Please solve the problem Sub parts B,C,D thank u... Im very needed in 60-120 minutes max. thank u tor he expert, please solving
![1. The city of Busville contains three school districts. The number of
minority and nonminority students in each district is given in Table 1.
Of all students, 25% (200/800) are minority students.
The local court has decided that both of the town's two high schools
(Cooley High and Walt Whitman High) must have approximately the
same percentage of minority students (within + 5%) as the entire town.
The distances (in miles) between the school districts and the high
schools are given in Table 2. Each high school must have an enrolment
of 300 – 500 students. The city school board needs to determine an
assignment of students to schools that minimizes the total distance
students must travel to schools.
Table 1. Number of students
Table 2. Distances (in miles)
Minority Nonminority
District Students
Cooley
District High Whitman
Walt
Students
High
1.
50
200
1.8
2.9
50
250
2
2.8
1.9
100
150
3
1.8
1.9
(Adapted from Winston 2004)
PL = Program Linear or Linear Program ( LP)
%3D
2.
3.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff4d2d762-637a-4e0a-8ef5-39ae233cf593%2F8ecb0a0d-05cf-4047-a6d3-dd066cb1b0a9%2Fyc51t0m_processed.png&w=3840&q=75)
Transcribed Image Text:1. The city of Busville contains three school districts. The number of
minority and nonminority students in each district is given in Table 1.
Of all students, 25% (200/800) are minority students.
The local court has decided that both of the town's two high schools
(Cooley High and Walt Whitman High) must have approximately the
same percentage of minority students (within + 5%) as the entire town.
The distances (in miles) between the school districts and the high
schools are given in Table 2. Each high school must have an enrolment
of 300 – 500 students. The city school board needs to determine an
assignment of students to schools that minimizes the total distance
students must travel to schools.
Table 1. Number of students
Table 2. Distances (in miles)
Minority Nonminority
District Students
Cooley
District High Whitman
Walt
Students
High
1.
50
200
1.8
2.9
50
250
2
2.8
1.9
100
150
3
1.8
1.9
(Adapted from Winston 2004)
PL = Program Linear or Linear Program ( LP)
%3D
2.
3.
![A. Formulate the problem into the OT model! Define the decision
variables clearly. Give information about the objective function and
constraints.
B. Find the optimal solution of the PL model! Use the same variable
name (consistent) as you used in No. 1. The order of constraints
corresponds to the order of constraints in No.1. Include evidence in the
form of PL MODELS AND SOLUTIONS
C. Based on the solution obtained in No. 2, write a recommendation for
the City of Busville School Board! Show that your recommendation
meets all the requirements and that all students in the 3 districts get a
school.
D. Currently the maximum number of students that can be admitted to
Walt Whitman High (call it bwWma) is 500 people. What is the
allowable bwwmax value so that the current base remains optimal?
Explain with evidence.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff4d2d762-637a-4e0a-8ef5-39ae233cf593%2F8ecb0a0d-05cf-4047-a6d3-dd066cb1b0a9%2Fgls56ko_processed.png&w=3840&q=75)
Transcribed Image Text:A. Formulate the problem into the OT model! Define the decision
variables clearly. Give information about the objective function and
constraints.
B. Find the optimal solution of the PL model! Use the same variable
name (consistent) as you used in No. 1. The order of constraints
corresponds to the order of constraints in No.1. Include evidence in the
form of PL MODELS AND SOLUTIONS
C. Based on the solution obtained in No. 2, write a recommendation for
the City of Busville School Board! Show that your recommendation
meets all the requirements and that all students in the 3 districts get a
school.
D. Currently the maximum number of students that can be admitted to
Walt Whitman High (call it bwWma) is 500 people. What is the
allowable bwwmax value so that the current base remains optimal?
Explain with evidence.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.