Melola Discovery

← Melola Discovery

Journal SINTA 3

Risk Analysis of Project Scheduling Using Microsoft Excel

Logic: Jurnal Rancang Bangun dan Teknologi · Vol. 18 No. 3 (2018) · pp. 131–136

DOI
10.31940/logic.v18i3.1135
ISSN
2580-5649, 1412-114X
Published
2018-11-30
Publisher
Pusat Penelitian dan Pengabdian kepada Masyarakat (P3M) Politeknik Negeri Bali
Language
eng

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.

Collaboration network of the authors

26 authors · 59 co-authorship links

Hover or tap a name to highlight its co-authors. Double-click to open the author's page.

  • Politeknik Negeri Bali
  • Affiliation unknown
  • Different organisations
  • Same organisation
  • Affiliation unknown
  • Thicker line = more joint articles · bigger circle = more articles
Show as table
Co-authorOrganisationJoint articles
I Nengah Darma SusilaPoliteknik Negeri Bali3
I Nyoman SutapaPoliteknik Negeri Bali3
I Made TapayasaPoliteknik Negeri Bali3
I Made SudiarsaPoliteknik Negeri Bali2
Ida Bagus WirahajiPoliteknik Negeri Bali2
I Made Anom SantianaPoliteknik Negeri Bali2
I Gede Sastra WibawaPoliteknik Negeri Bali2
I Wayan SuasiraPoliteknik Negeri Bali2
Komang Ayu Triana IndahPoliteknik Negeri Bali1
I Gusti Ayu Astri PramitariPoliteknik Negeri Bali1
I Nyoman ArdikaPoliteknik Negeri Bali1
I Putu Agus KrisnadinataPoliteknik Negeri Bali1
I Nyoman SutarnaPoliteknik Negeri Bali1
I Wayan Darya SupartaPoliteknik Negeri Bali1
I Nyoman RamiaPoliteknik Negeri Bali1
Denin Lintang TuhujatiPoliteknik Negeri Bali1
Fajar Surya HerlambangAffiliation unknown1
Made SudiarsaPoliteknik Negeri Bali1
I Made BudiadiAffiliation unknown1
I Made Suardana KaderAffiliation unknown1
I Wayan SuasiraAffiliation unknown1

Affiliations come from OpenAlex; journal OAI-PMH metadata carries none. Authors without an OpenAlex ID are matched by name, which can merge or split people.

Metadata source: OAI-PMH (metadata jurnal) https://ojs.pnb.ac.id/index.php/LOGIC/oai, first harvested 19 Nov 2026, last seen 19 Nov 2026.
Original metadata (oai_dc)
<oai_dc:dc xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/  http://www.openarchives.org/OAI/2.0/oai_dc.xsd">
	<dc:title xml:lang="en-US">Risk Analysis of Project Scheduling Using Microsoft Excel</dc:title>
	<dc:creator>Suardika, I Nyoman</dc:creator>
	<dc:creator>Suryawan, Kadek Adi</dc:creator>
	<dc:creator>Sutapa, I Ketut</dc:creator>
	<dc:creator>Sudiarta, I Komang</dc:creator>
	<dc:creator>Kader, I Made Suardana</dc:creator>
	<dc:description xml:lang="en-US">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.</dc:description>
	<dc:publisher xml:lang="en-US">Pusat Penelitian dan Pengabdian kepada Masyarakat (P3M) Politeknik Negeri Bali</dc:publisher>
	<dc:date>2018-11-30</dc:date>
	<dc:type>info:eu-repo/semantics/article</dc:type>
	<dc:type>info:eu-repo/semantics/publishedVersion</dc:type>
	<dc:type xml:lang="en-US">Peer-reviewed Article</dc:type>
	<dc:format>application/pdf</dc:format>
	<dc:identifier>https://ojs.pnb.ac.id/index.php/LOGIC/article/view/1135</dc:identifier>
	<dc:identifier>10.31940/logic.v18i3.1135</dc:identifier>
	<dc:source xml:lang="en-US">Logic : Jurnal Rancang Bangun dan Teknologi; Vol 18 No 3 (2018): November; 131-136</dc:source>
	<dc:source>2580-5649</dc:source>
	<dc:source>1412-114X</dc:source>
	<dc:source>10.31940/logic.v18i3</dc:source>
	<dc:language>eng</dc:language>
	<dc:relation>https://ojs.pnb.ac.id/index.php/LOGIC/article/view/1135/884</dc:relation>
	<dc:rights xml:lang="en-US">Copyright (c) 2018 Logic : Jurnal Rancang Bangun dan Teknologi</dc:rights>
</oai_dc:dc>