Fall $2023,$ MGMT$-$ECON $305$

HW $3$

Name:

#$1.$ Consider the following LP$.$ Implement it on Excel and answer the following questions:

Solve the following LP using Excel;

Maxz$=41+62+73+84$

s$.$t$.$

$\backslash$table$[[x1+,x2+,x3+,x4,=950,($constraint $1)],[,,x4,400,($constraint $2),],[21+,32+,43+,74,4,600,($constraint $3)],[31+,42+,53+,64,5,000,($constraint $4)]]$

$x1,x2,x3,x40$

$($a$)$ What is the optimal value?

$($b$)$ What is the optimal solution?

$($c$)$ Which constraints are binding?

$($d$)$ What is the optimal value and optimal solution is the RHS of constraint $1$ is increased by $10$ units?

$($e$)($d$)$ What is the optimal value and optimal solution is the RHS of constraint $2$ is decreased by $10$ units?

#$2.$ Consider the following LP$.$ Implement it on Excel and answer the following questions: Solve the following LP using Excel;