Development of Excel-Based Building Defect Management System Using Business Process Reengineering in Education Building

  • Abdi Telaga Department of Building Construction Technology, Astra Polytechnic, Indonesia
  • Thyana Avianto Department of Building Construction Technology, Astra Polytechnic, Indonesia
  • Andreadie Wicaksono Department of Production Engineering and Manufacturing Process, Astra Polytechnic, Indonesia
  • Hadi Susanto Department of Industrial Engineering, Telkom University, Indonesia
Keywords: building maintenance, business process reengineering, defect management system, excel dashboard, productivity


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%.


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.

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.

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.

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.

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.

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.

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.

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.

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.

O'Neill, P., & Sohal, A. S. (1999, 1999/09/01/). Business Process Reengineering A review of recent literature. Technovation, 19(9), 571-581.

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.

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.

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.

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.

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.

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.

How to Cite
Telaga, A., Avianto, T., Wicaksono, A., & Susanto, H. (2023). Development of Excel-Based Building Defect Management System Using Business Process Reengineering in Education Building. Indonesian Journal of Applied Research (IJAR), 4(2), 104-122.