Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2 . ( 3 0 Points ) StampOil owns oil sands in Fort McMurray, Cold Lake, and Peace River. Theyalso have hired refining capacity
Question Points StampOil owns oil sands in Fort McMurray, Cold Lake, and Peace River. Theyalso have hired refining capacity from facilities located in Edmonton, Strathcona, and Burnaby. Theyhave contracted with customers located in Denver, Vancouver, and Sarnia for the refined oil. Supposethat existing pipelines connect each oil sand to each refinery and each refinery to each customer point.Edmonton and Strathcona refineries are also connected via a twoway pipeline, meaning that oil canflow in any direction desired. Tables below summarizes all relevant data. Based on the optimaldistribution plan, StampOil will rent pipeline capacity from the operators.Use the Minimum Cost Network template to solve the following problems.a Find the optimal distribution plan from the oil sands to the demand points. Tabulate and explainthe optimal distribution plan. From which pipelines should StampOil rent capacity? How muchprocessing capacity does StampOil need at the Edmonton refinery?b Modify your base model to accommodate a total processing capacity at each refinery. Assumethat Edmonton refinery has a processing capacity of barrels per day dedicated toStampOil. Tabulate and explain the new distribution plan. How is this different than the plan ofpart ac Now assume that CN can carry StampOils oil from any oil sands to any refinery for $ per barrels and from any refinery to any demand point for $ per barrels per day. Develop anew optimal distribution plan for StampOil if the demand at Denver increases to barrelsper day. Assume that each railcar can hold barrels of oil and CN can allocate up to railcarsto StampOil. Tabulate and explain the optimal solution. Ignore any capacity at Edmontonrefinery.T
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started