ANSWER USING EXCEL SOLVER AND SHOW WORKBOOK

Joe Bagov can make 600 donuts in Wayne and has customers in Tilden who want 100 donuts, in Norfolk who want 200 donuts and in South Sioux City who want 200 donuts. Joe has distributors (transshipment nodes) in Wisner and Laurel who will get the donuts and take them to the final destinations. Joe has to decide how much each distributor will take to each location. The locations have the following numbers to identify the locations: Wayne 1, Laurel 2, Wisner 3, Tilden 4, Norfolk 5, and South Sioux City 6.

It costs 10 cents per donut to get donuts from Wayne to the distributors in both Laurel and Wisner. The costs per donut to go from Laurel to Tilden, Norfolk and South Sioux City are 15, 10, and 15 cents, respectively. Similarly, from Wisner to these locations, respectively, are 13, 9 and 16 cents.

Formulate the linear programming problem to minimize the cost of transporting donuts to their final destinations, solve the problem is Solver and include an Answer and Sensitivity Report.

A-How many variables are there in a linear programming problem to minimize cost of getting donuts from Wayne to Tilden, Norfolk and South Sioux City in this transshipment problem?

B-How many constraints are there in a linear programming problem to minimize cost of getting donuts from Wayne to Tilden, Norfolk and South Sioux City in this transshipment problem(excluding the non-negativity constraints)?

C-How many donuts are shipped on each route and what is the minimum cost of the shipping?

D-Would the shipping amounts change if the cost of shipping from Wayne to Laurel changed to 6 cents? Yes or no? Why (why in the sense of what you see on an Excel printout of the problem, not why in terms of adjustments on routes)?

E-How much does the minimum cost change (be specific about the direction of change) if an additional unit is shipped from Wisner to South Sioux City over what we see in the original optimal solution?

F-What would happen to the total cost of shipping if Tilden only wanted 99 donuts (be specific about any direction of change)?