You are an investor and have $$77,000$ to divide among several investments. The investments are all evaluated after one year. Alternative investments are

$$ Municipal Bonds with an $8\mathrm{.}5\%$ annual return,

$$ Certificates of Deposit $($CD$)$ with a $5\%$ return,

$$ Treasury Bills with a $6\mathrm{.}5\%$ return,

$$ and a Growth Stock Fund with a $13\%$ annual return.

The following guidelines must be established:

$1.$ All $$77,000$ should be invested.

$2.$ No more than $20\%$ of the total investment is in municipal bonds.

$3.$ Investment in CDs should not exceed the other three alternatives together.

$4.$ At least $30\%$ of the total investment is in municipal bonds and CDs

$5.$ The total invested in CDs and treasury bills should be at least $1\mathrm{.}2$ times of the total in municipal bonds and growth stocks.

How much to invest in each investment to maximize the annual return?

Setup and solve the problem in the adjacent $("$Solver Solution Q$1")$ worksheet, generate the answer and sensitivity reports, then answer the questions given on the first worksheet.