Question Help v A business student has $3500 available from a summer job and has identified three potential stocks in which to invest. To find an optimal solution to maximize, the Excel add-in Solver was used The accompanying figure shows the Solver Sensitivity Report Using only the information in the Sensitivity Report, complete parts a through c A Click the icon to view the Solver Sensitivity Report 1 Solver Sensitivity Report a. How much would the retum on stock B have to increase in order for the optimal solution to invest full in that stock It would need to increase by at least $2 per share, which is the negative of the reduced cost. (Type an integer or a decimal. Do not round) A B 6 Variable Cells D H. 7. b. How much would the return on stock C have to increase in order to fully invest in that stock? Final Reduced Objective Coefficient Allowable Allowable 8 Cell Name Value Cost Increase Decrease It would need to increase by at least $ per share, which is the 9 SB$5 Shares Purchased A V of the 203.1111111 9 1E + 30 2.5 (Type an integer or a decimal. Do not round.) 10 $CS5 Shares Purchased B 0. 7 3. 1E + 30 1E 30 11 SD$5 Shares Purchased C 7. 11 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price RH Side 16 SAS 16 Capacity Used Increase Decrease 3500 0.666666667 3500 1E + 30 3500
Question Help v A business student has $3500 available from a summer job and has identified three potential stocks in which to invest. To find an optimal solution to maximize, the Excel add-in Solver was used The accompanying figure shows the Solver Sensitivity Report Using only the information in the Sensitivity Report, complete parts a through c A Click the icon to view the Solver Sensitivity Report 1 Solver Sensitivity Report a. How much would the retum on stock B have to increase in order for the optimal solution to invest full in that stock It would need to increase by at least $2 per share, which is the negative of the reduced cost. (Type an integer or a decimal. Do not round) A B 6 Variable Cells D H. 7. b. How much would the return on stock C have to increase in order to fully invest in that stock? Final Reduced Objective Coefficient Allowable Allowable 8 Cell Name Value Cost Increase Decrease It would need to increase by at least $ per share, which is the 9 SB$5 Shares Purchased A V of the 203.1111111 9 1E + 30 2.5 (Type an integer or a decimal. Do not round.) 10 $CS5 Shares Purchased B 0. 7 3. 1E + 30 1E 30 11 SD$5 Shares Purchased C 7. 11 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price RH Side 16 SAS 16 Capacity Used Increase Decrease 3500 0.666666667 3500 1E + 30 3500
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...
Related questions
Concept explainers
Breakeven Analysis
Break Even Analysis is a term used in business, cost accounting and economics. It refers to a point where the total cost incurred becomes equal to the total revenue earned. Break Even Analysis determines the number of units to be sold to earn the revenue required to cover the total costs. Total cost is a sum total of fixed and variable costs.
Process analysis
The term process analysis can be defined as breakdown of production process into different phases that converts inputs into output. A series of routine activities are incorporated using organizational resources with a view to achieve operational excellence.
Question
15.1-3 see picture to solve
Transcribed Image Text:Question Help v
A business student has $3500 available from a summer job and has identified three potential stocks in which to invest To find an optimal solution to maximize, the Excel add-in Solver was used. The accompanying figure shows the Solver
Sensitivity Report Using only the information in the Sensitivity Report, complete parts a through c.
A Click the icon to view the Solver Sensitivity Report.
Solver Sensitivity Report
a. How much would the return.on stock B have to increase in order for the optimal solution to invest full in that stock
It would need to increase by at least $ 2 per share, which is the negative of the reduced cost.
A
6 Variable Cells
D
H
(Type an integer or a decimal. Do not round.)
b. How much would the return on stock C have to increase in order to fully invest in that stock?
Final
Reduced
Allowable
Objective
Coefficient
Allowable
8
Cll
Name
Value
Cost
Increase
Decrease
It would need to increase by at least $ per share, which is the
9
SB$5
Shares Purchased A
203.1111111
9
1E+ 30
25
Vof the
10
$C$5
Shares Purchased B
(Type an integer or a decimal. Do not round.)
2
7
3.
1E• 30
11
SD$5
Shares Purchased C
-7
11
1E + 30
12
13 Constraints
14
Final
Shadow
Constraint
Allowable
Allowable
15
Cell
Name
Value
Price
RH Side
Increase
Decrease
16
SAS16 Capacity Used
3500 0.666666667
3500
1E+ 30
3500
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 2 steps
Knowledge Booster
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
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.