Practical Spreadsheet-Based Modelling for Effective Construction Project Scheduling

Authors

  • Dimitrios Kantianis *

    Department of Business Administration, Business School, University of the Aegean, Chios 82132, Greece

DOI:

https://doi.org/10.55121/upc.v3i2.1058

Abstract

Schedule and cost are traditionally considered critical factors in the effective management of construction projects. Particularly, the endemic conflicting relationship between duration and different types of cost and the need for optimal solutions is one of the most demanding problems for construction managers over time. Several commercial software packages along with open-source free to use applications are nowadays available to support project scheduling. However, these specialized software tools do not always seem to offer all the required optimization functions to facilitate the decision-making process, and a practical method is still required that could automatically produce optimal solutions, immediately answer “what-if” questions, and allow managers to conduct time-cost simulations. The paper initially displays the fundamental critical path network analysis and defines the problem of optimizing the project time-cost interrelation. Then, a spreadsheet-based formulation of a linear programming model to solve the time-cost trade-off problem is proposed and its flexible application to a medium-scale real construction project is analyzed. The work demonstrates that project planners in the construction industry can benefit immediately from easily derived rapid solutions at relatively low cost by changing the reference values of critical variables. It is also believed that this practical and automated optimization technique can contribute to the accomplishment of successful decision-making in construction project scheduling. Therefore, the paper aims at motivating construction managers to make more extensive application of spreadsheet modelling in conjunction with the built-in solving add-in algorithms to address complex time-cost trade-off relationships and, in general, to achieve more realistic project simulation and scheduling.

Keywords:

Construction Project, Scheduling, Decision-Making, Mathematical Programming, Spreadsheet Modelling

References

[1] Combley, R. (Ed.), 2011. Cambridge Business English Dictionary. Cambridge University Press: Cambridge, UK.

[2] Fellows, R.F., Langford, D., Newcombe, R., et al., 1983. Construction Management in Practice. John Wiley & Sons: Hoboken, NJ, USA.

[3] Abbasi, A., Jaafari, A., 2018. Evolution of Project Management as a Scientific Discipline. Data and Information Management. 2(2), 91–102.

[4] Kwak, Y.H., Anbari, F.T., 2009. Analyzing Project Management Research: Perspectives from Top Management Journals. International Journal of Project Management. 27(5), 435–446.

[5] Project Management Institute, 2021. A Guide to the Project Management Body of Knowledge, 7th ed. Project Management Institute: Newtown Square, PA, US.

[6] Ngacho, C., Das, D., 2014. A Performance Evaluation Framework of Development Projects: An Empirical Study of Constituency Development Fund (CDF) Construction Projects in Kenya. International Journal of Project Management. 32(3), 492–507. DOI: https://doi.org/10.1016/j.ijproman.2013.07.005

[7] Bassioni, H.A., Price, A.D., Hassan, T.M., 2004. Performance Measurement in Construction. Journal of Management in Engineering. 20(2), 42–50.

[8] Haque, F., Mathur, V.S., 2025. Construction Project Planning and Scheduling. In: Bajaj, D. (Ed.). Handbook of Construction Project Management. Springer: Singapore. pp. 135–187.

[9] Atkinson, R., 1999. Project Management: Cost, Time and Quality, Two Best Guesses and a Phenomenon, It’s Time to Accept Other Success Criteria. International Journal of Project Management. 17(6), 337–342.

[10] Pollack, J., Helm, J., Adler, D., 2018. What Is the Iron Triangle, and How Has It Changed? International Journal of Managing Projects in Business. 11(2), 527–547.

[11] Demeulemeester, E.L., Herroelen, W.S., Elmaghraby, S.E., 1996. Optimal Procedures for the Discrete Time/Cost Trade-Off Problem in Project Networks. European Journal of Operational Research. 88(1), 50–68.

[12] Ammar, M.A., 2011. Optimization of Project Time-Cost Trade-Off Problem with Discounted Cash Flows. Journal of Construction Engineering and Management. 137(1), 65–71.

[13] Al-Zarrad, M.A., Fonseca, D., 2018. A New Model to Improve Project Time-Cost Trade-Off in Uncertain Environments. In: Moynihan, G.P. (Ed.). Contemporary Issues and Research in Operations Management. IntechOpen: London, UK. p. 95.

[14] Dewi, P.F., Kamandang, Z.R., 2023. Optimizing Project Performance by Applying the Crashing Method to Road Construction Project. Advance Sustainable Science Engineering and Technology. 5(2), 0230203.

[15] Jaśkowski, P., Ibadov, N., Biruk, S., et al., 2025. Reactive scheduling of repetitive construction projects by allocating additional resources. Archives of Civil Engineering. 71(4), 561–574.

[16] Lutfi, M.A., Witjaksana, B., Purnama, J., 2025. Cost and Time Analysis of Project Acceleration Using the Crashing Method with Additional Working Hours and Labor. Asian Journal of Social and Humanities. 3(7), 1430–1438.

[17] Liberatore, M.J., Pollack-Johnson, B., Smith, C.A., 2001. Project Management in Construction: Software Use and Research Directions. Journal of Construction Engineering and Management. 127(2), 101–107.

[18] Hamada, M.A., 2023. Investigate the Efficiency of Project Management Software in Construction Projects. The Eurasia Proceedings of Science Technology Engineering and Mathematics. 22, 247–257.

[19] Vanhoucke, M., Vereecke, A., Gemmel, P., 2005. The Project Scheduling Game (PSG): Simulating Time/Cost Trade-Offs in Projects. Project Management Journal. 36(1), 51–59.

[20] LeBlanc, L.J., Grossman, T.A., 2008. Introduction: The Use of Spreadsheet Software in the Application of Management Science and Operations Research. Interfaces. 38(4), 225–227.

[21] Diamant, A., 2024. Introducing prescriptive and predictive analytics to MBA students with Microsoft Excel. INFORMS Transactions on Education. 24(2), 152–174.

[22] Dasović, B., Klanšek, U., 2023. Spreadsheet-Based MINLP Model for Cost-Optimal Construction Project Scheduling. AIP Conference Proceedings. 2887(1), 020019.

[23] Thakkar, J.J., 2022. Project Management: Strategic and Operational Planning. Springer Nature: Singapore.

[24] Lockyer, K.G., 1974. An Introduction to Critical Path Analysis, 3rd ed. Pitman: London, UK.

[25] Burns, S.A., Liu, L., Feng, C.-W., 1996. The LP/IP Hybrid Method for Construction Time-Cost Trade-Off Analysis. Construction Management and Economics. 14(3), 265–276.

[26] Turkoglu, H., Polat, G., Akin, F.D., 2023. Crashing construction projects considering schedule flexibility: An illustrative example. International Journal of Construction Management. 23(4), 619–628.

[27] Bettemir, Ö.H., 2023. Simplified solution of time-cost trade-off problem for building constructions by linear scheduling. Jordan Journal of Civil Engineering. 17(2), 293–309.

[28] Brucker, P., Drexl, A., Möhring, R., et al., 1999. Resource-Constrained Project Scheduling: Notation, Classification, Models and Methods. European Journal of Operational Research. 112(1), 3–41.

[29] Vanhoucke, M., 2013. Project Management with Dynamic Scheduling: Baseline Scheduling, Risk Analysis and Project Control, 2nd ed. Springer: Berlin, Germany.

[30] De Marco, A., 2011. Project Management for Facility Constructions: A Guide for Engineers and Architects. Springer: Berlin, Germany.

[31] Assaf, S.A., Bubshait, A.A., Atiyah, S., et al., 2001. The Management of Construction Company Overhead Costs. International Journal of Project Management. 19(5), 295–303.

[32] Vanhoucke, M., Debels, D., 2007. The discrete time/cost trade-off problem: Extensions and heuristic procedures. Journal of Scheduling. 10, 311–326. DOI: https://doi.org/10.1007/s10951-007-0031-y

[33] Sönmez, R., Bettemir, Ö.H., 2012. A Hybrid Genetic Algorithm for the Discrete Time-Cost Trade-Off Problem. Expert Systems with Applications. 39(13), 11428–11434.

[34] De, P., Dunne, E.J., Ghosh, J.B., et al., 1997. Complexity of the Discrete Time-Cost Tradeoff Problem for Project Networks. Operations Research. 45(2), 302–306.

[35] Moussourakis, J., Haksever, C., 2004. Flexible Model for Time/Cost Trade-Off Problem. Journal of Construction Engineering and Management. 130(3), 307–314.

[36] Williams, T., 2003. The Contribution of Mathematical Modelling to the Practice of Project Management. IMA Journal of Management Mathematics. 14(1), 3–30.

[37] Ahuja, V., Thiruvengadam, V., 2004. Project Scheduling and Monitoring: Current Research Status. Construction Innovation. 4(1), 19–31.

[38] ElSahly, O.M., Ahmed, S., Abdelfatah, A., 2023. Systematic review of the time-cost optimization models in construction management. Sustainability. 15(6), 5578.

[39] Siemens, N., 1971. A Simple CPM Time-Cost Trade-Off Algorithm. Management Science. 17(6), 354–363.

[40] Moselhi, O., 1993. Schedule Compression Using the Direct Stiffness Method. Canadian Journal of Civil Engineering. 20, 65–72.

[41] Agarwal, A.K., Chauhan, S.S., Sharma, K., et al., 2024. Development of time–cost trade-off optimization model for construction projects with MOPSO technique. Asian Journal of Civil Engineering. 25(6), 4529–4539.

[42] Li, H., Love, P., 1997. Using Improved Genetic Algorithms to Facilitate Time-Cost Optimization. Journal of Construction Engineering and Management. 123(3), 233–237.

[43] Hegazy, T., 1999. Optimisation of Resource Allocation and Levelling Using Genetic Algorithms. Journal of Construction Engineering and Management. 125(3). DOI: https://doi.org/10.1061/(ASCE)0733-9364(1999)125:3(167)

[44] Ko, Y., Ngov, K., Choi, H., et al., 2025. Duration-cost optimization in earthmoving operations using NSGA-II and simulation techniques. Journal of Asian Architecture and Building Engineering. 25(2), 1363–1382.

[45] 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. In press. DOI: https://doi.org/10.1108/ECAM-06-2025-1046

[46] Adeli, H., Karim, A., 1997. Scheduling/Cost Optimisation and Neural Dynamics Model for Construction. Journal of Construction Engineering and Management. 123(4), 450–458.

[47] Elbeltagi, E., Hegazy, T., Grierson, D., 2005. Comparison among Five Evolutionary-Based Optimisation Algorithms. Advanced Engineering Informatics. 19(1), 43–53.

[48] Yang, X., Yuan, J., Mao, H., 2007. A Modified Particle Swarm Optimizer with Dynamic Adaptation. Applied Mathematics and Computation. 189(2), 1205–1213.

[49] Ng, S.T., Zhang, Y., 2008. Optimizing Construction Time and Cost Using Ant Colony Optimization Approach. Journal of Construction Engineering and Management. 134(9), 721–728.

[50] Kalhor, E., Khanzadi, M., Eshtehardian, E., et al., 2011. Stochastic Time-Cost Optimisation Using Non-Dominated Archiving Ant Colony Approach. Automation in Construction. 20(8), 1193–1203.

[51] Singh, S., Singh, S., 2022. Time–cost trade-off in a multi-choice assignment problem. Engineering Optimization. 54(4), 576–592.

[52] Toğan, V., Dede, T., Başağa, H.B., 2021. Application of teaching-learning-based optimization on solving of time cost optimization problems. In: Kulkarni, A.J., Siarry, P. (Eds.). Handbook of AI-based Metaheuristics, 1st ed. CRC Press: Boca Raton, FL, USA. DOI: https://doi.org/10.1201/9781003162841

[53] Toğan, V., Said Sulub, A., Azim Eirgash, M., et al., 2026. Project Scheduling to Minimize the Time and Cost in Large-Scale Construction Projects with Repulsion-Based Improved Arithmetic Optimization. Journal of Construction Engineering and Management. 152(3), 04025277.

[54] Kantianis, D., 2020. The Impact of Overheads Variation on Time-Cost Optimisation of Building Infrastructure Projects. European Project Management Journal. 10(2), 18–31.

[55] Foldes, S., Sourmis, F., 1993. PERT and Crashing Revisited: Mathematical Generalizations. European Journal of Operational Research. 64(2), 286–294.

[56] Falk, J.E., Horowitz, J.L., 1972. Critical Path Problems with Concave Cost-Time Curves. Management Science. 19(4), 446–455.

[57] Deckro, R.F., Hebert, J.E., Verdini, W.A., 1995. Nonlinear Time/Cost Tradeoff Models in Project Management. Computers & Industrial Engineering. 28(2), 219–229.

[58] Van Eynde, R., Vanhoucke, M., 2022. A reduction tree approach for the discrete time/cost trade-off problem. Computers & Operations Research. 143, 105750.

[59] Son, P.V.H., Nguyen Dang, N.T., 2023. Solving large-scale discrete time–cost trade-off problem using hybrid multi-verse optimizer model. Scientific Reports. 13(1), 1987.

[60] Kelley, J.E., Walker, M.R., 1959. Critical-Path Planning and Scheduling. In Proceedings of the Eastern Joint IRE-AIEE-ACM Computer Conference, Boston, MA, USA, 1–3 December 1959; pp. 160–173.

[61] Abdullah, K.A., Hassan, W.A.W., Amran, M.F.M., et al., 2012. Implementations of Spreadsheet Modeling for Generalized Critical Path Method. Management Science and Engineering. 6(4), 120–125.

[62] Seal, K.C., 2001. A Generalized PERT/CPM Implementation in a Spreadsheet. INFORMS Transactions on Education. 2(1), 16–26.

[63] Baker, B.M., 2005. Computer-Aided Learning and Assessment for Spreadsheet Modelling of Critical Path Analysis. INFORMS Transactions on Education. 6(1), 3–12.

[64] Ragsdale, C.T., 2003. A New Approach to Implementing Project Networks in Spreadsheets. INFORMS Transactions on Education. 3, 76–85.

[65] Davis, R.E., 2005. A Fast Spreadsheet Implementation of the Critical Path Method. INFORMS Transactions on Education. 5(2). Available from: https://www.sjsu.edu/cob/docs/I-06-004.pdf

[66] Hegazy, T., Ayed, A., 1999. Simplified Spreadsheet Solutions: Models for Critical Path Method and Time-Cost-Tradeoff Analysis. Cost Engineering. 41(7), 26.

[67] Ragsdale, C.T., 2010. Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Management Science, 6th ed. South-Western College Publishing: Mason, OH, US.

[68] Li, K., Shao, B., Zelbst, P., 2012. Project Crashing Using Excel Solver: A Simple AON Network Approach. International Journal of Management & Information Systems. 16(2), 177–182.

[69] Gaspars-Wieloch, H., 2012. Time-Cost Project Management with Solver: Contemporary Issues in Business, Management and Education. Available from: https://ssrn.com/abstract=2257473 (cited 11 August 2025).

[70] Kantianis, D.D., 2023. Construction Project Crashing with Uncertain Correlated Normal and Crash Task Durations and Costs: An Integrated Stochastic Practical Approach. European Project Management Journal. 13(1), 3–22.

[71] Hajdu, M., 2013. Network Scheduling Techniques for Construction Project Management. Springer Science + Business Media B.V.: Dordrecht, The Netherlands.

[72] Cooke, B., Williams, P., 2025. Construction Planning, Programming and Control, 4th ed. Wiley Blackwell: Chichester, UK.

[73] Van de Vonder, S., Demeulemeester, E., Herroelen, W., 2007. A Classification of Predictive-Reactive Project Scheduling Procedures. Journal of Scheduling. 10(3), 195–207.

Downloads

Issue

Vol. 3 No. 2 (November 2025): In Progress

Section

Article