Answered step by step
Verified Expert Solution
Question
1 Approved Answer
World Oil Company can buy two types of crude oil: light oil at a cost of $25 per barrel, and heavy oil at $22 per
World Oil Company can buy two types of crude oil: light oil at a cost of $25 per barrel, and heavy oil at $22 per barrel. Each barrel of crude oil, when refined, yields three products: gasoline, jet fuel, and kerosene. The following table indicates the quantities in barrels of gasoline, jet fuel, and kerosene produced per barrel of each type of crude oil: Gasoline Jet Fuel Kerosene Light Crude 0.45 0.18 0.30 Heavy Crude 0.35 0.36 0.20 The refinery has contracts to deliver 1,260,000 barrels of gasoline, 900,000 barrels of jet fuel, and 300,00 barrels of kerosene. Build a model and solve the problem using an Excel solver. What is the minimum cost of crude oil to satisfy the contracts? For World Oil, in the optimal solution, how many barrels of Kerosene in excess of the contracted amount is available for sale on the open market?
Step by Step Solution
★★★★★
3.37 Rating (163 Votes )
There are 3 Steps involved in it
Step: 1
To solve this problem using Excel Solver we can set up a linear programming model Lets define the decision variables as follows x barrels of light cru...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started