Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting for Decision Making and Control

Authors: Jerold Zimmerman

9th edition

125956455X, 978-1259564550

More Books

Students also viewed these Chemistry questions