X$1$

X$2$

Q

$15$

$17$

Max

$412\mathrm{.}5$

Microsoft Excel $7\mathrm{.}0$ Sensitivity Report

Changing Cells

Final

Reduced

Objective

Allowable

Allowable

Name

Value

Cost

Coefficient

Increase

Decrease

Variables Variable $1$

$15$

$0$

$10$

$12\mathrm{.}5$

$2\mathrm{.}5$

Variables Variable $2$

$17$

$0$

$15$

$5$

$8\mathrm{.}33$

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Name

Value

Price

R$.$H$.$ Side

Increase

Decrease

constraint $1$ Used

$100$

$3\mathrm{.}13$

$100$

$60$

$46\mathrm{.}66$

constraint $2$ Used

$80$

$1\mathrm{.}25$

$80$

$70$

$30$

What is the optimal solution including the optimal value of the objective function?

a$.$

x$1=7\mathrm{.}6,$ x$2=6\mathrm{.}67,$ z $=412\mathrm{.}50$

b$.$

x$1=10,$ x$2=15,$ z $=412\mathrm{.}50$

c$.$

x$1=15,$ x$2=17,$ z $=412\mathrm{.}50$

d$.$

x$1=15,$ x$2=17,$ z $=160$