Michael has decided to invest $40,000 in three types of funds. Fund A has projected an annual return of 8 percent, Fund B has projected an annual return of 10 percent, and Fund C has projected an annual return of 9 percent. He has decided to invest no more than 30 percent of the total amount in Fund B and no more than 40 percent of the total amount in Fund C. (PLEASE SHOW ALL THE WORK IN AN EXCEL SHEET INCLUDING THE CONSTRAINTS)
(A) Formulate a linear programming model that can be used to determine the amount of investments Michael should allocate to each type of fund to maximize the total annual return.
(B) How much should be allocated to each type of fund? What is the total annual return? Provide solver screenshot.