Question: Figure shows the Solver sensitivity report for the investment scenario in Problem. Using only the information in the sensitivity report, answer the following questions.
a. How much would the return on stock A have to increase to invest fully in that stock?
b. How much would the return on stock C have to be to invest fully in that stock?
c. Explain the value of the shadow price for the total investment constraint. If the student could borrow $1,000 at 8% a year to increase her total investment, what would you recommend and why?
Problem: A business student has $2,500 available from a summer job and has identified three potential stocks in which to invest. The cost per share and expected return over the next 2 years is given in the table.
Stock A B C
Price/Share $25 $15 $30
Return/Share $8 $7 $11
a. Identify the decision variables, objective function, and constraints in simple verbal statements.
b. Mathematically formulate a linear optimization model.
