THE OPTIMUM DECISION OF OIL AND GAS PRODUCTION SPREADSHEET MODELLING

Authors

  • Rudy Winarto Institut Teknologi Sepuluh Nopember
  • Anak Agung Bagus Dinariyana Institut Teknologi Sepuluh Nopember

DOI:

https://doi.org/10.35794/jmbi.v10i3.52765

Abstract

The optimum revenue of an oil and gas industry is subject to the production volume deliverability and relatively volatile product market price which depends on demand and supply level. Naturally, mature production wells will be dominantly producing water instead of oil and gas, meanwhile, the central processing facilities are having their limited capacity to handle it. This study intends to gain the optimum oil and gas production in mature fields by deciding the opening of well choke valves and considering process facilities limitations as constraints. The model is developed using a simplex LP-based spreadsheet. Three wellhead facilities with a total of forty-seven active producing wells gas, oil, and water data are taken as input parameters. The developed model is validated using the last ten days’ actual production data to identify the error margin consistency, a total of 1,410 data combinations were used. It results in an average error margin of 4.57%-gas and 0.9%-oil. The model could be used as an operator decision reference in opening the well’s choke valve to get the optimum production rate, a minor adjustment might need considering the dynamic process parameter condition.

 

Keywords: optimal production, mature wells, choke valve opening, spreadsheet modeling

References

Alas, R., Übius, U., Lorents, P., & Matsak, E. (2017). Corporate Social Responsibility In European And Asian Countries. Jurnal Manajemen Bisnis Dan Inovasi (JMBI) UNSRAT Vol. 4 No. 1

Bakker, S. J., Kleiven, A., Fleten, S. E., & Tomasgard, A. (2021). Mature offshore oil field development: Solving a real options problem using stochastic dual dynamic integer programming. Computers and Operations Research, 136. https://doi.org/10.1016/j.cor.2021.105480

Duffuaa, S. O., Al-Zayer, J. A., Al-Marhoun, M. A., & Al-Saleh, M. A. (n.d.). A Linear Programming Model to Evaluate Gas Availability for Vital Industries in Saudi Arabia.

Essien, G. (2016). Development and Validation of Linear Programming Models for Gasoline and Fuel Oil Blending. http://www.ijser.org

Jha, V., Jha, V. N., Karn, S. K., & Kumar, K. (n.d.). Review on the Role of Mathematical Modeling in Energy Sectors. www.ijesi.org

Lei, G., Stanko, M., & Silva, T. L. (2022). Formulations for automatic optimization of decommissioning timing in offshore oil and gas field development planning. Computers and Chemical Engineering, 165. https://doi.org/10.1016/j.compchemeng.2022.107910

Mojambo, G. A., Tulung, J. E., & Saerang, R. T. (2020). The Influence of Top Management Team (TMT) Characteristics Toward Indonesian Banks Financial Performance During the Digital Era (2014-2018). JMBI UNSRAT (Jurnal Ilmiah Manajemen Bisnis dan Inovasi Universitas Sam Ratulangi)., 7(1).

Popoola, L. T., Susu, A. A., Lateef, A. A., & Grema, A. S. (2015). Application of Linear Programming in Profit Optimization of Crude Oil Distillation Column of Port Harcourt Refinery, Nigeria.

Ronn, E. I. (1987). A New Linear Programming Approach to Bond Portfolio Management. The Journal of Financial and Quantitative Analysis, 22(4), 439. https://doi.org/10.2307/2330794

Salih, Y., & Rubiani, H. (2020). Application of Linear Programming in Oil Production Distribution Networks: Literature Review. International Journal of Research in Community Service, 1(3), 1–6.

Taha, H. A. (2007). Operations Research: An Introduction Eighth Edition.

Downloads

Published

2023-12-30

How to Cite

Winarto, R., & Dinariyana, A. A. B. (2023). THE OPTIMUM DECISION OF OIL AND GAS PRODUCTION SPREADSHEET MODELLING. JMBI UNSRAT (Jurnal Ilmiah Manajemen Bisnis Dan Inovasi Universitas Sam Ratulangi)., 10(3), 2451–2460. https://doi.org/10.35794/jmbi.v10i3.52765