The teenage daughter of a recently deceased movie star inherited a number of items from her famous father’s estate. Rather than convert these assets to cash immediately, her financial advisor has recommended that she let some of these assets appreciate in value before disposing of them. An appraiser has given the following estimates of the assets’ worth (in $1,000s) for each of the next five years.

Knowing this teenager’s propensity to spend money, her financial advisor would like to develop a plan to dispose of these assets that will maximize the amount of money received and ensure that at least $30,000 of new funds become available each year to pay her college tuition.
a. Formulate an ILP model for this problem.
b. Create a spreadsheet model for this problem and solve it.
c. What is the optimalsolution?

Transcribed Image Text:

Year 1Year a3Yar4Year 5 Car Piano Necklace Desk Golf Clubs 40 Humidor $ 35 $ 16 $125 $ 25 $ 37 $17 18 $130 $27 29 $ 43 $ 39 $136 46 $ 42 $ 19 $139 $ 30 S 50 $ 45 $ 20 $144 $ 33 S 52 $5 $7 8 1 11