Problem 1 - Investment Over Time Jason Smith is a part-time business student who would like to optimize his financial decisions. Currently, he has $17,000 in his savings account. Based on an analysis of his take-home pay, expected bonuses, and anticipated tax refund, he has estimated his income for each month over the next year. In addition, he has estimated his monthly expenses, which vary because of scheduled payments for insurance utilities, tuition, books, etc. The following table summarizes his estimates: Month Income Expenses January $4,500 $4,600 February $4,500 $3,700 March $4,200 $6,600 April $11,500 $3,800 May $4,500 $4,800 June $7,000 $5,600 July $5,200 $4,100 August $5,400 $4,800 September $4,300 $4,400 October $4,700 $4,800 November $4,600 $3,700 December $6,200 $2,400 Jason has identified several short-term investment opportunities. There are no limits (minimums or maximums) on any of the short-term investments A three-month certificate of deposit (CD) yielding 0.50% at maturity. He can purchase a three- month CD in January, February, March, April, May, June, July, August, and/or September. A six-month certificate of deposit (CD) yielding 1.63% at maturity. He can purchase a six-month CD in January, February, March, April, May, and/or June. An eleven-month certificate of deposit (CD) yielding 4.12% at maturity. He can purchase an eleven-month CD in January. Any monies not invested in a CD will be invested in his savings account yielding 0.0446% per month. To ensure enough cash for emergencies, he would like to maintain at least $1,200 every month in the savings account. Assume that any money not invested in CDs will be invested in the savings account. Formulate as a linear program to maximize Jason's cash balance at the end of the year Enter your formulation into the template downloaded from Carmen and use Solver to find the optimum solution. Do not type in "O" for those coefficients that are zero; leave these cells blank