MY CONSTRAINTS ARE WRONG .CAN YOU HELP PLEASE . i need help with my constraints values only . PLEASE SO THE WORKINGS PLEASE , USE MY EXCEL FORMULA

A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual retum. The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free. 1. Formulate the LP model for this problem. 2. Create the spreadsheet model and use Solver to solve the problem. \begin{tabular}{|r|r|r|r|r|r|r|r|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c|}{ B } & \multicolumn{1}{c|}{ C } & \multicolumn{1}{c|}{ D } & \multicolumn{1}{c|}{ E } & & & \\ \hline 3750.000 & 33750.00 & 86250.00 & 0.00 & 26250.00 & & & \\ \hline 0.095 & 0.08 & 0.09 & 0.09 & 0.09 & 13181.25 & & \\ \hline & & & & & & & \\ \hline 1 & 1 & 1 & 1 & 1 & 150000 & = & 150000 \\ \hline 0 & 1 & 0 & 0 & 1 & 60000 & >= & 60000 \\ \hline 1 & 0 & 0 & 1 & 1 & 30000 & = & 37500 \\ \hline 0 & 0 & 0 & 0 & 0 & 13181.25 & >= & 5931.6 \\ \hline & & & & LHS & Sign & RHS \\ \hline & & & & & & \\ \hline \end{tabular} A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual retum. The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free. 1. Formulate the LP model for this problem. 2. Create the spreadsheet model and use Solver to solve the problem. \begin{tabular}{|r|r|r|r|r|r|r|r|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c|}{ B } & \multicolumn{1}{c|}{ C } & \multicolumn{1}{c|}{ D } & \multicolumn{1}{c|}{ E } & & & \\ \hline 3750.000 & 33750.00 & 86250.00 & 0.00 & 26250.00 & & & \\ \hline 0.095 & 0.08 & 0.09 & 0.09 & 0.09 & 13181.25 & & \\ \hline & & & & & & & \\ \hline 1 & 1 & 1 & 1 & 1 & 150000 & = & 150000 \\ \hline 0 & 1 & 0 & 0 & 1 & 60000 & >= & 60000 \\ \hline 1 & 0 & 0 & 1 & 1 & 30000 & = & 37500 \\ \hline 0 & 0 & 0 & 0 & 0 & 13181.25 & >= & 5931.6 \\ \hline & & & & LHS & Sign & RHS \\ \hline & & & & & & \\ \hline \end{tabular}