[@ Release x = A NJcuB x| Rl NJCUE A Content x %k Chapter X @ Francoic x (@ ChatGP x Home|! X @ Peoples X = @ Pleaset X | % Course! X =+ & (e webassign.net/web/Student/Assignment-Responses/last?dep=35755919#question5120703_2 Vi LT LT ) Finish update : Text Blaze Dashbo... Text Blaze Diction... 2 Meet - vea-xbsm-... A live boosts - Goog... KoV Cash Card - Overv... = #cco-cs-escalatio... = Empathy Library!... b 3 All Bookmarks Francois and Camille Merrit recently inherited a substantial amount of money from a deceased relative. They want to use part of this money to establish an account to pay for their daughter's college education. Their daughter, Lisa, will be starting college five years from now. The Merrits estimate that her first year college expenses will amount to $13,000 and increase $3,000 per year during each of the remaining three years of her education. The following investments are available to the Merrits. Investment Available Matures Return of Maturity A Every year 1 year 6% B 1;3;5; 7 2 years 14% C 1,4 3 years 18% D 1 7 years 65% The Merrits want to determine an investment plan that will provide the necessary funds to cover Lisa's anticipated college expenses with the smallest initial investment. (Let A= investment in year / into investment A in thousands of dollars, B/. = investment in year j into investment B in thousands of dollars, C/. = investment in year j into investment C in thousands of dollars, and Di = investment in year j into investment D in thousands of dollars.) (a) Formulate an LP model for this problem to find the smallest initial investment (in thousands of dollars). MIN: Subject to: Cash Flow Year 2 Cash Flow Year 3 Cash Flow Year 4 Cash Flow Year 5 Cash Flow Year 6 Cash Flow Year 7 Cash Flow Year 8 Cash Flow Year 9 Aj B;, C, D;2 0 [[@ Release x U NNTo VR =T /R NATeIVE: P U OTe 1T T S o)1 -1 1 Y S @ Francoi= X (@ ChatGP x Home|! X @ PeopleS X [T R * Course' X =+ & (e webassign.net/web/Student/Assignment-Responses/last?dep=35755919#question5120703_2 Vi LT LT ) Finish update : Text Blaze Dashbo... Text Blaze Diction... 2 Meet - vea-xbsm-... A live boosts - Goog... KoV Cash Card - Overv... = #cco-cs-escalatio... = Empathy Library!... b 3 All Bookmarks The Merrits want to determine an investment plan that will provide the necessary funds to cover Lisa's anticipated college expenses with the smallest initial investment. (Let A; = investment in year / into investment A in thousands of dollars, B; = investment in year i into investment B in thousands of dollars, C; = investment in year i into investment C in thousands of dollars, and D; = investment in year / into investment D in thousands of dollars.) (a) Formulate an LP model for this problem to find the smallest initial investment (in thousands of dollars). MIN: Subject to: Cash Flow Year 2 Cash Flow Year 3 Cash Flow Year 4 Cash Flow Year 5 Cash Flow Year 6 Cash Flow Year 7 Cash Flow Year 8 Cash Flow Year 9 A, B, CyD;20 (b) Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution? (Round your answers to three decimal places.) A A A A 3 =([ ) Need Help Read It Viewing Saved Work Revert to Last Response Submit