linear program and solve it using Excel Solver. How much should she invest in each security? Note: It is possible to purchase fractional shares.

$24.$ Cash Flow Management. A financial manager is managing a cash fund. His investment alternatives available are various certificates of deposit, also known as CDs$,$ as listed in the following table:

$\backslash$table$[[$Investment$,$Yield,Availability$],[1-$month CD$,0\mathrm{.}5\%,$Beginning of each month$],[3-$month CD$,1\mathrm{.}75\%,$Beginning of Months $1,2,3,4],[6-$month CD$,2\mathrm{.}3\%,$Beginning of Month $1]]$

DATAfile

However, he also must ensure that sufficient funds are available to pay company expenditures over the next six months. The following table lists the net expenditures $($in thousands of dollars$)$ that the manager is obligated to cover $($cash amounts in parenthesis indicate a net inflow of cash rather than outflow$).$

$\backslash$table$[[$Month$,$Net Expenditures $($$$1,000$s$)],[1,$$$45$