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 ofminority 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 thesame percentage of minority students (within + 5%) as the entire town.The distances (in miles) between the school districts and the highschools are given in Table 2. Each high school must have an enrolmentof 300 – 500 students. The city school board needs to determine anassignment of students to schools that minimizes the total distancestudents must travel to schools.Table 1. Number of studentsTable 2. Distances (in miles)Minority NonminorityDistrict StudentsCooleyDistrict High WhitmanWaltStudentsHigh1.502001.82.95025022.81.910015031.81.9(Adapted from Winston 2004)PL = Program Linear or Linear Program ( LP)%3D2.3. A. Formulate the problem into the OT model! Define the decisionvariables clearly. Give information about the objective function andconstraints.B. Find the optimal solution of the PL model! Use the same variablename (consistent) as you used in No. 1. The order of constraintscorresponds to the order of constraints in No.1. Include evidence in theform of PL MODELS AND SOLUTIONSC. Based on the solution obtained in No. 2, write a recommendation forthe City of Busville School Board! Show that your recommendationmeets all the requirements and that all students in the 3 districts get aschool.D. Currently the maximum number of students that can be admitted toWalt Whitman High (call it bwWma) is 500 people. What is theallowable 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.

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

See similar textbooks

Similar questions

Some citizens complained to city council members that there should be equal protection under the law against the occurrence of crimes. The citizens argued that this equal protection should be interpreted as indicating that high-crime areas should have more police protection than low-crime areas. Therefore, police patrols and other methods for preventing crime (such as street lighting or cleaning up abandoned areas and buildings) should be used proportionately to crime occurrence. The city has been broken down into 20 geographic areas, each containing 5,000 residences. The police recognize that not all crimes and offenses are reported: people do not want to become involved, consider the offenses too small to report, are too embarrassed to make a police report, or do not take the time, among other reasons. Every month, because of this, the police are contacting by phone a random sample of 800 of the 5,000 residences for data on crime. (Respondents are guaranteed anonymity.) The 800…
In November 2023, a certified investment property appraiser was hired to appraise the value of a 72,000 square foot Safeway anchored neighborhood shopping center in Fremont, California that was last sold in 2014 to a foreign investment company based in the Cayman Islands for $26 million. The November 2023 appraised value represents the: a. Actual market value of that property b. Actual purchase price of that property c. Actual replacement cost of that property d. Actual opinion of value by that appraiser
Some citizens complained to city council members that there should be equal protection under the law against the occurrence of crimes. The citizens argued that this equal protection should be interpreted as indicating that high-crime areas should have more police protection than low-crime areas. Therefore, police patrols and other methods for preventing crime (such as street lighting or cleaning up abandoned areas and buildings) should be used proportionately to crime occurrence. The city has been broken down into 20 geographic areas, each containing 5,000 residences. The police recognize that not all crimes and offenses are reported: people do not want to become involved, consider the offenses too small to report, are too embarrassed to make a police report, or do not take the time, among other reasons. Every month, because of this, the police are contacting by phone a random sample of 1,000 of the 5,000 residences for data on crime. (Respondents are guaranteed anonymity.) The 1,000…
Use the information below to answer question 2x + 3y + 3z = 2 4x – 3y – 6z = 2 10x – 6y + 3z = 0 1. The co-factor for the first element in the coefficient matrix for this system is: A. -27 B. -45 C. 27 D. 45
A.4 YU is a charity based in country K which aims to offer value for money. It has been set up to manage an area of woodland on behalf of the local population. YU aims to have around 3,000 visitors to the woodland every year, but in the last year it has only had around half of this number. YU has spent the same amount on advertising as in previous years, but has moved from using leaflets to radio advertisements. While YU was able to buy a large amount of radio advertising, YU’s directors were unaware that the chosen station had relatively low numbers of listeners. With reference to value for money, the low number of visitors indicates that YU has failed with regards to _____1______ over the past year. Its poor use of its advertising budget also indicates a lack of ____2____. Use the options below to fill in the missing words in gaps 1 and 2. Effectiveness Economy Ethics Efficiency Expertise
) Creative Sports Design (CSD) manufactures a standard-size racket and an oversize racket.The firm’s rackets are extremely light due to the use of a magnesium-graphite alloy that wasinvented by the firm’s founder. Each standard-size racket uses 0.125 kilograms of the alloy andeach oversize racket uses 0.4 kilograms; over the next two-week production period only 80kilograms of the alloy are available. Each standard-size racket uses 10 minutes of manufacturingtime and each oversize racket uses 12 minutes. The profit contributions are $10 for eachstandard-size racket and $15 for each oversize racket, and 40 hours of manufacturing time areavailable each week. Management specified that at least 20% of the total production must be thestandard-size racket. How many rackets of each type should CSD manufacture over the next twoweeks to maximize the total profit contribution? Assume that because of the unique nature oftheir products, CSD can sell as many rackets as they can produce.
Example 3. The age of mothers and the average number of children born per mother are given in the following table. Interpolate the average number of children born per mother aged 30 - 34. Age of Mother (in years) Average number of children born 15 – 19 0.7 20 - 24 2.1 25 – 29 3.5 30 – 34 35 - 39 5.7 40 – 44 5.8
Explain Johnson’s rule?
A sample of 406 people is selected. The people are classified according to place of residence ("urban", "suburban", or "rural"). They are also classified according to highest educational degree earned ("no college degree", "two-year degree", "four-year degree", or "advanced degree"). The results are given in the contingency table below. No college degree Two-year degree Two-year degree Four-year degree Advanced degree Urban 42T 44 41 25 25 Suburban 29 20 47 19 Rural 40 32 48 19 Among the people in the sample whose highest degree is a two-year degree, what is the relative frequency of those whose place of residence happens to be urban? Round your answer to two decimal places. X 5
Caribbean Energy (CE) has recently taken over a fuel supply plant which is in close proximity to one of its competitors. The collection point for both fuel companies is located at the same seaport. The general manager of CE intends to hire a consultant to train CE’s employees regarding the new procedures for affixing the fuel lines at the collection point to the high-capacity storage tanks and is debating whether the competitor should be invited to attend given that they use the same seaport. The general manager (GM) is mindful of the high cost of hiring the consultant and sourcing the equipment to train CE’s employees and is therefore hesitant to invite his competitors. The manager is also aware that there have been no accidents at the port since operations started 10 years ago and might not invite the competitors to participate in the training. The GM decides, based on the high price for the consultant (facilitation fee, air travel, accommodation) and the training material that he…
Maximize p = 10x + 20y + 15z subject to x + 2y + z ≤ 40 2y − z ≥ 10 2x − y + z ≥ 20 x ≥ 0, y ≥ 0, z ≥ 0.
(d) As part of a marketing program, a city block containing 4 households was selected and a sample of 3 households was sampled as follows. Jeremiah, the research assistant, identified the households and numbered each household from 1 to 4. He then want to list all combinations of the 4 households 2 at a time. These are: 1 and 2 1 and 3 1 and 4 2 and 3 2 and 4 3 and 4 Unfortunately, Jeremiah got this job because he was related to the Department Chairman, and he was very careless. He forgot the combina- tion 3 and 4. He chose a random number between 1 and 5 (it turned out to be 4) which corresponded to the combination 2 and 3. Thus households 2 and 3 were sampled. The variable of interest was out-of-pocket medical expenses incurred by the household (Table Q1 (d)). Table Q1 (d) : Out-Of-Pocket Medical Expenses Incurred by the Household Expenses ($) 345.00 Household 1 126.00 492.00 962.00 3 4 (ii) Based on Jeremiah's sampling procedure, what is the expected value of mean and variance of…