Cell

$10$

$3\mathrm{.}5$

$11$

Final

Value

$50$

$25$

$0-1\mathrm{.}666666667$

Reduced

Cost

Objective

Coefficient

$16$

$171\mathrm{.}666666667$

Allowable

Increase

$130\mathrm{.}3333333332\mathrm{.}333333333$

$0\mathrm{.}4$

$1$E$+30$

Allowable

Decrease

$12$

$13$

$14$

$15$

Name

$16$

$17$

$0$

Increase

$1$E$+30$

$1$E$+30$

$18$

$0\mathrm{.}166666667$

$19$

$20$

$21$

Variable Cells

Name

SC$$3$ x$1$

SD$$3$ x$2$

SE$$3$ x$3$

Constraints

Cell

SF$$10$ Wire Used

SF$$11$ Nuts Used

SF$$12$ Bolts Used

SF$$13$ Motor Used

$F$$14$ Blades Used

Final

Value

$100$

$700$

$700$

$75$

$4002\mathrm{.}333333333$

Shadow

Price

Constraint Allowable

R$.$H$.$ Side

$500$

$700$

$700$

$200$

$400$

Allowable

Decrease

$400$

Consider the sensitivity report below and determine the objective function value?

$5$

$6$

$7$

$1$E$+30$

$37\mathrm{.}5$

$60$

$125$

$50$

$$1073$

$$1075$

$$1240$

$$1050$

$$1040$