Question: please solve lingo or excel solver. (question b) 1. (20 marks) Cindy has $9000 to invest in a portfolio. Her investment alternatives and their expected

please solve lingo or excel solver. (question b)

1. (20 marks) Cindy has $9000 to invest in a portfolio. Her investment alternatives and their expected returns are: Investment 1 2 3 Description Expected Return RRSP (retirement) 4.1% Employer's retirement plan 6.2% Money Market Fund 5.7% She will put at least $1500 into each investment, and cannot invest more than $9000 in total. In addition, she has three goals which may be violated if need be. Goal 1 is for the expected annual return to be at least $550. Goal 2 is to invest no more than $4000 in the two retirement plans combined. Goal 3 is to invest in investment 3 at least twice as much as in investment 1. Goal 1 is five times as important as Goal 2, and Goal 2 is twice as important as Goal 3. (a) Write the algebraic model for this problem. (b) Solve the model using LINGO or the Excel Solver. (c) State the solution in words. 1. (20 marks) Cindy has $9000 to invest in a portfolio. Her investment alternatives and their expected returns are: Investment 1 2 3 Description Expected Return RRSP (retirement) 4.1% Employer's retirement plan 6.2% Money Market Fund 5.7% She will put at least $1500 into each investment, and cannot invest more than $9000 in total. In addition, she has three goals which may be violated if need be. Goal 1 is for the expected annual return to be at least $550. Goal 2 is to invest no more than $4000 in the two retirement plans combined. Goal 3 is to invest in investment 3 at least twice as much as in investment 1. Goal 1 is five times as important as Goal 2, and Goal 2 is twice as important as Goal 3. (a) Write the algebraic model for this problem. (b) Solve the model using LINGO or the Excel Solver. (c) State the solution in words

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 General Management Questions!

***USE LINGO*** questions using excel will be reported incorrect. please state all relevant steps and provide the lingo code. Thank you 1. (20 marks) Cindy has $9000 to invest in a portfolio. Her...

1. (20 marks) Cindy has $9000 to invest in a portfolio. Her investment alternatives and their expected returns are: Investment Description Expected Return 1 RRSP (retirement) 4.1% 2 Employers...

please do not just copy paste from another answer. And solve the model using LINGO. thanks 1. (20 marks) Cindy has $9000 to invest in a portfolio. Her investment alternatives and their expected...

(20 marks) Cindy has $9000 to invest in a portfolio. Her investment alternatives and their expected returns are: Investment 1 2 3 Description Expected Return RRSP (retirement) 4.1% Employer's...

1. (20 marks) Cindy has $10,000 to invest in a portfolio. Her investment alternatives and their expected returns are: Investment 1 2 3 Description RRSP (retirement) Employer's retirement plan Money...

1. (20 marks) John has $8000 to invest in a portfolio. His investment alternatives and their expected returns are: Investment 1 2 3 Description Expected Return RRSP (retirement) 4.1% Employer's...

Use lingo (20 marks) Cindy has $10,000 to invest in a portfolio. Her investment alternatives and their expected returns are: Investment Description Expected Return 1 RRSP (retirement) 4.1% 2...

(20 marks) Cindy has $10,000 to invest in a portfolio. Her investment alternatives and their expected returns are: Investment Description Expected Return 1 RRSP (retirement) 4.1% 2 Employer's...

1. ( 20 marks) John has $8000 to invest in a portfolio. His investment alternatives and their expected returns are: He will put at least $1000 into each investment, and cannot invest more than $8000...

1. (20 marks) John has $8000 to invest in a portfolio. His investment alternatives and their expected returns are: Investment 1 2 3 Description Expected Return RRSP (retirement) 4.1% Employer's...

Complete a closing trial balance, recording the following activities and transactions within the trial balance provided which has the beginning trial balance for the company. Cash 500,000 Accounts...

Suppose you have decided to fund your education through Loans. You will receive $10,000 at the beginning of each of the four years of your study program during which no interest will accrue. After...

Question: give a presentation at an online training session for employees who are now working from home. The subject of this training session is: Access Controls and Why They Matter. Background:...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...