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 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
Get Answers For Free
Most questions answered within 1 hours.