Squamish Savings has $$40$ million available for investment. It wishes to invest over the next four months in such a way that it will maximize the total interest earned over the four$-$month period as well as have at least $$20$ million available at the start of the fifth month for a mall building venture in which it will be participating.

For now, Squamish wishes to invest only in $2-$month government bonds $($earning $2\mathrm{.}5\%$ over the $2-$month period$)$ and $3-$month construction loans $($earning $8\%$ over the $3-$month period$).$ Each of these is available each month for investment. Funds not invested in these two investments are liquid and earn $1\%$ per month when invested locally.

Formulate a linear program and then solve it in Excel, to help Squamish Savings determine how to invest over the next four months if at no time does it wish to have more than $$10$ million in either government bonds or construction loans.