This project was awarded to nevo1234 for $5 USD / hour.Get free quotes for a project like this
Project Budget$2 - $8 USD / hour
1. Use Excel to answer your assignment. Solve each part (A, B, and C) in a separate sheet.
2. Explain all the details, define decision variables, objective function, constraints, etc.
Assignment 2: Assume you have $X000 (X thousand dollars) to invest over the next
seven years. At the beginning of each year you can invest money in one or three-year
time deposits. The bank pays 1 percent interest on one-year deposits and 4 percent
(total) on three-year time deposits. In addition, Royal Bank of Canada will offer twoyear
certificates starting at the beginning of the third year. This investment in RBC will
return [url removed, login to view] percent (total). If you invest your money that is available every year,
formulate a linear programming to maximize your total cash on hand at the end of the
A: Suppose X is the sum of your student ID digits. Moreover, assume that you can
invest at the beginning of each year any value in the available investment options.
Define decision variables, objective function, and constraints for your linear
programming model. (6 marks)
B: Solve your investment LP model using Excel Solver and interpret your investment
plan. (3 marks)
C: Assume the two-year RBC deposit starts at the beginning of the fifth year. What
would be the corresponding change in your model formulated in Part A?
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online