Broker Shader. Stock broker Susan Shader has made the following recommendations to her client:

$\backslash$table$[[$Type of Investments,Cost $($$$),$Expected Return $($$$)],[$Hanover Municipal Bonds,$500,50],[$Hamilton City Bonds,$1000,100],[$S$.$E$.$ Power and Light, Co$.,350,30],[$Nebraska Electric Service,$490,45],[$Southern Gas and Electric,$700,65],[$Samuels Product Co$.,270,20],[$National Builder Paint Co$.,800,90],[$Hammer Head Hotels Co$.,400,35]]$

The client agrees to this list but provides several conditions:

no more than $$3,000$ can be invested

the money is to be spread among at least five investments

no more than one type of bond can be purchased, and

at least two utility stocks must be purchased

at least two regular stocks must be purchased

Formulate this as $0-1$ IP problem for Ms$.$ Shader to maximize expected return, Solve in excel.

Optimal Objective Function: If you do everything correct, you should get $285$ for the objective function.