Use the previous spreadsheet and Solver sensitivity report. Would you pay $.50 each for up to 60 more units of Resource 1?

A.	Cannot be determined

B.

No

C.

Yes

Use the spreadsheet and Solver sensitivity report below to answer questions #6-7 2 Input Information ar ar Avail 4 Constraint 1 5 Constraint 2 6 Constraint 3 30 fit 4 10 lOutput Information 11 Variables 12 Profit Total Used 14 Resources 15 Constraint l 16 Constraint 2 17 Constraint 3 18 Slack/Surplus nsitivity Report Changing Cells Final Value Reduced Objective Allowable Allowable Cost Cell SBS12 SCS12 Name Coefficient Increase Decrease Variable 8.4615384620 Variable 2 4.6153846150 3.4 2.333333333 8.5 Constraints Final Value Shadow Constraint Allowable Allowable Cell SBS15 SBS16 SBS17 Name Price 0.538461538 40 1.307692308 30 R.H. Side Increase Decrease constraint 1 40 Used constraint 2 30 Used constraint 3 13.07692308 o 110 30 1.076923077 1E+30 4.666666667 12 What is the optimal value for Variable 2? O 30 O 40 O 8.46