Using excel solver, solve the following LP problem. x1= number of tables to be made x2= number of chairs to be made x3= number of TV-stands to be made Mincost(Z)=40x1+20x2+15x3 Subject to 7x1+3x2+2x338 Min wood 2x1+4x2+1x350 Min fiber x22 Min demand chairs x3=4 Exact TV stands x1,x2,x30 (Non-negativity constraint) Note that fractional values for the variables are acceptable. Use two decimal places to provide answers to questions 4 through 8 1. Generate Input Sheet 2. Answer report 5 marks 3. Sensitivity report 7.5 marks 7.5 marks Each of the following questions carries three marks 54=20 marks 4. What is the solution to the problem? 5. what is the reduced cost of tables? Calculate this value from the outputs. Show your calculation. What do you understand from this value? 6. What is the new cost if a table cost decreases by $5 and a chair by $5 ? Show all your steps and explanation 7. What is the new cost if you add two wood units and two fiber units? 8. What is the solution to the problem? \begin{tabular}{|l|rrr|r|r|} \hline & X1 tables 2 chairs 3 Tv & & \\ \hline Min & 0 & 11.5 & 4 & & \\ \hline wood & 40 & 20 & 15 & 290 & 38 \\ fiber & 7 & 3 & 2 & 42.5>= & 50 \\ chairs & 2 & 4 & 1 & 50>= & 2 \\ Tvstand & & 1 & & 11.5>= & 4 \\ \hline \end{tabular} Variahlo Colle Objective Cell (Min) Variable Cells