Module B

Homework $27($Due at $11$:$59$pm on April $28$th$)$: Solve the formulation of Homework $26$ by using Excel solver.

Minimize cost $=7x+4Y+9Z$

Subject $to$:

$11x+16Y+7Z60$

$32x+12Y+23Z30$

$43x+24Z40$

$23Y+33Z20$

$x3$

$Y3$

$Z3$

all variables $0$

Subject to:

$11x+16Y+7Z60$

$32x+12Y+23Z30$

$43x+24Z40$

$23Y+33Z20$

$x3$

$Y3$

$Z3$

all variables $0$

Alternative Formulation:

Minimize cost $=0\mathrm{.}07x+0\mathrm{.}04Y+0\mathrm{.}09Z$

Subject to:

$0\mathrm{.}11x+0\mathrm{.}16Y+0\mathrm{.}07Z60$

$0\mathrm{.}32x+0\mathrm{.}12Y+0\mathrm{.}23Z30$

$0\mathrm{.}43x+0\mathrm{.}24Z40$

$0\mathrm{.}23Y+0\mathrm{.}33Z20$

$x300$

$Y300$

$Z300$

all variables $0$