How many decision variables does the problem have

Assignment Help Finance Basics

Reference no: EM132046837

Question: Porter Investments needs to develop an investment portfolio from the following list of possible investments:

Investments	Cost	Expected Return
A	15,000	1,700
B	17,000	1,850
C	8,500	1,400
D	10,000	1,500
E	13,500	1,750
F	13,000	1,650
G	9,000	1,500
H	9,500	1,700

The client can invest up to $100,000. The following conditions should be met: (1) If investment C is chosen, then investment D must also be part of the portfolio, (2) at least four investments should be chosen, (3) of investment A and B, exactly one of these investments should be included, (4) of investments F,G,H - exactly two of these should be included in the portfolio. What investments should be included in the portfolio? Remember the investments is either included or not - it cannot be partially included and multiples of the investment cannot be included. Formulate this as a binary linear program and solve in Excel. The objective should be to maximize total return.

a) How many decision variables does this problem have?

b) Not counting the non-negativity constraint - how many constraints does this problem have?

c) What is the total return for the portfolio?

d) Which investments should be included in the portfolio?

Reference no: EM132046837

Questions Cloud

Find the maximum torque in shaft b : The shaft B carries a flywheel of mass 30 kg. If the radius of gyration of the flywheel is 100 mm, find the maximum torque in shaft B

What are the portfolio expected return : A portfolio has two assets; A & B. Asset A has an expected return of 5% and a standard deviation of return of 2%. Asset B, on the other hand.

What is the maximum number of mosquitoes : How many centimeters of rain will produce the maximum number of mosquitoes? What is the maximum number of mosquitoes?

Relevant discount rate for the entire period : If the relevant discount rate for the entire period is 10%. What is the present value (pv) of this cash flow stream?

How many decision variables does the problem have : The client can invest up to $100,000. The following conditions should be met: (1) If investment C is chosen, then investment D must also be part.

Symmetrically distributed around the? mean : Between what two values of Z? (symmetrically distributed around the? mean) will 97.86?% of all possible Z values be? contained?

Perfectly predict future interest rates : When managing interest rate risk, the first method to handle would be to “perfectly predict future interest rates”.

What is the value of z : What is the value of Z if only 4?% of all possible Z values are? larger? The value of Z if only 4?% of all possible Z values are larger is.

Investments wants to sell the bill on secondary market : After 60 days of holding the bill, Luke-Warm Investments wants to sell the bill on the secondary market.

User Account

All Pages