What is the maximum profit attainable while satisfying all 9 constraints?

If the company could obtain additional cup holders, what is the maximum number of additional cup holders that should be obtained?

Using your answer from the above question, what would be the new optimal profit from the model if the maximum number of cup holders is obtained?

What is the highest profit margin that the company could receive from Sedans and still retain the same optimal solution?

What is the lowest profit margin that the company could receive from Trucks and still retain the same optimal solution?

Problem 3 - Sensitivity Houser Automotive (HA) is a small firm that manufactures automobiles and wants to maximize profit. They are restricted by federal regulations that limits the number of large vehicles they are able to produce. The company's CEO, Mackenzie, likes sedans and electric vehicles and has the company manufacture a set minimum of each. She assembled her finance and operations departments to determine the ideal product mix to maximize profit. The redacted LP output and sensitivity analysis are presented below. Answer the questions that appear on the following page. Sedans Coups Trucks / SUVs Electric LHS $3,100.00 $3,200.00 $4,500.00 $2,000.00 Sign RHS 1.00 210 2 210 1.00 230 2 230 1.00 118.3333333 s 200 Solution Maximize Profit Constraints Min Sedans Min Electric Max Trucks Max Large Wheels Max Small Wheels Max number of cup holders Wheel Storage Capacity Seat Belt Receptacles Total Production 4.00 473.3333333 s 1,200 4.00 4.00 4.00 2200 5 2,200 4.00 2.00 6.00 4.00 2690 s 3,400 4.00 4.00 4.00 4.00 2673.333333 S 2,800 3,350 5.00 4.00 6.00 5.00 3350 s .. 1.00 1.00 1.00 1.00 668.3333333 2 650 Variable Cells Final Allowable Reduced Objective Allowable Cost Coefficient Increase Value Decrease 210 0 3100 850 1E+30 Cell Name $C$3 Solution Sedans $D$3 Solution Coups $E$3 Solution Trucks / SUVs $F$3 Solution Electric 110 0 3200 1E+30 200 118.3333333 0 4500 300 4500 230 0 2000 1950 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease 2200 50 2200 380 220 2690 0 3400 1E+30 710 2673.333333 0 2800 1E+30 126.6666667 3350 750 3350 190 110 $G$10 Max Small Wheels LHS $G$11 Max number of cup holders LHS $G$12 Wheel Storage Capacity LHS $G$13 Seat Belt Receptacles LHS $G$14 Total Production LHS $G$6 Min Sedans LHS $G$7 Min Electric LHS $G$8 Max Trucks LHS $G$9 Max Large Wheels LHS 668.3333333 0 650 18.33333333 1E+30 210 -850 210 110 190 230 - 1950 230 110 190 118.3333333 0 200 1E+30 81.66666667 473.3333333 0 1200 1E+30 726.6666667