On the tab labeled "Original Problem", I have provided the modeling of Problem #17 in Chapte problem in the textbook and then review the model to familiarize yourself with the integration example from the text. First requirement is to fill in the formulas in the GREEN cells for the Objective function and th values in the RED cells. Next, load the solver by filling in the 'Set Target Cell', 'By Changing Cells', and 'Subject to the Once you have loaded the solver and solved the problem, you are required to obtain the sens 'Sensitivity Report' will show up in a new tab in the bottom of the sheet. From there, proceed to the Solutions tab where you will find five questions. To answer each q sensitivity analysis and locate the correct information from the analysis to answer each ques model (after loading the solver) and obtaining and consulting the sensitivity data, not by reso In your response to each question, you should begin with a written sentence(s) that explains you found the information you need to answer each question followed by a sentence answeri worth 20 points: 10 points for explaining where in the sensitivity analysis you found the infor (mechanical component) and 10 points for a clear, concise, grammatically correct answer to t should be answered on the Solutions tab and typed in unbolded print right after the statemen Good luck, and HAVE FUN! Problem #17 in Chapter 3. Carefully read the statement of the elf with the integration of the LP into Excel. Reference the 'Par.xls' jective function and the constraints. There is no need to change the s', and 'Subject to the Constraints' boxes. ired to obtain the sensitivity analysis. If you do this correctly, the . ons. To answer each question, you will be required to consult the s to answer each question. All answers should come from solving the tivity data, not by resolving the model multiple times! tence(s) that explains where specifically in the sensitivity analysis by a sentence answering each respective question. Each question is sis you found the information necessary to answer the question ally correct answer to the question (written component). Questions ght after the statement of the question. Porsche Club Number to Make Unit Profits Constraints Steel available Manufacturing minutes Assembly minutes DRB 0 $200 DRW 0 $280 20 40 60 25 100 40 Total Profit Used Available 40,000 120,000 96,000 Question 1 (20 Points): What are the optimal solution and the total profit? Question 2 (20 Points): If the unit profit of the DRW decreases to $260 per unit, how Question 3 (20 Points): How much should the company be willing to pay to acquire a minutes' area? Explain in detail. Question 4 (20 Points): How much should the company be willing to pay to acquire a Question 5 (20 Points): How much will the objective function, 'Total Profit', change if Manufacturing capacity available? total profit? to $260 per unit, how would the optimal solution change? ing to pay to acquire additional capacity in the 'Assembly ing to pay to acquire additional 'Steel'? Explain in detail. Total Profit', change if there was one additiional hour of