Figure 8.15 Sensitivity Report for the Investment Advisors Problem Variable Cells Model Variable Name Final Value Reduced Cost U U.S. Oil 800.000 0.000 H Huber 1200.000 0.000 Constraints Constraint Number Name Final Value Shadow Price 1 Funds available 80000.000 0.093 2 Risk maximum 700.000 1.333 4 U.S. Oil maximum 800.000 0.000 Refer to Figure 8.15, which shows the sensitivity report for Problem 7. How much would the return for U.S. Oil have to increase before it would be beneficial to increase the investment in this stock? How much would the return for Huber Steel have to decrease before it would be beneficial to reduce the investment in this stock? How much would the total annual return be reduced if the U.S. Oil maximum were reduced to 900 shares?
Figure 8.15 Sensitivity Report for the Investment Advisors Problem Variable Cells Model Variable Name Final Value Reduced Cost U U.S. Oil 800.000 0.000 H Huber 1200.000 0.000 Constraints Constraint Number Name Final Value Shadow Price 1 Funds available 80000.000 0.093 2 Risk maximum 700.000 1.333 4 U.S. Oil maximum 800.000 0.000 Refer to Figure 8.15, which shows the sensitivity report for Problem 7. How much would the return for U.S. Oil have to increase before it would be beneficial to increase the investment in this stock? How much would the return for Huber Steel have to decrease before it would be beneficial to reduce the investment in this stock? How much would the total annual return be reduced if the U.S. Oil maximum were reduced to 900 shares?
Principles of Information Systems (MindTap Course List)
12th Edition
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter12: Systems Development: Investigation, Analysis, And Design
Section: Chapter Questions
Problem 12SAT: Data modeling is most often accomplished through the use of a(n) __________________. a....
Related questions
Question
Figure 8.15 Sensitivity Report for the Investment Advisors Problem
Variable Cells
|
Model Variable |
Name |
Final Value |
Reduced Cost |
|
U |
U.S. Oil |
800.000 |
0.000 |
|
H |
Huber |
1200.000 |
0.000 |
Constraints
|
Constraint Number |
Name |
Final Value |
Shadow Price |
|
1 |
Funds available |
80000.000 |
0.093 |
|
2 |
Risk maximum |
700.000 |
1.333 |
|
4 |
U.S. Oil maximum |
800.000 |
0.000 |
- Refer to Figure 8.15, which shows the sensitivity report for Problem 7.
- How much would the return for U.S. Oil have to increase before it would be beneficial to increase the investment in this stock?
- How much would the return for Huber Steel have to decrease before it would be beneficial to reduce the investment in this stock?
- How much would the total annual return be reduced if the U.S. Oil maximum were reduced to 900 shares?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage