Variable Cells Constraints What Is the Allowable Range for the Objective Function Coefficient

question 19

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 { 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
$\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}$
What is the allowable range for the objective function coefficient for Activity 3?

• A) 150 ? A3 ? ?
• B) 0 ? A3 ? 650
• C) 0 ? A3 ? 250
• D) 400 ? A3 ? ?
• E) 300 ? A3 ? 500

---

Definitions:

Hurdle Rate

The minimum rate of return on an investment that a manager or company requires before pursuing a project or investment.

Capital-Budgeting

The process by which organizations evaluate potential major projects or investments to determine their cost-effectiveness and alignment with business strategy.

Risk-Free Rate

The hypothetical yield of a risk-free investment, typically mirrored by the interest rate on sovereign debt.

IRR Method

The Internal Rate of Return method, a capital budgeting technique used to evaluate the profitability of an investment or project.