Question: 3. Do sensitivity analysis. please include your sensitivity analysis. and answer the following ques- tions'. {a} Use the sensitivity report to check how much the

 3. Do sensitivity analysis. please include your sensitivity analysis. and answerthe following ques- tions'. {a} Use the sensitivity report to check how

3. Do sensitivity analysis. please include your sensitivity analysis. and answer the following ques- tions'. {a} Use the sensitivity report to check how much the transport from area 2 to school 2 can increase [ assuming no other cost increases) before the current optimal solution would no longer be optimal. If the allowable increase is less or equal to 5|] percent use solver to nd the new solution with a 55 percent increase. {b} \"That is the reduced cost of 3:11, what does this mean? {c} How many more than the 1'." percent of learners in school 1 are grade ones? [row 3} {d} The school board has the option of adding portable classrooms to increase the capacity of one or more schools. Each portable classroom holds 21] students and has a lease cost of 32 5% per month. For each school use the corresponding shadow price from the sensitivity report to determine whether it would be worthwhile to add any portable classrooms. After seeing your recommendation, the school board expresses concern about all the splitting of learners from residential areas among different schools. They indi- cate that they would like to keep each neighborhood together. They relax their rule that about the l?% and 23% percent of the school may be grade onm to be able to nd a solution. 4. Adjust your recommendation to enable each area to be assigned to just one school by formulat ing a binary integer model for the problem under the current policy of providing transportation for students having to travel more than a km.{The question 1 model.) 5. How much dom this increase the total transportation cost? Option 2 is to also eliminate transport for students traveling 1,5 to 2 km, where the estimated cost per student is H3i}.The school board is considering eliminating some transport to reduce costs. Option 1 is to only eliminate transport for students traveling 1 to 1,5 km, where the cost per student is given in the table as R2l'll'l. Option 2 is to also eliminate transport for students traveling 1,5 to 2 km, where the estimated cost per student is R300. They have to let go of the percentages of learners in grade one to be able to solve this problem.[ no 1? and 23 percent constraints) 6. Revise the model from question 1 to t Option 1., and solve. 7. Revise the model from question 1 to t Option 2., and solve. The school board now needs to choose among the three alternative transportation plans {the current one or Option 1 or Option 2}. 3. Which one is the most cost effective? Goal programming a One important goal is to keep the coat below.R15'D. 1 Casestudy The education department of lGautecng {EG} has to place learners into schools. They always have a problem with grade one and grade eight learners. They have to place learners into the three available schools. The department provides transport for all learners who must travel more than approximately a kilometre, so the department wants a plan for reassigning the students that will minimize the total transportation cost. The monthly cost per student for transport From each of the six residential areas of the city to each of the schools is shown in the following table [along with other basic data for next year}, where [1 indicates that transport is not needed and a dash indicates an infeasible assignment. Transportation lCost per Student Number in School 1 School 2 School 3 Till] dill] 501'] SUI] 201:] 500 4'00 300 {1 School capacity: The education department also has imposed the restriction that each grade must constitute between 17 and 23 percent of each school population. The above table shows the number of learners in each area that falls into each of the two grades. You have been hired as a decision analyst {operations research consultant to assist the board in deciding how many students in each area should be assigned to each school. 1. Formulate and solve a linear program for this problem. Please provide all your model formulations and solutions. 2. 1What is your resulting recommendation to the school board? Prepare a managerial report to the EG

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!