Examlex

Solved

Variable Cells Constraints If the Coefficient of Activity 2 in the Objective Function

question 65

Multiple Choice

Variable cells
 Cell  Name  Final  Value  Reduced  Cost  Objective  Coefficient  Allowable  Increase  Allowable  Decrease $B$6 Activity 1 04255001E+30425$C$6 Activity 2 27.50.0300500300$D$ Activity 3 02504001E+30250\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 { Coefficient }\end{array} & \begin{array}{c}\text { Allowable } \\\text { Increase }\end{array} & \begin{array}{c}\text { Allowable } \\\text { Decrease }\end{array} \\\hline \$ \mathrm{B} \$ 6 & \text { Activity 1 } & 0 & 425 & 500 & 1 \mathrm{E}+30 & 425 \\\hline \$ \mathrm{C} \$ 6 & \text { Activity 2 } & 27.5 & 0.0 & 300 & 500 & 300 \\\hline \$ \mathrm{D} \$ & \text { Activity 3 } & 0 & 250 & 400 & 1 \mathrm{E}+30 & 250 \\\hline\end{array}
Constraints
 Cell  Name  Final  Value  Shadow  Price  Constraint  R.H. Side  Allowable  Increase  Allowable  Decrease $E$2 Benefit A 110060501E+3C$E$3 Benefit B 110751101E+3046$E$4 Benefit C 137.508057.51E+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 { 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 { Benefit A } & 110 & 0 & 60 & 50 & 1 \mathrm{E}+3 \mathrm{C} \\\hline \$ \mathrm{E} \$ 3 & \text { Benefit B } & 110 & 75 & 110 & 1 \mathrm{E}+30 & 46 \\\hline \$\mathrm{E} \$ 4 & \text { Benefit C } & 137.5 & 0 & 80 & 57.5 & 1 \mathrm{E}+30 \\\hline\end{array}
If the coefficient of Activity 2 in the objective function changes to $100, then:


Definitions:

Unfavorable Effect

A situation or outcome in financial analysis or performance metrics where actual results are worse than planned or expected results.

Variances

Discrepancies between planned financial outcomes and the actual results, used in budgeting and accounting to analyze and control costs.

Quantity Variance

A variance that is computed by taking the difference between the actual quantity of the input used and the amount of the input that should have been used for the actual level of output and multiplying the result by the standard price of the input.

Standard Quantity

This refers to the predefined amount of materials or labor deemed necessary to produce a single unit of a product under normal operations.

Related Questions