E 1 Sensitive report 2 3 4 Variable cells cells SCS4 SCSS 5 nare X1 amount X2 amount Finale value 0 160 Reduced cost -0.8 0 Objective coefficient Allowable increase Allowable decrease 12 0.8 1.00E-30 16 100E30 1 7 8 Constraints Cells SHS4 SHS5 Final value 10 11 Name Rubber LHS Leather LHS 320 800 Reduced cost Objective coefficient Allowable increase Allowable decrease 0 500 1.00E+30 180 32 800 450 800 A. What is the maximum number by which I can increase the price of a basketball without changing the optimal mix of products? B. Which of the two constraints is a binding constraint? C. What is the shadow price for any additional unit I purchase of the leather resource? D. If the company purchased 20 more units of Leather, calculate the expected change in the profit that this purchase would yield. E. Can you tell from the output how much of an increase in profit would result from purchasing 670 additional units of the leather resource? 10.00 PM, MUNUdy, September 14 Do Problem 7 on Page 98. Problem 7 is about "Southern Sporting Goods Company". After you formulate the model in Problem 7, solve it using Excel Solver. Make sure you ask Solver to give you the sensitivity report. Based on the report, answer the following questions: A. What is the maximum number by which I can increase the price of a basketball without changing the optimal mix of products? B. Which of the two constraints is a binding constraint? C. What is the shadow price for any additional unit I purchase of the leather resource? D. If the company purchased 20 more units of Leather, calculate the expected change in the profit that this purchase would yield. E. Can you tell from the output how much of an increase in profit would result from purchasing 670 additional units of the leather resource? Submission Guidelines: I want you to upload one MS Excel file that has the following: 1. Computer solution and sensitivity report. 2. Answers to all the questions above