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 stocksExcel 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!