Examlex

Solved

Variable Cells Constraints If the Coefficients of Activity 1 and Activity 2 in |

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 coefficients of Activity 1 and Activity 2 in the objective function are both increased by $10, then:


Definitions:

Total Compensation

The complete package of salary, benefits, bonuses, and any other form of remuneration given to an employee.

Exporting Industry

A sector of a country's economy that produces goods or services for sale abroad.

Imported Good

A product or service that is brought into one country from another and offered for sale.

Exported Good

A product manufactured in one country but shipped and sold abroad, contributing to a country's foreign trade balance.

Related Questions