he Excel spreadsheet and Solver sensitivity report are shown below. What is the optimal value for Variable 1? A B C 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 1 > 12 7 8 Profit 5 4 9 10 Output Information 11 Variables 12 Profit = Total 13 14 Resources Used Slack/Surplus 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 Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$15 constraint 1 Used 40 0.5384615 40 110 7 $B$16 constraint 2 Used 30 1.3076923 30 30 4.6666667 $B$17 constraint 3 Used 13.076923 0 12 1.0769231 1E+30 Group of answer choices 40 4.61