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 \fL____ _. . 2a) Dene shadow price and explain each shadow price in a sentence or two. 2b) What is the reduced cost of the bracelet? Show the calculations to get this reduced cost. 2c) If the objective coefcients of the necklace increase by l, bracelet increase by 1, and ear-stud increase by 1, what is the new prot? Show your calculations. 2d) If you add 3 units of gold and 2 units of platinum to the current stock, what is the new prot? 2e) What are the lower and upper limits of objective coefcients? ' 7 uestioll 3 5*7=35 marks _ gmefOur sells manually and mechanically processed lettuce. The xed cost of manual process ts 554000 and a variable cost of $3 per bag, while the mechanized process incurs a xed cost of $69750 and a variable cost of $2 per bag. The store sells a bag of lettuce for $10. Since the. manually processed bags are packaged in enviromnentally friendly bags, the government gives 0.50 per bag to Carrefour to encourage environmental sustainability. Mechanically processed lettuce needs non-recyclable plastic bags, violating the government initiative to remove non- recyclable plastic bags; therefore, Carrefour pays the government a penalty tax of 0.25 per bag of mechanically processed lettuce. . a) What is the breakeven volume for the manual process? Also, calculate the breakeven 1n dollars. . b) What is the breakeven volume for the mechanized process? Also, calculate the breakeven 1n dollars. . c) Which process will you select if the sales volume is 63000 bags? Provide respective prots. d) At what sales volume, prot of manually processed lettuce is more than the mechamcally processed by 10000 dollars? _ 8) Find the sales volumes such that i) the volume of the manual process 15 more than the mechanical process by 2000 ii) and the prot from manual process 15 more than the mechanical process by 28250