Variable Cells

Cell

$B$$18$

$C$$18$

$D$$18$

$E$$18$

Name

Necklace

Bracelet

Ring

Earrings

Final

Value

$8$

Reduced

Cost

$0$

Increase

$1$E$+30$

$0$

$17$

$33$

$-5$

$0$

$5$

$0$

Objective

Coefficient

$100$

$120$

$150$

$125$

$12\mathrm{.}5$

$25$

Allowable Allowable

Decrease

$12\mathrm{.}5$

$1$E$+30$

$25$

$5$

Constraints

Name

Space

$B$$26$

Cell

$B$$24$

$B$$25$ Time

Restriction

$1$

Restriction

Final

Value

$108$

$57$

Shadow

Price

$75$

$0$

Constraint

R$.$H$.$ Side

$108$

$120$

Allowable

Increase

$15\mathrm{.}75$

$1$E$+30$

Allowable

Decrease

$8$

$63$

$25$

$25$

$25$

$33$

$17$

$B$$27$

$2$

$50$

$-25$

$50$

$4$

$8\mathrm{.}5$