Enhancing efficiency in construction scheduling for SMEs: A novel matrix-based VBA-excel model

L. Nguyen-Son; T. Thai-Phuong

doi:10.37385/jaets.v7i2.9232

Authors

L. Nguyen-Son Industrial University of Ho Chi Minh City https://orcid.org/0000-0002-5823-2344 (unauthenticated)
T. Thai-Phuong Faculty of Civil Engineering, Industrial University of Ho Chi Minh City https://orcid.org/0000-0003-3492-7309 (unauthenticated)

DOI:

https://doi.org/10.37385/jaets.v7i2.9232

Keywords:

Construction Scheduling, VBA-Excel, PDM, SMEs, Matrix-Based Model, Dependency Management, Cost-Effective Tool

Abstract

Small and medium-sized enterprises (SMEs) in construction face challenges managing complex project schedules cost-effectively. This study develops a user-friendly, matrix-based VBA-Excel model to enhance scheduling efficiency. The objective is to create an accessible tool that automates task dependency management without requiring advanced coding skills. The model employs the Precedence Diagramming Method (PDM), integrating all dependency types (FS, SS, FF, SF) with lag/lead adjustments through VBA automation in Excel. Implementation involved designing a novel matrix structure for dependency handling and a simple interface, validated via case studies with 11 and 9 tasks, benchmarked against industry standards. Results show accurate schedule calculations matching benchmarks, with seamless adjustments, though processing slows for large projects. The tool enables SMEs to optimize resources, reduce delays, and improve competitiveness at no cost. Limitations include Excel’s computational limits and omission of real-world calendar constraints like holidays. Future enhancements could include cloud-based scalability and risk integration. This innovative model fosters inclusive project management, reducing infrastructure disparities in underserved regions.

Downloads

Download data is not yet available.

References

Abuhasel, K. (2023). Sustainable Green City Development Project Analysis using the Critical Path Method (CPM) and the Crashing Project Method on Time and Cost Optimization. Engineering, Technology and Applied Science Research, 13(3). https://doi.org/10.48084/etasr.5980

Al-Dhamad, S. H. R., Kurwi, S. I. B., Varouqa, I. F., Hayder, G., Obaid, A. H., & Al-Zwainy, F. M. S. (2025). Optimizing Project Management: Planning, Scheduling, and Cost Estimation Using Microsoft Project. Journal of Applied Science, Engineering, Technology, and Education, 7(2). https://doi.org/10.35877/454RI.asci4165

Alfandi Rizki Pratama, R., Djakfar, L., & Negara, K. P. (2025). Monte Carlo Mathematical Model Simulation: An Evaluation of The Probability of Construction Project Acceleration. Journal of Multidisciplinary Applied Natural Science, 5(2). https://doi.org/10.47352/JMANS.2774-3047.269

Amer, F., Koh, H. Y., & Golparvar-Fard, M. (2021). Automated Methods and Systems for Construction Planning and Scheduling: Critical Review of Three Decades of Research. Journal of Construction Engineering and Management, 147(7). https://doi.org/10.1061/(asce)co.1943-7862.0002093

Arditi, D., & Bentotage, S. N. (1996). System for scheduling highway construction projects. Microcomputers in Civil Engineering, 11(2). https://doi.org/https://doi.org/10.1111/j.1467-8667.1996.tb00316.x

Aslan, S., & Türkakın, O. H. (2022). A construction project scheduling methodology considering COVID-19 pandemic measures. Journal of Safety Research, 80. https://doi.org/10.1016/j.jsr.2021.11.007

Babu, V. K. V., Saini, P., & Charu, K. M. (2026). Integrating Building Information Modelling (BIM) in Construction Projects: A Study to Increase the Efficiency of Construction Projects. Lecture Notes in Networks and Systems, 1511 LNNS. https://doi.org/10.1007/978-981-96-8796-1_3

Bettemır, Ö. H., & Bulak, Ö. F. (2022). Scheduling, Management and Optimization of Construction Process. Teknik Dergi/Technical Journal of Turkish Chamber of Civil Engineers, 33(6). https://doi.org/10.18400/tekderg.981601

Bidhendi, A., Nahri, Z., MotamedManesh, M., & Poshdar, M. (2025). Leveraging BIM and Prefabrication for Enhanced Architectural Excellence in Sustainable Construction. Lecture Notes in Civil Engineering, 591 LNCE. https://doi.org/10.1007/978-981-96-4051-5_106

Chen, S., Eyers, D. R., Gosling, J., & Huang, Y. (2025). Supply chain risks for SMEs in construction projects: a structured literature review and research agenda. In International Journal of Logistics Management (Vol. 36, Number 3). https://doi.org/10.1108/IJLM-12-2023-0548

Corral, F., Forcael, E., & Linfati, R. (2023). Workforce scheduling efficiency assessment in construction projects through a multi-objective optimization model in the COVID-19 context. Heliyon, 9(6). https://doi.org/10.1016/j.heliyon.2023.e16745

Datta, S. D., Sobuz, M. H. R., Mim, N. J., & Nath, A. D. (2023). Investigation on the effectiveness of using building information modeling (BIM) tools in project management: a case study. Revista de La Construccion, 22(2). https://doi.org/10.7764/RDLC.22.2.306

Doukari, O., Seck, B., & Greenwood, D. (2022). The Creation of Construction Schedules in 4D BIM: A Comparison of Conventional and Automated Approaches. Buildings, 12(8). https://doi.org/10.3390/buildings12081145

Elazouni, A., & Abido, M. A. (2014). Enhanced Trade-Off of Construction Projects: Finance-Resource-Profit. Journal of Construction Engineering and Management, 140(9). https://doi.org/10.1061/(asce)co.1943-7862.0000880

Elkliny, A., Sanad, H., & Etman, E. (2025). GA-driven MCDM model for time-cost-quality-resource trade-off in construction projects. Engineering, Construction and Architectural Management. https://doi.org/10.1108/ECAM-06-2025-1046

Fares, A., Elazouni, A., Al-Shihabi, S., & Al-Alawi, M. (2025). Finance-based scheduling for projects in owners’ portfolios: MILP versus improved GA and PSO. Engineering, Construction and Architectural Management. https://doi.org/10.1108/ECAM-07-2024-0960

Goh, C. S., & Lee, S. S. H. (2023). an Investigation of the Implications of Covid-19 for Digitalisation in the Malaysian Construction Industry. Journal of Engineering Science and Technology, 18(5). https://doi.org/10.25046/aj0505119

Hansen, S., Fassa, F., & Wijaya, S. (2023). Factors Influencing Scheduling Activities of Construction Projects. Journal of Legal Affairs and Dispute Resolution in Engineering and Construction, 15(1). https://doi.org/10.1061/(asce)la.1943-4170.0000594

Hu, C., Wang, J., & Mei, Y. (2021). Uncertain Time-Resource-Cost Trade-Off Models for Construction Project Schedule. KSCE Journal of Civil Engineering, 25(8). https://doi.org/10.1007/s12205-021-1798-7

Isah, M. A., & Kim, B. S. (2021). Integrating schedule risk analysis with multi‐skilled resource scheduling to improve resource‐constrained project scheduling problems. Applied Sciences (Switzerland), 11(2). https://doi.org/10.3390/app11020650

Kannimuthu, M., Raphael, B., Ekambaram, P., & Kuppuswamy, A. (2020). Comparing optimization modeling approaches for the multi-mode resource-constrained multi-project scheduling problem. Engineering, Construction and Architectural Management, 27(4). https://doi.org/10.1108/ECAM-03-2019-0156

Khan, A. N., Mehmood, K., & Soomro, M. A. (2024). Knowledge Management-Based Artificial Intelligence (AI) Adoption in Construction SMEs: The Moderating Role of Knowledge Integration. IEEE Transactions on Engineering Management, 71. https://doi.org/10.1109/TEM.2024.3403981

Le, L. Q., Teo, P., & Gajanayake, A. (2025). Explicit CSR Communication Among Trade and Subcontractor SMEs in the Construction Industry. Corporate Social Responsibility and Environmental Management, 32(3). https://doi.org/10.1002/csr.3160

Lotfi, R., Yadegari, Z., Hosseini, S. H., Khameneh, A. H., Tirkolaee, E. B., & Weber, G. W. (2022). A ROBUST TIME-COST-QUALITY-ENERGY-ENVIRONMENT TRADE-OFF WITH RESOURCE-CONSTRAINED IN PROJECT MANAGEMENT: A CASE STUDY FOR A BRIDGE CONSTRUCTION PROJECT. Journal of Industrial and Management Optimization, 18(1). https://doi.org/10.3934/jimo.2020158

Mafundu, R. H., & Mafini, C. (2019). Internal constraints to business performance in black-owned small to medium enterprises in the construction industry. Southern African Journal of Entrepreneurship and Small Business Management, 11(1). https://doi.org/10.4102/SAJESBM.V11I1.165

Maravas, A., & Pantouvakis, J.-P. (2025). Schedula Anima: Dynamic Visualization of Gantt Charts and Resource Usage Graphs in Project Scheduling. Buildings, 15(3), 393. https://doi.org/10.3390/buildings15030393

Mohamed Meabed, E. S., Mahfouz, S. Y., & Alhady, A. (2025). Modified critical chain scheduling for construction projects. HBRC Journal, 21(1). https://doi.org/10.1080/16874048.2025.2459038

Nicholas, M., Monko, R., Malekela, K., & Zulu, S. (2024). Assessment of building information modeling adoption in building material scheduling in Tanzania’s construction industry. Sustainable Engineering and Innovation, 6(2). https://doi.org/10.37868/sei.v6i2.id307

Pranata, C., Setyandito, O., Kosalim, V., Purnamasari, C., & Syahputra, M. Y. (2023). Analysis of Cost Planning and Time Control of Breakwater Embankment Ground Improvement Method at Port in Subang Regency West Java. AIP Conference Proceedings, 2846(1). https://doi.org/10.1063/5.0155433

Pregina, K., & Ramesh Kannan, M. (2022). Stochastic Project Network Scheduling Technique for Construction Projects Using GERT. Lecture Notes in Civil Engineering, 191. https://doi.org/10.1007/978-981-16-5839-6_33

Purushothaman, M. B., Elenzano, D., GhaffarianHoseini, A., & Ghaffarianhoseini, A. (2025). Dynamic scheduling: influential and influenced factors and their interrelationships in the New Zealand construction industry. Smart and Sustainable Built Environment. https://doi.org/10.1108/SASBE-11-2024-0488

Ramahwati, A., & Osly, P. J. (2024). Estimasi Biaya Dan Penjadwalan Pembangunan Prototipe Ruang Modular Operating Theatre (Cost Estimation And Scheduling Modular Operating Theatre Prototype Construction). Jurnal Artesis, 4(2).

Rosener, W. J. (2024). Comparative Analysis of Google Sheets and Microsoft Excel. Journal of Cases on Information Technology, 26(1). https://doi.org/10.4018/jcit.351672

S, S., & George, G. (2021). A COMPARISON OF PROJECT PLANNING AND SCHEDULING SOFTWARE’S PRIMAVERA AND MICROSOFT PROJECT USED IN THE CONSTRUCTION INDUSTRY. International Journal of Engineering Technologies and Management Research, 8(9). https://doi.org/10.29121/ijetmr.v8.i9.2021.1039

Sapitri, Aziz Azizi, F. A., Yulianti, A., Retno, D. P., Elizar, & Susanti, B. (2025). Application of BIM Technology in Construction Industry for Modeling, Quantity Takeoff, and Scheduling Simulation. 2025 7th International Conference on Smart Applications, Communications and Networking, SmartNets 2025. https://doi.org/10.1109/SmartNets65254.2025.11106790

Schkarin, T., & Dobhan, A. (2022). Prerequisites for Applying Artificial Intelligence for Scheduling in Small- and Medium-sized Enterprises. International Conference on Enterprise Information Systems, ICEIS - Proceedings, 1. https://doi.org/10.5220/0011064000003179

Shah, P., & Chandragade, A. A. (2023). Application of project management tool in construction for Planning, Scheduling and Optimization. Materials Today: Proceedings, 77. https://doi.org/10.1016/j.matpr.2022.11.446

Shalaby, A., & Ezeldin, A. S. (2022). A model for work packages optimization in results-based-finance projects. Engineering, Construction and Architectural Management, 29(7). https://doi.org/10.1108/ECAM-10-2019-0556

Sibiya, A., Sibiya, B., Jordaan, J., & Mahosi, B. N. (2023). Enhancing Project Management for SMEs: A Hybrid Approach. Journal of Management and Entrepreneurship Research, 4(2). https://doi.org/10.34001/jmer.2023.12.04.2-42

Singh, J. (2025). Lean Construction Principles and Practices. In Handbook of Construction Project Management. https://doi.org/10.1007/978-981-96-7631-6_30

Siriwardhana, S. D., Moehler, R. C., & Fang, Y. (2025). Construction 4.0 in Australia: Evaluating technological implementation, organisational adaptation and skills development. Journal of Innovation and Knowledge, 10(6). https://doi.org/10.1016/j.jik.2025.100822

Srinath, P., & Varghese, K. (2023). Identifying and Analysing the Root Causes of Quality Non-Conformance in Construction Project Baseline Schedules. Journal of The Institution of Engineers (India): Series A, 104(2). https://doi.org/10.1007/s40030-023-00713-0

Tembo, M., & Abdullahi, C. M. (2023). Improving the Efficiency and Effectiveness of Construction Project Planning and Scheduling Using Lean Principles. International Journal of Construction Engineering and Management, 2023(3). https://doi.org/10.5923/j.ijcem.20231203.01

Tomczak, M., & Jaśkowski, P. (2024). Customized particle swarm optimization for harmonizing multi-section construction projects. Automation in Construction, 162. https://doi.org/10.1016/j.autcon.2024.105359

Wan, Z., & He, J. (2004). Construction project scheduling problem with uncertain resource constraints. Chinese Journal of Engineering, (70371032). https://doi.org/10.1007/s12205-023-2164-8

Wang, J., Zeng, S., & Ju, J. (2017). Construction Schedule Management Using Resource-Constrained Project Scheduling Model. Tongji Daxue Xuebao/Journal of Tongji University, 45(10). https://doi.org/10.11908/j.issn.0253-374x.2017.10.020

Wang, K., Xu, X., Mao, P., Deng, X., & Cao, D. (2025). Digital transformation and organizational readiness: evidence from Chinese construction SMEs with a dynamic managerial capabilities lens. Engineering, Construction and Architectural Management. https://doi.org/10.1108/ECAM-01-2025-0069

Xie, L., Chen, Y., & Chang, R. (2021). Scheduling optimization of prefabricated construction projects by genetic algorithm. Applied Sciences (Switzerland), 11(12). https://doi.org/10.3390/app11125531

Xu, Z. (2025). Integrating BIM Technology in High-Rise Building Construction: Applications in Deep Foundation Optimization, Slipform Process Control, and Safety Management. Applied and Computational Engineering, 167(1). https://doi.org/10.54254/2755-2721/2025.gl25441

Yang, Y., Pan, M., & Pan, W. (2022). Integrated Offsite Logistics Scheduling Approach for High-Rise Modular Building Projects. Journal of Construction Engineering and Management, 148(6). https://doi.org/10.1061/(asce)co.1943-7862.0002280

Yu, Z., Wang, C., Zhao, Y., Hu, Z., & Tang, Y. (2023). Linear Project-Scheduling Optimization Considering a Reverse Construction Scenario. Applied Sciences (Switzerland), 13(16). https://doi.org/10.3390/app13169407

Zhang, Z., & Xu, J. (2016). Bi-level multiple mode resource-constrained project scheduling problems under hybrid uncertainty. Journal of Industrial and Management Optimization, 12(2). https://doi.org/10.3934/jimo.2016.12.565

Zhao, J., Pikas, E., Seppänen, O., & Peltokorpi, A. (2021). Using Real-Time Indoor Resource Positioning to Track the Progress of Tasks in Construction Sites. Frontiers in Built Environment, 7. https://doi.org/10.3389/fbuil.2021.661166