Please answer A & B for question 1. You should type the calculations and your solution as your responses. You should not solve the problems of this homework by using Excel solver tool. This should be done just by using the sensitivity analysis procedures and reviewing the information below.

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

Variable Cells
Cell	Name	Final Value	Reduced Cost	Objective Coefficient	Allowable Increase	Allowable Decrease
$B$3	$ invested Apple	1695.332	0	1	0.082	0.286
$C$3	$ invested Microsoft	0	0.106	1	1.00E+30	0.106
$D$3	$ invested FactSet	1646.192	0	1	0.138	0.076
Constraints
Cell	Name	Final Value	Shadow Price	Constraint R.H. side	Allowable Increase	Allowable Decrease
$E$6	Short Term Growth	1066.83	0	850	216.83	1.00E+30
$E$7	Intermediate Growth	5500	0.491	5500	1340	985.714
$E$8	Dividend Income	200	3.194	200	43.671	39.181

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.