MGMT $430$ Week $2$ Discussion $3$

A B C D E F

$1$

$2$ Input Information

$3$ Variable $1$ Variable $2$ Used $($type$)$ Available

$4$ Constraint $12540\mathrm{.}0<=40$

$5$ Constraint $23130\mathrm{.}0<=30$

$6$ Constraint $31113\mathrm{.}1>=12$

$7$

$8$ Profit per Unit $54$

$9$

$10$ Output Information

$11$ Variables $8\mathrm{.}54\mathrm{.}6$

$12$ Total Profit $42\mathrm{.}318\mathrm{.}5$ Total Profit $=60\mathrm{.}8$

A What is the cell formula for B$12$ in the Excel model?

B What is the cell formula for C$12$ in the Excel model?

C What is the cell formula for E$12$ in the Excel model?

D What is the cell formula for D$4$ in the Excel model?

E What is the cell formula for D$5$ in the Excel model?

F What is the cell formula for D$6$ in the Excel model?

G What is the optimal value for x$1$ in the Excel model?

H What is the optimal value for x$2$ in the Excel model?

I What does the value of cell F$4$ represent in the Excel model?

J What does the value of cell B$5$ represent in the Excel model?

K What is the cell C$7$ represent on the sensitivity report?

L What is the cell C$8$ represent on the sensitivity report?

M What is the cell E$7$ represent on the sensitivity report?

N What is the cell E$8$ represent on the sensitivity report?

O What is the cell F$8$ represent on the sensitivity report?

P What is the cell G$7$ represent on the sensitivity report?

Q What is the cell D$13$ represent on the sensitivity report?

R What is the cell D$15$ represent on the sensitivity report?

S What is the cell F$14$ represent on the sensitivity report?

T What is the cell G$15$ represent on the sensitivity report?