Micro Personal. Residential Industrial Limits Micro Personal Residential Industrial 8 19 Decision Variables 20 21 22 23 24 25 26 Objective Function 27 28 29 30 31 32 33 34 35 26 3 4 5 6 Air Conditioners 7 Air Conditioners LL 2.5 14 4.4 8000 10. Stamping lo 100 100 Min Sales + Welding 1.3 32 3.6 4.1 8000 Max Sales 500 750 1000 1500 2.1 2.8 3.3 Chem. 14.8 8000 Profit 1900 1300 1800 2200 Constraints LHS Assembly Inspection 124 2.6 2.1 3.5 3.1 4.9 4.1 8000 8000 TYPE RHS Storage 96 11.8 13.4 30000 Given this problem, complete the following tasks and questions: 1. Implement the linear optimization problem (do not require your variables to be integers!) in Excel and determine the optimal production plan. What is the monthly profit and monthly production for each air conditioner type? Answer the question below and upload your solved Excel workbook (including the sensitivity analysis from the next steps). 2. Run the sensitivity report. Which constraints are binding? 3. Only using the sensitivity report (do not change the value and re-run the model), would the optimal production plan change if the profit for each Micro air conditioner change to 950? If your answer is yes, explain your reasoning. If your answer is no, what is the new monthly profit and explain your calculation. 4. Only using the sensitivity report (do not change the value and re-run the model), would the optimal production plan change if the profit for each Residential air conditioner change to 1700? If your answer is yes, explain your reasoning. If your answer is no, what is the new monthly profit and explain your calculation. 5. Only using the sensitivity report (do not change the value and re-run the model), can you determine the new objective function value without re-running the model if the number of hours available in the Stamping department change to 8100? If your answer is no, explain your reasoning. If yes, what is the new monthly profit and explain your calculation. 6. Only using the sensitivity report (do not change the value and re-run the model), can you determine the new objective function value without re-running the model if the number of hours available in the Welding department change to 7000? If your answer is no, explain your reasoning. If yes, what is the new monthly profit and explain your calculation. Micro Personal. Residential Industrial Limits Micro Personal Residential Industrial 8 19 Decision Variables 20 21 22 23 24 25 26 Objective Function 27 28 29 30 31 32 33 34 35 26 3 4 5 6 Air Conditioners 7 Air Conditioners LL 2.5 14 4.4 8000 10. Stamping lo 100 100 Min Sales + Welding 1.3 32 3.6 4.1 8000 Max Sales 500 750 1000 1500 2.1 2.8 3.3 Chem. 14.8 8000 Profit 1900 1300 1800 2200 Constraints LHS Assembly Inspection 124 2.6 2.1 3.5 3.1 4.9 4.1 8000 8000 TYPE RHS Storage 96 11.8 13.4 30000 Given this problem, complete the following tasks and questions: 1. Implement the linear optimization problem (do not require your variables to be integers!) in Excel and determine the optimal production plan. What is the monthly profit and monthly production for each air conditioner type? Answer the question below and upload your solved Excel workbook (including the sensitivity analysis from the next steps). 2. Run the sensitivity report. Which constraints are binding? 3. Only using the sensitivity report (do not change the value and re-run the model), would the optimal production plan change if the profit for each Micro air conditioner change to 950? If your answer is yes, explain your reasoning. If your answer is no, what is the new monthly profit and explain your calculation. 4. Only using the sensitivity report (do not change the value and re-run the model), would the optimal production plan change if the profit for each Residential air conditioner change to 1700? If your answer is yes, explain your reasoning. If your answer is no, what is the new monthly profit and explain your calculation. 5. Only using the sensitivity report (do not change the value and re-run the model), can you determine the new objective function value without re-running the model if the number of hours available in the Stamping department change to 8100? If your answer is no, explain your reasoning. If yes, what is the new monthly profit and explain your calculation. 6. Only using the sensitivity report (do not change the value and re-run the model), can you determine the new objective function value without re-running the model if the number of hours available in the Welding department change to 7000? If your answer is no, explain your reasoning. If yes, what is the new monthly profit and explain your calculation
