Aplikasi Estimasi Biaya Bangunan Gedung Berdasarkan Analisa Harga Satuan Pekerjaan Berbasis Macro Excel

Lendra Lendra, Robby Robby, Frediyantoni F. Adji, Muhammad Faqqih

Abstract


Estimating construction project costs is usually done manually; it takes a long time, and the more comprehensive the estimate, the more manual calculations must be performed, increasing the risk of human errors. This study aims to make a building cost estimation application using the 2022 Work Unit Price Analysis (AHSP), based on excel macros, so that cost estimates become more accurate and efficient. The first step is to design the framework and application design and then analyze the database requirements. The second step: database creation and application interface design. The third step: testing, validation, and verification on two building projects in 2022. The estimation results of this application are very accurate and efficient, where the total cost is Rp. 382,998,432.00, while the bid price is Rp. 383,000,000.00. There is a difference in calculation costs compared to the bid price, which is Rp. 1,568.00 (0.00041%).

Keywords


Engineering, Civil Engineering, Construction Management, Risk Management

Full Text:

PDF

References


S. Tayefeh Hashemi, O. M. Ebadati, and H. Kaur, “Cost estimation and prediction in construction projects: a systematic review on machine learning techniques,” SN Appl. Sci., vol. 2, no. 10, pp. 1–27, 2020, doi: 10.1007/s42452-020-03497-1.

S. H. Ji, J. Ahn, H. S. Lee, and K. Han, “Cost Estimation Model Using Modified Parameters for Construction Projects,” Adv. Civ. Eng., vol. 2019, pp. 1–10, 2019, doi: 10.1155/2019/8290935.

A. Jrade and S. Alkass, “Computer-Integrated System for Estimating the Costs of Building Projects,” J. Archit. Eng., vol. 13, no. 4, pp. 205–223, 2007, doi: 10.1061/(asce)1076-0431(2007)13:4(205).

D. Jumas, Model Estimasi Biaya Pada Bangunan Gedung, no. July. Padang: LPPM Universitas Bung Hatta, 2020.

A. Rizal, M. Fajri, and L. S. Yuniar, “Estimasi Biaya Konstruksi Pada Perumahan Tipe 45 di Sulawesi Tengah Menggunakan Regresi Kuadratik,” Rekonstruksi Tadulako Civ. Eng. J. Res. Dev., vol. 1, no. 2, pp. 31–34, 2020, doi: 10.22487/renstra.v1i2.27.

P. S. Nugroho and B. Mulyono, “Estimasi Biaya Tidak Langsung pada Kontraktor Kecil di Semarang,” Pros. Konf. Nas. Tek. Sipil 9 (KoNTekS 9), vol. 9, no. October 2015, pp. 573–578, 2015.

M. Sayed, M. Abdel-Hamid, and K. El-Dash, “Improving cost estimation in construction projects,” Int. J. Constr. Manag., vol. 0, no. 0, pp. 1–20, 2020, doi: 10.1080/15623599.2020.1853657.

P. A. Eman, L. Elisabeth, and F. Jansen, “Estimasi Biaya Konstruksi Menggunakan Metode Parameter Pada Proyek Pemeliharaan Berkala Jalan Di Kota Manado,” in Jurnal Ilmiah Media Engineering, 2019, vol. 8, no. 2, pp. 1033–1050.

N. Nasril and D. Jumas, “Improving Conceptual Cost Estimating Performance Pada Perhitungan Harga Satuan Tertinggi Bangunan Gedung di Sumatera Barat,” J. Rekayasa Sipil, vol. 10, no. 1, pp. 32–42, 2014.

B. Mulyono and P. S. Nugroho, “Estimasi Biaya Konseptual Pada Jembatan Beton Bertulang Dengan Metode Indeks Biaya,” Din. Rekayasa, vol. 13, no. 2, pp. 105–111, 2017.

S. Famiyeh, C. T. Amoatey, E. Adaku, and C. S. Agbenohevi, “Major causes of construction time and cost overruns: A case of selected educational sector projects in Ghana,” J. Eng. Des. Technol., vol. 15, no. 2, pp. 181–198, 2017, doi: 10.1108/JEDT-11-2015-0075.

S. Hassim, R. Muniandy, A. H. Alias, and P. Abdullah, “Construction tender price estimation standardization (TPES) in Malaysia: Modeling using fuzzy neural network,” Eng. Constr. Archit. Manag., vol. 25, no. 3, pp. 443–457, 2018, doi: 10.1108/ECAM-09-2016-0215.

M. T. Hatamleh, M. Hiyassat, G. J. Sweis, and R. J. Sweis, “Factors affecting the accuracy of cost estimate: Case of Jordan,” Eng. Constr. Archit. Manag., vol. 25, no. 1, pp. 113–131, 2018, doi: 10.1108/ECAM-10-2016-0232.

D. I. Prasetyo, M. Indrayadi, and B. Arfan, “Pembuatan Program RAB dan Harga Satuan dengan Menggunakan Microsoft Excel Macros dan Visual Basic,” J. Mhs. Tek. Sipil Univ. Tanjungpura, vol. 2, no. 2, pp. 1–5, 2015.

G. Aldy, L. Lendra, and R. Waluyo, “Aplikasi Estimasi Biaya Pembangunan Bangunan Gedung Satu Lantai Berbasis Macro Excel,” J. Prot. (Proyeksi Tek. Sipil), vol. 2, no. 2, pp. 143–152, 2016.

D. David, “Peningkatan Keterampilan Penggunaan Macro VBA,” in Prosiding Seminar Nasional Pengabdian Pada Masyarakat, 2019, pp. 29–37.

T. Connolly and C. Begg, Database Systems A Practical Approach to Design, Implementation, and Management, 6th ed. Essex: Pearson, 2015.

H. J. Sitanggang, E. Hernawati, and F. A. Tridalestari, “Aplikasi Reservasi Kamar Wisma Berbasis Web Studi Kasus: Penginapan Imbalo Group Rantau Parapat Sumatera Utara,” e-Proceeding Appl. Sci., vol. 3, no. 3, pp. 1331–1342, 2017.




DOI: http://dx.doi.org/10.12962/j2579-891X.v21i4.15078

Refbacks

  • There are currently no refbacks.


Jumlah Kunjungan:Web Analytics

Creative Commons License
Jurnal Aplikasi Teknik Sipil by Pusat Publikasi Ilmiah LPPM Institut Teknologi Sepuluh Nopember is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

Based on work at https://iptek.its.ac.id/index.php/jats