(20 marks) Answer the following questions using the sensitivity report shown below:

Report the optimal solution and the optimal value of the objective function. (6 marks)

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

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? (3 marks)

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 (5 marks)

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

		Final	shadow	constraint	allowable	allowable
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

Please answer asap