Reference no: EM133641195
Case: An oil company has 4 drilling rigs to be used to manufacture 4 different types of products (asphalt, liquefied gas, sulfur, kerosene). It is known that the capacities of each rig are 50000L, 84000L, 16000L, 22000L respectively. The oil company has 4 orders of oil to manufacture the products, the needs correspond to: asphalt=35000L, liquefied gas=42000, sulfur=52000 and paraffin=43000L.
Data: Drilling rig 1: 50 dollars of asphalt, 60 dollars of liquefied gas, 90 dollars of sulfur and 130 dollars of kerosene.
Drilling rig 2: $30 asphalt, $20 liquefied gas, $140 sulfur and $70 kerosene.
Drilling rig 3: $180 of asphalt, $20 of liquefied gas, $20 of sulfur and $90 of kerosene.
Drilling rig 4: $90 of asphalt, $30 of liquefied gas, $110 of sulfur and $70 of kerosene.
You are requested to:
Question 1. a) Correctly assemble the supply and demand table according to the data provided.
Question 2. b) Determine the minimum distribution cost of the towers to manufacture the 4 types of product through Excel.