1. What is the final value of the objective function?
2. What are the values of the decision variables?
3. Which constraints are binding?
4. What would you pay to relax each constraint?

Please show work with Excel. Thank you!

Excel printout with values

An Excel printout with formulas (Ctrl ~) (Adjust column width to show full content.)

A printout of the Answer Report

A printout of the Sensitivity report

...B.38 Tri-State Manufacturing has three factories (1, 2, and 3) and three warehouses (A, B, and C). The following table shows the shipping costs between each factory and warehouse, the factory manufacturing capabilities (in thousands), and the warehouse capacities (in thousands). Management would like to keep the warehouses filled to capacity in order to generate demand. TO WAREHOUSE WAREHOUSE WAREHOUSE PRODUCTION CAPABILITY FROM $3 Factory 1 Factory 2 Factory 3 Capacity $6 $ 8 $11 $ 5 $10 $14 $18 12 ...B.38 Tri-State Manufacturing has three factories (1, 2, and 3) and three warehouses (A, B, and C). The following table shows the shipping costs between each factory and warehouse, the factory manufacturing capabilities (in thousands), and the warehouse capacities (in thousands). Management would like to keep the warehouses filled to capacity in order to generate demand. TO WAREHOUSE WAREHOUSE WAREHOUSE PRODUCTION CAPABILITY FROM $3 Factory 1 Factory 2 Factory 3 Capacity $6 $ 8 $11 $ 5 $10 $14 $18 12