Does anyone know how to do B? Also need help with C

1. In your new community, you have decided to join the Home Owners Association in your neighborhood or Condominium Group. They realize that you have a business degree from URI and expertise in the field of inventing. You are elected President of their Investment Committee. 2. Your first chore is to invest $250,000 collected annually from various fees charged to the association members. You explain that it would be wise to invest part of this money into Treasury Notes yielding an 8% return on their money and the remainder in Municipal Bonds with an average rate of return of 9%. You explain that diversification is important and that at least 50% of the $250,000 should be invested in Treasury Notes but no more than 40% of the $250,000 invested in Municipal Bonds due to defaults in many municipalities. 3. Write and solve the linear program that will allow you to maximize the rates of return on your investments while meeting the stated constraints. E DATE: Friday, October 2 -n in: a. The handwritten linear program with the unknowns clearly identified b. The Excel physical sheet with your work and the answer report sheet (with the date and time stamp) C. Type a Memo explaining the solution to the committee, in your own words. Explain how much will be invested in each option and what the maximum total return of your investment will be 1. In your new community, you have decided to join the Home Owners Association in your neighborhood or Condominium Group. They realize that you have a business degree from URI and expertise in the field of inventing. You are elected President of their Investment Committee. 2. Your first chore is to invest $250,000 collected annually from various fees charged to the association members. You explain that it would be wise to invest part of this money into Treasury Notes yielding an 8% return on their money and the remainder in Municipal Bonds with an average rate of return of 9%. You explain that diversification is important and that at least 50% of the $250,000 should be invested in Treasury Notes but no more than 40% of the $250,000 invested in Municipal Bonds due to defaults in many municipalities. 3. Write and solve the linear program that will allow you to maximize the rates of return on your investments while meeting the stated constraints. E DATE: Friday, October 2 -n in: a. The handwritten linear program with the unknowns clearly identified b. The Excel physical sheet with your work and the answer report sheet (with the date and time stamp) C. Type a Memo explaining the solution to the committee, in your own words. Explain how much will be invested in each option and what the maximum total return of your investment will be