(Blending & Refining LP optimization problem)
American Oil of Middle East has a refinery in Kuwait. This refinery has access to two types of crude oils that come from Wafra Field: Ratawi Crude and Eocene Crude. The daily availability for Ratawi Crude and Eocene Crude are 300,000 bbl per day and 200,000 bbl per day, respectively. The Ratawi Crude costs the company $15 per bbl, and the Eocene Crude costs $20 per bbl. The refinery distills the crude oils and produces two intermediate products naphtha and light oil. One bbl of Ratawi Crude yields 0.35 bbl of naphtha and 0.65 bbl of light oil, while one bbl of Eocene Crude yields 0.55 bbl of naphtha and 0.45 bbl of light oil. Naphtha and light oil are blended to produce the three final gasoline products: Regular gasoline has a blend ratio of 3:1 (naphtha to light oil), premium gasoline has a blend ratio of 2:1, and jet fuel has a blend ratio of 1:3. The revenues for regular gasoline, premium gasoline, and jet fuel is $45 per bbl, $65 per bbl, and $90 per bbl, respectively. The demand is 250,000 bbl per day for regular gasoline, 150,000 bbl per day for premium gasoline, and 90,000 bbl per day for jet fuel. If the production is not sufficient to cover the demand, the shortage must be made up from outside sources at an extra cost. This extra cost is $6 per bbl of regular gasoline, $9 per bbl of premium gasoline, and $15 per bbl of jet fuel. The refinery has to decide on the product mix.
Tasks:
1. Read the problem carefully and draw a picture representing the
product flow in the refinery
2. Identify the decision variable(s)
3. Set up the objective function for the quantity to be
optimized
4. Identify the constraints the solution must satisfy
5. Formulate the problem as a linear program.
6. Solve the problem using EXCEL solver.
7. Express the formulated linear program using LINGO sets.
8. Solve the problem using LINGO.
9. Discuss the implications of your solution on the product
mix.
10. What-if questions:
a. In your solution, which product has the highest shortage? And is it acceptable or not compared with the other products?
b. If the company cannot buy the shortage anymore and has to depend
only on their production capacity, adjust your LINGO code
accordingly and discuss the answer?
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
(Blending & Refining LP optimization problem) American Oil of Middle East has a refinery in Kuwait....
Question 2 A refinery processed two crude oils that have the yields shown in the following table. Because of equipment and storage limitations, production of gasoline, kerosene and fuel oil must be limited as shown below. There are no plant limitation on the production of the other products such as gas oils. The profit on processing Crude #1 is $26b1 and on Crude #2 is $1.4/bbl. Find the optimum daily feed rates of the two crudes to this plant via...
Question 2 A refinery processed two crude oils that have the yields shown in the following table. Because of equipment and storage limitations, production of gasoline, kerosene and fuel oil must be limited as shown below. There are no plant limitation on the production of the other products such as gas oils. The profit on processing Crude #1 is $26b1 and on Crude #2 is $1.4/bbl. Find the optimum daily feed rates of the two crudes to this plant via...
Problem 4 (15 Points) An oil refining company can purchase crude oil from 2 countries: Kuwait and Canada. One barrel of crude oil yields useable gasoline, jet fuel, and lubricant, in barrels, according to the following table (there is a 10% loss due to waste in the refining process): Product Yield (in barrels) Kuwait Canada 0.3 0.4 0.2 0.4 0.2 0.3 Gasoline Jet Fuel Lubricant Kuwait can offer up to 9000 barrels of crude oil at a cost of $20...
Process Some Products produced from Pprocess Refining a barrel of crude oil Gasoline, diesel fuel, gas, naphtha, kerosene Distillation of coal Coke, gas Processing of mineral ore Gold, silver Processing of raw milk Cream milk, liquid milk, cheese Questions 1. The cost of refining a barrel of crude oil is $500 dollars per barrel. The company refines 4 barrels of crude oil and the result of this process leads to the production of gasoline and kerosene. Identify the amount of...
An oil company has to transport oil products from three sites (S1, S2, S3), through two refineries (R1, R2) and finally to three markets (C1, C2, C3). The supply(in 1,000 barrels per day) are given in Table 1. Table 1. (Site supply) Site Supply S1 1,500 S2 750 S3 1,200 Table 2 below shows the costs in $1,000 of transporting 1,000 barrels of crude oil between sites and refineries. It also has the costs of refining 1,000 barrels of crude...
Oil and fuel industry Malaysia’s energy security strategy has always been to export its premium Tapis sweet crude oil and import low-grade oil to refine in its downstream facilities. However, to move up the value chain, Malaysia is gearing up to increase its refining capacity to become a net oil product exporter. The Pengerang Integrated Petroleum Complex (PIPC) in Johor, and Sipitang Oil & Gas Industrial Park (SOGIP) in Sabah has been established to cater to this growth, almost doubling...
10. Write a one-page summary of the attached paper? INTRODUCTION Many problems can develop in activated sludge operation that adversely affect effluent quality with origins in the engineering, hydraulic and microbiological components of the process. The real "heart" of the activated sludge system is the development and maintenance of a mixed microbial culture (activated sludge) that treats wastewater and which can be managed. One definition of a wastewater treatment plant operator is a "bug farmer", one who controls the aeration...