please show the formulas you use to solve this problem on your excel sheet

Problem 2 Problem 4.78@) - Oil Company (p. 204) Selling price per barrel Input Sulfur Density Viscosit Light gas oil Heavy gas oil Waxy distillate Atmospheric residue Vacuum residue OS t $69.50 $66.70 $56.40 $16.50 $10.40 0.83 0.88 0.92 0.97 1.50 40 26 30 65 48 1.0 2.2 2.8 4.1 5.0 Sola Upper limits Blending plan (1000s of barrels) Input Input used Light gas oil Heavy gas oil Waxy distillate Atmospheric residue Vacuum residue A A A A Availabl e 40 50 70 60 80 Constraints Actual Density Viscosity Sulfur Maximum Profit An oil company produces gasoline from five inputs. The cost, density, viscosity, and sulfur content, and the number of barrels available of each input are listed in the file P04 78.xlsx. Gasoline sells for $75 per barrel. Gasoline can have a density of at most 0.95 units per barrel, a viscosity of at most 35 units per barrel, and a sulfur content of at most 3.3 units per barrel. a. How can the company maximize its profit? Problem 2 Problem 4.78@) - Oil Company (p. 204) Selling price per barrel Input Sulfur Density Viscosit Light gas oil Heavy gas oil Waxy distillate Atmospheric residue Vacuum residue OS t $69.50 $66.70 $56.40 $16.50 $10.40 0.83 0.88 0.92 0.97 1.50 40 26 30 65 48 1.0 2.2 2.8 4.1 5.0 Sola Upper limits Blending plan (1000s of barrels) Input Input used Light gas oil Heavy gas oil Waxy distillate Atmospheric residue Vacuum residue A A A A Availabl e 40 50 70 60 80 Constraints Actual Density Viscosity Sulfur Maximum Profit An oil company produces gasoline from five inputs. The cost, density, viscosity, and sulfur content, and the number of barrels available of each input are listed in the file P04 78.xlsx. Gasoline sells for $75 per barrel. Gasoline can have a density of at most 0.95 units per barrel, a viscosity of at most 35 units per barrel, and a sulfur content of at most 3.3 units per barrel. a. How can the company maximize its profit