Please solve the following question using excel commands like solver, Analytic Solver, or sensitivity analysis.

5. Reconsider the model given in Problem 5.2. While doing what-if analysis, you learn that the estimates of the right-hand sides of the two functional constraints are accurate only to within + 50 percent. In other words, the ranges of likely values for these parameters are 5 to 15 for the first right-hand side and 6 to 18 for the second right-hand side. a. After solving the original spreadsheet model, determine the shadow price for the first functional constraint by increasing its right-hand side by one and solving again. b. Use a parameter analysis report to generate the optimal solution and total profit as the right-hand side of the first functional constraint is incremented by 1 from 5 to 15. Use this table to estimate the allowable range for this right-hand side, that is, the range over which the shadow price obtained in part a is valid. c. Repeat part a for the second functional constraint. d. Repeat part b for the second functional constraint where its right- hand side is incremented by 1 from 6 to 18. e. Use Solver's sensitivity report to determine the shadow price for each functional constraint and the allowable range for the right-hand side of each of these constraints