Question: A refinery processes two crude oils that have the yields shown in the following table. Because of equipment and storage Limitations, production of gasoline, kerosene,

A refinery processes 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 limitations on the production of other products such as gas oils. The profit on processing crude No. 1 is $2.00/bbl, and on crude No. 2 it is $1.40/bbl. Find the optimum daily feed rates of the two crudes to this plant via linear programming using the ExcelSolver. Yields (Volume %) Maximum Crude Crude Allowable Production Rate (bbi/day) No. 1

Yields (Volume %) Maximum Crude Crude Allowable Production Rate (bbi/day) No. 1 No. 2 Gasoline 70 31 6,000 2,400 12,000 Kerosene Fuel oil 24 60

Step by Step Solution

★★★★★

3.26 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Let x be the daily feed rate of Crude No1 in bblday x be the daily feed rate of Crude No2 in bbld... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

38-E-C-E-P-C (315).docx

120 KBs Word File

Students Have Also Explored These Related Chemical Engineering Questions!

A refnery processes two crude oils that have the yields shown in the table below. Because of equipment and storage limitations, production of gasoline, kerosene, and fuel oil must be limited as shown...

The data shown in the following table were obtained from the 1990 Census. Included is information on 26 randomly selected Metropolitan Statistical Areas (MSAs). Of interest are factors that...

A government held the securities shown in the following table in one of its investment portfolios. All the securities are either stocks or bonds that mature in more than one year. 1. Ignoring...

Please help with all these questions 1. A refinery has available two crude oils that have the yields shown in the following table. Because of equipment and storage limitations, production of...

A rafinary has available two cruale oils that hove the gields shown in the following table. Because of equipment and storage limitations, production of gasoline, kerosene and fuel oil must be limited...

Refinery Optimization An oil refinery purchases two crude oils (crude 1 and crude 2). These crude oils are put through four processes: distillation, reforming, cracking, and blending, to produce...

1. You are working for an oil refinery and have been tasked with formulation of a mathematical model to determine the daily distilling and blending amounts so that profit is maximized, subject to the...

CASE STUDY OilCois an oil company building a refinery to produce four products: diesel, gasoline, lubricants, and jet fuel. The minimum demand in (bbl/day) for each of these products was estimated...

Problem 1. (Portfolio Allocation. Considering following four: an aggressive growth fund (Fund 1), an index fund (Fund 2), a corporate bond fund (Fund 3), and a money market fund (Fund 4), each with...

please identify the decision variables, objective function and constraints of the problem Gasoline-Blending Problem of Hexxon Oil Co. Another example of the use of a linear programming model is in...

List three problems that can occur because of careless construction of scales.

Why are control account balances reported in external financial statements while subsidiary account balances are not? Are subsidiary account balances useful to anyone? Who?

During an interview with an asset management company, you are asked to team up with another candidate to explain why arbitrary activities may not eliminate my mispricing. In the market period your...

Khan Borrows 20,000 from Zarak and promises to pay after two months. Draft a relevant note for giving payment. Also list down the essential elements of promissory note.

A thin metal plate is insulated on the back and exposed to solar radiation on the front surface. If solar radiation is incident on the plate at a rate of 450 W/m and the surrounding air temperature...

An aluminum pan whose thermal conductivity is 237 W/mC has a flat bottom whose diameter is 27 cm and thickness 0.64 cm. Heat is transferred steadily to boiling water in the pan through its bottom at...

Two particles are fixed on an x axis. Particle 1 of charge 59.0 C is located at x = -7.55 cm; particle 2 of charge Q is located at x = 31.4 cm. Particle 3 of charge magnitude 53.7 C is released from...

21. What organelle that holds water, food and waste materials? a. Cell Wall 22. This mode of reproduction in plants is possible when spores come out from the sporangium and carried by wind or water....

Suppose that we wish to study the possible galvanic corrosion between zinc and chromium, so we set up the following cell: What is the chemical reaction that takes place, and what is the standard free...

A round tubular column has outside and inside diameters of D and d, respectively, and a diametral ratio of K = d/D. Show that buckling will occur when the outside diameter is 64 Perl

For the conditions of Prob. 473, show that buckling according to the parabolic formula will occur when the outside diameter is D-2 Per Sy/2 1/2

Link 2, shown in the figure, is 1 in wide, has 1 2 -in-diameter bearings at the ends, and is cut from low-carbon steel bar stock having a minimum yield strength of 24 kpsi. The end-condition...

Debt and financial risk Tower Interiors has made the forecast of sales shown in the following table. Also given is the probability of each level of sales. Sales Probability $190,000 0.25 290,000 0.55...

QUESTION 1 Security A has an expected rate of return of 15.50% and a beta of 1.95.The riskfree rate is 2.25% and the market risk premium is 6%.What is the alpha of security A? Enter your answer...

For each of the following, compute the present value (Do not round intermediate calculations and round your final answers to 2 decimal places (e.g.. 32.16).)