A refinery 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 %)
Crude No. 1 | Crude No. 2 | Maximum Allowable Production Rate (bbl/day) | |
Gasoline | 70 | 41 | 6,000 |
Kerosene | 6 | 9 | 2,400 |
Fuel oil | 24 | 50 | 12,000 |