Question: I need help in this question. Please show me how to use solver table. Please I know how to use SOLVER but we need to
I need help in this question. Please show me how to use solver table. Please I know how to use SOLVER but we need to do this with SOLVER TABLE. so please show me all the steps and do it correctly and accurately. please show me all the solutions and steps.



A B D E J K M 1 2 Chandler Oil has 5000 barrels of crude oil 1, 10,000 barrels of crude oil 2, and 15000 barrels of crude oil 3 available. Chandler sells gasoline and heating oil. These products are produced by blending the three crude oils together. Each barrel of crude oil 1 has a quality level of 10, each barrel of crude oil 2 has a quality level of 7, and each barrel of crude oil 3 has a quality level of 2.5. Gasoline must have an average quality level of at least 8, whereas heating oil must have an average quality level of at least 5. Gasoline sells for $80 per barrel, and heating oil sells for $50 per barrel. In addition, if any barrels of the crude oils are leftover, they can be sold for $65, $55 and $25 per barrel, respectively. We assume that demand for heating oil and gasoline is unlimited, so that all of Chandler's production can be sold. Please answer the following questions - 4 5 6 7 8 9 a.) Chandler wants to maximize its revenue from selling gasoline, heating oil, and any leftover crude oils. Use Solver to help him. b.) Using SolverTable to conduct a sensitivity analysis, find out how the quality level of crude oil 3 affect the total revenue and sales of gasoline and heating oil respectively. Assume the quality level of crude oil 3 to be 2, 2.5, 3, 3.5, 4, 4.5, 5, 5.5, and 6. 10 12 c D E F G H 1 J K Quality level 10 7 2.5 . B 13 14 oil blending model 15 16 Properties of crude oil inputs Value per barrel 17 Crude oil 1 $65 18 Crude oil 2 $55 19 Crude oil 3 $25 20 21 Properties of outputs Gasoline 22 Selling price per barrel $80 23 Required quality level 8 24 25 Blending plan (barrels of crude in each output) 26 Gasoline 27 Crude oil 1 28 Crude oil 2 29 Crude oil 3 30 Barrels sold 31 Heating oil $50 5 Heating oil Used Available Leftover 5000 10000 15000 Heating oil Used Available Leftover 5000 10000 15000