\fMicrosoft Excel 16.0 Sensitivity Report Worksheet: [Final Exam Question 3 Excel Answer.xlsx]5heet1 Report Created: 5/13f2023 6:49:45 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SC$11 X1 Value 88 U 20 30 11.66666667 SCSI! X2 Value 104 U 25 35 6.666 66666? SC$13 X3 Value 0 16 10 16 ' :+3[} $C$14 X4 Value 0 41 15 4 ' :+30 Co nstrai nts Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H Side Increase Decrease SHSE Constraint 1 Used 192 0 150 42 1E+30 SHS? Constraint 2 Used 430 6 430 440 210 SHSS Constraint 3 Used 280 ii 280 520 105 3. (a) Determine the optimal solution and the optimal value for this problem and interpret their meanings. (b) Determine the slack (or surplus] value for each constraint in this problem and interpret its meaning. 4. (a) What are the ranges of optimality for the prot of Product 1, Product 2, Product 3. and Product 4'? (b) Find the shadow prices of the three constraints and interpret their meanings. What are the ranges in which each of these shadow prices is valid? (c) If the prot contribution of Product 1 changes from $20 per unit to $36 per unit. what will be the optimal solution? What will be the new total prot? (Note: Answer this question by using the sensitivity results given above. Do not solve the problem again). (d) Which resource should be obtained in larger quantity to increase the prot most? (Note: Answer this question using the sensitivity results given above. Do not solve the problem again}