Solved

Variable Cells Constraints If the Coefficient for Activity 1 in the Objective Function

Question 28

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}
If the coefficient for Activity 1 in the objective function changes to $40, then the objective function value:


A) will increase by $77.80.
B) will increase by $23.
C) will increase by $30.
D) will remain the same.
E) can only be discovered by resolving the problem.

Correct Answer:

verifed

Verified

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

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents