Linear programming:

The Faculty Cooperative has P250,000 available to invest in a 12-month commitment. The money can be placed in Treasury notes yielding an 8% return or in municipal bonds at an average rate of return of 9%. Cooperatives regulations require diversification to the extent that at least 50% of the investment be placed in Treasury notes. Because of restrictions of Bureau of Internal Revenue, it is decided that no more than 40% of the investment be placed in bonds.

Use the following methods:

a) Excel Solver

b) Excel QM