The writer is very fast, professional and responded to the review request fast also. Thank you.
Presentation/PPT
27/08/2022
ADM 2302 -Assignment #1
Problem 1 (15 points)The price of oil has been dropping significantly recently. This urges fund managers to adjust their investment portfolios. In particular, many fund managers in Canada used to have a significant portion of their investments in the energy sector, but now they need to look into otherinvestment opportunity. The fund manager of XYZ investment corp. estimates that in the past the rate-of-return for the investment made in the energy sector is about 3%, i.e. 100 dollars of investment can generate 3 dollars of profit, but given the trend of oil price the manager alsopredicts that the rate of return might drop to -5% in the worst-case scenario. The manager read the market reports of the other sectors and learned that in average the past rate-of-return for nonenergy sectors is around 1.5%. Given that investing in other sectors appears to be less risky, the manager predicts that even in the worst-case scenario the rate-of-return for non-energy sectors can still be around 1%. The manager needs to determine how much money she should invest in the energy sector and how much she should invest in the non-energy sectors so that the total profit estimated based on the past rate-of-return can be maximized. However, she cannot invest more than 5 million dollarsand has to make sure that the overall investment cannot lose more than $25,000 in the worst-case scenario estimated based on the predicted rate-of-return.(a) Formulate algebraically a linear programming model for the above problem. Define the decision variables, objective function, and constraints. (5 points)(b) Draw the feasible region for the linear programming model. (2 points)(c) Find the optimal solution(s) and optimal value of the objective function for the linear programing model. Justify why the solution is optimal. Describe also verbally how the manager should invest. (3 points)
(d) Suppose that the manager can also invest in bonds, which in the past had rate-of-returnaround 0.5%. The rate-of-return for bonds is known to be stable, so the manager predicts thateven in the worst-case scenario the rate-of-return remains the same, i.e. 0.5%.Formulate a linear programming model on a spreadsheet to find out how much the managershould invest in the energy sector, non-energy sectors, and bonds with the objective andrequirements specified above. SOLVE using Excel solver (Provide a printout of thecorresponding “Excel Spreadsheet” and the “Answer Report”). Describe verbally how themanager should invest. (5 points)
Problem 2 (6 points)Consider the following linear programming model:Minimize x+0.5ySubject to2y – x<=1
y<=1.5
x+2y >=22x – y<=8
2x+3y<=12
x >=1x >=0, y>=0(a) Draw the feasible region and objective function for the model. Show the optimal solution andoptimal value of the objective function. Justify why the solution is optimal. (4 points)(b) What other method can you choose to find the optimal solution without drawing the objectivefunction? Considering the structure of the feasible region, which method is better? Justify youranswer. (2 points)
Problem 3 (7 points)Consider the following linear programming model:Maximize 3x + ySubject to2x + y<=14
x – y<=1
x +12y<=108
x >=3, y >=0(a) Draw the feasible region and objective function for the model. Report what you find aboutthe optimal solution(s) and the optimal value of the objective function. Justify your finding.(4 points)(b) Is there any redundant constraint? Which one(s) and why? (1 point)(c) Is there any constraint(s) that can be removed without changing the optimal solution(s) youobtained in (a) and why? (2 points)Problem 4 (6 points)Consider the following linear programming model:Maximize –2x + 0.5ySubject toy – 4x<=1
4x + y>=4y<=6
y>=0x >=0.5(a) Draw the feasible region and objective function for the model. Report what you find aboutthe optimal solution(s) and the optimal value of the objective function. Justify your finding.(4 points)(b) Change the objective function in the LP model to “2x-0.5y”. Report what you find about theoptimal solution(s) and the optimal value. Justify your finding. (2 points)
Problem 5 (6 points)Consider the following linear programming model:Maximize 2x – ySubject tox+5y<=12
x – 2y<=6
x – y>=0x+2y<=8
x+3y<=9
x>=0, y>=0(a) Draw the feasible region for the model, however DO NOT draw the objective function.Without graphing the objective function (i.e. use the corner point method), find the optimalsolution(s) and the optimal value of the objective function. Justify your method and why thesolution(s) you obtain is (are) optimal. (4 points)(b) Add the constraint “x+5y>=12” to the linear programming model. Is the optimal solution thesame as the one in (a)? If yes, justify your answer by highlighting the new feasible region. Ifnot, provide the new optimal solution also by highlighting the new feasible region. In bothcases, justify why the solution is optimal. (2points)
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more