Answer these questions and fill out the excel using solver, show the solver as well.

1. What is the minimum cost to ship these boots from our plants to the warehouses while satisfying all of our constraints?

2. What are the final values of the decision variables?

3. Is there any slack in the system? If so, what is the amount/route that shows slack?

3. Suppose management tells us that the per unit shipping cost from Plant P3 to Distribution Center D1 is going to change to $.60. How do your answers to #1 and #2 change?

(To) Warehouse Objective: Minimize total shipping cost \begin{tabular}{l|l|l} Stage 1 & Stage 2 & Total \end{tabular}