Please assist and ignore grade 8 as on the table it doesn't exits.

1 Mail all '5" 00156 B courseherocom 1 Casestudy The education department of Gauteng (EG) has to plane learners into schools. They always have a problem with grade one and grade eight learners. The}: have to place learners into the three available schools. The depart merit 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 oust per student for transport from each of the six residential areas of the cit}r to each of the schools is shown in the following table (along with other basic data for next year}. where III indicates that transport is not needed and a dash indicates an infeasible assignment. Transportation Cost per Student Area Number men-tannin]- 145 am 701} 400 300 500 6 153 5m 3m] 0 \"mm 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 umnher of learners in each area that falls into each of the two grades. You have been hired as a decision analystfoperat-ions 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 fornnilations and solutions. 2. What is your rewriting recommendation to the school board? Prepare a managerial report to the ES