rosoft Excel Sensitivity Report (Obtained Using Standard LP/Quadratic Engine) ple Cells Final Reduced Objective Allowabl Cell Name Value Cost Coefficient Increase SB$4 Quantity Made HyperLink 500 -43.66666667 53 43,666666 SC$4 Quantity Made FastLink 1000 48 SD$4 Quantity Made SpeedLink 1500 33 SE$4 Quantity Made MicroLink 2250 32
rosoft Excel Sensitivity Report (Obtained Using Standard LP/Quadratic Engine) ple Cells Final Reduced Objective Allowabl Cell Name Value Cost Coefficient Increase SB$4 Quantity Made HyperLink 500 -43.66666667 53 43,666666 SC$4 Quantity Made FastLink 1000 48 SD$4 Quantity Made SpeedLink 1500 33 SE$4 Quantity Made MicroLink 2250 32
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Transcribed Image Text:Based on the following sensitivity report, identify which constraints are binding.
Microsoft Excel Sensitivity Report (Obtained Using Standard LP/Quadratic Engine)
Adjustable Cells
Final
Reduced
Objective
Allowable
Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
$B$4 Quantity Made HyperLink
500 -43.66666667
53 43.66666667
1E+30
$C$4 Quantity Made FastLink
1000
48
16
1E+30
$D$4 Quantity Made SpeedLink
1500
33
15
1
$E$4 Quantity Made MicroLink
2250
32
15.272727273
$F$4 Quantity Made EtherLink
500 -9.666666667
38 9.666666667
1E+30
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
$G$13 PC Board (sq in) Used
60,500
80000
1E+30
19500
$G$14 Resistors Used
100,000
100000
10500
6000
$G$15 Memory chips Used
30,000
7.5
30000
2000 2333.333333
$G$16 Assembly Hours Used
3,688
5000
1E+30
1312.5
$G$17 Fast/Hyper>2 Used
16
500
875
O resistors and memory chips
O none
O PC boards
O assembly hours and resistors
Expert Solution
Step 1
From the above output, there are five constraints.
PcBoard(sq.in) used
Resistors Used
Memory chips used
Assembly hours used
Fast/Hyper>2 used
If the constraint is not binding then the shadow price of a constraint is equal to zero.
If the constraint is a binding constraint then the shadow price of a constraint is non-zero.
The non-binding constraints are :
PcBoard(sq.in) used
Resistors Used
Assembly hours used
Which has a 0 value in the shadow price.
Step by step
Solved in 2 steps
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman