Excel Sensitivity Report:

Variable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

$B$$18$

Umbrellas Women

$8$

$0$

$4$

$5$

$3$

$C$$18$

Umbrellas Golf

$0$

$0$

$6$

$0\mathrm{.}5$

$10$

$D$$18$

Umbrellas Men

$15$

$0$

$5$

$2\mathrm{.}5$

$0\mathrm{.}5$

$E$$18$

Umbrellas Folding

$20$

$0$

$5$

$1$E$+30$

$0\mathrm{.}5$

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R$.$H$.$ Side

Increase

Decrease

$B$$24$

Space

$120$

$2$

$120$

$48$

$24$

$B$$25$

Racks

$18$

$0$

$54$

$1$E$+30$

$36$

$B$$26$

Demand

$72$

$1\mathrm{.}5$

$72$

$24$

$48$

$B$$27$

Restriction

$12$

$-2\mathrm{.}5$

$12$

$12$

$12$

How many women's umbrellas, should be stocked?

Group of answer choices

$12$

$4$

$8$

$5$