Use the Excel spreadsheet and Solver's sensitivity report to answer the questions. Direction: For numerical answers, round non-integer values to 2 decimal places. Keep integer values as integers. Size What is the optimal value for Xi? Answer: X2= What is the optimal value for X? Answer: X- . Would you pay $0.50 each for up to 100 more units of resource 1? Answer: Enter Yes or No Is the current solution still optimal even when the objective function coefficient of product 1 is decreased to 1.5? Answer: Enter Yes or No Does the third constraint have a slack or a surplus? What is its current value? Answers: and If 20 more units of resource 2 were available, would the profit increase by $26.2? Answer: Enter Yes or No. Input Section: 12 4 5 Objective function Coefficients Constraints #1 #2 #3 am 2 3 5 1 1 Constraint Sign RHS 40 30 12 VIVIAI Sensitivity Analysis: Variable Final Value 8.4615 4.6154 Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease 0 5 7 3.4 0 4. 8.5 2.3333 Constraint Final Value Shadow Price RHS Value Allowable Increase Allowable Decrease #1 LHS 40 0.5385 40 110 7 #2 LHS 30 1.3077 30 30 4.6667 #3 LHS 13.0769 0 12 1.0769 1E-30