Development of Excel-Based Building Defect Management System Using Business Process Reengineering in Education Building
Abstract
Effective maintenance of a university campus building is crucial to ensure the safety and well-being of its academic community. However, maintaining the building and its various equipment and assets can take time and effort. This study aims to optimize building maintenance by implementing Business Process Reengineering (BPR) and using an Excel-based application system to detect points of damage. The study analyzes the maintenance process's cost, duration, and damage reports using dashboard features such as Gantt chart diagrams. By comparing the Excel-based application system with the conventional system, we found that the former is more effective and efficient. The results show that the application system saves 12 hours of recapitulation time per week, increases labor productivity by 32.2%, and speeds up damage reparation by 5%.
References
AlShaali, S. K., Alhammadi, A. S., AlKatheeri, N. S., Zeineldine, S. M., Alzarooni, A. A., Thani, S. M., & Eid, E. E. (2022). From Months to Days— An Efficient Microsoft-Excel Database: A Case of Dam Maintenance in United Arab Emirates. Modern Applied Science, 16(3), 1-19.
Alves Tenório de Morais, G., & Casado Lordsleem Júnior, A. (2019). Building maintenance management activities in a public institution. Engineering, Construction and Architectural Management, 26(1), 85-103. https://doi.org/10.1108/ECAM-01-2018-0024
Amri, S., & Napitupulu, H. L. (2021). Business process reengineering android-based sales: Case PT. XYZ. IOP Conference Series: Materials Science and Engineering,
Barrett, J. L. (1994, 1994/01/01). PROCESS VISUALIZATION Getting the Vision Right Is Key. Information Systems Management, 11(2), 14-23. https://doi.org/10.1080/10580539408964631
Benachio, G. L. F., Freitas, M. d. C. D., & Tavares, S. F. (2020). Circular economy in the construction industry: A systematic literature review. Journal of Cleaner Production, 260, 121046.
Bhaskar, H. L. (2015). A comparative analysis of business process reengineering and total quality management. Bhaskar, HL (2015)‘A Comparative Analysis of Business Process Reengineering and Total Quality Management’, Global Journal of Business Management, 9(1), 11-28.
Bhaskar, H. L., & Singh, R. (2014). Business process reengineering: a recent review. Bhaskar, HL, and Singh, RP (2014). Business process reengineering: a recent review. Global Journal of Business Management, 8(2), 24-51.
Chou, J.-S., Telaga, A. S., Chong, W. K., & Gibson, G. E. (2017, 2017/04/15/). Early-warning application for real-time detection of energy consumption anomalies in buildings. Journal of Cleaner Production, 149, 711-722. https://doi.org/https://doi.org/10.1016/j.jclepro.2017.02.028
Das, A. (2020). Utilizing Business Process Reengineering for Optimization of A Third Party Logistics Company. University of Illinois at Chicago].
Dhillon, B. S. (2002). Engineering maintenance: a modern approach. cRc press.
dos Santos, C. H., Gabriel, G. T., do Amaral, J. V. S., Montevechi, J. A. B., & de Queiroz, J. A. (2021, 2021/09/01). Decision-making in a fast fashion company in the Industry 4.0 era: a Digital Twin proposal to support operational planning. The International Journal of Advanced Manufacturing Technology, 116(5), 1653-1666. https://doi.org/10.1007/s00170-021-07543-z
Frangopol, D. M., & Liu, M. (2019). Maintenance and management of civil infrastructure based on condition, safety, optimization, and life-cycle cost. Structures and Infrastructure Systems, 96-108.
Garcia-Garcia, G., Coulthard, G., Jagtap, S., Afy-Shararah, M., Patsavellas, J., & Salonitis, K. (2021). Business process reengineering to digitalise quality control checks for reducing physical waste and resource use in a food company. Sustainability, 13(22), 12341.
Government Regulation Number 16 of 2021 concerning Regulations for Implementing Law Number 28 of 2002 concerning Buildings. https://jdih.pu.go.id/detail-dokumen/2851/1#div_cari_detail
Harika, A., Sunil Kumar, M., Anantha Natarajan, V., & Kallam, S. (2021, 2021//). Business Process Reengineering: Issues and Challenges. Proceedings of Second International Conference on Smart Energy and Communication, Singapore.
Harode, A., Ensafi, M., & Thabet, W. (2022). Linking BIM to Power BI and HoloLens 2 to Support Facility Management: A Case Study Approach. Buildings, 12(6), 852. https://www.mdpi.com/2075-5309/12/6/852
Horner, R. M. W., El‐Haram, M. A., & Munns, A. K. (1997). Building maintenance strategy: a new management approach. Journal of Quality in Maintenance Engineering, 3(4), 273-280. https://doi.org/10.1108/13552519710176881
Peraturan Pelaksanaan Undang-undang Nomor 28 Tahun 2002 tentang bangunan dan gedung, (2021).
Mamaghani, O. A., & Noorzai, E. (2023). A framework to implement augmented reality based on BIM to improve operation and maintenance of mechanical facilities of commercial complexes. Facilities(ahead-of-print).
Mesarosova, J., Martinovicova, K., Fidlerova, H., Chovanova, H. H., Babcanova, D., & Samakova, J. (2022). IMPROVING THE LEVEL OF PREDICTIVE MAINTENANCE MATURITY MATRIX IN INDUSTRIAL ENTERPRISE. Acta Logistica, 9(2), 183-193.
Munbodh, R., Roth, T. M., Leonard, K. L., Court, R. C., Shukla, U., Andrea, S., Gray, M., Leichtman, G., & Klein, E. E. (2022). Real-time analysis and display of quantitative measures to track and improve clinical workflow. Journal of Applied Clinical Medical Physics, 23(9), e13610. https://doi.org/https://doi.org/10.1002/acm2.13610
Mustafa, A., & Hatemi-J, A. (2022). A VBA module simulation for finding optimal lag order in time series models and its use on teaching financial data computation. Applied Computing and Informatics, 18(3/4), 208-220. https://doi.org/10.1016/j.aci.2019.04.003
O'Neill, P., & Sohal, A. S. (1999, 1999/09/01/). Business Process Reengineering A review of recent literature. Technovation, 19(9), 571-581. https://doi.org/https://doi.org/10.1016/S0166-4972(99)00059-0
Pasaribu, R. D., Anggadwita, G., Hendayani, R., Kotjoprayudi, R. B., & Apiani, D. I. N. (2021). Implementation of business process reengineering (BPR): Case study of official trip procedures in higher education institutions. Journal of Industrial Engineering and Management, 14(3), 622-644.
Ramadhan, F., Rukmi, H. S., Imran, A., Nugraha, C., & Ferdiansyah, R. (2020). Software Design using Visual Basic for Application and Microsoft Excel Programming for Students. REKA ELKOMIKA: Jurnal Pengabdian kepada Masyarakat, 1(2), 86-97.
Regulation of the Minister of Public Works 24 (2008). Building Maintenance and Care Guidelines. https://peraturanpedia.id/peraturan-menteri-pekerjaan-umum-dan-perumahan-rakyat-nomor-24-prt-m-2008/
Riyanto, A., Primiana, I., & Azis, Y. (2018). Reengineering support for competitive advantage through organizational basis, information and communication technology: a literature review. Problems and perspectives in management, 16(3), 464.
Sallahuddin, A. N. S. (2013). Development of an Excel Based Spreadsheet of Analytical Hierarchy Process And Decision Making Grid For Maintenance Policy Decision. [Doctoral Dissertation Universiti Teknologi PETRONAS, Malaysia]
Susnjak, T., Ramaswami, G. S., & Mathrani, A. (2022, 2022/02/14). Learning analytics dashboard: a tool for providing actionable insights to learners. International Journal of Educational Technology in Higher Education, 19(1), 12. https://doi.org/10.1186/s41239-021-00313-7
Villa, V., Bruno, G., Aliev, K., Piantanida, P., Corneli, A., & Antonelli, D. (2022). Machine Learning Framework for the Sustainable Maintenance of Building Facilities. Sustainability, 14(2), 681.
Villa, V., Naticchia, B., Bruno, G., Aliev, K., Piantanida, P., & Antonelli, D. (2021). IoT Open-Source Architecture for the Maintenance of Building Facilities. Applied Sciences, 11(12), 5374. https://www.mdpi.com/2076-3417/11/12/5374
Weeks, D. J., & Leite, F. (2022). Minimizing Facility Corrective Maintenance: Benchmarking Preventative-to-Corrective Maintenance Ratios Using Maintenance Data and Building Age in Dormitories. Journal of Management in Engineering, 38(1), 04021086. https://doi.org/doi:10.1061/(ASCE)ME.1943-5479.0000996
Yousif, O. S., Zakaria, R., Aminudin, E., Shamsuddin, S. M., Abdul Rahman, M. F., Gara, J., & Ahmad, N. F. (2022, 2022/10/01). Integration Method for Web based Visualization Framework of Green Highway Index and Carbon Footprint Calculator. IOP Conference Series: Earth and Environmental Science, 1067(1), 012016. https://doi.org/10.1088/1755-1315/1067/1/012016
Zhang, Q., & Cao, M. (2002). Business process reengineering for flexibility and innovation in manufacturing. Industrial Management & Data Systems, 102(3), 146-152.
Zondo, R. W. D. (2021). The impact of Business Process Reengineering (BPR) on labour productivity in the automotive assembly organisation in South Africa. Quality-Access to Success; Vol. 22, Issue 183.
Copyright (c) 2023 Indonesian Journal of Applied Research (IJAR)
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
The Authors submitting a manuscript do so on the understanding that if accepted for publication, copyright publishing of the article shall be assigned/transferred to Indonesian Journal of Applied Research (IJAR) Universitas Djuanda as Publisher of the journal. Upon acceptance of an article, authors will be asked to complete a 'Copyright Transfer Agreement'. An e-mail will be sent to the corresponding author confirming receipt of the manuscript together with a 'Copyright Transfer Agreement' form by online version of this agreement.
Indonesian Journal of Applied Research (IJAR) Universitas Djuanda, the Editors and the Editorial Board make every effort to ensure that no wrong or misleading data, opinions or statements be published in the journal. In any way, the contents of the articles and advertisements published in the Indonesian Journal of Applied Research (IJAR) Universitas Djuanda are sole and exclusive responsibility of their respective authors and advertisers.
Remember, even though we ask for a transfer of copyright, our journal authors retain (or are granted back) significant scholarly rights as mention before.
The Copyright Transfer Agreement (CTA) Form can be downloaded here: Copyright Transfer Agreement-IJAR 2020
The copyright form should be signed electronically and send to the Editorial Office e-mail below:
Prof. Dr. Ir. Dede Kardaya, M.Si. (Editor-in-Chief)
Universitas Djuanda
Jl. Tol Jagorawi No.1, Ciawi, Kec. Ciawi, Bogor, Jawa Barat 16720
Website: http://journal.unida.ac.id/index.php/IJAR/index
Email: ijar@unida.ac.id
This work is licensed under a 