Refer to the Sensitivity Report. Suppose the company has the opportunity to sell 500 feet of Sheet Metal for $3 more than they paid for it. Should they sell the Sheet Metal? Explain your reasoning. Changing Cells Cell Name $B$4 $C$4 $D$4 $E$4 Constraints Product 1 Product 2 Product 3 Product 4 Cell Name $G$8 Labor, Hours $G$9 Machine 1, Hours $G$10 Machine 2, Hours $G$11 Sheet Metal, Feet Final Reduced Objective Allowable Allowable Value Coefficient Increase Decrease 1E+30 0 58 0 27 Final Value 750 250 420 3,800 Cost -26 0 -8 0 Shadow Price 8 8 (0) 4 110 150 100 200 Constraint R.H. Side 750 250 500 3800 26 150 8 175 Allowable Allowable Increase Decrease 400 75 70 1E+30 32 100 300 300 50 80 780
Refer to the Sensitivity Report. Suppose the company has the opportunity to sell 500 feet of Sheet Metal for $3 more than they paid for it. Should they sell the Sheet Metal? Explain your reasoning. Changing Cells Cell Name $B$4 $C$4 $D$4 $E$4 Constraints Product 1 Product 2 Product 3 Product 4 Cell Name $G$8 Labor, Hours $G$9 Machine 1, Hours $G$10 Machine 2, Hours $G$11 Sheet Metal, Feet Final Reduced Objective Allowable Allowable Value Coefficient Increase Decrease 1E+30 0 58 0 27 Final Value 750 250 420 3,800 Cost -26 0 -8 0 Shadow Price 8 8 (0) 4 110 150 100 200 Constraint R.H. Side 750 250 500 3800 26 150 8 175 Allowable Allowable Increase Decrease 400 75 70 1E+30 32 100 300 300 50 80 780
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter14: Data Mining
Section14.2: Classification Methods
Problem 7P
Related questions
Question
solve question
![Refer to the Sensitivity Report. Suppose the
company has the opportunity to sell 500
feet of Sheet Metal for $3 more than they
paid for it. Should they sell the Sheet Metal?
Explain your reasoning.
Changing Cells
Final
Reduced
Objective Allowable Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
SB$4
Product 1
-26
110
26
IE+30
SC$4
Product 2
58
150
150
70
IE+30
32
SD$4
Product 3
-8
100
8
SE$4
Product 4
27
200
175
Constraints
Constraint Allowable Allowable
Final
Shadow
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
SG$8
Labor, Hours
750
8.
750
400
300
$G$9
Machine 1, Hours
250
8.
250
75
50
$G$10 Machine 2, Hours
420
500
100
80
$G$11
Sheet Metal, Feet
3,800
4
3800
300
780](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F48b6d298-bf82-4a83-97ad-03d8c4dc45d7%2Fcfa384c1-4d79-4d9d-af0c-579f05d79dc7%2Fp7esiwt_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Refer to the Sensitivity Report. Suppose the
company has the opportunity to sell 500
feet of Sheet Metal for $3 more than they
paid for it. Should they sell the Sheet Metal?
Explain your reasoning.
Changing Cells
Final
Reduced
Objective Allowable Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
SB$4
Product 1
-26
110
26
IE+30
SC$4
Product 2
58
150
150
70
IE+30
32
SD$4
Product 3
-8
100
8
SE$4
Product 4
27
200
175
Constraints
Constraint Allowable Allowable
Final
Shadow
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
SG$8
Labor, Hours
750
8.
750
400
300
$G$9
Machine 1, Hours
250
8.
250
75
50
$G$10 Machine 2, Hours
420
500
100
80
$G$11
Sheet Metal, Feet
3,800
4
3800
300
780
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.
Step by step
Solved in 2 steps
![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,
![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,