This problem has been solved!

Do you need an answer to a question different from the above? Ask your question!

# 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

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?

- Expert Answer

## To solve this problem using Excel Solver, we can set up a linear programming model. Let's define the decision variables as follows: x = barrels of lig View the full answer

**Related Book For**

## Accounting for Decision Making and Control

ISBN: 978-1259564550

9th edition

Authors: Jerold Zimmerman

Post a Question and Get Help

Cannot find your solution?

Post a FREE question now and get an answer within minutes*.

*Average response time.