please see attachment  · No handwritten homework will b

· No handwritten homework will be accepted. If you use equations, you must also contain a nomenclature.

· Use the HW spreadsheet for homework questions below.

· Clearly state all assumptions. 

· Turn in your Excel HW spreadsheet with your written homework and please have your spreadsheet neatly organized.

1.  You have been asked to design a gathering system with a five well connect package. All five wells are to IP (Initial Production) at the same time. Preliminary engineering work has determined that a ten mile 10″ header along with a six-unit compressor station will be needed to move the new gas production. With the following information provided below, run an economic analysis to determine if the proposed project is viable. If the proposed project is not viable, what recommendations would you make to improve the economic viability of this project? For instance, can the five well connect package stand on its own or will additional volumes need to be added (i.e. third party) to justify the project cost or can you lower your material costs; for example, pipeline cost, compression costs or labor cost (within reason) to make the project economical?

a. Choosing only one of the five wells, use the Arps’ and Duong’s type curve models to determine what type of well you are dealing with, all five wells are assumed to produce from the same formation. For example, is this well unconventional or conventional and clearly state why?

i. Plot the type curve and show the curve in your write-up.

b. You have been given seven years of future production data, see HW 4 excel datasheet, from the producer; however, all projects are required to have a ten-year minimum contract term; therefore, you will need to estimate future production. Use empirical concepts (i.e. type curves or a curve fitting technique of your choosing) to project future gas production for years eight, nine and ten.

i. Plot this curve showing production data and your prediction model.

c. Economic metrics are as follows for this project:

i. Company hurdle rate is 13%

ii. Minimum contract length is 10 years.

iii. Pipeline cost for this area is assumed to be $100,000/in-mile.

iv. Labor cost are assumed to be 30% of year 1 revenue and 30% of subsequent yearly revenue.

v. Six-unit equity compressor station is ~ $13,000,000/station.

vi. Use 20% contingency for cost estimates.

d. Deliverables

i. Using the economic example shown in the lecture 4 slides, and in the HW 4 spreadsheet, to provide a similar economic analysis in spreadsheet form.

ii. Determine the following based on the economic metrics provided in item “c”: minimum cost of service, IRR, NPV @ 13%, payback period, total revenue, total profit and total labor cost over the ten-year period.

iii. Plot a Break-Even Cost Analysis showing the payback period for no contingency and with contingency dollars.

iv. What is the total profit, revenue and labor cost of the project over a ten-year period?

v. If one can reduce all material costs by 10% what is the new IRR and NPV @ 13% with the same cost of service found in d(ii)?