please asnwer the question on an excel

or explain how to do that

thanks

DEFGH Stratford National Bank Short Term? Amount Invested Sond % Return yes, o no) Rating High Long 0 Noul Total Invested Total Available 50 $150,000 Short High Total: Total: Required $75,000 Required 50 at least at most Yes No Total: Required at least $75,000 $45,000 Total Retur Free Return 14 40% of Total Return SO 98 A banking officer at Stratford National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize annual return. The officer wants to invest at least 50% of the money in short term bonds and no more than 50% in high risk bonds. At least 30% of the funds should go intax-free investements, andat least 40% of the totalreturn shouldbetax free Create a linear programming modelto represet the problem using ExcelSolver. The decision variables are the amounts of money that should be investedineach bond The Objective Function is to maximize the total annual return in cell 012 To effectively solve thisproblem you will have to use the=SUMIF function in cells F10, H10, J10, andB13. Maturity Tax Free Annual Return HI Cover Sheetland VOORUS Vookup & Match Scatterolot Squared Investment Decision Ready