A refnery processes two crude oils that have the yields shown in the table below. Because of

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, 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,40