Risk and uncertainty are factors that construction project managers have been increasingly had to deal with. Project completion time is one of the areas where the expected time is often underestimated or shorter than the actual completion time. Monte Carlo simulation is a widely used simulation technique in modeling a process that is difficult to predict due to its random variables. This study provides a practical way to use Monte Carlo simulation to simulate a project using functions available in a spreadsheet application. A project with five activities was simulated 2000 times using minimum, maximum, and expected duration. The mean, mode, and median simulation results were then plugged into their respective precedence diagram networks to compare them. The precedence diagram computations found that mean, mode, and median project completion times were longer than the initially expected completion time. The mean, mode, and median were 50, 53, and 48 days, respectively, which were 8, 11, and 6 days longer, respectively, than the 42 days initially expected. The study showed that the Monte Carlo simulation could assist the project manager in planning a project schedule that deals with risk and uncertainty more realistically.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
customersupport@researchsolutions.com
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.