Question: Answer all the following questions Question 1 Using Excel solver generate an answer and sensitivity reports to the following problem. x1=number of tables made X2=


Answer all the following questions Question 1 Using Excel solver generate an answer and sensitivity reports to the following problem. x1=number of tables made X2= number of chairs made X3= number of doors made Min cost (Z) = 40 x1 + 50 x2 + 40 X3 Subject to 3x1 + 3x2 + 2x3 2 80 Fiber 4x1 + 2x2 + 2x3 5 74 wood X2 2 10 min Chair x1 5 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 10 marks "Integer" columns. Objective Cell ( Cell Name Original Value Final Value Variable Cells Cell Name Original Value Final Value Integer Constraints Slack Cell Name Cell Value Formula Status
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
