Please show all steps and use excel if needed. Formulare linear constraints for all parts as well.

17 Vehicle loans Consumer Loans 19 Other secured loans 10 11 Signature loans Risk-free securities 6 The firm will have $2,000,000 of funds available for investment during the coming year. The following restrictions apply: (A) All available funds must be invested: (B) Risk-free securities may not exceed 30% of the total funds, but must comprise at least 5% of the total; (C) Signature loans may not exceed 12% of the funds invested in all loans (vehicle, consumer, other secured loans, and signature loans) (D) Consumer loans plus other secured loans may not exceed the vehicle loans (E) Other secured loans plus signature loans may not exceed the funds invested in risk-free securities, Type of Investment Annual rate of return, (%) Vehicle loans 7 Consumer Loans 9 Other secured loans 10 Signature loans 11 Risk-free securities 16 The firm will have $2,000,000 of funds available for investment during the coming year. The following restrictions apply: (A) All available funds must be invested; (B) Risk-free securities may not exceed 30% of the total funds, but must comprise at least 5% of the total: (C) Signature loans may not exceed 12% of the funds invested in all loans (vehicle, consumer, other secure and signature loans) (D) Consumer loans plus other secured loans may not exceed the vehicle loans