Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suncor Energy manufactures three types of gasoline (gas 1, gas 2, and gas 3). All types of gasoline are produced from a type of

image text in transcribed

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?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management

Authors: Chuck Williams

4th Edition

978-0324316797, 0324316798

More Books

Students also viewed these General Management questions