Question

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.

Answer 1

SOLUTION:-

Excel Formula Used:

MINVERSE for Calculation of Inverse

MMULT for calculating A-1B

(Remember to press ctrl + shift when you press enter else value for entire matrix valueswont show up )

Summary:

Edmoton Refinery should be used for 24 days

Redwater Refinery should be used for 17 days

and Scotford should be used for 10 days th meet the demand.

THANK YOU, if any querise please leave your valuable comment on comment box....

If possible then rate the answer as well....