Andrew is ready to invest $200,000 in stocks and he has been provided nine different alternatives by his financial consultant. The following stocks belong to three different industrial sectors and each sector has three varieties of stocks each with different expected rate of return. The average rate of return taken for the past ten years is provided with each of the nine stocks. Stock Industry Annual Return 1 Airlines 18.24% 2 Airlines 28.75% 3 Airlines 11.08% 4 Banking 20.12% 5 Banking 14.00% 6 Banking 26.17% 7 Agriculture 23.67% 8 Agriculture 18.25% 9 Agriculture 16.50% The decision will be based on the constraints provided below: Exactly five alternatives should be chosen. Any stock chosen can have a maximum investment of $55,000. Any stock chosen must have a minimum investment of at least $25,000. For the Airlines sector, the maximum number of stocks that can be chosen is two. The total amount invested in Banking must be at least as much as the amount invested in Agriculture. a. Formulate a model that will decide Andrew's investment strategy to maximize his expected annual return. b. Based on the Solver output below, what would be the chosen stocks? What is the return? c. Which constraints are binding and which constraints are non-binding? 1 Parameters 2 3 Stock Industry Annual Return 4 1 Airlines 18.24% 5 2 Airlines 28.75% 6 3 Airlines 11.08% 7 4 Banking 20.12% 8 5 Banking 14.00% 9 6 Banking 26.17% 10 7 Agriculture 23.67% 11 8 Agriculture 18.25% 12 9 Agriculture 16.50% 13 14 Model 15 D Minimum Maximum H If investment Minimum investment Maximum investment 25000 55000 Total investment 200000 16 Stock Selection Amount Invested amount (if any) amount (if any) Other constraints 17 1 LHS RHS 18 2 1 55000 25000 55000 5 5 19 3 0 1 2 20 4 1 25000 25000 55000 80000 65000 21 S 0 22 6 1 55000 25000 55000 23 7 1 40000 25000 55000 24 8 25000 25000 55000 25 9 26 Total invested 200000 27 27 28 Return (S) 49266.5