Based on the following sensitivity report, what would be the change in the objective function value if the objective function for Product 2 increases to 17? Variable Cells Final Objective Allowable Allowable Cell Name Value Reduced Cost Coefficient Increase Decrease $B$2 Product 1 -2 13 6. 1E+30 $B$3 Product 2 175 11 $B$4 Product_3 -1.5 12 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell SH$9 Name Value Price R.H.Side Increase Decrease Resource A Resource 8 Resource C 100 1E+30 100 SH$10 SH$11 525 700 s00 1E+30 275 1.75 700 366.6666667 700 (Round your answer to the nearest whole number.) Change in the objective function value
Based on the following sensitivity report, what would be the change in the objective function value if the objective function for Product 2 increases to 17? Variable Cells Final Objective Allowable Allowable Cell Name Value Reduced Cost Coefficient Increase Decrease $B$2 Product 1 -2 13 6. 1E+30 $B$3 Product 2 175 11 $B$4 Product_3 -1.5 12 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell SH$9 Name Value Price R.H.Side Increase Decrease Resource A Resource 8 Resource C 100 1E+30 100 SH$10 SH$11 525 700 s00 1E+30 275 1.75 700 366.6666667 700 (Round your answer to the nearest whole number.) Change in the objective function value
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
Question
![ools
g Enabled: Chapter 5 What-If Analysis for Linear . 6
Saved
Based on the following sensitivity report, what would be the change in the objective function value if the objective function coefficient
for Product_2 increases to 17?
Variable Cells
se
Final
Objective
Coefficient
Cell
Allowable
Allowable
Name
Value
Reduced Cost
Increase
Decrease
$B$2
$B$3
$B$4
Product_1
Product 2
-2
13
6.
1E+30
175
11
6.
1
Product_3
-1.5
12
1E+30
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H.Side
Increase
Decrease
SH$9
SH$10
SH$11
Resource A
Resource B
Resource C
100
1E+30
100
525
800
1E+30
275
700
1.75
700
366.6666667
700
(Round your answer to the nearest whole number.)
Change in the objective function value
Mc
Graw
Hill
< Prev
3 of 5
Neg >](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc8244eec-2e21-42e7-b76b-91432fe1842b%2F82754f15-7bb7-4e13-9726-6fa863399e9a%2Fgk2f3lg_processed.jpeg&w=3840&q=75)
Transcribed Image Text:ools
g Enabled: Chapter 5 What-If Analysis for Linear . 6
Saved
Based on the following sensitivity report, what would be the change in the objective function value if the objective function coefficient
for Product_2 increases to 17?
Variable Cells
se
Final
Objective
Coefficient
Cell
Allowable
Allowable
Name
Value
Reduced Cost
Increase
Decrease
$B$2
$B$3
$B$4
Product_1
Product 2
-2
13
6.
1E+30
175
11
6.
1
Product_3
-1.5
12
1E+30
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H.Side
Increase
Decrease
SH$9
SH$10
SH$11
Resource A
Resource B
Resource C
100
1E+30
100
525
800
1E+30
275
700
1.75
700
366.6666667
700
(Round your answer to the nearest whole number.)
Change in the objective function value
Mc
Graw
Hill
< Prev
3 of 5
Neg >
![Is
g Enabled: Chapter 5 What-If Analysis for Linear . A
Saved
Help
Save & Ex
Based on the following sensitivity report, what would be the impact of changing the constraint right-hand side for Resource_A to 72
and, at the same time, changing the constraint right-hand side for Resource_C to 530?
Variable Cells
Final
Value
Objective
Coefficient
Allowable
Cell
Reduced Cost
Allowable
Name
Increase
Decrease
$B$2
$B$3
Product 1
Product_2
Product_3
-2
1E+30
175
7.
1E+30
$B$4
-1.5
6.
1.5
1E+30
Constraints
Final
Shadow
Price
Constraint
Allowable
Increase
Allowable
Cell
Name
Value
R.H.Side
Decrease
SH$9
Resource_A
100
1E+30
70
SH$10
SH$11
Resource B
525
800
1E+30
310
Resource C
700
1.75
700
260
140
Applying the 100% rule,
because the total change in the constraint right-hand sides
100%.
Mc
Graw
Hill
< Prav
4 of 5
Nax](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc8244eec-2e21-42e7-b76b-91432fe1842b%2F82754f15-7bb7-4e13-9726-6fa863399e9a%2Fj5kjywk_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Is
g Enabled: Chapter 5 What-If Analysis for Linear . A
Saved
Help
Save & Ex
Based on the following sensitivity report, what would be the impact of changing the constraint right-hand side for Resource_A to 72
and, at the same time, changing the constraint right-hand side for Resource_C to 530?
Variable Cells
Final
Value
Objective
Coefficient
Allowable
Cell
Reduced Cost
Allowable
Name
Increase
Decrease
$B$2
$B$3
Product 1
Product_2
Product_3
-2
1E+30
175
7.
1E+30
$B$4
-1.5
6.
1.5
1E+30
Constraints
Final
Shadow
Price
Constraint
Allowable
Increase
Allowable
Cell
Name
Value
R.H.Side
Decrease
SH$9
Resource_A
100
1E+30
70
SH$10
SH$11
Resource B
525
800
1E+30
310
Resource C
700
1.75
700
260
140
Applying the 100% rule,
because the total change in the constraint right-hand sides
100%.
Mc
Graw
Hill
< Prav
4 of 5
Nax
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.