Risk Analysis of Project Scheduling Using Microsoft Excel

  • I Nyoman Suardika Politeknik Negeri Bali
  • Kadek Adi Suryawan Politeknik Negeri Bali
  • I Ketut Sutapa Politeknik Negeri Bali
  • I Komang Sudiarta Politeknik Negeri Bali
  • I Made Suardana Kader Politeknik Negeri Bali

Abstract

Scheduling plays a very important role for the successful implementation of construction projects. One of the biggest risks in scheduling is in terms of project costs and duration uncertainty. To anticipate these uncertainties, scheduling methods have been developed using probabilistic duration, including PERT and Monte Carlo Simulation methods. In this research the simulation process was carried out using Microsoft Excel which was integrated with @Risk's add-ins. From the results of the analysis, the project duration obtained from the scheduling model with the CPM method, conventional PERT and Monte Carlo simulation produces an average value that is close to the same. The difference occurs in the standard deviation value, the conventional PERT method produces the smallest standard deviation, followed by a Monte Carlo simulation using the PERT distribution and the last is Monte Carlo simulation using the TRIANGULAR distribution. From the results of the sensitivity analysis, it was found that the dominant input variables that affect the duration of the project are the duration of activities that most often enter the critical path or those that have a great critical index. Meanwhile, project costs are influenced by a combination of the duration of activities on the critical path and activities that have a great direct cost.

Downloads

Download data is not yet available.
Published
Nov 30, 2018
How to Cite
SUARDIKA, I Nyoman et al. Risk Analysis of Project Scheduling Using Microsoft Excel. Logic : Jurnal Rancang Bangun dan Teknologi, [S.l.], v. 18, n. 3, p. 131-136, nov. 2018. ISSN 2580-5630. Available at: <http://ojs.pnb.ac.id/index.php/LOGIC/article/view/1135>. Date accessed: 14 dec. 2018. doi: http://dx.doi.org/10.31940/logic.v18i3.1135.
Section
Articles