How many miles of pipeline arctic oil must install

Assignment Help Operation Management
Reference no: EM13251753

The Arctic Oil Company has recently drilled two new wells in a remote area of Alaska. The company is planning to install a pipeline to carry the oil from the two new wells to a transportation and refining (T&R) center. The locations of the oil wells and the T&R center are summarized in the following table. Assume a unit change in either coordinate represents 1 mile.
X Coordinate Y Coordinate
Oil Well 1 50 150
Oil Well 2 30 40
T&R Center 230 70

Installing the pipeline is a very expensive undertaking, and the company wants to minimize the amount of pipeline required. Because the shortest distance between two points is a straight line, one of the analysts assigned to the project believes that a separate pipe should be run from each well to the T&R Center. Another alternative is to run separate pipes from each well to some intermediate substation where the two lines are joined into a single pipeline that continues on to the T&R center. Arctic Oil's Management wants to determine which alternative is best. Furthermore, if using the intermediate substation is best, management wants to determine where this station should be located.

a. Create a spreadsheet model to determine how many miles of pipeline Arctic Oil must install if it runs separate pipelines from each oil well to the T&R center. How much pipe will be needed? Use Solver.

b.If Arctic Oil wants to build a substation, where should it be built? How much pipe is needed for this solution? Use Solver.

c. Which alternaive is best?

d. Suppose the substation cannot be built within a 10-mile radius of the coordinates X=80, Y=95. (Assume the pipeline can run through this area, but the substation cannot be built in this area.) What is the optimal location of the substation now, and how much pipe will be needed? Use Solver.

Reference no: EM13251753

What is the process specification

Studies on a bottle filling machine indicates it fill bottles to a mean of 16 ounces with a standard deviation of 0.10 ounces. What is the process specification, assuming th

Which one does a project manager have least control over

Which metric does a project manager have most control over: cost variance, schedule variance, cost performance index, and schedule performance index? Explain how so. Which o

Communicate the status of quality during a project

While cost and time are critical components of projects, how would you define the quality of a project? Provide some examples of project reporting metrics a project manager

What is the optiaml value for x

If we have a stochastic model with a= 3, 4, 5, or 6 as the possible values for the number of hours required per unit, what is the optiaml value for x? What problems does thi

What is the capacity of the assembly line per hour

DHP is a company that assembles and sells computers. Suppose DHP has only one sequential process to produce PCs. Under the current process layout, each step has one worker a

Draw the context diagram and level-0 dfd to model the proces

Draw the context diagram and level-0 DFD to model the process described below. If you feel the narrative is incomplete, make some reasonable assumptions to complete the stor

What decision would he make

As Nick does not know how his product will be received, he assumes that all three states of nature are equally likely to occur. If he uses the equally likely criterion, what

What mode of treatment maximizes the expected value

Patient survives treatment but is permanently disabled, and 3. Patient fails to survive treatment. Dr. Mac has prepared the decision table below. What mode of treatment maxi


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd