1. A large bank is planning the allocation of available funds for the upcoming year. The bank makes four types of loans to its customers and also invests in risk-free securities to diversify and stabilize income. The various investments and their annual rates of return are outlined in the table below. $2,000,000 is available for investment for the upcoming year, and several restrictions exist that must be adhered to, including the following:
   • Furniture loans plus other secured loans may not exceed automobile loans
   • Other secured loans plus signature loans may not exceed the funds invested in risk-free securities
   • Risk-free securities may not exceed 30% of the total funds available for investment
   • Signature loans may not exceed 10% of the funds invested in all loans, including automobile, furniture, other secured, and signature loans.

Your goal is to create and solve a linear programming model in Excel in order to maximize total annual return.

Type	Annual Rate of Return (%)
Automobile	8
Furniture	10
Other Secured	11
Signature	12
Risk-free securities	9