(Please write any required calculation to get the full credit, do not solve the problem with excel solver tool) 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.

SEQUEL financial group investment LP modeling problem

	Apple	Microsoft	FactSet
$ invested	$1,695.33	$0.00	$1,646.19
Investment	1	1	1	$3,341.52
Constraints
Short term growth	0.27	0.39	0.37	$1,066.83	>=	$850
Intermediate growth	1.71	1.43	1.58	$5,500.00	>=	$5,500
Dividend income	0.05	0.06	0.07	$200.00	>=	$200
				LHS	Sign	RHS

sensitivity report

		Final	Reduced	Objective	Allowable	Allowable
Cell	Name	Value	Cost	Coefficient	Increase	Decrease
$B$3	$ invested Apple	1695.3317	0	1	0.082278481	0.285714286
$C$3	$ invested Microsoft	0	0.105651106	1	1E+30	0.105651106
$D$3	$ invested FactSet	1646.1916	0	1	0.138263666	0.076023392
		Final	Shadow	Constraint	Allowable	Allowable
Cell	Name	Value	Price	R.H. Side	Increase	Decrease
$E$6	Short term growth	$1,066.83	0	850	216.8304668	1E+30
$E$7	Intermediate growth	$5,500.00	0.491400491	5500	1340	985.7142857
$E$8	Dividend income	$200.00	3.194103194	200	43.67088608	39.18128655