please use Solver and sensitivity report in excel to show how to solve. Thank you in advance!

AM= number of cases of Model A to manufacture BM= number of cases of Model B to manufacture CM= number of cases of Model C to manufacture DM=number of cases of Model D to manufacture AP = number of cases of Model A to purchase BP = number of cases of Model B to purchase CP = number of cases of Model C to purchase DP = number of cases of Model D to purchase Objective function: MIN: 8.2AM +9.1BM +6.5CM+8.8DM+8.5AP +9.5BP + 5.9CP + 7.1DP Subject to: Constraints: C1 (Demand for Model A): 1AM + LAP= 300 C2 (Demand for Model B): IBM + IBP = 500 C3 (Demand for Model C): 1CM+1CP = 600 C4 (Demand for Model D): IDM + IDP = 705 C5 (Injection molding time): 10.2AM + 3.1BM +2.5CM+3.2DM 0 a After running your Solver model and generating a sensitivity report, you must answer the questions listed below in your Excel file. (Continued on next page) 2 Problem 1 - Part a) Use the Sensitivity Report that you generated and refer to your original answer. Assume that we will increase the value of the coefficient of CP to 6.4: Amount of the Increase equals what value? The Allowable Increase equals what value? Is this change within the Allowable Increase? What will the new objective function value equal? Problem 1 - Part b) Use the Sensitivity Report that you generated and refer to your original answer. Assume that we will decrease the right-hand-side value of C6 to 705: Amount of the Decrease equals what value? The Allowable Decrease equals what value? Is this change within the Allowable Decrease? What will the new objective function value equal