Stockbroker Susan Drexler has advised her client as shown in the following table. The client agrees to

Question:

Stockbroker Susan Drexler has advised her client as shown in the following table.

The client agrees to this list but provides several conditions: (1) No more than $3,000,000 can be invested, (2) the money is to be spread among at least five investments, (3) no more than one type of bond can be purchased, (4) at least two utility stocks must be purchased, and (5) at least two regular stocks must be purchased. Formulate this as a 0-1 IP problem for Ms. Drexler to maximize expected return. Solve it by using Excel.

Stocks
Stocks or shares are generally equity instruments that provide the largest source of raising funds in any public or private listed company's. The instruments are issued on a stock exchange from where a large number of general public who are willing...