Abstract
ABSTRACT The objective of this paper is two folds: one is to present a spreadsheet modeling for project crashing using the Excel Evolutionary Solver because a nonlinear solver will not be reliable due to the presence of unsmooth functions such as MIN(), MAX(), and IF() functions in the forward and backward passes in the critical path identification, and the other is to present a way to enter a single formula and copy it down for the forward pass and backward pass. Although the presence of unsmooth functions undermines the performance of the linear and nonlinear solving method, yet the availability of the Evolutionary solving method in the Microsoft Excel Solver which is suitable for unsmooth functions allows us to build our project management models with the flexibility. This paper presents an efficient spreadsheet model for the optimal crashing for a project which includes both direct and stepwise indirect costs. Keywords PERT/CPM, Excel Solver, Evolutionary Solving Method
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
