Question

An oil refining company has refineries located in Edmonton, AB, Redwater, AB, and Scotford, AB. The...

An oil refining company has refineries located in Edmonton, AB, Redwater, AB, and Scotford, AB. The company produces three blends of gasoline: regular, midgrade, and premium.

  • The Edmonton refinery is the smallest of the three, and produces 20,000 barrels/day of premium gasoline, 40,000 barrels/day of midgrade, and 80,000 barrels/day of regular.
  • The Redwater refinery produces 60,000 barrels/day of each of premium and midgrade gasoline, along with 120,000 barrels/day of regular.
  • The Scotford refinery is the largest but does not produce any premium gasoline, only 100,000 barrels/day of midgrade and 210,000 barrels/day of regular.

The company is planning for some refinery maintenance, and needs to know how many days to run each refinery during the following month in order to meet its anticipated gasoline demand of 1,500,000 barrels of premium, 2,980,000 barrels of midgrade, and 6,060,000 barrels of regular. Determine how many days each refinery should run to produce enough gasoline to meet this exact level of demand. Use the Matrix Algebra template which has been provided, or create your own matrices within Excel. Note that in order to receive full marks, your solution must be provided in Excel, and must use Matrix Algebra calculations.

PLEASE COMPLETE IN EXCEL SHOWING EQUATIONS

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
An oil refining company has refineries located in Edmonton, AB, Redwater, AB, and Scotford, AB. The...
An oil refining company has refineries located in Edmonton, AB, Redwater, AB, and Scotford, AB. The company produces three blends of gasoline: regular, midgrade, and premium. The Edmonton refinery is the smallest of the three, and produces 20,000 barrels/day of premium gasoline, 40,000 barrels/day of midgrade, and 80,000 barrels/day of regular. The Redwater refinery produces 60,000 barrels/day of each of premium and midgrade gasoline, along with 120,000 barrels/day of regular. The Scotford refinery is the largest but does not produce...
An oil company operates two refineries in a certain city. Refinery I has an output of...
An oil company operates two refineries in a certain city. Refinery I has an output of 200, 100, and 100 barrels of low-, medium-, and high-grade oil per day, respectively. Refinery II has an output of 100, 200, and 600 barrels of low-, medium-, and high-grade oil per day, respectively. The company wishes to produce at least 1000, 1400, and 3000 barrels of low-, medium-, and high-grade oil to fill an order. If it costs $600/day to operate Refinery I...
MINIMIZATION APPLICATIONS 3) An oil company has two refineries. Each day, Refinery A produces 200 barrels...
MINIMIZATION APPLICATIONS 3) An oil company has two refineries. Each day, Refinery A produces 200 barrels of high-grade oil, 300 barrels of medium-grade oil, and 200 barrels of low-grade oil and costs $12,000 to operate. Each day, Refinery B produces 100 barrels of high-grade oil, 100 barrels of medium-grade oil, and 200 barrels of low-grade oil and costs $10,000 to operate. The company must produce at least 800 barrels of high-grade oil, 900 barrels of medium-grade oil, and 1,000 barrels...
Torrance Refinery produces approximately 20.3 Million barrels of gasoline per year. A California distributor sources its...
Torrance Refinery produces approximately 20.3 Million barrels of gasoline per year. A California distributor sources its gasoline from the Torrance refinery. The annual demand for gasoline at the California distributor is 10.5 Million barrels. The cost of storing gasoline is approximately $22 per barrel (per year). The cost of placing an order to the Torrance refinery (including shipping) is $7700 per order. Orders will be received gradually instead of delivered all at once (hence EPQ). a) At what quantity will...
The next three questions are based on the following information. The Low Knock Oil Company produces...
The next three questions are based on the following information. The Low Knock Oil Company produces two grades of cut-rate gasoline for industrial distribution. The grades, regular and economy, are produced by refining a blend of two types of crude oil, type X100 and type X220. Each crude oil differs not only in cost per barrel, but in composition as well. The following indicates the percentage of crucial ingredients found in each of the crude oils and the cost per...
You are employed to advise a petroleum company on the following problem: The company has three...
You are employed to advise a petroleum company on the following problem: The company has three oil plants A, B and C. They want to know how many barrels of crude oil each plant should produce to meet the market demand. Each plant can produce barrels of crude oil, and then convert the crude into motor oil, diesel oil, and gasoline. The capabilities of each of the plants are as follows: Plant A: From each barrel of crude oil, plant...
Oil supply You are employed to advise a petroleum company on the following problem: The company...
Oil supply You are employed to advise a petroleum company on the following problem: The company has three oil plants A, B and C. They want to know how many barrels of crude oil each plant should produce to meet the market demand. Each plant can produce barrels of crude oil, and then convert the crude into motor oil, diesel oil, and gasoline. From each barrel of crude oil, plant A can produce 20 gallons of motor oil, 10 gallons...
The Wearever Carpet Company manufactures two brands of carpets-shag and sculptured-in 100 yard lots. It requires...
The Wearever Carpet Company manufactures two brands of carpets-shag and sculptured-in 100 yard lots. It requires 8 hours to produce one lot o shag carpet and 6 hours to produce one lot of sculpture carpet. The company has the following production goals, in prioritized order: 1) Do Not underutilize production capacity, which is 480 hours. 2) Achieve product demand for shag is more important than meeting demand for sculptured, by a ration of 5 to 2. 3) Limit production overtime...
Intercontinental Chemical Company, located in Buenos Aires, Argentina, recently received an order for a product it...
Intercontinental Chemical Company, located in Buenos Aires, Argentina, recently received an order for a product it does not normally produce. Since the company has excess production capacity, management is considering accepting the order. In analyzing the decision, the assistant controller is compiling the relevant costs of producing the order. Production of the special order would require 8,900 kilograms of theolite. Intercontinental does not use theolite for its regular product, but the firm has 8,900 kilograms of the chemical on hand...
MySchool Notebook Company produces custom 3-ring binders with school logos for high schools in the Midwest....
MySchool Notebook Company produces custom 3-ring binders with school logos for high schools in the Midwest. They mold binders in four standard colors and then imprint the school’s logo on a to-order basis. The average daily demand for the base color notebooks is as follows: Green: 200 notebooks/day Blue: 255 notebooks/day Red: 185 notebooks/day Black: 525 notebooks/day MySchool can produce 1,620 notebooks per 24-hour day. It takes 8 hours to setup production for another color at a cost of $460....