Considering the following excel sensitivity report: Variable Cells Cell $B$12 Product 1= $B$13 Product 2= $B$14 Product 3= $B$15 Product 4= Constraints Name Cell SH$6 Process 1 (hrs) Usage SH$7 Process 2 (hrs) Usage SH$8 Process 3 (hrs) Usage SH$9 Process 4 (hrs) Usage 8 09 Name O 13 O 14 Final Value O None of the above 0 30.64516129 0 12.09677419 Final Value 225.8064516 268.5483871 300 250 Reduced Objective Allowable Cost Coefficient Increase -1 0 -1 0 Shadow Constraint Price R.H. Side 0 0 10 12 11 13 0.5 1.5 600 500 1 46.5 1 6.2 Allowable Increase 1E+30 1E+30 150 300 250 281.372549 Which one of the following values of the second objective function coefficient (c₂) would generate a different optimal solution (remember: all of the other variables remain the same)? Allowable Decrease 1E+30 3.1 1E+30 1.291666667 Allowable Decrease 374.1935484 231.4516129 237.5 83.33333333
Considering the following excel sensitivity report: Variable Cells Cell $B$12 Product 1= $B$13 Product 2= $B$14 Product 3= $B$15 Product 4= Constraints Name Cell SH$6 Process 1 (hrs) Usage SH$7 Process 2 (hrs) Usage SH$8 Process 3 (hrs) Usage SH$9 Process 4 (hrs) Usage 8 09 Name O 13 O 14 Final Value O None of the above 0 30.64516129 0 12.09677419 Final Value 225.8064516 268.5483871 300 250 Reduced Objective Allowable Cost Coefficient Increase -1 0 -1 0 Shadow Constraint Price R.H. Side 0 0 10 12 11 13 0.5 1.5 600 500 1 46.5 1 6.2 Allowable Increase 1E+30 1E+30 150 300 250 281.372549 Which one of the following values of the second objective function coefficient (c₂) would generate a different optimal solution (remember: all of the other variables remain the same)? Allowable Decrease 1E+30 3.1 1E+30 1.291666667 Allowable Decrease 374.1935484 231.4516129 237.5 83.33333333
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
![Considering the following excel sensitivity report:
Variable Cells
Cell
$B$12 Product 1=
$B$13 Product 2=
$B$14 Product 3=
$B$15 Product 4=
Constraints
Name
Cell
SH$6 Process 1 (hrs) Usage
$HS7 Process 2 (hrs) Usage
SH$8 Process 3 (hrs) Usage
SH$9 Process 4 (hrs) Usage
O
8
O
9
Name
13
O 14
Final
Value
O None of the above
0
30.64516129
Final
Value
0
12.09677419
225.8064516
268.5483871
300
250
Reduced Objective
Cost Coefficient
-1
0
-1
0
Shadow Constraint
Price R.H. Side
0
0
10
12
11
13
0.5
1.5
Allowable
Increase
1
46.5
1
6.2
Allowable
Increase
1E+30
1E+30
150
Which one of the following values of the second objective function coefficient (c₂) would generate a different optimal
solution (remember: all of the other variables remain the same)?
600
500
300
250 281.372549
Allowable
Decrease
1E+30
3.1
1E+30
1.291666667
Allowable
Decrease
374.1935484
231.4516129
237.5
83.33333333](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe31eec36-93d9-4d07-bc7e-56350ebdf77f%2F79a360e8-f6fb-45fc-8fe0-8b0602a11f1c%2F29ejbbd_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Considering the following excel sensitivity report:
Variable Cells
Cell
$B$12 Product 1=
$B$13 Product 2=
$B$14 Product 3=
$B$15 Product 4=
Constraints
Name
Cell
SH$6 Process 1 (hrs) Usage
$HS7 Process 2 (hrs) Usage
SH$8 Process 3 (hrs) Usage
SH$9 Process 4 (hrs) Usage
O
8
O
9
Name
13
O 14
Final
Value
O None of the above
0
30.64516129
Final
Value
0
12.09677419
225.8064516
268.5483871
300
250
Reduced Objective
Cost Coefficient
-1
0
-1
0
Shadow Constraint
Price R.H. Side
0
0
10
12
11
13
0.5
1.5
Allowable
Increase
1
46.5
1
6.2
Allowable
Increase
1E+30
1E+30
150
Which one of the following values of the second objective function coefficient (c₂) would generate a different optimal
solution (remember: all of the other variables remain the same)?
600
500
300
250 281.372549
Allowable
Decrease
1E+30
3.1
1E+30
1.291666667
Allowable
Decrease
374.1935484
231.4516129
237.5
83.33333333
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 5 steps with 3 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.