Clampett Oil purchases crude oil products from suppliers in Texas (TX), Oklahoma (OK), Pennsylvania (PA), and Alabama (AL), from which it refines four end-products: gasoline, kerosene, heating oil, and asphalt. Because of differences in the quality and chemical characteristics of the oil from the different suppliers, the amount of each end product that can be refined from a barrel of crude oil varies depending on the source of the crude. Additionally, the amount of crude available from each source varies, as does the cost of a barrel of crude from each supplier. These values are summarized below. For example, the first line of this table indicates that a barrel of crude oil from Texas can be refined into 2 barrels of gasoline, 2.8 barrels of kerosene, 1.7 barrels of heating oil, or 2.4 barrels of asphalt. Each supplier requires a minimum purchase of at least 500 barrels.

The company owns a tanker truck that picks up whatever crude oil it purchases. This truck can hold 2,000 barrels of crude. The cost of sending the truck to pick up oil from the various locations is shown in the column labeled “Trucking Cost.” The company’s plans for its next production cycle specify 750 barrels of gasoline, 800 barrels of kerosene, 1,000 barrels of heating oil, and 300 barrels of asphalt to be produced.
a. Formulate an ILP model that can be solved to determine the purchasing plan that will allow the company to implement its production plan at the least cost.
b. Implement this model in a spreadsheet and solve it.
c. What is the optimalsolution?

Transcribed Image Text:

Raw Material Characteristics Possible Production Per Barrel Crude Trucking Cost Barrels Cost Oils Available GasK TX OK PA AL Asphal Per Barrel 2.40 2,000 .80 2.301.75 1.90 2.60 2.40 $22 $21 $22 $23 1,5002.00 2.801.70 $1,500 $1,700 $1,500 $1,400 1,500 2.30 2.201.60 2.10 2.60 1.90