Computational

Question $12(10$ points$)$

Question $12$ options:

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

P$1$

Product $1$

$-$

$(19\mathrm{.}3)$

$200\mathrm{.}0$

$19\mathrm{.}3$

$1$E$+30$

P$2$

Product $2$

$157\mathrm{.}1$

$-$

$220\mathrm{.}0$

$33\mathrm{.}8$

$21\mathrm{.}7$

P$3$

Product $3$

$176\mathrm{.}2$

$-$

$210\mathrm{.}0$

$12\mathrm{.}2$

$33\mathrm{.}8$

P$4$

Prodcut $4$

$126\mathrm{.}2$

$-$

$275\mathrm{.}0$

$45\mathrm{.}0$

$18\mathrm{.}0$

P$5$

Product $5$

$290\mathrm{.}5$

$-$

$100\mathrm{.}0$

$81\mathrm{.}0$

$13\mathrm{.}5$

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R$.$H$.$ Side

Increase

Decrease

C $1$

Raw$1$

$700\mathrm{.}0$

$8\mathrm{.}6$

$700\mathrm{.}0$

$336\mathrm{.}4$

$11\mathrm{.}8$

C $2$

Raw$2$

$490\mathrm{.}5$

$-$

$500\mathrm{.}0$

$1$E$+30$

$9\mathrm{.}5$

C $3$

Raw$3$

$1,200\mathrm{.}0$

$77\mathrm{.}1$

$1,200\mathrm{.}0$

$9\mathrm{.}1$

$108\mathrm{.}8$

C $4$

Labor

$1,200\mathrm{.}0$

$18\mathrm{.}6$

$1,200\mathrm{.}0$

$50\mathrm{.}0$

$183\mathrm{.}3$

C $5$

Capacity

$750\mathrm{.}0$

$19\mathrm{.}3$

$750\mathrm{.}0$

$275\mathrm{.}0$

$16\mathrm{.}7$

Which resource would be worth most if we could obtain one more unit?

A$.$ Labor

B$.$ Raw $1$

C$.$ Raw $2$

D$.$ Raw $3$

E$.$ Capacity

enter capital letter

An additional unit Capacity is worth?

$1$ decimal place

Ten more units of Labor is worth?

$1$ decimal place

The objective function coefficient for product $2($P$2)$ could increase to a value of $\_\_\_\_\_\_$ without changing the solution quantities?

$1$ decimal places

Which constrint has slack?

A$.$ Labor

B$.$ Raw $1$

C$.$ Raw $2$

D$.$ Raw $3$

E$.$ Capacity

enter capital letter