THE OPTIMUM DECISION OF OIL AND GAS PRODUCTION SPREADSHEET MODELLING
DOI:
https://doi.org/10.35794/jmbi.v10i3.52765Abstract
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.




