Answer all the following questions Question 1 m\" Using Excel solver generate an answer and sensitivi re . xlumber of tables made W ports to the following problem. xz= number of chairs made x3= number of doors made Min cost (Z) = 40 x1 + 50 x2 + 40 x3 Subject to . 3x1 + 3x; + 2x3 .2 80 Fiber 4x1 + 2x2 + 2x3 S 74 wood 3:; 2 10 min Chair ' x1 S 10 max table x1,x2,x3 2 0 (Non-negativity constraint) a) Fill up the answer report. Note: you do not need to complete "Cell" and "Formula" and "Integer" columns 10 marks Objective Cell ( ) Cell Name Original Value Final Value I/ Variable Cells Cell Name Original Value Final Value Integer Constraints Cell Name Cell Value Formula Status Slack b\" Fill out the sensitivity report. NO\": you do not need to complete the \"Cell" column In place of 1E+30, you may put 00 10 marks Variable Cells Final Reduced Objective Mllowable Allowable Cell Name Value Cost Coefcient Increase Decrease Constraints Shadow Constraint Allowable Allowable Final Value R.H. Side Increase Decrease Price Cell Name