Suncor Energy manufactures three types of gasoline (gas 1, gas 2, and gas 3). All types...

Transcribed Image Text:

Suncor Energy manufactures three types of gasoline (gas 1, gas 2, and gas 3). All types of gasoline are produced from a type of crude oil that is limited by 6000 barrels per day. Each barrel of gas 1 needs 0.5 barrels of crude oil. Each barrel of gas 2 needs 0.8 barrels of crude oil, and each barrel of gas 3 needs 0.5 barrels of crude oil. The whole production process costs $45, $30 and $35 per barrel for gas 1, gas2 and gas 3. The demand for gas1, gas 2 and gas 3 is 3000, 2000 and 1000 barrels per day, respectively. Notwithstanding the higher demand for gas 1, to have a consistent production, the policy of the company is to produce gas 1 at not more than 70% of the total production and to produce gas 3 at at least 20% of the total production. Additionally, for each type of gasoline, the production should not exceed the demand. The sales prices per barrel for gas 1, gas 2 and gas 3 are $70, $60, $55. Formulate the linear program for this problem and solve it in Excel. Q1. How many constraints are there in your formulation (not including non-negativity)? Q2. What percentage of the output is gas 3 in the optimal solution? Q3. What is the company's total profit at the optimal solution? Q4. How many constraints are binding in the optimal solution? Q5. How many barrels of gas 2 are produced at the optimal solution? Suncor Energy manufactures three types of gasoline (gas 1, gas 2, and gas 3). All types of gasoline are produced from a type of crude oil that is limited by 6000 barrels per day. Each barrel of gas 1 needs 0.5 barrels of crude oil. Each barrel of gas 2 needs 0.8 barrels of crude oil, and each barrel of gas 3 needs 0.5 barrels of crude oil. The whole production process costs $45, $30 and $35 per barrel for gas 1, gas2 and gas 3. The demand for gas1, gas 2 and gas 3 is 3000, 2000 and 1000 barrels per day, respectively. Notwithstanding the higher demand for gas 1, to have a consistent production, the policy of the company is to produce gas 1 at not more than 70% of the total production and to produce gas 3 at at least 20% of the total production. Additionally, for each type of gasoline, the production should not exceed the demand. The sales prices per barrel for gas 1, gas 2 and gas 3 are $70, $60, $55. Formulate the linear program for this problem and solve it in Excel. Q1. How many constraints are there in your formulation (not including non-negativity)? Q2. What percentage of the output is gas 3 in the optimal solution? Q3. What is the company's total profit at the optimal solution? Q4. How many constraints are binding in the optimal solution? Q5. How many barrels of gas 2 are produced at the optimal solution?