Optimal solution will change using sensitivity analysis

Assignment Help Operation Management

Reference no: EM132178678

MSC 600 Quantitative Methods HW6Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client’s needs. For a new client, Innis has been authorized to invest up to $1.2 million in two investment funds: a stock fund and a money market fund. Each unit of the stock funds costs $50 and provides an annual rate of return of 10%; each unit of the money market funds costs $100 and provides an annual rate of return of 4%. The client wants to minimize risk subject to the requirement that the annual income from the investment be at least $60,000. According to Innis’s risk measurement system, each unit invested in the stock fund has a risk index of 8, and each unit invested in the money market fund has a risk index of 3; the higher risk index associated with the stock fund simply indicates that it is the riskier investment. Innis’s client also specifies that at least $300,000 be invested in the money market fund. Assuming that the company wants to minimize the total risk index for the portfolio (Let S=number of units purchased in the stock funds, M=number of units purchased in the money market fund), answer the following questions:1) What is the linear programming model for this problem?2) Find the optimal solution (the minimum total risk) and the sensitivity report using Excel’s solver. 3) How much annual income will this investment strategy will generate? 4) Suppose the client desires to maximize annual return. How should the funds be invested?5) Specify the objective coefficient ranges. 6) What is the rate of return for the portfolio?7) What is the shadow price for the funds available constraint?8) Suppose the risk index for the stock fund (the objective function coefficient for S) increases from its current value of 8 to 12. How does the optimal solution change, if at all? 9) Suppose the risk index for the money market fund (the objective function coefficient for M) increases from its current value of 3 to 3.5. How does the optimal solution change, if at all?10) Suppose the objective function coefficient for S increases to 12 and the objective function coefficient for M increases to 3.5. Can you determine how the optimal solution will change using the Sensitivity Analysis report?

Reference no: EM132178678

Questions Cloud

What are most important supply chain integration issues : What are the most important supply chain integration issues? Explain why these issues are important and how supply chains are integrated.

Define ethics and the role ethics play in negotiations : Define ethics and the role ethics play in negotiations. Why is it important to consider ethics during a negotiation process?

Operational relatedness and corporate relatedness : Firms which have successfully achieved both operational relatedness and corporate relatedness.

Employment laws that affect employee-employer relationship : What are the examples/areas of concern that employees take advanrage of employment laws that affect employee-employer relationship?

Optimal solution will change using sensitivity analysis : Can you determine how the optimal solution will change using the Sensitivity Analysis report?

Industry is facing-possible solutions to these challenges : Identify and discuss major strategic challenges the industry is facing and possible solutions to these challenges.

One on conditions of opportunity-one on carrying capacity : Create three statements: one on directionality, one on conditions of opportunity, and one on carrying capacity.

What is bounded awareness and bounded rationality : What is bounded awareness and bounded rationality? How has overconfidence limited the success of business goals for companies and individuals?

Challenges facing hospital human resources management : Briefly discuss some of the challenges facing hospital human resources management given the 24/7 availability of services.

User Account

All Pages