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

Questions Cloud

Scarf joints and finger joints are often used in : Scarf joints and finger joints are often used in? Each of the following is a reason why large wood beams are usually glue-laminated today rather than sawn except
What will the market shares be for the next period : At the present time, each of the four bookstores has an equal share of the market. What will the market shares be for the next period?
Find the electric potential difference between two points : What is the electric potential difference between two points that are 3.00 cm and 5.00 cm from a proton
Which input frequency would be able to eliminate completley : a)Write the diffrenece equation for a four-term moving average filter. b) The input x[n] = cos(n pi/6)u[n] is passed through the four-term moving average filter. Solve for the first 5 samples of the output.
How many miles of pipeline arctic oil must install : 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.
Control theories believe that everyone could commit crimes : Control theories believe that everyone could commit crimes, however it depends on the control that is on us to determine whether or not we do. Give you opinion on control theories and whether or not you agree with them.
Calculate the maximum height after the elastic collision : Two blocks are free to slide along the frictionless wooden track shown below. The block of mass m1 = 5.02 kg is released from the position shown, Calculate the maximum height to which m1 rises after the elastic collision
Differences between fire scene-post blast scene examination : What are the differences between a fire scene and a post blast scene examination? Would you as fire investigator, include any other "experts" in your scene examination?
Determine which frequencies will be the aliased one : a) Plot the spectrums for the range from 0 Hz to 25000 Hz. Make sure to label the frequncies. b) sketch the recoverd analog signal spectrum if an ideal lowpass filter with a cutoff frequncey of 4.5 kHzis used to filter the sampled signal.

Reviews

Write a Review

Operation Management Questions & Answers

  Estimate the average time spent by each order waiting

An automobile brake supplier receives an average of 1,000 orders per week. An average of 500 orders are waiting to be processed.

  Illustrate range of output is theoretically possible line

Line will operate for 450 minutes per day. Illustrate what is minimum number of workstation needed if maximum output rate is to be sought. Illustrate what range of output is theoretically possible for line.

  What is the effective capacity of the process

For the month of November, 2010, the firm has generated the 150 orders, 75 of each type. Assume one month equals 20 days. What is the effective capacity of the process (contracts per day)?

  Determine the quantity of produced cookies

Father's Cookies produces chocolate-chip cookies in a large oven that holds up to 2,000 pounds of cookies at a time. Annual demand is constant at 200,000 pounds; variable cost is $.25 per pound.

  What are coordinate values of ideal location to live at

A consultant provides service around the country. The consultant has the liberty to live anywhere, but wants to decide geographically. what are coordinate values of ideal location to live at? the primary clients and associated number of trips are.

  The malcolm baldrige award selection process helps

The Malcolm Baldrige award selection process helps improve quality and productivity by which of the following means?

  Determine the minimum cycle time

As part of a major plant renovation project, the industrial engineering department has been asked to balance a revised assembly operation to achieve an output of 240 units per eight-hour day.

  Describe why the product or offering has been successful

Identify one or two first movers and provide a review of what happened when they entered that industry. Describe why the product or offering has been successful or why it failed.

  How would you describe william bissell''s personality

What role do you think John Bissell and William Bissell played in Fabindia's organizational culture?Which of your specific values will be evident in the way you will manage? Why?

  Develop a forecast for the expected number

Use an appropriate technique to develop a forecast for the expected number of passengers for the next three weeks. (Round your intermediate calculations to 3 decimal places and final answers to 2 decimal places.) Week Forecasted demand 19 20 21

  Forecasts are more accurate using the concept of mad

Forecast registration for the last six weeks (5-10) using a two-week and a four-week moving average, which forecasts are more accurate using the concept of MAD?

  What term is used by the federal government

What term is used by the Federal Government to denote ultra high security prisons?

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