You should type the calculations and your solution to each question, and submit your answer in a word file. You should not solve the problems of this homework by using Excel solver tool.

Use the following sensitivity report for this LP model to answer the following questions. (Please write any required calculation to get the full credit)

What is the impact on the least amount SEQUEL can invest under the following scenarios?

1. Dividend should be at least $210 per year.
2. The criteria on the short-term growth is eliminated.

Variable Cells Cell Name $B$3 $ invested Apple $C$3 $ invested Microsoft $D$3 $ invested FactSet Final Value 1695.332 0 1646.192 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 0 1 0.082 0.286 0.106 1 1E+30 0.106 0 1 0.138 0.076 Constraints Cell Name $E$6 Short term growth $E$7 Intermediate growth $E$8 Dividend income Final Value $1,066.83 $5,500.00 $200.00 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 0 850 216.830 1E+30 0.491 5500 1340 985.714 3.194 200 43.671 39.181