Integer, goal and nonlinear programming models (excel: Managerial decision modeling)
The questioned i need answered is :
Porter investments needs to develop an investment portfolio for Mrs. Singh from the following list of possible investments: (i will upload a chart of investments)
Mrs. Singh has a total of $60,000 to invest. the following conditions must be met: (1) if investment F is chosen, then investment G must also be part of the portfolio, (2) at least four investments should be chosen, and (3) of investment A and B, exactly one must be included. What stocks should be included in Mrs.Singhs portfolio.
along with that question i have an example question i already completed and i will give to you as something to work off of.
Example:
Stockbroker Susan has advised her client as shown in the following table (i will upload a chart for example problem too).... 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 lessr 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. Susan Drexler to maximize expected return. ( will upload answer for this as well)