Overview
3questions , only solve questions 7,8,9. I want the answer in Excel sheet only
For these 3 questions I do need part 1 and 2 too.
7. Loan offer analysis
8. Change in advertising effectiveness
9. Sensitivity analysis
-Initial optimal solution of question 2 is required to solve 7,8,9
Question 7 mai I’ve to get the real cost of the loan
I’ve to find shadow price and calculate marginal profit vs cost
-Question 8 mai I’ve to resolve the LP model and change coefficients
I’ve to compare everything w the plan from question 2
-Question 9 requires if we remove George’s personal sales balance constraints toh max potential profit increase what we can get