please use lindo/lingo for this question

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