Problem 4 For the problem above, using the Sensitivity report below, answer the following questions fill in the blanks / multiple choice: Microsoft Excel 11.0 Sensitivity Report Adjustable Cells Cell Name $C$17 Western Foods Salsa $D$17 Mexico City Salsa Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 560 0.000 1.00 0.107 0.25 240 0.000 1.25 0.25 0.15 Constraints Cell Name $K$10 Whole Tomatoes $K$11 Tomato Sauce $K$12 Tomato Paste Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 4480 0.125 4480 1120 160 1920 0.000 2080 1E+30 160 1600 0.187 1600 40 320 a) How many jars of Western Foods Salsa should Tom's produce? b) How many jars of Mexico City Salsa should Tom's produce? What is the profit of the optimal solution? d) Which constraints are non-binding? 1) Whole tomatoes 2) Tomato Sauce 3) Tomato paste e) What would be the value of 30 more ounces of tomato paste? f) How much less profit would Tom's make if they had 100 fewer ounces of tomato sauce? g) How would Tom's profit change if they 500 more ounces of tomato sauce? (hint: the shadow price is 1E + 30 which is 10 to the power 30) h) How would Tom's profit change if they had 170 more ounces of whole tomatoes