If someone could put this into an excel spreadsheet and include the workings that would be great. Thank you.

3 roblem 2) 25 Points Given: Decision Variables: 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 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 10AM + 5.5BM + 5CM + 9AP + 6BP + 6.2CP Objective function: MIN: Subject to: Constraints: C1 (Demand for Model A): C2 (Demand for Model B): C3 (Demand for Model C): C4 (Injection molding time): C5 (Assembly time): C6 (Non-negativity): 1AM + 1AP = 120 1BM + 1BP = 160 1CM + 1CP = 200 5AM+ 2BM + 1.5CM0 Instructions: Create a Solver model and generate a sensitivity report. Submit your Excel spreadsheet (save as Problem 2) with Solver model and Sensitivity Report to the Exam 1 Lab Part assignment on Canvas. Then answer the questions below. Setting up a correct Solver model and submitting it correctly are worth 10 points (5 points each). {Problem 2 continued on next page) should be purchased, and what is the value of the objective function (Total Cost)? (3 points) Problem 2 - Part a) How many of each model should be produced, how many of each model 4 Problem 2 - Part b) Use the Sensitivity Report that you generated and refer to your original answer. Assume that we will decrease the value of the coefficient of CM to $4.40: Amount of the Decrease equals what value? (1 point) The Allowable Decrease equals what value? (1 point) Is this change within the Allowable Decrease? (1 point) What will the new objective function value equal? (3 points) Note: You must calculate this value in your spreadsheet using the SUMPRODUCT formula that we used in all spreadsheets posted on Canvas. Problem 2 - Part c) Use the Sensitivity Report that you generated and refer to your original answer. Assume that we will decrease the right-hand-side value of C3 to 180: Amount of the Decrease equals what value? (1 point) The Allowable Decrease equals what value? (1 point) Is this change within the Allowable Decrease? (1 point) What will the new objective function value equal? (3 points) Note: You must calculate this value in your spreadsheet using the simple formula that we used in all spreadsheets posted on Canvas