Fred and Sally 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 5 years from now. The Merrits estimate that her first year college expenses will amount to $12,000 and increase $2,000 per year during each of the remaining three years of her education. The following investments are available to the Merrits:

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.
a. Formulate an LP model for this problem.
b. Create a spreadsheet model for this problem and solve it using Solver.
c. What is the optimalsolution?

Transcribed Image Text:

Investment Available Matures Return at Maturity 6% 1490 18% 69% Every year 1,3, 5,7 1 year 2 years years years