Variable cells

Cell

Name

$B$$6$

Activity $1$

$C$$6$Multiple Choice

the original solution remains optimal.

None of the choices is correct.

the shadow price is valid.

the problem must be resolved to find the optimal solution.

the shadow price is not valid

Activity $2$

$D$$6$

Activity $3$

Constraints

Cell

$$E$$2$

SE$$3$

$E$$4$

Name

Benefit A

Benefit B

Benefit C

Final

Value

$0$

$27\mathrm{.}5$

$0$

Final

Value

$110$

$110$

$137\mathrm{.}5$

Reduced

Cost

$425$

$0\mathrm{.}0$

$250$

Shadow

Price

$0$

$75$

$0$

If the right$-$hand side of Resource C changes to $130,$ then:

Objective

Coefficient

$500$

$300$

$400$

Constraint R$.$H$.$

Side

$60$

$110$

$80$

Allowable

Increase

$1$E$+30$

$500$

$1$E$+30$

Allowable

Increase

$50$

$1$E$+30$

$57\mathrm{.}5$

Allowable

Decrease

$425$

$300$

$250$

Allowable

Decrease

$1$E$+30$

$46$

$1$E$+30$