Logic : Jurnal Rancang Bangun dan Teknologi
Vol 18 No 3 (2018): November

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)



Article Info

Publish Date
30 Nov 2018

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.

Copyrights © 2018






Journal Info

Abbrev

LOGIC

Publisher

Subject

Computer Science & IT Education

Description

Logic : Jurnal Rancang Bangun dan Teknologi is a peer-reviewed research journal aiming at promoting and publishing original high quality research in all disciplines of engineering and applied technology. All research articles submitted to Logic should be original in nature, never previously ...