Integer goal and nonlinear programming models

Assignment Help Business Management

Reference no: EM13236137

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)

Reference no: EM13236137

Questions Cloud

Explain the proton responsible for the observed peak : Predict the proton NMR spectrum expected for CH3CHBrCH3. Indicate the proton responsible for the observed peak. Sketch the spectrum.

Was charmagne considering the strategic nature : Was Charmagne considering the strategic nature of human resource planning when she challenged Brian's "good news" forecast? Discuss.

Determine the equivalent annual cost of manufacture : Costs associated with the manufacture of "blah" are $73,000 per year. They found that by spending $16,000 now, the cost will go down to $58,000 next year and $52,000 in years 2 through 5.

Compute the energy difference : A 200 MHz proton NMR instrument is used to obtain a ^13C spectrum. calculate the energy difference that will develop between teh two spin states of the ^13C nuclei.

Integer goal and nonlinear programming models : Integer, goal and nonlinear programming models (excel: Managerial decision modeling)

Explain spectrum a methylene peak appeared at delta : In a proton nmr spectrum a methylene peak appeared at delta = 2.1 ppm when a simple 60 MHz spectrometer was used. At what frequency would this peak appear if the scale were instead given in Hertz

What is the marginal rate of substitution between a and b : Susie is at the grocery store buying milk. She has a choice between milk from Dairy A or milk from Dairy B. She doesn't actually care at all which dairy her milk comes from. (a) Draw a possible indifference curve for Susie between milks A and B.

Internal analysis and strategy map : Internal Analysis and Strategy Map

Why these are the most important internal factors : briefly describe Nike and then list the key internal factors you identified. Explain why these are the most important internal factors to consider when formulating strategy. Justify the weights you chose for each key internal factor.

User Account

All Pages