Can I get the answer on paper and not excel?

6) Answer the following questions using the sensitivity report shown below: (20 min) a) Construct the objective function and calculate the optimal value of it. (4 marks) b) Report and interpret the reduced cost associated with variable "z". (5 marks) 0 4 5 2. 9 2 2 6 3 c) Explain what constraints are binding and which one(s) are non-binding? (4 marks) Variable Cells d) Assuming the "wood" to be sunk Final Reduced Objective Allowable Allowable cost, what is the total price for an Cell Name Value Cost Coefficient Increase Decrease additional 25 units of wood? (3 Type Ax 6 3 Type By 0 marks) Type Cz 0 -6.5 1E+30 Constraints e) If the coefficient of x changes to 7 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease and the coefficient of y changes to 4 10 32 32 20 1.5 Wood 110 2 Steel 2.5 40 simultaneously, will the optimal 1E+30 hours 3 15 solution remain unchanged? Explain 30 25 1 40 38 0 (10 marks)