Question: Excel Linear Optimization please Alex is ready to invest $200,000 in stocks and he has been provided nine different alternatives by his financial consultant. The
Excel Linear Optimization please
Alex 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 8.24% 2 Airlines 18.75% 3 Airlines 11.08% 4 Banking 10.12% 5 Banking 14.00% 6 Banking 16.17% 7 Agriculture 23.67% 8 Agriculture 18.25% 9 Agriculture 16.50% The decision will be based on the constraints provided below: o Exactly 5 alternatives should be chosen. o Any stock chosen can have a maximum investment of $55,000. 0 Any stock chosen must have a minimum investment of at least $25,000. o For all industries, the maximum number of stocks that can be chosen is two. o The total amount invested in Banking must be at least as much as the amount invested in Agriculture. Formulate and solve a model that will decide Andrew's investment strategy to maximize his expected annual return
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
