In the problem on excel : 1.What are the decision variables 2.What is the objective functions 3. What are the 12 constraints and explain You won $750,000 from a lottery and, you have decided to come up with a list of possible investments that you will invest, all of the $750,000 that you have won. The expected return of each of the 6 possible investments that you are considering investing in,and their Expected Rate of Return over the next year are in the table below. Investment Expected Rate of return Amazon Inc (USA Shares) 13.5% Royal Bank of Canada (Canadian Shares) 7.4% Nike Inc (USA Shares) 10.0% Telus Corporation (Canadian Shares) 6.1% Snap Inc (USA Shares) 3.0% Nestle SA (Switzerland Shares) 4.8% it is important to have a diversified portfolio, and therefore have come up with the following guidelines on how to invest your money: 1.The total invested in USA Shares should be at least 10% but no more then 45% of the total amount invested. 2.Not more then $275,000 invested in Nestle SA. 3.At least $220,000 invested in a combination of the 2 Canadian Stocks. 4.There must be a minimum of $50,000 invested in each non-USA company. 5.The amount invested in Snap Inc must equal the amount invested in Amazon Inc. 6.The amount in RBC is not to be more then four times greater then the amount invested in Amazon. 7.Together, the amount invested in all USA shares, must not be more then the amount invested in Nestle. 8.The amount invested in Nestle SA must be exactly double plus $5,000 more then Telus Corporation. Subject to these constraints, your goal is to maximize projected returns on your investment portfolio. Formulate this problem on Excel and solve for the amount of money that should be invested in each of the 5 different investments while making as high of a return as possible.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 56P

See similar textbooks

Related questions

Question

100%

In the problem on excel : 1.What are the decision variables 2.What is the objective functions 3. What are the 12 constraints and explain You won $750,000 from a lottery and, you have decided to come up with a list of possible investments that you will invest, all of the $750,000 that you have won. The expected return of each of the 6 possible investments that you are considering investing in,and their Expected Rate of Return over the next year are in the table below. Investment Expected Rate of return Amazon Inc (USA Shares) 13.5% Royal Bank of Canada (Canadian Shares) 7.4% Nike Inc (USA Shares) 10.0% Telus Corporation (Canadian Shares) 6.1% Snap Inc (USA Shares) 3.0% Nestle SA (Switzerland Shares) 4.8% it is important to have a diversified portfolio, and therefore have come up with the following guidelines on how to invest your money: 1.The total invested in USA Shares should be at least 10% but no more then 45% of the total amount invested. 2.Not more then $275,000 invested in Nestle SA. 3.At least $220,000 invested in a combination of the 2 Canadian Stocks. 4.There must be a minimum of $50,000 invested in each non-USA company. 5.The amount invested in Snap Inc must equal the amount invested in Amazon Inc. 6.The amount in RBC is not to be more then four times greater then the amount invested in Amazon. 7.Together, the amount invested in all USA shares, must not be more then the amount invested in Nestle. 8.The amount invested in Nestle SA must be exactly double plus $5,000 more then Telus Corporation. Subject to these constraints, your goal is to maximize projected returns on your investment portfolio. Formulate this problem on Excel and solve for the amount of money that should be invested in each of the 5 different investments while making as high of a return as possible.

Expert Solution

Step by step

Solved in 4 steps with 7 images

SEE SOLUTION Check out a sample Q&A here