Stochastic Linear Programming Method in Housing Investment Feasibility in West Jakarta

Authors

  • Frenki Tarumanagara University Author
  • Mark Setiadi Universitas Tarumanagara Author
  • Waty Asriningsih Pranoto Universitas Tarumanagara Author

DOI:

https://doi.org/10.20884/1.dinarek.2024.20.2.87

Keywords:

investasi, two-stage stochastic, studi kelayakan, net present value, internal rate of return

Abstract

This research was conducted in light of a planned investment for residential development in West Jakarta, given the very limited availability of land in the area in terms of land size, price, shape, and other factors, necessitating an investment feasibility study. The purpose of the investment feasibility study is to analyze the viability of this investment. Besides the limited land availability, there is often uncertainty during the sales stage. Thus, this study employs a two-stage stochastic programming model. The houses to be built are divided into two types, namely houses with a width of 4 meters and houses with a width of 4.5 meters. The two-stage stochastic programming model created consists of 2 steps, namely step 1 during housing construction and step 2 during home sales. The objective function is to get the maximum net present value (Zmax). The overall time required in this investment is 4 years. After creating a two-stage stochastic programming model, the analysis was carried out using the Solver Add-in in Microsoft Excel. The analysis concluded that the maximum net present value expected in this investment is 4,092.036 million Rupiah, with a positive net present value, this investment is acceptable. This analysis was added with the calculation of IRR as a supporter of the net present value which resulted in an interest rate of 23,63%. With a large enough IRR interest rate, it can be concluded that this housing development investment is acceptable.

Downloads

Download data is not yet available.

References

B. Sujatmiko, M. O. Bustamin, and G. N. Ardiansyah, “Analisis Biaya Investasi Proyek Pembangunan Perumahan La Diva Green Hill Menganti Gresik,” Publikasi Riset Orientasi Teknik Sipil (Proteksi), vol. 5, no. 1, pp. 51–59, Jun. 2023, doi: 10.26740/proteksi.v5n1.p51-59.

T. Shou, “A Literature Review on the Net Present Value (NPV) Valuation Method,” in Proceedings of the 2022 2nd International Conference on Enterprise Management and Economic Development (ICEMED 2022), Australia: Atlantis Press, 2022, pp. 826–830. doi: 10.2991/aebmr.k.220603.135.

H. Ahmed, “Formulation of Two-Stage Stochastic Programming with Fixed Recourse,” Britain International of Exact Sciences (BIoEx) Journal, vol. 1, no. 1, pp. 18–21, 2019, doi: 10.33258/bioex.v1i1.23.

S. K. Barik, M. P. Biswal, and D. Chakravarty, “Multiobjective two-stage stochastic programming problems with interval discrete random variables,” Advances in Operations Research, vol. 2012, pp. 1–21, 2012, doi: 10.1155/2012/279181.

N. P. Putri, “Analisis kelayakan investasi pada perumahan Dadapan Ika Residence Semarang,” Univesitas Sultan Agung, Semarang, 2022.

H. Gaspars-Wieloch, “Project Net Present Value estimation under uncertainty,” Cent Eur J Oper Res, vol. 27, no. 1, pp. 179–197, Mar. 2019, doi: 10.1007/s10100-017-0500-0.

F. Felix, I. B. Santoso, and M. Setiadi, “Analisis investasi perumahan dengan sistem cluster di provinsi Jawa Timur,” Jurnal Muara Sains, Teknologi, Kedokteran, dan Ilmu Kesehatan, vol. 2, no. 1, pp. 96–106, 2018, doi: 10.24912/jmstkik.v2i1.1464.

M. N. Harahap, “Analisis payback period, net present value (NPV), dan internal rate of return (IRR) pada usaha perhotelan di Kepulauan Seribu,” ACCOUNTHINK : Journal of Accounting and Finance, vol. 5, no. 2, pp. 148–164, 2020, doi: 10.35706/acc.v5i02.4330.

C. Sinaga, T. Tulus, and H. Mawengkang, “Simplifying Complexity: Scenario Reduction Techniques in Stochastic Programming,” Sinkron : Jurnal dan Penelitian Teknik Informatika, vol. 8, no. 3, pp. 1821–1831, Jul. 2023, doi: 10.33395/sinkron.v8i3.12753.

R. Krenek, “Developing a two-stage stochastic programming model in tolerance optimization using a guard band approach,” Engineering Reports, vol. 4, no. 2, pp. 1–19, Feb. 2022, doi: 10.1002/eng2.12461.

K. Kungwalsong, C. Y. Cheng, C. Yuangyai, and U. Janjarassuk, “Two-stage stochastic program for supply chain network design under facility disruptions,” Sustainability (Switzerland), vol. 13, no. 5, pp. 1–19, Mar. 2021, doi: 10.3390/su13052596.

P. Y. Hsu, P. Angeloudis, and M. Aurisicchio, “Optimal logistics planning for modular construction using two-stage stochastic programming,” Autom Constr, vol. 94, pp. 47–61, Oct. 2018, doi: 10.1016/j.autcon.2018.05.029.

G. Mavromatidis, K. Orehounig, and J. Carmeliet, “Design of distributed energy systems under uncertainty: A two-stage stochastic programming approach,” Appl Energy, vol. 222, pp. 932–950, Jul. 2018, doi: 10.1016/j.apenergy.2018.04.019.

Q. Li, J. Wang, Y. Wang, and J. Lv, “A Two-Stage Stochastic Programming Model for Emergency Supplies Pre-Position under the Background of Civil-Military Integration,” Sustainability (Switzerland), vol. 14, no. 19, Oct. 2022, doi: 10.3390/su141912080.

J. Dumouchelle, R. Patel, E. B. Khalil, and M. Bodur, “Neur2SP: Neural Two-Stage Stochastic Programming,” in 36th Conference on Neural Information Processing Systems (NeurIPS 2022), New Orleans: Neural Information Processing Systems Foundation, Inc., 2022, pp. 23992–24005.

M. C. Patterson and B. Harmel, “An Algorithm for Using Excel Solver© for the Traveling Salesman Problem,” Journal of Education for Business, vol. 78, no. 6, pp. 341–346, Jul. 2003, doi: 10.1080/08832320309598624.

“Excel Solver Linear Programming | Real-life Case Studies.” Accessed: May 08, 2024. [Online]. Available: https://www.someka.net/blog/excel-solver-linear-programming/

L. Briones, V. Morales, J. Iglesias, G. Morales, and J. M. Escola, “Application of the microsoft excel solver tool in the optimization of distillation sequences problems,” Computer Applications in Engineering Education, vol. 28, no. 2, pp. 304–313, Mar. 2020, doi: 10.1002/cae.22193.

Downloads

Published

2024-07-31

How to Cite

Stochastic Linear Programming Method in Housing Investment Feasibility in West Jakarta. (2024). Jurnal Ilmiah Dinamika Rekayasa, 20(2), 101-109. https://doi.org/10.20884/1.dinarek.2024.20.2.87

Similar Articles

You may also start an advanced similarity search for this article.

Most read articles by the same author(s)

1 2 > >>