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)