Andrew is ready to invest $200,000 in stocks and he has been provided nine different alternatives...

Transcribed Image Text:

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? 2 4 30% 36.17% 1 2 1 15000 " 1 25000 1 15000 1 4000 25000 1-1-1-111- Memun Other 3000 . 100 3000 2 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? 2 4 30% 36.17% 1 2 1 15000 " 1 25000 1 15000 1 4000 25000 1-1-1-111- Memun Other 3000 . 100 3000 2