Solved

Variable Cells Constraints Which Parameter Is Most Sensitive to an Increase in Its

Question 31

Multiple Choice

Variable cells
 Cell  Name  Final  Value  Reduced  Cost  Objective  Codficient  Allowable  Increase  Allowuble  Decrease  $B$6  Activity 1 30302317 $C$6  Activity 2 60405010 $D$6  Activity 3 072071E+30\begin{array} { | r | r | r | r | r | r | r | } \hline \text { Cell } & \text { Name } & \begin{array} { c } \text { Final } \\\text { Value }\end{array} & \begin{array} { c } \text { Reduced } \\\text { Cost }\end{array} & \begin{array} { c } \text { Objective } \\\text { Codficient }\end{array} & \begin{array} { c } \text { Allowable } \\\text { Increase }\end{array} & \begin{array} { c } \text { Allowuble } \\\text { Decrease }\end{array} \\\hline \text { \$B\$6 } & \text { Activity 1 } & 3 & 0 & 30 & 23 & 17 \\\hline \text { \$C\$6 } & \text { Activity 2 } & 6 & 0 & 40 & 50 & 10 \\\hline \text { \$D\$6 } & \text { Activity 3 } & 0 & - 7 & 20 & 7 & 1 \mathrm { E } + 30 \\\hline\end{array}
Constraints
 Cell  Name  Final  Value  Shadow  Price  Constraint  R.H. Side  Allowable  Increase  Allowable  Decrease $E$2 Resource A 207.78201012.5$E$3 Resource B 306305010$E$4 Resource C 180401E+3022\begin{array}{|r|r|r|r|r|r|r|}\hline \text { Cell } & \text { Name } & \begin{array}{c}\text { Final } \\\text { Value }\end{array} & \begin{array}{c}\text { Shadow } \\\text { Price }\end{array} & \begin{array}{c}\text { Constraint } \\\text { R.H. Side }\end{array} & {\begin{array}{c}\text { Allowable } \\\text { Increase }\end{array}} & \begin{array}{c}\text { Allowable } \\\text { Decrease }\end{array} \\\hline \$ \mathrm{E} \$ 2 & \text { Resource A } & 20 & 7.78 & 20 & 10 & 12.5 \\\hline \$ \mathrm{E} \$ 3 & \text { Resource B } & 30 & 6 & 30 & 50 & 10 \\\hline \$ \mathrm{E} \$ 4 & \text { Resource C } & 18 & \mathrm{0} & 40 & 1 \mathrm{E}+30 & 22\\\hline\end{array}
Which parameter is most sensitive to an increase in its value?


A) The objective coefficient of Activity 1.
B) The objective coefficient of Activity 2.
C) The objective coefficient of Activity 3.
D) All of the choices are correct.
E) None of the choices is correct.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions