SENG 3330 - Fall 2021 Assignment 3 Due: 10:00 PM, Monday, September 20 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. 7. Southern Sporting Goods Company makes basketballs and footballs. Each product is produced from two resources--rubber and leather. The resource requirements for each product and the total resources available are as follows: Resource Requirements per Unit Product Rubber (lb.) Leather (ft.?) 4 Basketball Football Total resources available 3 2 500 lb. 5 800 ft.2 Each basketball produced results in a profit of $12, and each football earns $16 in profit. Formulate linenr nr a