PLEASE USE EXCEL IF NECESSARY

(worth 20 points) Consider the following LP problem, in which X and Y denote the number of units of products X and Y to produce, respectively: Maximizeprofit=$5X+$5Y subject to the constraints 2X+3Y60(resource1)4X+2Y80(resource2)X18(resource3)X,Y0(nonnegativity) The Excel Sensitivity Report for this problem is shown below. Calculate and explain what happens to the optimal solution for each of the following situations. Each question is independent of the other questions. a. What is the optimal solution to this problem? b. For what ranges of values, holding all else constant, could each of the objective function coefficients be changed without changing the optimal solution? c. If we could obtain one additional unit of resource 1, how would it impact profit? Over what range of RHS values could we rely upon this value? d. If we were to give up one unit of resource 2, how would it impact profit? Over what range of RHS values could we rely upon this value? e. If we were to increase the profit for product X by $4, how would the solution change? What would be the new solution values and the new profit? f. If we were to decrease the profit for product Y by $2, how would the solution change? What would be the new solution values and the new profit? g. Suppose that two units of resource 3 were found to be unusable, how would the solution change? h. If we were able to obtain five more units of resource 3, would you be interested in the deal? Why or why not? Variahle ralle Conotrainte