Please use excel for all thesw problems! The previous "expert" did not follow my request I needed! please use excel, excel solver, and excel solver sensitivity report with all steps and formulas in everything! Thank you!

5. (5.11) Reconsider the model given in Problem 5.2. While doing whatif 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 righthand 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. 5.2. Consider a resource-allocation problem having the following data