Question: 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,
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 below. There are no plant limitations on the production of other products such as gas oils. The profit on processing crude No. 1 is $3.00/bbl, and on crude No. 2 it is $2.00/bbl. Find the optimum daily feed rates of the two crudes to this plant via linear programming using the Excel Solver.

Yields (Volume %) Maximum Crude Crude Allowable Production Rate (bbl/day) No. 1 No. 2 Gasoline 70 41 6,000 Kerosene 2,400 12,000 Fuel oil 24 50
Step by Step Solution
3.32 Rating (173 Votes )
There are 3 Steps involved in it
Let x 1 be the daily feed rate of Crude No1 in bblday ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1602_606321ef1b912_683266.pdf
180 KBs PDF File
1602_606321ef1b912_683266.docx
120 KBs Word File
