Use the spreadsheet and Solver sensitivity report below to answer questions #6-7. B D E 1 2 Input Information 3 Var. 1 Var. 2 (type) Avail. 4 Constraint 1 2 5 40 5 Constraint 2 3 1 30 6 Constraint 3 1 12 7 8 Profit 5 4 9 Output 10 Information 11 Variables 12 Profit = Total 13 Used Slack/Surplus 14 Resources 15 Constraint 1 16 Constraint 2 17 Constraint 3 18 Sensitivity Report Changing Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 Variable 1 8.4615385 0 5 7 3.4 $C$12 Variable 2 4.6153846 0 4 8.5 2.3333333 Constraints Final Shadow Price Constraint Allowable Allowable R.H. Side Increase Decrease Cell Name Value $B$15 constraint 1 Used 40 0.5384615 40 110 7 $B$16 30 4.6666667 constraint 2 30 1.3076923 30 Used constraint 3 13.0769230 12 Used $B$17 1.0769231 1E+30 What is the optimal value for Variable 2? 0 4.61 030 O 40 8.46