Question number 1. 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 Maximize Revenue (Z)=50x1+25x2+10x3 Subject to 7x1+3x2+2x328stockofwood2x1+3x2+1x340stockoffiberx13Mindemandfortablex27Maxdemandforchairsx1,x2,x30(Non-negativityconstraint) 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 TV stands? How do you compute this value from the outputs? Show your calculation. What is the significance of this value in the context of the business? 6. The shadow price of wood, (provide wood shadow price) is valid for an increase of up to units from the current value and decrease of up to units. 7. What is the new revenue if the revenue from a table increases by $3 and a chair decreases by S2? Show all your steps and explanation 8. What is the new revenue if the wood stock decreases to 24 from 28 and the fiber stock increases to 44 from 40 ? Show all your steps and explanation