Use sensitivity report shown (20 marks)

Report the optimal solution and the optimal value of the objective function.

Calculate the amounts of slack/surplus and comment on what constraints are binding and which ones are non-binding

How much improvement in the objective function will we get if we increase the amount of Wood by 10 more units? How about 10 more units of steel?

Calculate the optimal value of the objective function (according to this sensitivity report) if the coefficient of x changes to 8 and the coefficient of y changes to 3 simultaneously. Show all the calculations

Variable cells

Final. Reduced Objective Allowable Allowable

Cell Name Value Cost Coefficient Increase Decrease

A x 5 0 6 3 4

B y 2 0 4 5 3

C z 0 -4.5 3 3.5 1E+30

Constraints

Cell Name Value Price R.H side Increase Decrease

Wood 1 32 3.5 32 20 6

Steel 2 30 0 40 15 10

Hours 3 15 2.5 15 10 5