Q2. What is the optimal solution and what is the value of the objective function? Show the relevant portion of the Solver's output. Fully interpret the results.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

can i get help with q2?

An investment company manages portfolios of stocks, bonds, and other investment alternatives.
One of the company's clients would like to invest $200,000 in stocks. The client is interested in
four specific stocks - A, B, C, and/or D. The company gathered the following relevant financial
data for the four stocks:
Stock A
Stock B
Stock C
Stock D
Price per share
Annual rate of
$100
$50
$80
$40
0.12
0.08
0.06
0.10
return
Risk measure
0.10
0.07
0.05
0.08
per dollar
invested
Based on the above data, the investor has stipulated the following investment guidelines:
1. The entire amount of $200,000 must be invested.
2. The annual rate of return must be at least 9% of the invested capital of $200,000.
3. Not every stock has to be purchased, however, if selected, no one stock can account for more
than 50% of the total dollar investment.
4. The total investment in stocks A and B combined must be equal to or greater than the total
investment in stocks C and D combined.
Q1. Build a linear programming model to develop an investment portfolio that minimizes total
risk under the above constraints.
a) Define the decision making variables.
b) Show the objective function.
c) Show the constraints.
Q2. What is the optimal solution and what is the value of the objective function? Show the
relevant portion of the Solver's output. Fully interpret the results.
Q3. What are the objective coefficient ranges for the four stocks? Show the relevant portion of
the Solver's output. Fully interpret these ranges.
Q4. Suppose the investor decides that the annual rate of return no longer has to be at least 9%
and agrees to at minimum level of 8%. What does the shadow price associated with this
constraint indicate about a possible change in total risk that could ocur from this lower rate of
return? Show the relevant portion of the Solver's output. Fully interpret the results.
Transcribed Image Text:An investment company manages portfolios of stocks, bonds, and other investment alternatives. One of the company's clients would like to invest $200,000 in stocks. The client is interested in four specific stocks - A, B, C, and/or D. The company gathered the following relevant financial data for the four stocks: Stock A Stock B Stock C Stock D Price per share Annual rate of $100 $50 $80 $40 0.12 0.08 0.06 0.10 return Risk measure 0.10 0.07 0.05 0.08 per dollar invested Based on the above data, the investor has stipulated the following investment guidelines: 1. The entire amount of $200,000 must be invested. 2. The annual rate of return must be at least 9% of the invested capital of $200,000. 3. Not every stock has to be purchased, however, if selected, no one stock can account for more than 50% of the total dollar investment. 4. The total investment in stocks A and B combined must be equal to or greater than the total investment in stocks C and D combined. Q1. Build a linear programming model to develop an investment portfolio that minimizes total risk under the above constraints. a) Define the decision making variables. b) Show the objective function. c) Show the constraints. Q2. What is the optimal solution and what is the value of the objective function? Show the relevant portion of the Solver's output. Fully interpret the results. Q3. What are the objective coefficient ranges for the four stocks? Show the relevant portion of the Solver's output. Fully interpret these ranges. Q4. Suppose the investor decides that the annual rate of return no longer has to be at least 9% and agrees to at minimum level of 8%. What does the shadow price associated with this constraint indicate about a possible change in total risk that could ocur from this lower rate of return? Show the relevant portion of the Solver's output. Fully interpret the results.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Introduction to Supply chain management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.