Reference no: EM13879748

Please Show process Using Solver Data Analysis so I can understand the process for each Each year a municipality hires a private bus company to transport (round back ) elementary students . The service manager must develop city a transportation plan to minimize the cost of  transportation. The annual cost of transportation It depends on the number of student - mile that the company transports (eg 20 students take two miles involves 40 students - mile is the same carry 8 Students 5 miles).

3 city schools can receive students from each point of the town, north (N ) , East ( E) , west (O ), and south ( S ) In the north live 240 children attending elementary school In the east , 120, in the west, 400, and in the south, 200. In one school may enroll no more than 360 students , the School 2 not more than 400 , and in school 3 , no more than 260. The following table shows the distance in miles between neighborhoods and schools :

	N	E	W	S
School 1	2	3	1.4	3.2
School 2	3.2	2.4	2	2
School 3	3.6	1.4	3	2.2

1) - Set your objective function and restrictions to minimize costs in this case number of students - mile. Also identify their decision variables.

2) -Find the result of the objective function and the number of children in each neighborhood They are going to the 3 schools . Explain your results.

3) -¿Change 2) If now the ability of students from the School 2 is 500 and the School 3 is 180 ?

Do not forget to set the trivial restrictions (which means variables decision must be greater or equal to zero)