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
icon
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
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
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,