OPERATIONS RESEARCH

YOU CAN USE SOLVER EXCEL

IGNORE GRADE 8 BECAUSE THERE IS NO INFORMATION ONLY CONSIDER GRADE 1

1 Casestudy The education department of Gauteng {EB} 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 minimise the total transportation cost. The monthly cost per student for transport from each of the six residential areas of the cityr to each of the schools is shown in the following table [along with other basic data for next year}, where U indicates that transport is not needed and a dash indicates an infeasible assignment. Transportation Cost per Student Area Number School 3 400 sea Sill] 3th! 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 analystfoperations research consultant to amid. the hoard in deciding how many studrsits in each area should he amigned to each school. 1. Formulate and solve a linear program for this problem. Please provide all your model formulations and solutions. 2. What is your resulting recommendation to the school hoard? Prepare a managerial report to the El}