M24 X V fx A B C D E F G H L K L M N Beginning Balance $60,000 Minimum Balance $0 A W N- Investment A A A A B B B C Year 1 2 3 4 1 2 3 2 5 Year 1 -1 -1 Year 2 -1 -1 -1 go OUT Year 3 1.4 -1 -1 Year 4 1.4 -1 1.7 Year 5 1.4 1.7 -1 Year 6 1.4 1.7 1.9 1.3 12 13 Dollars Invested 14 15 16 17 18 19Al Ferris has $60,000 that he wishes to invest now in order to use the accumulation for purchasing a retirement annuity in five years. After consulting with his financial advisor, he has been offered four types of fixed-income investments, which we will label as investments A, B, C, and D. Investments A and B are available at the beginning of each of the next five years (call them Years 1to 5). Each dollar invested in A at the beginning of a year returns $1.40 (a profit of $0.40) two years later (in time for immediate reinvestment). Each dollar invested in B at the beginning of a year returns $1.70 three years later. Investments C and D will each be available at one time in the future. Each dollar invested in C at the beginning of Year 2 returns $1.90 at the end of Year 5. Each dollar invested in D at the beginning of Year 5 returns $1.30 at the end of Year 5. [ Click here for the Excel Data File Formulate and solve a linear programming model for this problem on a spreadsheet. a. Which investment plan maximizes the amount of money that can be accumulated by the end of Year 57 b. Determine the ending balance at the end of Year 5. Complete this question by entering your answers in the tabs below. Required A Required B Determine the ending balance at the end of Year 5. Endingbalance [ |