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

question 45

Multiple Choice

Variable cells
$$\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
$\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 3 in the objective function changes to $30, then the objective function value:

• A) will increase by $70.
• B) is $0.
• C) will increase by $30.
• D) will remain the same.
• E) will increase by an unknown amount.

---

Definitions:

Douglas Conant

An American business executive known for his leadership roles at various companies, including as CEO of Campbell Soup Company.

10-Year Plan

A strategic framework set for a decade, outlining long-term goals, strategies, and milestones for future operations.

Campbell Soup Co.

An American processed food and snack company known for its iconic canned soups and related products.

Zone of Indifference

A concept in organizational behavior referring to the range of authoritative requests that an employee is willing to accept without critical assessment.