Integration of Mixed-Integer Nonlinear Program and Project Management Tool to Support Sustainable Cost-Optimal Construction Scheduling

Abstract

This paper presents the integration of mixed-integer nonlinear program (MINLP) and project management tool (PMT) to support sustainable cost-optimal construction scheduling. An integrated structure of a high-level system for exact optimization and PMT was created. To ensure data compatibility between the optimization system and PMT and to automate the process of obtaining a cost-optimal schedule, a data transformation tool (DTT) was developed within a spreadsheet application. The suggested system can determine: (i) an optimal project schedule with associated network diagram and Gantt chart in continuous or discrete time units; (ii) optimal critical and non-critical activities, including their early start, late start, early finish, late finish along with total and free slack times; and (iii) minimum total project cost along with the allocation of direct and indirect costs. The system provides functionalities such as: (i) MINLP can be updated, and schedules can be re-optimized; (ii) the optimal schedule can be saved as a baseline to track changes; (iii) different optimization algorithms can be engaged whereby switching between them does not require model changes; (iv) PMT can be used to track task completion in the optimized schedule; (v) calendar settings can be changed; and (vi) visual reports can be generated to support efficient project management. Results of cost-optimal project scheduling are given in a conventional PMT environment, which raises the possibility that the proposed system will be more widely used in practice. Integration of MINLP and PMT allows each software to be used for what it was initially designed. Their combination leads to additional information and features of optimized construction schedules that would be significantly more difficult to achieve if used separately. Application examples are given in the paper to show the advantages of the proposed approach.