Petrol 2 Petrol 3 5,600 1,000 ExxonMobil considers meeting its contractual obligations related to client demands for gasoline products to be a non-negotiable obligation. In addition to the associated purchase costs, it also costs $4 to process one barrel of crude oil into one barrel of finished gasoline product. ExxonMobil fears that their Beaumont Facility is operating at a point below optimal margin and is thus not achieving maximum profitability. Accordingly, ExxonMobil has hired you as a consultant to optimize the operations of the plant. In Question 21 and Question 22, you will complete optimization of ExxonMobil's Beaumont Facility operations. Hint 1: More octane content is good, and less octane content is less good. Less sulfur content is good, and more sulfur content is bad. Hint 2: As a consultant, it is important to understand who is paying for your services so that you know exactly which services you are expected to provide. In this case, you have been hired by the client ExxonMobil, which is a profit-driven company. Hint 3: You do not need to do anything special to obtain your initial guess values for this problem. You simply need to make a guess. Hint 4: Assume that no fuel inventory is retained. That is, assume that all fuel produced is immediately sold. Use the following prompt to Answer Questions 21 and 22 ExxonMobil's Beaumont, Texas facility manufactures 3 different types of finished gasoline product: petrol 1, petrol 2, and petrol 3. Each of gasolines is produced by blending 3 different types of crude oil in various combinations. The 3 types of finished gasoline product each differ in their octane rating and sulfur content. The sales price per barrel of finished gasoline blend, and the purchase piece per barrel of crude are provided in the following table: Gasoline Sale Price Purchase Price Crude Blend Petrol 1 [$/barrel] Type [$/barrel] $90.00 Crude 1 $85.00 Petrol 2 Petrol 3 $150.00 $110.00 Crude 2 $80.00 Crude 3 $77.00 The crude oil blended to form Petrol 1 must have an average octane rate of at least 10 pounds per finished barrel, and contain, at most, 1 pounds per finished barrel sulfur. The crude oil blended to form Petrol 2 must have an average octane rate of at least 8 pounds per finished barrel, and contain, at most, 2 pounds per finished barrel sulfur. The crude oil blended to form Petrol 3 must have an average octane rate of at least 6 pounds per finished barrel, and contain, at most, 1 pounds per finished barrel sulfur. The octane rating and sulfur content of each of the three types of crude oil are provided in the following table: Crude Octane Rating Sulfur Content Blend [lb/barrel] [lb/barrel] Crude 1 12 0.5 Crude 2 6 2.0 Crude 3 10 1.8 The ExxonMobil Beaumont Facility can purchase up to 6,500 barrels of each type of crude per day and produce up to 21,000 barrels total of finished gasoline product per day. The clients purchasing finished gasoline product from the Beaumont Facility hold contracts with Exxon Mobil that require the company provide them with following amounts of gasoline each day: Gasoline Blend Demand [barrels/day] Petrol 1 3,200 8

Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter3: Introduction To Linear Programming
Section3.4: A Diet Problem
Problem 2P
Question

Answer these on an excel spreadsheet a.  Identify and list all decision variables for this problem
b.  Identify and list all constraints for this problem
c. Identify and describe the goal that you are trying to achieve 

Petrol 2
Petrol 3
5,600
1,000
ExxonMobil considers meeting its contractual obligations related to client demands for
gasoline products to be a non-negotiable obligation. In addition to the associated
purchase costs, it also costs $4 to process one barrel of crude oil into one barrel of
finished gasoline product.
ExxonMobil fears that their Beaumont Facility is operating at a point below optimal margin
and is thus not achieving maximum profitability. Accordingly, ExxonMobil has hired you
as a consultant to optimize the operations of the plant. In Question 21 and Question 22,
you will complete optimization of ExxonMobil's Beaumont Facility operations.
Hint 1: More octane content is good, and less octane content is less good. Less sulfur
content is good, and more sulfur content is bad.
Hint 2: As a consultant, it is important to understand who is paying for your services so
that you know exactly which services you are expected to provide. In this case, you have
been hired by the client ExxonMobil, which is a profit-driven company.
Hint 3: You do not need to do anything special to obtain your initial guess values for this
problem. You simply need to make a guess.
Hint 4: Assume that no fuel inventory is retained. That is, assume that all fuel produced
is immediately sold.
Transcribed Image Text:Petrol 2 Petrol 3 5,600 1,000 ExxonMobil considers meeting its contractual obligations related to client demands for gasoline products to be a non-negotiable obligation. In addition to the associated purchase costs, it also costs $4 to process one barrel of crude oil into one barrel of finished gasoline product. ExxonMobil fears that their Beaumont Facility is operating at a point below optimal margin and is thus not achieving maximum profitability. Accordingly, ExxonMobil has hired you as a consultant to optimize the operations of the plant. In Question 21 and Question 22, you will complete optimization of ExxonMobil's Beaumont Facility operations. Hint 1: More octane content is good, and less octane content is less good. Less sulfur content is good, and more sulfur content is bad. Hint 2: As a consultant, it is important to understand who is paying for your services so that you know exactly which services you are expected to provide. In this case, you have been hired by the client ExxonMobil, which is a profit-driven company. Hint 3: You do not need to do anything special to obtain your initial guess values for this problem. You simply need to make a guess. Hint 4: Assume that no fuel inventory is retained. That is, assume that all fuel produced is immediately sold.
Use the following prompt to Answer Questions 21 and 22
ExxonMobil's Beaumont, Texas facility manufactures 3 different types of finished gasoline
product: petrol 1, petrol 2, and petrol 3. Each of gasolines is produced by blending 3
different types of crude oil in various combinations. The 3 types of finished gasoline
product each differ in their octane rating and sulfur content. The sales price per barrel of
finished gasoline blend, and the purchase piece per barrel of crude are provided in the
following table:
Gasoline Sale Price
Purchase Price
Crude
Blend
Petrol 1
[$/barrel]
Type
[$/barrel]
$90.00
Crude 1
$85.00
Petrol 2
Petrol 3 $150.00
$110.00
Crude 2
$80.00
Crude 3
$77.00
The crude oil blended to form Petrol 1 must have an average octane rate of at least 10
pounds per finished barrel, and contain, at most, 1 pounds per finished barrel sulfur. The
crude oil blended to form Petrol 2 must have an average octane rate of at least 8 pounds
per finished barrel, and contain, at most, 2 pounds per finished barrel sulfur. The crude
oil blended to form Petrol 3 must have an average octane rate of at least 6 pounds per
finished barrel, and contain, at most, 1 pounds per finished barrel sulfur. The octane
rating and sulfur content of each of the three types of crude oil are provided in the
following table:
Crude
Octane Rating Sulfur Content
Blend
[lb/barrel]
[lb/barrel]
Crude 1
12
0.5
Crude 2
6
2.0
Crude 3
10
1.8
The ExxonMobil Beaumont Facility can purchase up to 6,500 barrels of each type of
crude per day and produce up to 21,000 barrels total of finished gasoline product per
day. The clients purchasing finished gasoline product from the Beaumont Facility hold
contracts with Exxon Mobil that require the company provide them with following amounts
of gasoline each day:
Gasoline Blend
Demand
[barrels/day]
Petrol 1
3,200
8
Transcribed Image Text:Use the following prompt to Answer Questions 21 and 22 ExxonMobil's Beaumont, Texas facility manufactures 3 different types of finished gasoline product: petrol 1, petrol 2, and petrol 3. Each of gasolines is produced by blending 3 different types of crude oil in various combinations. The 3 types of finished gasoline product each differ in their octane rating and sulfur content. The sales price per barrel of finished gasoline blend, and the purchase piece per barrel of crude are provided in the following table: Gasoline Sale Price Purchase Price Crude Blend Petrol 1 [$/barrel] Type [$/barrel] $90.00 Crude 1 $85.00 Petrol 2 Petrol 3 $150.00 $110.00 Crude 2 $80.00 Crude 3 $77.00 The crude oil blended to form Petrol 1 must have an average octane rate of at least 10 pounds per finished barrel, and contain, at most, 1 pounds per finished barrel sulfur. The crude oil blended to form Petrol 2 must have an average octane rate of at least 8 pounds per finished barrel, and contain, at most, 2 pounds per finished barrel sulfur. The crude oil blended to form Petrol 3 must have an average octane rate of at least 6 pounds per finished barrel, and contain, at most, 1 pounds per finished barrel sulfur. The octane rating and sulfur content of each of the three types of crude oil are provided in the following table: Crude Octane Rating Sulfur Content Blend [lb/barrel] [lb/barrel] Crude 1 12 0.5 Crude 2 6 2.0 Crude 3 10 1.8 The ExxonMobil Beaumont Facility can purchase up to 6,500 barrels of each type of crude per day and produce up to 21,000 barrels total of finished gasoline product per day. The clients purchasing finished gasoline product from the Beaumont Facility hold contracts with Exxon Mobil that require the company provide them with following amounts of gasoline each day: Gasoline Blend Demand [barrels/day] Petrol 1 3,200 8
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage