2. Solve Example 2.4-7 (Crude Oil Refining and Gasoline Blending) on pp43-46. a. First, show your LP model b. Solve the LP model using EXCEL. What is the optimal solution (i.e., xij ) and its corresponding objective value? c. Submit an Excel sheet with the formula (not just numbers, Excel has an option to print the formulas). You are welcome to search online if needed. Example 2.4-7 (Crude Oil Refining and Gasoline Blending) Shale Oil, located on the island of Aruba, has a capacity of 1,500,000 bbl of crude oil per day. The final products from the refinery include three types of unleaded gasoline with different octane numbers (ON) : regular with ON=87, premium with ON=89, and super with ON=92. The refining process encompasses three stages: (1) a distillation tower that produces feedstock (ON=82) at the rate of .2bbl per bbl of crude oil, (2) a cracker unit that produces gasoline stock (ON=98) by using a portion of the feedstock produced from the distillation tower at the rate of .5bbl per bbl of feedstock, and (3) a blender unit that blends the gasoline stock from the cracker unit and the feedstock from the distillation tower. The company estimates the net profit per barrel of the three types of gasoline to be $6.70, $7.20, and $8.10, respectively. The input capacity of the cracker unit is 200,000 bbl of feedstock a day. The demand limits for regular, premium, and super gasoline are 50,000, 30,000, and 40,000 bbl, respectively, per day. Develop a model for determining the optimum production schedule for the refinery