Question: Please show calculations and format in EXCEL with equations such as ; SUMPRODUCT and using SOLVER Thank you!! A bank is attempting to determine where

A bank is attempting to determine where its assets should be allocated in order to maximize its annual return. At present, $750,000 is available for investment in three types of mutual funds: A, B, and C. The annual rate of return on each type of fund is as follows: fund A, 15\%; fund B, 12%; fund C;13%. The bank's manager has placed the following restrictions on the bank's portfolio: - No more than 20% of the total amount invested may be in fund A. - The amount invested in fund B cannot exceed the amount invested in fund C. Determine the optimal allocation that maximizes the bank's annual return. Set this problem up in an Excel spreadsheet in a well-organized manner. Use formulae that rely on cell references. Clearly label your input parameters, decision variable (or changing cells), constraints (both left- and right-hand sides), and objective function. Use Solver within Excel to solve the
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
