Atrust officer at pond island bank needs to determine what percentage of the bank’s investable funds to place in each of following investments. the yield column represents each investment’s annual yield. the maturity column indicates the number of years funds must be placed in each investment. the risk column indicates an independent financial analyst’s assessment of each investment’s risk. in general, the trust officer wants to maximize the weighted average yield on the funds placed in these investments while minimizing the weighted average maturity and the weighted average risk. a. formulate an molp model for this problem and implement your model in a spreadsheet. determine the best possible value for each objective in the problem. round your answers to one decimal place, if necessary. objectives: yield % maturity risk