You have $16,000 in your savings account and your income and expenses for the next twelve months are listed in the table below.

You would like to maintain at least $2,000 in the savings account at all times. You have identified four short-term investment opportunities as listed in the table below.

Formulate and solve a linear optimisation model that will help you maximize your cash balance at the end of the year.

(Solved with excel but please write to your constraints and the objective function.)

Month Expenses Income January $3,360.00 $3,400.00 February $2,900.00 $3,400.00 March $6,600.00 $3,400.00 April $2,750.00 $9,500.00 May $2,800.00 $3,400.00 June $6,800.00 $5,000.00 July $3,200.00 $4,600.00 August $3,600.00 $3,400.00 September $6,550.00 $3,400.00 October $2,800.00 $3,400.00 November $2,900.00 $3,400.00 December $6,650.00 $5,000.00 Investment Opportunity 1. three-month CD 2. six-month CD 3. 11-month CD 4. Savings account Yield 0.60% at maturity 1.42% at maturity 3.08% at maturity 0.0375% per month