Melola Discovery

← Melola Discovery

Jurnal SINTA 3

Risk Analysis of Project Scheduling Using Microsoft Excel

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

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

Abstrak

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.

Jaringan kolaborasi para penulis

26 penulis · 59 tautan kepenulisan bersama

Arahkan kursor atau ketuk sebuah nama untuk menyorot rekan penulisnya. Klik dua kali untuk membuka halaman penulis.

  • Politeknik Negeri Bali
  • Afiliasi tidak diketahui
  • Organisasi berbeda
  • Organisasi sama
  • Afiliasi tidak diketahui
  • Garis lebih tebal = lebih banyak artikel bersama · lingkaran lebih besar = lebih banyak artikel
Tampilkan sebagai tabel
Rekan penulisOrganisasiArtikel bersama
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 HerlambangAfiliasi tidak diketahui1
Made SudiarsaPoliteknik Negeri Bali1
I Made BudiadiAfiliasi tidak diketahui1
I Made Suardana KaderAfiliasi tidak diketahui1
I Wayan SuasiraAfiliasi tidak diketahui1

Afiliasi berasal dari OpenAlex; metadata OAI-PMH jurnal tidak memuatnya. Penulis tanpa ID OpenAlex dicocokkan berdasarkan nama, sehingga dua orang bisa tergabung atau satu orang bisa terpisah.

Sumber metadata: OAI-PMH (metadata jurnal) https://ojs.pnb.ac.id/index.php/LOGIC/oai, pertama di-harvest 19 Nov 2026, terakhir terlihat 19 Nov 2026.
Metadata asli (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>