Use the spreadsheet and Excel Solver sensitivity report to answer these questions. When applicable, round non-integer values to 2 decimal places. Leave integer values as integers. a What is the optimal value for x? b. What is the optimal value for x?? c Would you pay $1.30 each for up to 50 more units of resource 1? Is the current solution still optimal even when the objective function coefficient of product 2 is decreased to 2? The second constraint has a and its current value is e. f. If only 30 units of resource 1 were available, would profit decrease by $5.4? 2 Input Information Sign of the constraint RHS Parameters Parameters associated with associated with variable 1 variable 2 25 3 4 Constraint 1 40 | vivi 5 Constraint 2 6 Constraint 3 5 Constraint 2 6 Constraint 3 8 Objective function coefficient 10 Output Information 11 Variables Profit: max Z= Total =B12-C12 =B8%B11 =C8C11 / 12 13- | 14 Resources Constraint 1 Constraint 2 Constraint 3 Used Slack/Surplus =B4*B11-C4*C11 =E4-B15 =B5*B11+C5*C11 =E5-B16 =B6*B11+C6*C11] =B17-E6 16 17 18 Sensitivity Report Changing Cells Final Reduced Cell Name Value Cost Objective Coefficient 7 Allowable Allowable Increase Decrease 340 8.46 Sensitivity Report Changing Cells Final Cell Name Value Reduced Cost 0 0 4 Objective Coefficient 5 8 SBS11 Allowable Increase 7 .5 8.46 Allowable Decrease 3.40 2.33 Variable 1 SCS11 Variable 2 4.62 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price SB515 constraint 1 Used 40 constraint 2 Used 30 constraint 3 Used 13.08 R.H. Side 40 30 12 Increase 110 30 1.08 0.54 .31 0 SB516 Decrease 7 4.67 1E-30 1 SB517