Use Solver, a Microsoft Excel add-in program, to finish this assignment. Read th

Use Solver, a Microsoft Excel add-in program, to finish this assignment. Read the instructions here: Decision Modeling with Spreadsheets Assignment.docx . Complete static model, dynamic model and Product-Mix Linear Programming Model in Microsoft Excel. Create one Excel file. You can include several sheets for different models.

Question 1 Original ModelCreate the 2 original models in Excel.

Question 1.a What is the effect of a change in the interest rate from 8 percent to 10 percent?

Question 1.b What interest rate is required to decrease the monthly payments by 20 percent? What change in the loan amount would have the same effect?

Question 1.c What is the effect of a prepayment of $200 per month? What prepayment would be necessary to pay off the loan in 25 years instead of 30 years?

Question 2a Model
Create the MBI product-mix problem using Excel’s Solver.

Question 2b Output Report
Did you get the same results as reported in this chapter?

Question 2c Sensitivity
Report 1Lower the right-hand side of the CC-8 marketing constraint by 1 unit, from 200 to 199. What happens to the solution when you solve this modified problem?

Question 2d Sensitivity Report
Eliminate the CC-8 lower-bound constraint entirely (this can be done easily by deleting it in Solver or setting the lower limit to zero) and re-solve the problem. What happens?