Question 3. (20 points) Robin Tires, Inc. makes two types of tires, for SUVs and Hatch- backs. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping. The production time required per tire type is given in the following table: Production Hours Type Production Packaging Shipping Profit/Tire SUV Tires 1.5 $22 Hatchback Tires 1.5 0.5 $12 Assume that the company is interested in maximizing the total profit contribution. The sensitivity report provided below was generated using the Excel Solver to determine the optimal solution to this problem. Using the sensitivity report, answer the following: Microsoft Excel 16.0 Sensitivity Report Worksheet: [Booki]Sheet1 Report Created: 11/12/2018 1:58:45 AM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient increase Decrease $E$3 1000 22 24 100 0 12 2.666666667 1 $F$3 Constraints Final Shadow Cell Name Value Price $G$10 150 16 $G$8 350 0 $G$9 250 4 Constraint Allowable Allowable R.H. Side Increase Decrease 150 16.66666667 25 500 1E+30 150 250 50 25 (a) Optimal production quantity of SUV tires: (b) Optimal production quantity of Hatchback tires: (c) Optimal profit: (d) Will the current optimal solution stay optimal if the unit profit of SUV tires increases to 23.5? (Yes or No) (e) Will the current optimal solution stay optimal if we add a constraint that say produc- tion quantity of SUV tires should be at most 85? (Yes or No) (f) Calculate the effect on the total profit of increasing the available time for shipping to 160. (g) Calculate the effect on the total profit of decreasing the available time for production to 400