berdasarkan hasil dari “analis pembangunan embung …repository.untag-sby.ac.id/8740/5/bab...

75

BAB 5KESIMPULAN DAN SARAN

5.1. KESIMPULANBerdasarkan hasil dari “Analisis Konstruksi Tubuh Embung Pada

Pembangunan Embung Kembangan Antara Timbunan Tanah Dan Beton CyclopsDitinjau Terhadap Mutu, Biaya Dan Waktu Pelaksanaan”, didapatkan beberapakesimpuan, antara lain :1. Kualitas konstruksi tubuh embung pada pembangunan Embung Kembangan

dari Timbunan Tanah Dan Beton Cyclops cukup dan memenuhi aspek teknikdan ekonomis serta lingkungan,

2. Nilai biaya dan waktu yang digunakan pada pelaksanaan konstruksi tubuhembung pada pembangunan Embung Kembangan adalah Rp.1,397,132,878.59 untuk biaya dengan kontruksi timbunan dan Rp.1,476,646,727.21 untuk kontruksi beton cyclop, sedangkan waktu yangdibutuhkan untuk pembangunan 126 hari dengan kontruksi timbunan dan274 hari untuk kontruksi beton cyclops,

3. Tingkat efisiensi biaya dan waktu yang digunakan untuk pelaksanaankonstruksi tubuh embung pada pembangunan Embung Kembangan untukbiaya Rp. 79,513,848.62 atau 5,39 % sedangkan dari sisi waktu dapatmempercepat 274 hari – 126 hari = 148 hari

5.2. SARANHasil penelitian ini diharapkan dapat menjadi pedoman untuk analisa

konstruksi tubuh embung pada pembangunan embung antara timbunan tanah danbeton cyclops ditinjau terhadap mutu, biaya dan waktu pelaksanaan pada masayang akan datang.

Untuk bisa penelitian selanjutnya tentang alternative rekayasa nilai padabahan bangunan pada pelimpah embung.

75

76

Halaman ini sengaja dikosongkan

77

DAFTAR PUSTAKA

Ali Basyah Siregar dan Tma Ari Samadhi, Manajemen, 1987.Anjasmoro Bimas, dkk, 2015. Analisis Prioritas Pembangunan Embung Metode

Cluster Analysis AHP dan Weighted Average (Studi Kasus : Embung diKabupaten Semarang).

Bria Melchior, 2017. Analisis Kriteria Untuk Perencanaan Program PemeliharaanEmbung Irigasi

Cholifah Anis Mulyati, 2014. Studi Pengembangan Pemanfaatan Embung KaliajiSebagai Suplai Air Pdam Sleman.

Crum, L. W., DFC, CEng, FRAes, Value engineering: The Organised Search forValue, 1971.

Direktorat Sumber Daya Air Kementerian Pekerjaan Umum. 2013. StandarPerencanaan Irigasi KP02 Bangunan Utama. Jakarta.

Kasiro, Ibnu, dkk. 1994. Pedoman Kriteria Desain Embung Kecil untuk DaerahSemi Kering di Indonesia. Jakarta : PT. Mediatama Saptakarya.

Fatmawati Laily Endah, dkk, 2019. Analisis Stabilitas Bendung Embung Made,Desa Made, Kecamatan Kudu, Kabupaten Jombang.

Hanggara Ikrar, 2019. Analisa Kelayakan Teknis dan Ekonomi Embung PutukrejoKabupaten Malang.

Pujiastuti Indah Tri, 2016. Studi Perencanaan Embung Tegaldlimo KecamatanTegaldlimo Kabupaten Banyuwangi.

RSNI T-01-2002 (Tata Cara Desain Tubuh Bendungan Tipe Urugan)Saaty, 1983. The Analytic Hierarchy Process; Planning, Priority, Setting,

Resource Allocation, University of PittsburghSantoso Muhammad Bagus Hari, 2017. Studi Perencanaan Embung Banyuurip

Kecamatan Kalidawir Kabupaten Tulungagung Provinsi Jawa Timur.Setiyanto Raka, dkk, 2014. Analisis Struktur Bendungan (Studi Kasus Konstruksi

Embung Gamang)Simbolon Bernas, dkk, 2018. Evaluasi Kapasitas Embung Hadudu Daerah Irigasi

Hutabagasan Kabupaten Humbang Hasundutan.SNI 03-1724, 1989. Tata Cara Perencanaan Hidrologi dan Hidraulika untuk

Bangunan di Sungai.Soedibyo. 1993.Teknik Bendungan. PT. Pradnya Paramita. Jakarta.

77

78

60

Soeharto, I. 1995, Manajemen Proyek dari Konseptual Sampai Operasional,Erlangga.

Sosrodarsono, Suyono. 1993.Bendungan Type Urugan. PT. PradnyaParamita.Jakarta

Suripin, 2002. Pelestarian Sumber Daya Tanah dan Air, Andi Offset, YogyakartaWibowo Tedy, 2014. Perencanaan Bendungan Tugu Kabupaten Trenggalek

79

LAMPIRAN

Lampiran 1. Gambar DesainLampiran 2. Rencana Anggaran BiayaLampiran 3. Analisa Kebutuhan Tenaga dan Waktu

PelaksanaanLampiran 4. Analisa KelayakanLampiran 5. Data Tanah

80

60

Lampiran 1.Gambar Desain

81

GAMBAR DESAINTUBUH EMBUNG

DENGAN BETON CYCLOPS

82

60

84

60

86

60

88

60

GAMBAR DESAINTUBUH EMBUNG

DENGAN TIMBUNAN

90

60

92

60

94

60

96

Lampiran 2.Rencana Anggaran Biaya

97

PEKERJAAN : Pembangunan Embung KembanganLOKASI : Kabupaten Trenggalek

No Uraian Satuan KodeHarga

Satuan Dasar(Rp)

1 2 3 4 5I UPAH KERJA1 Pekerja OH 66,7682 Tukang Batu OH 92,7693 Tukang Kayu OH 92,7694 Tukang Besi OH 92,7695 Tukang Cat OH 92,7696 Tukang Aspal OH 93,8397 Kepala Tukang OH 109,8898 Mandor OH 104,2189 Juru ukur OH 86,50010 Operator alat berat OH 128,07911 Pembantu Operator OH 81,53412 Pembantu Juru Ukur & operator / mekanik alat berat OH 75,000

II BAHAN / MATERIALA KELOMPOK AIR, TANAH, BATU DAN SEMEN1 Air lt 602 Batu Kali m3 210,3503 Batu Bata bh 8564 Bata Berongga m3 175,0005 Batu pecah 2/3 m3 233,3006 Pasir Beton m3 225,4507 Pasir Pasang m3 193,2428 Pasir Urug m3 117,0009 Paving Stone 8 cm m² 78,64510 Portland Cement 50 Kg zak 90,95011 Portland Cement 50 Kg (warna) zak 125,00012 Paving Block 8 cm m2 75,00013 Keramik 30 x 30 cm Dos 125,00014 Keramik Dinding 10 x 20 cm bh 2,75015 Asbes Sement m2 25,50016 Genteng Karangpilang bh 7,50017 Genteng Bubung bh 6,500

B KELOMPOK KAYU1 Kayu Balok Lokal 5/7 cm m3 1,500,000.002 Kayu Reng 3/4 cm m3 1,600,000.003 Triplex 4 mm lbr 125,000.004 Multiplex 12 mm lbr 175,000.005 Papan Kayu m3 1,650,000.00

C KELOMPOK LOGAM1 Baja Tulangan U 24 (besi beton biasa) Polos kg 20,700.002 Kawat Beton / Bendrat kg 17,600.003 Paku Biasa 4 cm - 7 cm kg 19,000.004 Paku 10 cm kg 17,500.005 Paku 12 cm kg 18,000.006 Paku Triplex kg 17,500.007 Paku Asbes Gelombang kg 27,000.008 Kawat Bronjong dia 3 mm pabrikasi (0.5 x 1.0 x 3.0) kg 22,500.009 Besi Strip 5 mm kg 21,500.00

Daftar Harga Satuan Dasar Upah Kerja, Bahan dan AlatKelompok 3 (Kabupaten Trenggalek)

98

60

III KELOMPOK PERALATAN1 Molen (Concrete Mixer 0.35 m3) Sewa/hari 150,000.002 Jack Hammer Sewa/hari 125,000.003 Tripod Tinggi 7 m Sewa/hari 175,000.0045 LAIN - LAIN6 Minyak Begesting Ltr 7,500.007 Bensin Ltr 6,450.008 Solar Non Subsidi Ltr 7,200.009 Minyak Pelumas Ltr 37,500.0010 Lem Kayu kg 5,500.0011 Cat menie kg 25,000.0012 Plamuur kg 22,500.0013 Cat Dasar kg 27,500.0014 Cat Penutup kg 35,000.0015 Kuas bh 3,500.0016 Pengencer ltr 27,000.0017 Amplas bh 750.0018 Gate Valve 8" bh 135,500.0019 Pipa PVC 8" M' 112,500.0020 Pipa HDPE 8" M' 225,000.0021 Pipa Gavanis 4" M' 235,000.0022 Pipa GIP Ø 63 mm M' 125,000.0023 Asbes Gelombang Lbr 175,000.0024 Pintu Double Teakwood M2 125,000.0025 Kloset Jongkok unit 750,000.0026 Gebalan Rumput M2 17,500.0

99

JENIS PEKERJAAN : Galian Tanah dengan ExcavatorHasil Galian dimuat Dump Truck dibuang keluar

SATUAN PEMBAYARAN : m3

I. ASUMSI :1. Jam Kerja Efektif per hari Tk 7.00 Jam2. Faktor Pengembangan Tanah Fk 1.203. Jarak Angkut L 0.05 Km4. Tahapan Kerja :

a. Excavator menggali tanah di Sungai Kemudian dimuat kedalam Dump Truckb. Dump Truck memuat hasil galian ke Lokasi pekerjaan

II. ALAT :1. Excavator Long Arm

( Kedalaman ≥ 4 m- Kapasitas Bucket V 0.60 m3 Daya 120 HP

Berat Operasi 13 ton- Faktor Bucket Fb 1.00 Kondisi Operasi Sedang,

tanah Biasa- Faktor Efisiensi Alat Fa 0.75 Pemeliharaan Mesin Baik

- Menggali d > 4 m, Swing dan muat T. 1 0.55 menitke Dumptruck

- Swing kembali dan lain - lain T. 2 0.33 menit Swing 90° + Lain - lain 8sTs. 1 0.88 menit

- Q. 1 25.57 m3/jam

- Koefisien Alat/ m3 = 1 / Q.1 0.0391 jam

2. Dump Truck- Kapasitas Bak V 4.00 m3- Faktor Efisiensi Alat Fa 0.80 Kondisi Kerja Sedang- Kecepatan Rata2 bermuatan V.1 20.00 km/jam- Kecepatan Rata2 kosong V.2 30.00 km/jam

- Waktu Tempuh Isi = ( L : V.1 ) x 60 T.1 0.15 menit- Waktu Tempuh kosong = ( L : V.2 ) x 60 T.2 0.10 menit- Muat = ( V : Q.1 ) x 60 T.3 9.39 menit- Lain - lain T.4 1.00 menit

Waktu Siklus Ts. 2 10.64 menit

- Q. 2 15.04 m3/jam

- Koefisien Alat/ m3 = 1 / Q.2 0.066 jam

3. Tenaga :Produksi yang menentukanExcavator Q. 1 25.57 m3/jamProduksi/ hari = Tk x Q.1 Q. 1' 178.98 m3/hariKebutuhan Tenaga :Pekerja : P 4.00 orangMandor : M 0.50 orang

Koefisien Tenaga/ m3 :Pekerja = ( Tk x P ) : Q.1' 0.156 jamMandor = ( Tk x M ) : Q.1' 0.020 jam

ANALISA PRODUKSI ALAT BERAT

Agak Sulit + Swing 7s +Muat 7s

Kap. Produksi / jam = ( V x Fb x Fa x 60 )/ (Ts.1 x Fk )

Kondisi menanjak jalanrusak

Kap. Produksi/ jam = ( V x Fa x 60 ) / ( Ts.2 xFk )

No. URAIAN : KODE KOEFISIEN SATUAN KETERANGAN :

100

60

JENIS PEKERJAAN : PemadatanSATUAN PEMBAYARAN : m3

I. ASUMSI :1. Jam Kerja Efektif per hari Tk 7.00 Jam2. Faktor Pengembangan Tanah Fk 1.203. Faktor Tanah lepas Fk1 1.004. Tahapan Kerja :

a.

b.

c.

II. ALAT :a. Bulldozer 100 - 150 HP

Jarak Gusur D 50.00 m'Lebar Blade Lb 3.415 m' Bulldozer D.65 E - 8Tinggi Blade Tb 1.15 m'Faktor Blade Fb 0.80 Penggusuran SedangKecepatan

- Maju : Kecepatan sesuai0,75 x 4,5 km/ jam = 3,4 km/ jam F 56.67 m/ menit Spesifikasi Alat

- Mundur :0,85 x 8,2 km/ jam = 6,97 km/ jam R 116.17 m/ menitWaktu ganti Persneling Z 0.15 menitFaktor Efisiensi Alat E 0.75 Kondisi Kerja SedangKap. Per Siklus = Tb² x Lb x Fb q 3.61 m³Waktu Siklus = D/F + D/R + Z Ts 1.46 menit

Produksi Menggusur Alat =( q x 60 x E x Fk1 ) / Ts Q2 111.16 m³ Kupas = Gusur

Produksi Perataan Alat = Q3 40.61 m³ Overlap 10% x Lebar( q x 60 x E x Fk1 ) / 2 x Ts( diperlukan 2 kali bolak balik )

Koefisien Alat/ m3 = 1/Q3 0.025 jam

b. Water Tank Truck 3000 - 4500 LVolume Tangki Air V 4.00 m³Kebutuhan Air/ m3 material padat Wc 0.07 m³Pengisian Tangki/ jam n 3.00 kaliFaktor Efisien Alat Fa 0.75 baikProduksi/ jam = ( V x n x Fa )/ Wc Q4 128.57 m³Koefisien Alat/ m3 = 1/ Q4 0.0078 jam

c. Roller Vibro 5 - 8 tonLebar Drum W1 2.20 mKecepatan maju/ mundur V 1.50 km/jamTebal Pemadatan H 0.20 mJumlah Lintasan per lapis N 8 kaliEfisiensi Kerja E 0.75 baik

Lebar Efektif = 0,20 - 2,20 m W 2.00 mPruduksi/ jam = ( W x V x H x 1000 x E )/ N Q5 56.250 m3/jamKoefisien Alat/ m3 = 1/Q5 0.0178 Jam

Bulldozer menghampar dan meratakanTanah Tanah disiram air menggunakan WaterTanker Truck Kemudian dipadatkan dengan VibratoryRoller

No. URAIAN : KODE KOEFISIEN SATUAN KETERANGAN :

101

III. TENAGA :Produksi yang menentukan :Vibro Roller Q5 56.250 m3/jamProduksi/ hari = Tk x Q.5 Q1 393.75 m3/ hariKebutuhan Tenaga :

- Pekerja P 8.00

- Mandor M 0.80 Angkut 50 m' 2 - 3 m3/ OH

Koefisien Tenaga / m3 :- Pekerja = ( Tk x P ) : Q.1 0.1422 jam- Mandor = ( Tk x M ) : Q.1 0.0142 jam

Bantu Perataan 30 - 50m3/ OH

: Excavator, Dump truck, Buldozer: Rupiah/ Jam

A. URAIAN PERALATAN :1 Jenis Peralatan Excavator Dump Truck Buldozer Roller Vibro Water Tank Truck

( Long Arm )2 Merk/ Tipe 80 - 140 HP 3 - 4 m³ 100 - 150 HP 5 - 8 Ton 3000 - 4500 L3 Tenaga Pw HP 133.00 100.00 150.00 82.00 100.004 Kapasitas Cp 0.60 3.50 - 7.1 40005 Umur Ekonomis A Tahun 5.00 5.00 5.00 5.00 5.006 Jam Operasi dalam 1 Tahun W Jam 2000 2000 2000 2000 20007 Harga Alat B Rp. 900,000,000 368,750,000 2,875,000,000 1,495,000,000 310,500,000

B. BIAYA PASTI PERJAM KERJA :1 Nilai Sisa Alat C Rp. 90,000,000 36,875,000 287,500,000 149,500,000 31,050,000 Suku Bunga

Faktor Angsuran Modal D - 0.2638 0.2638 0.2638 0.2638 0.2638 i = 10 %

2 Biaya Pasti Per jama. Biaya Pengembalian Modal E Rp/jam 106,837.98 43,773.89 341,287.99 177,469.76 36,859.10b. Asuransi, dll. F Rp/jam 900.00 368.75 2,875.00 1,495.00 310.50 Asuransi

p = 0,2 %Biaya Pasti Per jam G = E + F Rp/jam 107,737.98 44,142.64 344,162.99 178,964.76 37,169.60

C. BIAYA OPERASI PERJAM KERJA :1 Bahan Bakar H Rp/jam 114,912.00 86,400.00 129,600.00 70,848.00 86,400.00 12%2 Pelumas I Rp/jam 124,687.50 93,750.00 140,625.00 76,875.00 93,750.00 2.5%

Biaya Bengkel J Rp/jam 28,125 11,523 89,844 46,719 9,703 6.25%3 Perawatan & Perbaikan K Rp/jam 56,250 23,047 179,688 93,438 19,406 12.5%4 Operator M Rp/jam 18,297.00 18,297.00 18,297.00 18,297.00 18,297.005 Pembantu Operator L Rp/jam 10,714.29 10,714.29 10,714.29 10,714.29 10,714.29

Biaya Operasi ( per jam ) P Rp/jam 352,985.79 243,731.60 568,767.54 316,890.54 238,270.66

D. BIAYA OPERASI ALAT/ JAM S Rp/jam 460,723.77 287,874.24 912,930.53 495,855.29 275,440.26

E. LAIN - LAIN1 Bahan Bakar Premium Mb Liter 6,450.00 6,450.00 6,450.00 6,450.00 6,450.002 Bahan Bakar Solar Ms Liter 7,200.00 7,200.00 7,200.00 7,200.00 7,200.003 Minyak Pelumas Mp Liter 37,500.00 37,500.00 37,500.00 37,500.00 37,500.00

Permen PU. No. 28/PRT/M/2016

Keterangan

JENIS ALATSATUAN PEKERJAAN

ANALISA OPERASI BIAYA ALAT BERATGALIAN TANAH DI SUNGAI

Uraian Pekerjaan :No. Kode Satuan Perhitungan Biaya Operasi Peralatan

102

60

TM. 04a.2. 1 m3 Galian tanah sedalam 2 - 4 m ( dipakai Alat Berat )

1 2 3 4 5 6 7A Tenaga Kerja1 Pekerja L.01 OH 0.1633 66,768.00 10,903.212 Mandor L.04 OH 0.0163 104,218.00 1,701.88

12,605.09B Bahan

-C Peralatan

Excavator (Long Arm) jam 0.0393 485,395.27 19,076.0319,076.03

D Jumlah Harga tenaga, Bahan dan Peralatan (A+B+C) 31,681.13E 15% x D 4,752.17F 36,433.30


TM. 04c. 1 m3 Pemadatan Tanah di Lokasi Pekerjaan


10,976.39B Bahan

-C Peralatan1 Bulldozer jam 0.0200 940,755.53 18,815.112 Water Tank Truck jam 0.0078 293,990.26 2,293.123 Roller Vibro jam 0.0178 511,066.29 9,096.98

30,205.21D Jumlah Harga tenaga, Bahan dan Peralatan (A+B+C) 41,181.60E 15% x D 6,177.24F 47,358.84


1 m3 Timbunan tanah atau urugan tanah kembali


25,472.63B Bahan

-C Peralatan

-D Jumlah Harga tenaga, Bahan dan Peralatan (A+B+C) 25,472.63E 15% x D 3,820.90F 29,293.53

Jumlah(Rp)

Jumlah(Rp)

Jumlah Harga Tenaga Kerja

Kode Satuan Koefisien

Jumlah Harga Peralatan

Overhead + Profit (Contoh 15%)

Kode Satuan Koefisien Harga Satuan(Rp)

Jumlah Harga Bahan

Satuan Koefisien Harga Satuan(Rp)

Harga Satuan Pekerjaan per - m3 (D+E)

No Uraian

ANALISA HARGA SATUAN PEKERJAAN

Jumlah(Rp)


Jumlah Harga Bahan


Overhead + Profit (Contoh 15%)Harga Satuan Pekerjaan per - m3 (D+E)

No Uraian Kode


Harga Satuan(Rp)


Jumlah Harga Bahan



No Uraian

103

P. 12a. 1 m2 Penanaman Gebalan Rumput


7,718.98B Bahan1 Gebalan Rumput m2 1.10 17,500.00 19,250.00

19,250.00C Peralatan

-D Jumlah Harga tenaga, Bahan dan Peralatan (A+B+C) 26,968.98E 15% x D 4,045.35F 31,014.33


B. 07b. 1 m3 beton mutu, f’c = 19,3 MPa (K225), slump (12±2) cm, w/c = 0,58( Menggunakan Molen )

1 2 3 4 5 6 7A Tenaga Kerja1 Pekerja L.01 OH 1.323 66,768.00 88,334.062 Tukang batu L.02 OH 0.189 92,769.00 17,533.343 Kepala tukang L.03 OH 0.019 109,889.00 2,087.894 Mandor L.04 OH 0.132 104,218.00 13,756.78

121,712.07B Bahan1 PC / Portland Cement M.15 kg 371.0 1,819.00 674,849.002 PB / Pasir Beton M.14.a kg 698.00 163.37 114,031.963 Kr / Krikil 2/3 M.12 kg 1,047.00 166.64 174,475.074 Air M.02 Ltr 215.0 60.00 12,900.00

976,256.03C Peralatan1 Molen E.28.b Sewa-hari 0.250 150,000.00 37,500.00

37,500.00D Jumlah Harga Tenaga Kerja, Bahan dan Peralatan (A+B+C) 1,135,468.10E 170,320.21F 1,305,788.31


A.3.2.1.10 1 m3 Beton Cyclop, 60% Beton (1Pc : 2Psr : 3Kr) & 40% Batu belah

1 2 3 4 5 6 7A Tenaga Kerja1 Pekerja L.01 OH 3.400 66,768.00 227,011.202 Tukang batu L.02 OH 0.850 92,769.00 78,853.653 Kepala tukang L.03 OH 0.085 109,889.00 9,340.574 Mandor L.04 OH 0.170 104,218.00 17,717.06

332,922.48B Bahan

Batu Belah M3 0.480 210,350.00 100,968.00PC / Portland Cement M.15 kg 194.000 1,819.00 352,886.00PB / Pasir Beton M.14.a M3 0.312 225,450.00 70,340.40Kr / Krikil 2/3 M.12 M3 0.468 233,300.00 109,184.40Air M.02 Ltr 215.00 60.00 12,900.00


-D Jumlah Harga Tenaga Kerja, Bahan dan Peralatan (A+B+C) 979,201.28E 146,880.19F 1,126,081.47



Uraian


Jumlah(Rp)

Jumlah(Rp)


KoefisienKode


No Uraian Kode Satuan Koefisien Harga Satuan(Rp)


Jumlah Harga Bahan


Harga Satuan(Rp)

Harga Satuan Pekerjaan per - m3



Jumlah Harga Bahan


Overhead + Profit (Contoh 15%) 15% x D

Jumlah(Rp)

Harga Satuan Pekerjaan per - m315% x DOverhead + Profit (Contoh 15%)

SatuanNo

Jumlah Harga Bahan

104

60

B. 17A. 100 Kg untuk Pembesian Dinding/ Plat

1 2 3 4 5 6 7A Tenaga Kerja1 Pekerja L.01 OH 0.70 66,768.00 46,737.602 Tukang Besi L.02 OH 0.70 92,769.00 64,938.303 Kepala tukang L.03 OH 0.07 109,889.00 7,692.234 Mandor L.04 OH 0.07 104,218.00 7,295.26

126,663.39B Bahan1 Besi Beton Polos/ Ulir kg 105.00 20,700.00 2,173,500.002 Kawat Beton kg 1.50 17,600.00 26,400.00

2,199,900.00C Peralatan

-D Jumlah Harga Tenaga Kerja, Bahan dan Peralatan (A+B+C) 2,326,563.39E 348,984.51F 26,755.48


B. 25b. 1 m2 Bekisting Dinding beton biasa dengan multiflex 12 mm atau 18 mm (TP)

1 2 3 4 5 6 7A Tenaga Kerja1 Pekerja L.01 OH 0.240 66,768.00 16,024.322 Tukang kayu L.02 OH 0.120 92,769.00 11,132.283 Kepala tukang L.03 OH 0.012 109,889.00 1,318.674 Mandor L.04 OH 0.024 104,218.00 2,501.23

30,976.50B Bahan1 Multiflex 12 mm M.38.d lbr 0.128 175,000.00 22,400.002 Kaso 5/7 cm m3 0.005 2,500,000.00 12,500.003 Paku 5 cm dan 7 cm M.65.b kg 0.240 19,000.00 4,560.004 Minyak bekisting M.129 L 0.200 7,500.00 1,500.00


D Jumlah Harga Tenaga Kerja, Bahan dan Peralatan (A+B+C) 71,936.50E 15% x D 10,790.48F 82,726.98


LA. 02 1 M² Pembuatan Direksi Keet

1 2 3 4 5 6 7A Tenaga Kerja1 Pekerja L.01 OH 1.200 66,768.00 80,121.602 Tukang Batu L.02 OH 0.400 92,769.00 37,107.603 Kepala Tukang L.03 OH 0.040 109,889.00 4,395.564 Mandor L.04 OH 0.120 104,218.00 12,506.16

134,130.92B Bahan1 Kaso 5/7 M3 0.750 2,500,000.00 1,875,000.002 Triplex 4 mm Lbr 1.000 125,000.00 125,000.006 Asbes Gelombang Lbr 0.300 175,000.00 52,500.007 Paku Asbes Kg 0.100 27,000.00 2,700.009 Pintu Double Teakwood M2 0.100 125,000.00 12,500.00


D Jumlah Harga Tenaga Kerja, Bahan dan Peralatan (A+B+C) 2,201,830.92E 15% x D 330,274.64F 2,532,105.56


Overhead + Profit (Contoh 15%)Harga Satuan Pekerjaan per - m2 (D+E)

15% x DHarga Satuan Pekerjaan per - kg

Jumlah Harga Bahan






Jumlah(Rp)


Jumlah Harga Bahan


Jumlah(Rp)

Jumlah(Rp)


Jumlah Harga Bahan


Overhead + Profit (Contoh 15%)Harga Satuan Pekerjaan per - m' (D+E)


105

1 m3 beton bertulang mutu, f’c = 19,3 MPa (K225), slump (12±2) cm, w/c = 0,58( Menggunakan Molen )

1 2 3 4 5 6 7A Tenaga Kerja1 -

-B Bahan1 Besi Beton Polos/ Ulir kg 100.00 26,755.48 2,675,547.902 Beton K225 m3 1.00 1,126,081.47 1,126,081.47


-D 3,801,629.36

Satuan

Jumlah Harga Bahan

Uraian Kode Jumlah(Rp)Koefisien Harga Satuan

(Rp)

Jumlah Harga PeralatanHarga Satuan Pekerjaan per - m3


No

106

60

108

60

110

60

112

60

Gal. Tnh. Berbatu Gal. Tnh. Biasa Timbunan Beton Cyclop Bekesting( M3 ) ( M3 ) ( M3 ) ( M3 ) ( M2 )

I. Potongan 1 :

1. Galian Tanah Biasa :L = 7.50 m

x 7.50 = 150.45

2. Timbunan :

x 7.50 = 188.025

- 150.450 188.025 - -

PERHITUNGAN VOLUME EMBUNG KEMBANGAN

No. SKET & PERHITUNGAN :

20.06

25.07

113

Gal. Tnh. Berbatu Gal. Tnh. Biasa Timbunan Beton Cyclop Beton Tulang( M3 ) ( M3 ) ( M3 ) ( M3 ) ( M3 )

II. Potongan 2 :


x 7.50 = 150.45

2. Timbunan :

x 7.50 = 262.125

- 150.450 262.125 - -


20.06

34.95


III. Potongan 3 :


x 7.50 = 1,255.88

2. Timbunan :

x 7.50 = 1,963.950

- 1,255.875 1,963.950 - -


167.45

261.86

114

60


IV. Potongan 4 :


x 7.00 = 1,038.45

2. Timbunan :

x 7.00 = 3,821.160

- 1,038.450 3,821.160 - -


148.35

545.88


V. Potongan 5 :


x 6.00 = 826.98

2. Timbunan :

x 6.00 = 1,810.500

- 826.980 1,810.500 - -


137.83

301.75

115


VI. Potongan 6 :


x 6.00 = 355.14

2. Timbunan :

x 6.00 = 603.420

- 355.140 603.420 - -


59.19

100.57


VII. Potongan 7 :


x 6.00 = 128.34

2. Timbunan :

x 6.00 = 230.640

- 128.340 230.640 -


21.39

38.44

116

60


VIII. Beton Bertulang

1. Beton bertulang (Penutup Hulu)a. Balok 15/25

L = 440.59 m

x 440.59 = 16.522125

b. Balok 20/30L = 48.68 m

x 48.68 = 2.9208

c. Plat beton t = 10 cmLuas = 656.59 m

x 656.59 = 65.65915

- - - 85.102


0.04

0.10

0.06

117

Nama Pekerjaan : Pembangunan Embung KembanganLokasi : Kabupaten Trenggalek

Harga Sat. Jumlah Harga

( Rp. ) ( Rp. )

A Pekerjaan Persiapan :1 Mobilisasi & Demobilisasi Ls 1.00 6,000,000.00 6,000,000.002 Pembuatan Direksi Keet M² 9.00 1,669,605.56 15,026,450.023 Pekerjaan Pengukuran Ls 1.00 2,500,000.00 2,500,000.00

Sub Jumlah A 23,526,450.02

B Pekerjaan Tubuh Embung1 Galian Tanah Biasa (Mekanis) M3 1,701.34 35,078.38 59,680,410.873 Timbunan Tanah dari Galian M3 1,701.34 29,293.53 49,838,381.694 Perataan & Pemadatan Tanah M3 2,709.09 51,080.06 138,380,479.315 Timbunan Tanah dari luar M3 1,007.75 64,371.91 64,870,514.636 Beton Cyclop M3 988.53 1,126,081.47 1,113,159,681.427 Begisting M² 422.75 75,951.89 32,108,663.088 Gebalan Rumput M² 600.00 31,014.33 18,608,596.20

Sub Jumlah B 1,476,646,727.21

C Pekerjaan Pelimpah1 Galian Tanah Biasa (Mekanis) M3 6,903.93 35,078.38 242,178,656.362 Beton Cyclop M3 8,583.02 1,126,081.47 9,665,181,593.233 Beton mutu K-225 M3 307.93 1,305,788.31 402,087,452.344 Pembesian Kg 32,795.86 26,755.48 877,468,892.695 Begisting M² 502.36 75,951.89 38,155,193.346 Pasangan Bronjong M3 218.00 982,636.95 214,214,855.847 Pas. Batu Bata 1Pc : 4Psr M3 2.30 1,075,630.12 2,478,251.80

Sub Jumlah C 11,441,764,895.60

D Pekerjaan Lain-lain1 Pemas. Pipa HDPE ɸ 8" M' 195.00 277,069.02 54,028,458.002 Pemas. Pipa Galvanis ɸ 4" M' 15.00 429,977.73 6,449,665.953 Pemas. Pipa Sandaran Jembatan M' 43.20 228,224.60 9,859,302.924 Pemas. Gate Valve Ø 8" unit 1.00 399,354.36 399,354.365 Paving Block 8 Cm M² 80.00 104,269.95 8,341,596.306 Rumah Jaga unit 1.00 435,388,633.25 435,388,633.25

Sub Jumlah D 514,467,010.78

Jumlah 13,456,405,083.62Jumlah Dibulatkan 13,456,405,000.00PPN 10% 1,345,640,500.00Jumlah Total 14,802,045,500.00

Jumlah Total Dibulatkan 14,802,045,000.00

RENCANA ANGGARAN BIAYA (RAB)KOSTRUKSI TUBUH EMBUNG DENGAN CYCLOPS

No. Uraian Pekerjaan : Sat. Volume

118

60


Harga Sat. Jumlah Harga

( Rp. ) ( Rp. )

A Pekerjaan Persiapan :1 Mobilisasi & Demobilisasi Ls 1.00 6,000,000.00 6,000,000.002 Pembuatan Direksi Keet M² 9.00 1,669,605.56 15,026,450.023 Pekerjaan Pengukuran Ls 1.00 2,500,000.00 2,500,000.00

Sub Jumlah A 23,526,450.02

B Pekerjaan Tubuh Embung1 Galian Tanah Biasa (Mekanis) M3 3,905.69 35,078.38 137,005,115.203 Timbunan Tanah dari Galian M3 3,905.69 29,293.53 114,411,297.204 Perataan & Pemadatan Tanah M3 8,879.82 51,080.06 453,581,728.605 Timbunan Tanah dari luar M3 4,974.14 64,371.91 320,194,582.136 Beton bertulang mutu K-225 M3 85.10 3,801,629.36 323,526,547.327 Begisting M² 249.50 75,951.89 18,949,997.498 Gebalan Rumput M² 950.00 31,014.33 29,463,610.65

Sub Jumlah B 1,397,132,878.59

C Pekerjaan Pelimpah1 Galian Tanah Biasa (Mekanis) M3 6,903.93 35,078.38 242,178,656.362 Beton Cyclop M3 8,583.02 1,126,081.47 9,665,181,593.233 Beton mutu K-225 M3 307.93 1,305,788.31 402,087,452.344 Pembesian Kg 32,795.86 26,755.48 877,468,892.695 Begisting M² 502.36 75,951.89 38,155,193.346 Pasangan Bronjong M3 218.00 982,636.95 214,214,855.847 Pas. Batu Bata 1Pc : 4Psr M3 2.30 1,075,630.12 2,478,251.80

Sub Jumlah C 11,441,764,895.60

D Pekerjaan Lain-lain1 Pemas. Pipa HDPE ɸ 8" M' 195.00 277,069.02 54,028,458.002 Pemas. Pipa Galvanis ɸ 4" M' 15.00 429,977.73 6,449,665.953 Pemas. Pipa Sandaran Jembatan M' 43.20 228,224.60 9,859,302.924 Pemas. Gate Valve Ø 8" unit 1.00 399,354.36 399,354.365 Paving Block 8 Cm M² 80.00 104,269.95 8,341,596.306 Rumah Jaga unit 1.00 435,388,633.25 435,388,633.25

Sub Jumlah D 514,467,010.78

Jumlah 13,376,891,235.00Jumlah Dibulatkan 13,376,891,000.00PPN 10% 1,337,689,100.00Jumlah Total 14,714,580,100.00

Jumlah Total Dibulatkan 14,714,580,000.00

RENCANA ANGGARAN BIAYA (RAB)KOSTRUKSI TUBUH EMBUNG DENGAN TIMBUNAN

No. Uraian Pekerjaan : Sat. Volume

119

Lampiran 3.Analisa Kebutuhan Tenaga

dan Waktu Pelaksanaan

120

60


Persatuan Jumlah Produk/hari Jumlah hari

1 Galian Tanah Biasa (Mekanis) M3 3,905.69 0.18 687 178.00 223 Timbunan Tanah dari Galian M3 3,905.69 0.36 1,418 394.00 104 Perataan & Pemadatan Tanah M3 8,879.82 0.16 1,389 394.00 235 Timbunan Tanah dari luar M3 4,974.14 0.54 2,681 394.00 136 Beton bertulang mutu K-225 M3 85.10 3.20 273 5.00 177 Begisting M² 249.50 0.36 91 10.00 258 Gebalan Rumput M² 950.00 0.11 105 55 17

6,643 126


Persatuan Jumlah Produk/hari Jumlah hari

1 Galian Tanah Biasa (Mekanis) M3 1,701.34 0.18 299 178.00 103 Timbunan Tanah dari Galian M3 1,701.34 0.36 618 394.00 44 Perataan & Pemadatan Tanah M3 2,709.09 0.16 424 394.00 75 Timbunan Tanah dari luar M3 1,007.75 0.54 543 394.00 36 Beton Cyclop M3 988.53 4.51 4,453 5.00 1987 Begisting M² 422.75 0.36 153 10.00 428 Gebalan Rumput M² 600.00 0.11 66 55 11

6,557 274

Volume

KOSTRUKSI TUBUH EMBUNG DENGAN CYCLOPS

KEBUTUHAN TENAGA DAN WAKTU PELAKSANAANKOSTRUKSI TUBUH EMBUNG DENGAN TIMBUNAN

KEBUTUHAN TENAGA DAN WAKTU PELAKSANAAN

Jumlah

Kebutuhan Tenaga

Waktu Pelaksanaan

Waktu PelaksanaanNo. Uraian Pekerjaan : Sat. Volume

Kebutuhan Tenaga

Jumlah

No. Uraian Pekerjaan : Sat.

121

Lampiran 4.Analisa Kelayakan

122

60

No. Satuan Harga (Rp)

I. Bibit1 Padi Kg 7,500.002 Jagung Kg 6,000.003 Kedelai Kg 8,400.004 Kacang Tanah Kg 9,000.00

II Pupuk1 Urea Kg 4,000.002 T S P Kg 3,400.003 K C L Kg 4,600.004 Z A Kg 2,800.00

III Pestisida1 Diazinon lt 100,000.002 Matador lt 80,000.003 Racumin Ons 70,000.004 Gramoxone lt 80,000.00

IV Tenaga1 Persemaian Org/Hr 75,000.002 Penyiapan Lahan :

a. Tenaga kerja Org/Hr 75,000.00b. Tenaga Hewan Pas/Hr 75,000.00c. Tenaga Traktor Ha 500,000.00

3 Penanaman Org/Hr 75,000.004 Pemeliharaan Org/Hr 75,000.005 Panen Org/Hr 75,000.006 Pasca Panen Org/Hr 75,000.00

V Sewa Tanah Ha/th 5,000,000.00

VI Hasil Produksi1 Padi Kg 5,000.002 Jagung Kg 4,000.003 Kedelai Kg 5,600.004 Kacang Tanah Kg 6,000.005 Tebu Kg 600.00

Uraian

Harga Satuan Bahan dan UpahDi Kabuapten Trenggalek

123

RATA-RATA KEBUTUHAN SARANA PRODUKSI DANTENAGA KERJA UNTUK TANAMAN UTAMA

Saprodi Nilai (Rp.) Saprodi Nilai (Rp.) Saprodi Nilai (Rp.) Saprodi Nilai (Rp.)

I. Sarana Produksi :1 Bibit

a. Padi Kg/Ha 7,500.00 20.00 150,000.00 - - - - - -b. Jagung Kg/Ha 6,000.00 - - 25.00 150,000.00 - - - -c. Kedelai Kg/Ha 8,400.00 - - - - 15.00 126,000.00 - -d. Kacang Tanah Kg/Ha 9,000.00 - - - - - - 25.00 225,000.00

2 Pupuk :a. Urea Kg/Ha 4,000.00 290.00 1,160,000.00 145.00 580,000.00 45.00 180,000.00 45.00 180,000.00b. T S P Kg/Ha 3,400.00 95.00 323,000.00 70.00 238,000.00 70.00 238,000.00 70.00 238,000.00c. K C L Kg/Ha 4,600.00 - - - - - - - -d. Z A Kg/Ha 2,800.00 - - - - - - - -

3 Obat-obatana. Diazinon Lt/Ha 100,000.00 1.00 100,000.00 - - - - - -b. Matador Lt/Ha 80,000.00 1.00 80,000.00 - - - - - -c. Racumin Ons/Ha 70,000.00 1.00 70,000.00 - - - - - -d. Gramoxone Lt/Ha 80,000.00 - - 1.50 120,000.00 - - - -

II. Tenaga Kerja :1 Persemaian Org/Hr/Ha 75,000.00 6.00 450,000.00 - - - - - -2 Penyiapan Lahan :

a. Tenaga kerja Org/Hr/Ha 75,000.00 22.00 1,650,000.00 12.00 900,000.00 12.00 900,000.00 12.00 900,000.00b. Tenaga Hewan Pas/Hr/Ha 75,000.00 - - - - - - - -c. Tenaga Traktor Ha 500,000.00 3.00 1,500,000.00 - - - - - -

3 Penanaman Org/Hr/Ha 75,000.00 22.00 1,650,000.00 15.00 1,125,000.00 15.00 1,125,000.00 15.00 1,125,000.004 Pemeliharaan Org/Hr/Ha 75,000.00 65.00 4,875,000.00 12.00 900,000.00 6.00 450,000.00 6.00 450,000.005 Panen Org/Hr/Ha 75,000.00 25.00 1,875,000.00 25.00 1,875,000.00 25.00 1,875,000.00 25.00 1,875,000.006 Pasca Panen Org/Hr/Ha 75,000.00 24.00 1,800,000.00 12.00 900,000.00 12.00 900,000.00 12.00 900,000.00

15,683,000.00 6,788,000.00 5,794,000.00 5,893,000.00

III. Biaya lain-lain1 (Karung, alat-alat, 10 % - 1,568,300.00 - 678,800.00 - 579,400.00 - 589,300.00

tali, dan lain-lain)

17,251,300.00 7,466,800.00 6,373,400.00 6,482,300.00

KedelaiJagung Kacang Tanah

Total

NO. URAIANPadi

Satuan Harga Sat.(Rp.)

Sub Total

124

60

REKAPITULASI NET BENEFIT DAN INCREMENTAL BENEFITBERDASARKAN KONDISI DENGAN PROYEK DAN TANPA PROYEK

No. Satuan Sebelum Proyek Sesudah Proyek

1 Luas Tanam :1.1 Musim Hujan

a. Padi rendeng Ha 8.00 30.00b. Kedelai Ha 0.00 0.00

1.2 Musim Kemarau Ia. Padi gadu Ha 5.00 30.00b. Jagung Ha 0.00 0.00c. Kedelai Ha 0.00 0.00d. Kacang Tanah Ha 0.00 0.00

1.3 Musim Kemarau IIa. Padi gadu Ha 4.00 0.00b. Jagung Ha 0.00 0.00c. Kedelai Ha 0.00 5.00d. Kacang Tanah Ha 0.00 25.00

1.4 Intensitas Tanam % 56.67 300.00

2 Hasil Tanaman :2.1 Padi ton/Ha 4.00 6.002.2 Jagung ton/Ha 3.00 4.002.3 Kedelai ton/Ha 2.00 3.002.4 Kacang Tanah ton/Ha 3.00 4.00

3 Harga Hasil Tanaman (Rp/Kg) :3.1 Padi (GKG) Rp/Kg 5,000.00 5,000.003.2 Jagung (pipil) Rp/Kg 4,000.00 4,000.003.3 Kedelai Rp/Kg 5,600.00 5,600.003.4 Kacang Tanah Rp/Kg 6,000.00 6,000.00

4 Satuan Biaya Produksi :4.1 Padi Rp/Ha 17,251,300.00 17,251,300.004.2 Jagung Rp/Ha 7,466,800.00 7,466,800.004.3 Kedelai Rp/Ha 6,373,400.00 6,373,400.004.4 Kacang Tanah Rp/Ha 6,482,300.00 6,482,300.00

5 Nilai Produksi Kotor : 340,000,000.00 2,484,000,000.005.1 Padi Rp 340,000,000.00 1,800,000,000.005.2 Jagung Rp 0.00 0.005.3 Kedelai Rp 0.00 84,000,000.005.4 Kacang Tanah Rp 0.00 600,000,000.00

6 Biaya Produksi : 293,272,100.00 1,229,002,500.006.1 Padi Rp 293,272,100.00 1,035,078,000.006.2 Jagung Rp 0.00 0.006.3 Kedelai Rp 0.00 31,867,000.006.4 Kacang Tanah Rp 0.00 162,057,500.00

7 Nilai Produksi Bersih : 46,727,900.00 1,254,997,500.007.1 Padi Rp 46,727,900.00 764,922,000.007.2 Jagung Rp 0.00 0.007.3 Kedelai Rp 0.00 52,133,000.007.4 Kacang Tanah Rp 0.00 437,942,500.00

8 Incremental Benefit : 1,208,269,600.00

Uraian

125

Tubuh Embung dari beton Cyclop

Manfaat Air Baku

No. Satuan Sebelum Proyek Sesudah Proyek

1 Suplai air baku untuk penduduk Rp - 1,825,000,000.00sebanyak 5000 orang100 @ 100 lt x 365 hari x 5000 orang

= 182,500,000= 182,500

Harga /m3

= 10,000Nilai = 1,825,000,000

Uraian

Kelayakan Ekonomi Embung Kembangan kondisi Biaya NormalPola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 12%

Biaya Manfaat Faktor Biaya Manfaat

Total Tahunan Diskon didiskon didiskon

0 14,802,045,000.00 14,802,045,000.00 0.00 1.00000 14,802,045,000.00 0.00

1 296,040,900.00 296,040,900.00 3,033,269,600.00 0.89286 264,322,232.14 2,708,276,428.57

2 296,040,900.00 296,040,900.00 3,033,269,600.00 0.79719 236,001,992.98 2,418,103,954.08

3 296,040,900.00 296,040,900.00 3,033,269,600.00 0.71178 210,716,065.16 2,159,021,387.57

4 296,040,900.00 296,040,900.00 3,033,269,600.00 0.63552 188,139,343.90 1,927,697,667.48

5 296,040,900.00 444,061,350.00 740,102,250.00 3,033,269,600.00 0.56743 419,953,892.63 1,721,158,631.67

6 296,040,900.00 296,040,900.00 3,033,269,600.00 0.50663 149,983,533.08 1,536,748,778.28

7 296,040,900.00 296,040,900.00 3,033,269,600.00 0.45235 133,913,868.82 1,372,097,123.47

8 296,040,900.00 296,040,900.00 3,033,269,600.00 0.40388 119,565,954.31 1,225,086,717.38

9 296,040,900.00 296,040,900.00 3,033,269,600.00 0.36061 106,755,316.34 1,093,827,426.23

10 296,040,900.00 444,061,350.00 740,102,250.00 3,033,269,600.00 0.32197 238,293,116.84 976,631,630.56

11 296,040,900.00 296,040,900.00 3,033,269,600.00 0.28748 85,104,684.59 871,992,527.29

12 296,040,900.00 296,040,900.00 3,033,269,600.00 0.25668 75,986,325.52 778,564,756.51

13 296,040,900.00 296,040,900.00 3,033,269,600.00 0.22917 67,844,933.50 695,147,104.03

14 296,040,900.00 296,040,900.00 3,033,269,600.00 0.20462 60,575,833.48 620,667,057.17

15 296,040,900.00 444,061,350.00 740,102,250.00 3,033,269,600.00 0.18270 135,213,914.03 554,167,015.33

16 296,040,900.00 296,040,900.00 3,033,269,600.00 0.16312 48,290,683.58 494,791,977.97

17 296,040,900.00 296,040,900.00 3,033,269,600.00 0.14564 43,116,681.77 441,778,551.76

18 296,040,900.00 296,040,900.00 3,033,269,600.00 0.13004 38,497,037.29 394,445,135.50

19 296,040,900.00 296,040,900.00 3,033,269,600.00 0.11611 34,372,354.73 352,183,156.70

20 296,040,900.00 444,061,350.00 740,102,250.00 3,033,269,600.00 0.10367 76,724,006.09 314,449,247.05

21 296,040,900.00 296,040,900.00 3,033,269,600.00 0.09256 27,401,430.75 280,758,256.29

22 296,040,900.00 296,040,900.00 3,033,269,600.00 0.08264 24,465,563.17 250,677,014.55

23 296,040,900.00 296,040,900.00 3,033,269,600.00 0.07379 21,844,252.83 223,818,762.99

24 296,040,900.00 296,040,900.00 3,033,269,600.00 0.06588 19,503,797.17 199,838,181.24

25 296,040,900.00 444,061,350.00 740,102,250.00 3,033,269,600.00 0.05882 43,535,261.53 178,426,947.54

Jumlah 17,672,167,076.23 23,790,355,437.20

NPV 6,118,188,360.97BCR 1.35

TahunKe Biaya Konstruksi Biaya Pemeliharaan

Tahunan 2%/thBiaya Pemeliharaan

Berkala 3%/5th

126

60

Kelayakan Ekonomi Embung Kembangan kondisi Biaya NormalPola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 15%



0 14,802,045,000.00 14,802,045,000 0 1.00000000 14,802,045,000.00 0.00

1 296,040,900 296,040,900 3,033,269,600 0.86956522 257,426,869.57 2,637,625,739.13

2 296,040,900 296,040,900 3,033,269,600 0.75614367 223,849,451.80 2,293,587,599.24

3 296,040,900 296,040,900 3,033,269,600 0.65751623 194,651,697.21 1,994,423,999.34

4 296,040,900 296,040,900 3,033,269,600 0.57175325 169,262,345.40 1,734,281,738.56

5 296,040,900 444,061,350 740,102,250 3,033,269,600 0.49717674 367,961,620.44 1,508,071,077.01

6 296,040,900 296,040,900 3,033,269,600 0.43232760 127,986,650.59 1,311,366,153.92

7 296,040,900 296,040,900 3,033,269,600 0.37593704 111,292,739.64 1,140,318,394.71

8 296,040,900 296,040,900 3,033,269,600 0.32690177 96,776,295.34 991,581,212.79

9 296,040,900 296,040,900 3,033,269,600 0.28426241 84,153,300.30 862,244,532.86

10 296,040,900 444,061,350 740,102,250 3,033,269,600 0.24718471 182,941,957.17 749,777,854.66

11 296,040,900 296,040,900 3,033,269,600 0.21494322 63,631,985.10 651,980,743.19

12 296,040,900 296,040,900 3,033,269,600 0.18690715 55,332,160.96 566,939,776.68

13 296,040,900 296,040,900 3,033,269,600 0.16252796 48,114,922.57 492,991,110.16

14 296,040,900 296,040,900 3,033,269,600 0.14132866 41,839,063.11 428,687,921.88

15 296,040,900 444,061,350 740,102,250 3,033,269,600 0.12289449 90,954,485.01 372,772,105.98

16 296,040,900 296,040,900 3,033,269,600 0.10686477 31,636,342.61 324,149,657.37

17 296,040,900 296,040,900 3,033,269,600 0.09292589 27,509,863.14 281,869,267.28

18 296,040,900 296,040,900 3,033,269,600 0.08080512 23,921,620.12 245,103,710.68

19 296,040,900 296,040,900 3,033,269,600 0.07026532 20,801,408.80 213,133,661.46

20 296,040,900 444,061,350 740,102,250 3,033,269,600 0.06110028 45,220,453.92 185,333,618.66

21 296,040,900 296,040,900 3,033,269,600 0.05313068 15,728,853.54 161,159,668.40

22 296,040,900 296,040,900 3,033,269,600 0.04620059 13,677,263.95 140,138,842.09

23 296,040,900 296,040,900 3,033,269,600 0.04017443 11,893,273.00 121,859,862.69

24 296,040,900 296,040,900 3,033,269,600 0.03493428 10,341,976.52 105,965,097.99

25 296,040,900 444,061,350 740,102,250 3,033,269,600 0.03037764 22,482,557.65 92,143,563.47

Jumlah 17,141,434,157.45 ###########

NPV 2,466,072,752.77BCR 1.144

TahunKe

Biaya Pemeliha-raanTahunan 2%/th

Biaya Pemeliha-raanBerkala 3%/5thBiaya Investasi

127

Pendapatan Pengeluaran Pendapatan DF DFTotal Total Bersih 15% 17%

1 2 3 4 5 6 7 8

0 0 14,802,045,000 -14,802,045,000 1.00000000 -14,802,045,000 1.00000000 -14,802,045,000

1 3,033,269,600 296,040,900 2,737,228,700 0.86956522 2,380,198,870 0.85470085 2,339,511,709

2 3,033,269,600 296,040,900 2,737,228,700 0.75614367 2,069,738,147 0.73051355 1,999,582,658

3 3,033,269,600 296,040,900 2,737,228,700 0.65751623 1,799,772,302 0.62437056 1,709,045,007

4 3,033,269,600 296,040,900 2,737,228,700 0.57175325 1,565,019,393 0.53365005 1,460,722,228

5 3,033,269,600 740,102,250 2,293,167,350 0.49717674 1,140,109,457 0.45611115 1,045,939,203

6 3,033,269,600 296,040,900 2,737,228,700 0.43232760 1,183,379,503 0.38983859 1,067,077,382

7 3,033,269,600 296,040,900 2,737,228,700 0.37593704 1,029,025,655 0.33319538 912,031,950

8 3,033,269,600 296,040,900 2,737,228,700 0.32690177 894,804,917 0.28478237 779,514,487

9 3,033,269,600 296,040,900 2,737,228,700 0.28426241 778,091,233 0.24340374 666,251,699

10 3,033,269,600 740,102,250 2,293,167,350 0.24718471 566,835,897 0.20803738 477,064,535

11 3,033,269,600 296,040,900 2,737,228,700 0.21494322 588,348,758 0.17780973 486,705,894

12 3,033,269,600 296,040,900 2,737,228,700 0.18690715 511,607,616 0.15197413 415,987,944

13 3,033,269,600 296,040,900 2,737,228,700 0.16252796 444,876,188 0.12989242 355,545,251

14 3,033,269,600 296,040,900 2,737,228,700 0.14132866 386,848,859 0.11101916 303,884,830

15 3,033,269,600 740,102,250 2,293,167,350 0.12289449 281,817,621 0.09488817 217,594,455

16 3,033,269,600 296,040,900 2,737,228,700 0.10686477 292,513,315 0.08110100 221,991,986

17 3,033,269,600 296,040,900 2,737,228,700 0.09292589 254,359,404 0.06931709 189,736,740

18 3,033,269,600 296,040,900 2,737,228,700 0.08080512 221,182,091 0.05924538 162,168,154

19 3,033,269,600 296,040,900 2,737,228,700 0.07026532 192,332,253 0.05063708 138,605,260

20 3,033,269,600 740,102,250 2,293,167,350 0.06110028 140,113,165 0.04327955 99,247,258

21 3,033,269,600 296,040,900 2,737,228,700 0.05313068 145,430,815 0.03699107 101,253,021

22 3,033,269,600 296,040,900 2,737,228,700 0.04620059 126,461,578 0.03161630 86,541,043

23 3,033,269,600 296,040,900 2,737,228,700 0.04017443 109,966,590 0.02702248 73,966,704

24 3,033,269,600 296,040,900 2,737,228,700 0.03493428 95,623,121 0.02309614 63,219,405

25 3,033,269,600 740,102,250 2,293,167,350 0.03037764 69,661,006 0.01974029 45,267,781

2,466,072,753 616,411,582

EIRR 17.67%

Tahun Ke

Analisa Economic Internal Rate of Return Embung Kembangan kondisi Biaya NormalPola Tanam : Padi - Padi - Polowijo

NVP NVP

128

60

Kelayakan Ekonomi Embung Kembangan kondisi Biaya Naik 10%Pola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 12%



0 16,282,249,500.00 16,282,249,500.00 0.00 1.00000 16,282,249,500.00 0.00

1 325,644,990.00 325,644,990.00 3,033,269,600.00 0.89286 290,754,455.36 2,708,276,428.57

2 325,644,990.00 325,644,990.00 3,033,269,600.00 0.79719 259,602,192.28 2,418,103,954.08

3 325,644,990.00 325,644,990.00 3,033,269,600.00 0.71178 231,787,671.68 2,159,021,387.57

4 325,644,990.00 325,644,990.00 3,033,269,600.00 0.63552 206,953,278.29 1,927,697,667.48

5 325,644,990.00 488,467,485.00 814,112,475.00 3,033,269,600.00 0.56743 461,949,281.89 1,721,158,631.67

6 325,644,990.00 325,644,990.00 3,033,269,600.00 0.50663 164,981,886.39 1,536,748,778.28

7 325,644,990.00 325,644,990.00 3,033,269,600.00 0.45235 147,305,255.70 1,372,097,123.47

8 325,644,990.00 325,644,990.00 3,033,269,600.00 0.40388 131,522,549.74 1,225,086,717.38

9 325,644,990.00 325,644,990.00 3,033,269,600.00 0.36061 117,430,847.98 1,093,827,426.23

10 325,644,990.00 488,467,485.00 814,112,475.00 3,033,269,600.00 0.32197 262,122,428.52 976,631,630.56

11 325,644,990.00 325,644,990.00 3,033,269,600.00 0.28748 93,615,153.04 871,992,527.29

12 325,644,990.00 325,644,990.00 3,033,269,600.00 0.25668 83,584,958.08 778,564,756.51

13 325,644,990.00 325,644,990.00 3,033,269,600.00 0.22917 74,629,426.85 695,147,104.03

14 325,644,990.00 325,644,990.00 3,033,269,600.00 0.20462 66,633,416.83 620,667,057.17

15 325,644,990.00 488,467,485.00 814,112,475.00 3,033,269,600.00 0.18270 148,735,305.43 554,167,015.33

16 325,644,990.00 325,644,990.00 3,033,269,600.00 0.16312 53,119,751.94 494,791,977.97

17 325,644,990.00 325,644,990.00 3,033,269,600.00 0.14564 47,428,349.95 441,778,551.76

18 325,644,990.00 325,644,990.00 3,033,269,600.00 0.13004 42,346,741.02 394,445,135.50

19 325,644,990.00 325,644,990.00 3,033,269,600.00 0.11611 37,809,590.20 352,183,156.70

20 325,644,990.00 488,467,485.00 814,112,475.00 3,033,269,600.00 0.10367 84,396,406.70 314,449,247.05

21 325,644,990.00 325,644,990.00 3,033,269,600.00 0.09256 30,141,573.82 280,758,256.29

22 325,644,990.00 325,644,990.00 3,033,269,600.00 0.08264 26,912,119.48 250,677,014.55

23 325,644,990.00 325,644,990.00 3,033,269,600.00 0.07379 24,028,678.11 223,818,762.99

24 325,644,990.00 325,644,990.00 3,033,269,600.00 0.06588 21,454,176.88 199,838,181.24

25 325,644,990.00 488,467,485.00 814,112,475.00 3,033,269,600.00 0.05882 47,888,787.68 178,426,947.54

Jumlah 19,439,383,783.85 23,790,355,437.20

NPV 4,350,971,653.34BCR 1.22



Berkala 3%/5th

129

Kelayakan Ekonomi Embung Kembangan kondisi Biaya Naik 10%Pola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 15%



0 16,282,249,500.00 16,282,249,500 0 1.00000000 16,282,249,500.00 0.00

1 325,644,990 325,644,990 3,033,269,600 0.86956522 283,169,556.52 2,637,625,739.13

2 325,644,990 325,644,990 3,033,269,600 0.75614367 246,234,396.98 2,293,587,599.24

3 325,644,990 325,644,990 3,033,269,600 0.65751623 214,116,866.94 1,994,423,999.34

4 325,644,990 325,644,990 3,033,269,600 0.57175325 186,188,579.94 1,734,281,738.56

5 325,644,990 488,467,485 814,112,475 3,033,269,600 0.49717674 404,757,782.49 1,508,071,077.01

6 325,644,990 325,644,990 3,033,269,600 0.43232760 140,785,315.65 1,311,366,153.92

7 325,644,990 325,644,990 3,033,269,600 0.37593704 122,422,013.61 1,140,318,394.71

8 325,644,990 325,644,990 3,033,269,600 0.32690177 106,453,924.88 991,581,212.79

9 325,644,990 325,644,990 3,033,269,600 0.28426241 92,568,630.33 862,244,532.86

10 325,644,990 488,467,485 814,112,475 3,033,269,600 0.24718471 201,236,152.88 749,777,854.66

11 325,644,990 325,644,990 3,033,269,600 0.21494322 69,995,183.61 651,980,743.19

12 325,644,990 325,644,990 3,033,269,600 0.18690715 60,865,377.05 566,939,776.68

13 325,644,990 325,644,990 3,033,269,600 0.16252796 52,926,414.83 492,991,110.16

14 325,644,990 325,644,990 3,033,269,600 0.14132866 46,022,969.42 428,687,921.88

15 325,644,990 488,467,485 814,112,475 3,033,269,600 0.12289449 100,049,933.51 372,772,105.98

16 325,644,990 325,644,990 3,033,269,600 0.10686477 34,799,976.87 324,149,657.37

17 325,644,990 325,644,990 3,033,269,600 0.09292589 30,260,849.46 281,869,267.28

18 325,644,990 325,644,990 3,033,269,600 0.08080512 26,313,782.14 245,103,710.68

19 325,644,990 325,644,990 3,033,269,600 0.07026532 22,881,549.68 213,133,661.46

20 325,644,990 488,467,485 814,112,475 3,033,269,600 0.06110028 49,742,499.31 185,333,618.66

21 325,644,990 325,644,990 3,033,269,600 0.05313068 17,301,738.89 161,159,668.40

22 325,644,990 325,644,990 3,033,269,600 0.04620059 15,044,990.34 140,138,842.09

23 325,644,990 325,644,990 3,033,269,600 0.04017443 13,082,600.30 121,859,862.69

24 325,644,990 325,644,990 3,033,269,600 0.03493428 11,376,174.17 105,965,097.99

25 325,644,990 488,467,485 814,112,475 3,033,269,600 0.03037764 24,730,813.41 92,143,563.47

Jumlah 18,855,577,573.20 19,607,506,910.22

NPV 751,929,337.02BCR 1.040

TahunKe Biaya Investasi Biaya Pemeliha-raan

Tahunan 2%/thBiaya Pemeliha-raan

Berkala 3%/5th

130

60


1 2 3 4 5 6 7 8

0 0 16,282,249,500 -16,282,249,500 1.00000000 -16,282,249,500 1.00000000 -16,282,249,500

1 3,033,269,600 296,040,900 2,737,228,700 0.86956522 2,380,198,870 0.85470085 2,339,511,709

2 3,033,269,600 296,040,900 2,737,228,700 0.75614367 2,069,738,147 0.73051355 1,999,582,658

3 3,033,269,600 296,040,900 2,737,228,700 0.65751623 1,799,772,302 0.62437056 1,709,045,007

4 3,033,269,600 296,040,900 2,737,228,700 0.57175325 1,565,019,393 0.53365005 1,460,722,228

5 3,033,269,600 740,102,250 2,293,167,350 0.49717674 1,140,109,457 0.45611115 1,045,939,203

6 3,033,269,600 296,040,900 2,737,228,700 0.43232760 1,183,379,503 0.38983859 1,067,077,382

7 3,033,269,600 296,040,900 2,737,228,700 0.37593704 1,029,025,655 0.33319538 912,031,950

8 3,033,269,600 296,040,900 2,737,228,700 0.32690177 894,804,917 0.28478237 779,514,487

9 3,033,269,600 296,040,900 2,737,228,700 0.28426241 778,091,233 0.24340374 666,251,699

10 3,033,269,600 740,102,250 2,293,167,350 0.24718471 566,835,897 0.20803738 477,064,535

11 3,033,269,600 296,040,900 2,737,228,700 0.21494322 588,348,758 0.17780973 486,705,894

12 3,033,269,600 296,040,900 2,737,228,700 0.18690715 511,607,616 0.15197413 415,987,944

13 3,033,269,600 296,040,900 2,737,228,700 0.16252796 444,876,188 0.12989242 355,545,251

14 3,033,269,600 296,040,900 2,737,228,700 0.14132866 386,848,859 0.11101916 303,884,830

15 3,033,269,600 740,102,250 2,293,167,350 0.12289449 281,817,621 0.09488817 217,594,455

16 3,033,269,600 296,040,900 2,737,228,700 0.10686477 292,513,315 0.08110100 221,991,986

17 3,033,269,600 296,040,900 2,737,228,700 0.09292589 254,359,404 0.06931709 189,736,740

18 3,033,269,600 296,040,900 2,737,228,700 0.08080512 221,182,091 0.05924538 162,168,154

19 3,033,269,600 296,040,900 2,737,228,700 0.07026532 192,332,253 0.05063708 138,605,260

20 3,033,269,600 740,102,250 2,293,167,350 0.06110028 140,113,165 0.04327955 99,247,258

21 3,033,269,600 296,040,900 2,737,228,700 0.05313068 145,430,815 0.03699107 101,253,021

22 3,033,269,600 296,040,900 2,737,228,700 0.04620059 126,461,578 0.03161630 86,541,043

23 3,033,269,600 296,040,900 2,737,228,700 0.04017443 109,966,590 0.02702248 73,966,704

24 3,033,269,600 296,040,900 2,737,228,700 0.03493428 95,623,121 0.02309614 63,219,405

25 3,033,269,600 740,102,250 2,293,167,350 0.03037764 69,661,006 0.01974029 45,267,781

985,868,253 -863,792,918

EIRR 16.07%

Analisa Economic Internal Rate of Return Embung Kembangan kondisi Biaya Naik 10%Pola Tanam : Padi - Padi - Polowijo

Tahun Ke NVP NVP

131

Kelayakan Ekonomi Embung Kembangan Kondisi Biaya Normal Manfaat turun 10 %Pola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 12%



0 14,802,045,000.00 14,802,045,000.00 0.00 1.00000 14,802,045,000.00 0.00

1 296,040,900.00 296,040,900.00 2,729,942,640.00 0.89286 264,322,232.14 2,437,448,785.71

2 296,040,900.00 296,040,900.00 2,729,942,640.00 0.79719 236,001,992.98 2,176,293,558.67

3 296,040,900.00 296,040,900.00 2,729,942,640.00 0.71178 210,716,065.16 1,943,119,248.82

4 296,040,900.00 296,040,900.00 2,729,942,640.00 0.63552 188,139,343.90 1,734,927,900.73

5 296,040,900.00 444,061,350.00 740,102,250.00 2,729,942,640.00 0.56743 419,953,892.63 1,549,042,768.51

6 296,040,900.00 296,040,900.00 2,729,942,640.00 0.50663 149,983,533.08 1,383,073,900.45

7 296,040,900.00 296,040,900.00 2,729,942,640.00 0.45235 133,913,868.82 1,234,887,411.12

8 296,040,900.00 296,040,900.00 2,729,942,640.00 0.40388 119,565,954.31 1,102,578,045.64

9 296,040,900.00 296,040,900.00 2,729,942,640.00 0.36061 106,755,316.34 984,444,683.61

10 296,040,900.00 444,061,350.00 740,102,250.00 2,729,942,640.00 0.32197 238,293,116.84 878,968,467.51

11 296,040,900.00 296,040,900.00 2,729,942,640.00 0.28748 85,104,684.59 784,793,274.56

12 296,040,900.00 296,040,900.00 2,729,942,640.00 0.25668 75,986,325.52 700,708,280.86

13 296,040,900.00 296,040,900.00 2,729,942,640.00 0.22917 67,844,933.50 625,632,393.62

14 296,040,900.00 296,040,900.00 2,729,942,640.00 0.20462 60,575,833.48 558,600,351.45

15 296,040,900.00 444,061,350.00 740,102,250.00 2,729,942,640.00 0.18270 135,213,914.03 498,750,313.79

16 296,040,900.00 296,040,900.00 2,729,942,640.00 0.16312 48,290,683.58 445,312,780.17

17 296,040,900.00 296,040,900.00 2,729,942,640.00 0.14564 43,116,681.77 397,600,696.58

18 296,040,900.00 296,040,900.00 2,729,942,640.00 0.13004 38,497,037.29 355,000,621.95

19 296,040,900.00 296,040,900.00 2,729,942,640.00 0.11611 34,372,354.73 316,964,841.03

20 296,040,900.00 444,061,350.00 740,102,250.00 2,729,942,640.00 0.10367 76,724,006.09 283,004,322.34

21 296,040,900.00 296,040,900.00 2,729,942,640.00 0.09256 27,401,430.75 252,682,430.66

22 296,040,900.00 296,040,900.00 2,729,942,640.00 0.08264 24,465,563.17 225,609,313.09

23 296,040,900.00 296,040,900.00 2,729,942,640.00 0.07379 21,844,252.83 201,436,886.69

24 296,040,900.00 296,040,900.00 2,729,942,640.00 0.06588 19,503,797.17 179,854,363.12

25 296,040,900.00 444,061,350.00 740,102,250.00 2,729,942,640.00 0.05882 43,535,261.53 160,584,252.78

Jumlah 17,672,167,076.23 21,411,319,893.48

NPV 3,739,152,817.25BCR 1.21



Berkala 3%/5th

132

60

Pola Tanam : Padi - Padi - PolowijoFaktor Diskon = 15%



0 14,802,045,000.00 14,802,045,000 0 1.00000000 14,802,045,000.00 0.00

1 296,040,900 296,040,900 2,729,942,640 0.86956522 257,426,869.57 2,373,863,165.22

2 296,040,900 296,040,900 2,729,942,640 0.75614367 223,849,451.80 2,064,228,839.32

3 296,040,900 296,040,900 2,729,942,640 0.65751623 194,651,697.21 1,794,981,599.41

4 296,040,900 296,040,900 2,729,942,640 0.57175325 169,262,345.40 1,560,853,564.70

5 296,040,900 444,061,350 740,102,250 2,729,942,640 0.49717674 367,961,620.44 1,357,263,969.31

6 296,040,900 296,040,900 2,729,942,640 0.43232760 127,986,650.59 1,180,229,538.53

7 296,040,900 296,040,900 2,729,942,640 0.37593704 111,292,739.64 1,026,286,555.24

8 296,040,900 296,040,900 2,729,942,640 0.32690177 96,776,295.34 892,423,091.51

9 296,040,900 296,040,900 2,729,942,640 0.28426241 84,153,300.30 776,020,079.58

10 296,040,900 444,061,350 740,102,250 2,729,942,640 0.24718471 182,941,957.17 674,800,069.20

11 296,040,900 296,040,900 2,729,942,640 0.21494322 63,631,985.10 586,782,668.87

12 296,040,900 296,040,900 2,729,942,640 0.18690715 55,332,160.96 510,245,799.02

13 296,040,900 296,040,900 2,729,942,640 0.16252796 48,114,922.57 443,691,999.14

14 296,040,900 296,040,900 2,729,942,640 0.14132866 41,839,063.11 385,819,129.69

15 296,040,900 444,061,350 740,102,250 2,729,942,640 0.12289449 90,954,485.01 335,494,895.38

16 296,040,900 296,040,900 2,729,942,640 0.10686477 31,636,342.61 291,734,691.64

17 296,040,900 296,040,900 2,729,942,640 0.09292589 27,509,863.14 253,682,340.55

18 296,040,900 296,040,900 2,729,942,640 0.08080512 23,921,620.12 220,593,339.61

19 296,040,900 296,040,900 2,729,942,640 0.07026532 20,801,408.80 191,820,295.32

20 296,040,900 444,061,350 740,102,250 2,729,942,640 0.06110028 45,220,453.92 166,800,256.80

21 296,040,900 296,040,900 2,729,942,640 0.05313068 15,728,853.54 145,043,701.56

22 296,040,900 296,040,900 2,729,942,640 0.04620059 13,677,263.95 126,124,957.88

23 296,040,900 296,040,900 2,729,942,640 0.04017443 11,893,273.00 109,673,876.42

24 296,040,900 296,040,900 2,729,942,640 0.03493428 10,341,976.52 95,368,588.19

25 296,040,900 444,061,350 740,102,250 2,729,942,640 0.03037764 22,482,557.65 82,929,207.12

Jumlah 17,141,434,157.45 17,646,756,219.20

NPV 505,322,061.74BCR 1.029



Berkala 3%/5th

Kelayakan Ekonomi Embung Kembangan Kondisi Biaya Normal Manfaat turun 10 %

133


1 2 3 4 5 6 7 8

0 0 14,802,045,000 -14,802,045,000 1.00000000 -14,802,045,000 1.00000000 -14,802,045,000

1 2,729,942,640 296,040,900 2,433,901,740 0.86956522 2,116,436,296 0.85470085 2,080,257,897

2 2,729,942,640 296,040,900 2,433,901,740 0.75614367 1,840,379,388 0.73051355 1,777,998,203

3 2,729,942,640 296,040,900 2,433,901,740 0.65751623 1,600,329,902 0.62437056 1,519,656,584

4 2,729,942,640 296,040,900 2,433,901,740 0.57175325 1,391,591,219 0.53365005 1,298,851,781

5 2,729,942,640 740,102,250 1,989,840,390 0.49717674 989,302,349 0.45611115 907,588,393

6 2,729,942,640 296,040,900 2,433,901,740 0.43232760 1,052,242,888 0.38983859 948,828,827

7 2,729,942,640 296,040,900 2,433,901,740 0.37593704 914,993,816 0.33319538 810,964,809

8 2,729,942,640 296,040,900 2,433,901,740 0.32690177 795,646,796 0.28478237 693,132,316

9 2,729,942,640 296,040,900 2,433,901,740 0.28426241 691,866,779 0.24340374 592,420,783

10 2,729,942,640 740,102,250 1,989,840,390 0.24718471 491,858,112 0.20803738 413,961,188

11 2,729,942,640 296,040,900 2,433,901,740 0.21494322 523,150,684 0.17780973 432,771,410

12 2,729,942,640 296,040,900 2,433,901,740 0.18690715 454,913,638 0.15197413 369,890,094

13 2,729,942,640 296,040,900 2,433,901,740 0.16252796 395,577,077 0.12989242 316,145,379

14 2,729,942,640 296,040,900 2,433,901,740 0.14132866 343,980,067 0.11101916 270,209,726

15 2,729,942,640 740,102,250 1,989,840,390 0.12289449 244,540,410 0.09488817 188,812,314

16 2,729,942,640 296,040,900 2,433,901,740 0.10686477 260,098,349 0.08110100 197,391,866

17 2,729,942,640 296,040,900 2,433,901,740 0.09292589 226,172,477 0.06931709 168,710,997

18 2,729,942,640 296,040,900 2,433,901,740 0.08080512 196,671,719 0.05924538 144,197,433

19 2,729,942,640 296,040,900 2,433,901,740 0.07026532 171,018,887 0.05063708 123,245,669

20 2,729,942,640 740,102,250 1,989,840,390 0.06110028 121,579,803 0.04327955 86,119,402

21 2,729,942,640 296,040,900 2,433,901,740 0.05313068 129,314,848 0.03699107 90,032,632

22 2,729,942,640 296,040,900 2,433,901,740 0.04620059 112,447,694 0.03161630 76,950,967

23 2,729,942,640 296,040,900 2,433,901,740 0.04017443 97,780,603 0.02702248 65,770,057

24 2,729,942,640 296,040,900 2,433,901,740 0.03493428 85,026,612 0.02309614 56,213,724

25 2,729,942,640 740,102,250 1,989,840,390 0.03037764 60,446,649 0.01974029 39,280,020

505,322,062 -1,132,642,529

EIRR 15.62%

Analisa Economic Internal Rate of Return Embung Kembangan Kondisi Biaya Normal Manfaat Turun 10 %Pola Tanam : Padi - Padi - Polowijo

Tahun Ke NVP NVP

No Kondisi EIRR NPV (milyar) BCR

1 Normal 17.667% 6.118 1.346

2 Biaya proyek naik 10%, manfaat normal 16.066% 4.351 1.224

3 Biaya proyek normal, manfaat turun 10% 15.617% 3.739 1.212

Rekapitulasi Hasil Analisa Kelayakan dengan Tubuh Embung dari beton Cyclop

134

60

Tubuh Embung dari Timbunan

Kelayakan Ekonomi Embung Kembangan, Biaya NormalPola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 12%



0 14,714,580,000.00 14,714,580,000.00 0.00 1.00000 14,714,580,000.00 0.00

1 294,291,600.00 294,291,600.00 3,033,269,600.00 0.89286 262,760,357.14 2,708,276,428.57

2 294,291,600.00 294,291,600.00 3,033,269,600.00 0.79719 234,607,461.73 2,418,103,954.08

3 294,291,600.00 294,291,600.00 3,033,269,600.00 0.71178 209,470,947.98 2,159,021,387.57

4 294,291,600.00 294,291,600.00 3,033,269,600.00 0.63552 187,027,632.12 1,927,697,667.48

5 294,291,600.00 441,437,400.00 735,729,000.00 3,033,269,600.00 0.56743 417,472,393.13 1,721,158,631.67

6 294,291,600.00 294,291,600.00 3,033,269,600.00 0.50663 149,097,283.26 1,536,748,778.28

7 294,291,600.00 294,291,600.00 3,033,269,600.00 0.45235 133,122,574.34 1,372,097,123.47

8 294,291,600.00 294,291,600.00 3,033,269,600.00 0.40388 118,859,441.38 1,225,086,717.38

9 294,291,600.00 294,291,600.00 3,033,269,600.00 0.36061 106,124,501.23 1,093,827,426.23

10 294,291,600.00 441,437,400.00 735,729,000.00 3,033,269,600.00 0.32197 236,885,047.38 976,631,630.56

11 294,291,600.00 294,291,600.00 3,033,269,600.00 0.28748 84,601,802.64 871,992,527.29

12 294,291,600.00 294,291,600.00 3,033,269,600.00 0.25668 75,537,323.78 778,564,756.51

13 294,291,600.00 294,291,600.00 3,033,269,600.00 0.22917 67,444,039.09 695,147,104.03

14 294,291,600.00 294,291,600.00 3,033,269,600.00 0.20462 60,217,892.05 620,667,057.17

15 294,291,600.00 441,437,400.00 735,729,000.00 3,033,269,600.00 0.18270 134,414,937.60 554,167,015.33

16 294,291,600.00 294,291,600.00 3,033,269,600.00 0.16312 48,005,334.86 494,791,977.97

17 294,291,600.00 294,291,600.00 3,033,269,600.00 0.14564 42,861,906.12 441,778,551.76

18 294,291,600.00 294,291,600.00 3,033,269,600.00 0.13004 38,269,559.04 394,445,135.50

19 294,291,600.00 294,291,600.00 3,033,269,600.00 0.11611 34,169,249.14 352,183,156.70

20 294,291,600.00 441,437,400.00 735,729,000.00 3,033,269,600.00 0.10367 76,270,645.41 314,449,247.05

21 294,291,600.00 294,291,600.00 3,033,269,600.00 0.09256 27,239,516.22 280,758,256.29

22 294,291,600.00 294,291,600.00 3,033,269,600.00 0.08264 24,320,996.62 250,677,014.55

23 294,291,600.00 294,291,600.00 3,033,269,600.00 0.07379 21,715,175.56 223,818,762.99

24 294,291,600.00 294,291,600.00 3,033,269,600.00 0.06588 19,388,549.60 199,838,181.24

25 294,291,600.00 441,437,400.00 735,729,000.00 3,033,269,600.00 0.05882 43,278,012.51 178,426,947.54

Jumlah 17,567,742,579.93 23,790,355,437.20

NPV 6,222,612,857.27BCR 1.35



Berkala 3%/5th

135

Kelayakan Ekonomi Embung Kembangan, Biaya NormalPola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 15%



0 14,714,580,000.00 14,714,580,000 0 1.00000000 14,714,580,000.00 0.00

1 294,291,600 294,291,600 3,033,269,600 0.86956522 255,905,739.13 2,637,625,739.13

2 294,291,600 294,291,600 3,033,269,600 0.75614367 222,526,729.68 2,293,587,599.24

3 294,291,600 294,291,600 3,033,269,600 0.65751623 193,501,504.07 1,994,423,999.34

4 294,291,600 294,291,600 3,033,269,600 0.57175325 168,262,177.45 1,734,281,738.56

5 294,291,600 441,437,400 735,729,000 3,033,269,600 0.49717674 365,787,342.28 1,508,071,077.01

6 294,291,600 294,291,600 3,033,269,600 0.43232760 127,230,379.92 1,311,366,153.92

7 294,291,600 294,291,600 3,033,269,600 0.37593704 110,635,112.98 1,140,318,394.71

8 294,291,600 294,291,600 3,033,269,600 0.32690177 96,204,446.07 991,581,212.79

9 294,291,600 294,291,600 3,033,269,600 0.28426241 83,656,040.06 862,244,532.86

10 294,291,600 441,437,400 735,729,000 3,033,269,600 0.24718471 181,860,956.65 749,777,854.66

11 294,291,600 294,291,600 3,033,269,600 0.21494322 63,255,984.92 651,980,743.19

12 294,291,600 294,291,600 3,033,269,600 0.18690715 55,005,204.28 566,939,776.68

13 294,291,600 294,291,600 3,033,269,600 0.16252796 47,830,612.42 492,991,110.16

14 294,291,600 294,291,600 3,033,269,600 0.14132866 41,591,836.88 428,687,921.88

15 294,291,600 441,437,400 735,729,000 3,033,269,600 0.12289449 90,417,036.71 372,772,105.98

16 294,291,600 294,291,600 3,033,269,600 0.10686477 31,449,404.07 324,149,657.37

17 294,291,600 294,291,600 3,033,269,600 0.09292589 27,347,307.89 281,869,267.28

18 294,291,600 294,291,600 3,033,269,600 0.08080512 23,780,267.73 245,103,710.68

19 294,291,600 294,291,600 3,033,269,600 0.07026532 20,678,493.68 213,133,661.46

20 294,291,600 441,437,400 735,729,000 3,033,269,600 0.06110028 44,953,247.12 185,333,618.66

21 294,291,600 294,291,600 3,033,269,600 0.05313068 15,635,912.04 161,159,668.40

22 294,291,600 294,291,600 3,033,269,600 0.04620059 13,596,445.26 140,138,842.09

23 294,291,600 294,291,600 3,033,269,600 0.04017443 11,822,995.87 121,859,862.69

24 294,291,600 294,291,600 3,033,269,600 0.03493428 10,280,865.98 105,965,097.99

25 294,291,600 441,437,400 735,729,000 3,033,269,600 0.03037764 22,349,708.65 92,143,563.47

Jumlah 17,040,145,751.79 ###########

NPV 2,567,361,158.43BCR 1.151

TahunKe

Biaya Pemeliha-raanTahunan 2%/th

Biaya Pemeliha-raanBerkala 3%/5thBiaya Investasi

136

60


1 2 3 4 5 6 7 8

0 0 14,714,580,000 -14,714,580,000 1.00000000 -14,714,580,000 1.00000000 -14,714,580,000

1 3,033,269,600 294,291,600 2,738,978,000 0.86956522 2,381,720,000 0.85470085 2,341,006,838

2 3,033,269,600 294,291,600 2,738,978,000 0.75614367 2,071,060,870 0.73051355 2,000,860,545

3 3,033,269,600 294,291,600 2,738,978,000 0.65751623 1,800,922,495 0.62437056 1,710,137,218

4 3,033,269,600 294,291,600 2,738,978,000 0.57175325 1,566,019,561 0.53365005 1,461,655,742

5 3,033,269,600 735,729,000 2,297,540,600 0.49717674 1,142,283,735 0.45611115 1,047,933,891

6 3,033,269,600 294,291,600 2,738,978,000 0.43232760 1,184,135,774 0.38983859 1,067,759,326

7 3,033,269,600 294,291,600 2,738,978,000 0.37593704 1,029,683,282 0.33319538 912,614,809

8 3,033,269,600 294,291,600 2,738,978,000 0.32690177 895,376,767 0.28478237 780,012,657

9 3,033,269,600 294,291,600 2,738,978,000 0.28426241 778,588,493 0.24340374 666,677,485

10 3,033,269,600 735,729,000 2,297,540,600 0.24718471 567,916,898 0.20803738 477,974,334

11 3,033,269,600 294,291,600 2,738,978,000 0.21494322 588,724,758 0.17780973 487,016,937

12 3,033,269,600 294,291,600 2,738,978,000 0.18690715 511,934,572 0.15197413 416,253,792

13 3,033,269,600 294,291,600 2,738,978,000 0.16252796 445,160,498 0.12989242 355,772,472

14 3,033,269,600 294,291,600 2,738,978,000 0.14132866 387,096,085 0.11101916 304,079,036

15 3,033,269,600 735,729,000 2,297,540,600 0.12289449 282,355,069 0.09488817 218,009,424

16 3,033,269,600 294,291,600 2,738,978,000 0.10686477 292,700,253 0.08110100 222,133,856

17 3,033,269,600 294,291,600 2,738,978,000 0.09292589 254,521,959 0.06931709 189,857,997

18 3,033,269,600 294,291,600 2,738,978,000 0.08080512 221,323,443 0.05924538 162,271,792

19 3,033,269,600 294,291,600 2,738,978,000 0.07026532 192,455,168 0.05063708 138,693,839

20 3,033,269,600 735,729,000 2,297,540,600 0.06110028 140,380,372 0.04327955 99,436,530

21 3,033,269,600 294,291,600 2,738,978,000 0.05313068 145,523,756 0.03699107 101,317,729

22 3,033,269,600 294,291,600 2,738,978,000 0.04620059 126,542,397 0.03161630 86,596,350

23 3,033,269,600 294,291,600 2,738,978,000 0.04017443 110,036,867 0.02702248 74,013,974

24 3,033,269,600 294,291,600 2,738,978,000 0.03493428 95,684,232 0.02309614 63,259,807

25 3,033,269,600 735,729,000 2,297,540,600 0.03037764 69,793,855 0.01974029 45,354,110

2,567,361,158 716,120,490

EIRR 17.77%

Tahun Ke

Analisa Economic Internal Rate of Return Embung Kembangan, Kondisi NormalPola Tanam : Padi - Padi - Polowijo

NVP NVP

137

Kelayakan Ekonomi Embung Kembangan, Kondisi Biaya Naik 10%Pola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 12%



0 16,186,038,000.00 16,186,038,000.00 0.00 1.00000 16,186,038,000.00 0.00

1 323,720,760.00 323,720,760.00 3,033,269,600.00 0.89286 289,036,392.86 2,708,276,428.57

2 323,720,760.00 323,720,760.00 3,033,269,600.00 0.79719 258,068,207.91 2,418,103,954.08

3 323,720,760.00 323,720,760.00 3,033,269,600.00 0.71178 230,418,042.78 2,159,021,387.57

4 323,720,760.00 323,720,760.00 3,033,269,600.00 0.63552 205,730,395.33 1,927,697,667.48

5 323,720,760.00 485,581,140.00 809,301,900.00 3,033,269,600.00 0.56743 459,219,632.44 1,721,158,631.67

6 323,720,760.00 323,720,760.00 3,033,269,600.00 0.50663 164,007,011.59 1,536,748,778.28

7 323,720,760.00 323,720,760.00 3,033,269,600.00 0.45235 146,434,831.77 1,372,097,123.47

8 323,720,760.00 323,720,760.00 3,033,269,600.00 0.40388 130,745,385.51 1,225,086,717.38

9 323,720,760.00 323,720,760.00 3,033,269,600.00 0.36061 116,736,951.35 1,093,827,426.23

10 323,720,760.00 485,581,140.00 809,301,900.00 3,033,269,600.00 0.32197 260,573,552.12 976,631,630.56

11 323,720,760.00 323,720,760.00 3,033,269,600.00 0.28748 93,061,982.90 871,992,527.29

12 323,720,760.00 323,720,760.00 3,033,269,600.00 0.25668 83,091,056.16 778,564,756.51

13 323,720,760.00 323,720,760.00 3,033,269,600.00 0.22917 74,188,443.00 695,147,104.03

14 323,720,760.00 323,720,760.00 3,033,269,600.00 0.20462 66,239,681.25 620,667,057.17

15 323,720,760.00 485,581,140.00 809,301,900.00 3,033,269,600.00 0.18270 147,856,431.36 554,167,015.33

16 323,720,760.00 323,720,760.00 3,033,269,600.00 0.16312 52,805,868.34 494,791,977.97

17 323,720,760.00 323,720,760.00 3,033,269,600.00 0.14564 47,148,096.74 441,778,551.76

18 323,720,760.00 323,720,760.00 3,033,269,600.00 0.13004 42,096,514.94 394,445,135.50

19 323,720,760.00 323,720,760.00 3,033,269,600.00 0.11611 37,586,174.06 352,183,156.70

20 323,720,760.00 485,581,140.00 809,301,900.00 3,033,269,600.00 0.10367 83,897,709.95 314,449,247.05

21 323,720,760.00 323,720,760.00 3,033,269,600.00 0.09256 29,963,467.84 280,758,256.29

22 323,720,760.00 323,720,760.00 3,033,269,600.00 0.08264 26,753,096.28 250,677,014.55

23 323,720,760.00 323,720,760.00 3,033,269,600.00 0.07379 23,886,693.11 223,818,762.99

24 323,720,760.00 323,720,760.00 3,033,269,600.00 0.06588 21,327,404.56 199,838,181.24

25 323,720,760.00 485,581,140.00 809,301,900.00 3,033,269,600.00 0.05882 47,605,813.76 178,426,947.54

Jumlah 19,324,516,837.92 23,790,355,437.20

NPV 4,465,838,599.27BCR 1.23



Berkala 3%/5th

138

60

Kelayakan Ekonomi Embung Kembangan, Kondisi Biaya Naik 10%Pola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 15%



0 16,186,038,000.00 16,186,038,000 0 1.00000000 16,186,038,000.00 0.00

1 323,720,760 323,720,760 3,033,269,600 0.86956522 281,496,313.04 2,637,625,739.13

2 323,720,760 323,720,760 3,033,269,600 0.75614367 244,779,402.65 2,293,587,599.24

3 323,720,760 323,720,760 3,033,269,600 0.65751623 212,851,654.48 1,994,423,999.34

4 323,720,760 323,720,760 3,033,269,600 0.57175325 185,088,395.20 1,734,281,738.56

5 323,720,760 485,581,140 809,301,900 3,033,269,600 0.49717674 402,366,076.51 1,508,071,077.01

6 323,720,760 323,720,760 3,033,269,600 0.43232760 139,953,417.92 1,311,366,153.92

7 323,720,760 323,720,760 3,033,269,600 0.37593704 121,698,624.28 1,140,318,394.71

8 323,720,760 323,720,760 3,033,269,600 0.32690177 105,824,890.67 991,581,212.79

9 323,720,760 323,720,760 3,033,269,600 0.28426241 92,021,644.07 862,244,532.86

10 323,720,760 485,581,140 809,301,900 3,033,269,600 0.24718471 200,047,052.32 749,777,854.66

11 323,720,760 323,720,760 3,033,269,600 0.21494322 69,581,583.41 651,980,743.19

12 323,720,760 323,720,760 3,033,269,600 0.18690715 60,505,724.71 566,939,776.68

13 323,720,760 323,720,760 3,033,269,600 0.16252796 52,613,673.66 492,991,110.16

14 323,720,760 323,720,760 3,033,269,600 0.14132866 45,751,020.57 428,687,921.88

15 323,720,760 485,581,140 809,301,900 3,033,269,600 0.12289449 99,458,740.38 372,772,105.98

16 323,720,760 323,720,760 3,033,269,600 0.10686477 34,594,344.48 324,149,657.37

17 323,720,760 323,720,760 3,033,269,600 0.09292589 30,082,038.68 281,869,267.28

18 323,720,760 323,720,760 3,033,269,600 0.08080512 26,158,294.50 245,103,710.68

19 323,720,760 323,720,760 3,033,269,600 0.07026532 22,746,343.05 213,133,661.46

20 323,720,760 485,581,140 809,301,900 3,033,269,600 0.06110028 49,448,571.84 185,333,618.66

21 323,720,760 323,720,760 3,033,269,600 0.05313068 17,199,503.25 161,159,668.40

22 323,720,760 323,720,760 3,033,269,600 0.04620059 14,956,089.78 140,138,842.09

23 323,720,760 323,720,760 3,033,269,600 0.04017443 13,005,295.46 121,859,862.69

24 323,720,760 323,720,760 3,033,269,600 0.03493428 11,308,952.58 105,965,097.99

25 323,720,760 485,581,140 809,301,900 3,033,269,600 0.03037764 24,584,679.51 92,143,563.47

Jumlah 18,744,160,326.97 19,607,506,910.22

NPV 863,346,583.25BCR 1.046



Berkala 3%/5th

139


1 2 3 4 5 6 7 8

0 0 16,186,038,000 -16,186,038,000 1.00000000 -16,186,038,000 1.00000000 -16,186,038,000

1 3,033,269,600 294,291,600 2,738,978,000 0.86956522 2,381,720,000 0.85470085 2,341,006,838

2 3,033,269,600 294,291,600 2,738,978,000 0.75614367 2,071,060,870 0.73051355 2,000,860,545

3 3,033,269,600 294,291,600 2,738,978,000 0.65751623 1,800,922,495 0.62437056 1,710,137,218

4 3,033,269,600 294,291,600 2,738,978,000 0.57175325 1,566,019,561 0.53365005 1,461,655,742

5 3,033,269,600 735,729,000 2,297,540,600 0.49717674 1,142,283,735 0.45611115 1,047,933,891

6 3,033,269,600 294,291,600 2,738,978,000 0.43232760 1,184,135,774 0.38983859 1,067,759,326

7 3,033,269,600 294,291,600 2,738,978,000 0.37593704 1,029,683,282 0.33319538 912,614,809

8 3,033,269,600 294,291,600 2,738,978,000 0.32690177 895,376,767 0.28478237 780,012,657

9 3,033,269,600 294,291,600 2,738,978,000 0.28426241 778,588,493 0.24340374 666,677,485

10 3,033,269,600 735,729,000 2,297,540,600 0.24718471 567,916,898 0.20803738 477,974,334

11 3,033,269,600 294,291,600 2,738,978,000 0.21494322 588,724,758 0.17780973 487,016,937

12 3,033,269,600 294,291,600 2,738,978,000 0.18690715 511,934,572 0.15197413 416,253,792

13 3,033,269,600 294,291,600 2,738,978,000 0.16252796 445,160,498 0.12989242 355,772,472

14 3,033,269,600 294,291,600 2,738,978,000 0.14132866 387,096,085 0.11101916 304,079,036

15 3,033,269,600 735,729,000 2,297,540,600 0.12289449 282,355,069 0.09488817 218,009,424

16 3,033,269,600 294,291,600 2,738,978,000 0.10686477 292,700,253 0.08110100 222,133,856

17 3,033,269,600 294,291,600 2,738,978,000 0.09292589 254,521,959 0.06931709 189,857,997

18 3,033,269,600 294,291,600 2,738,978,000 0.08080512 221,323,443 0.05924538 162,271,792

19 3,033,269,600 294,291,600 2,738,978,000 0.07026532 192,455,168 0.05063708 138,693,839

20 3,033,269,600 735,729,000 2,297,540,600 0.06110028 140,380,372 0.04327955 99,436,530

21 3,033,269,600 294,291,600 2,738,978,000 0.05313068 145,523,756 0.03699107 101,317,729

22 3,033,269,600 294,291,600 2,738,978,000 0.04620059 126,542,397 0.03161630 86,596,350

23 3,033,269,600 294,291,600 2,738,978,000 0.04017443 110,036,867 0.02702248 74,013,974

24 3,033,269,600 294,291,600 2,738,978,000 0.03493428 95,684,232 0.02309614 63,259,807

25 3,033,269,600 735,729,000 2,297,540,600 0.03037764 69,793,855 0.01974029 45,354,110

1,095,903,158 -755,337,510

EIRR 16.18%

Analisa Economic Internal Rate of Return Embung Kembangan, Kondisi Biaya Naik 10%Pola Tanam : Padi - Padi - Polowijo

Tahun Ke NVP NVP

140

60

Kelayakan Ekonomi Embung Kembangan, Kondisi Biaya Normal dan Manfaat turun 10%Pola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 12%



0 14,714,580,000.00 14,714,580,000.00 0.00 1.00000 14,714,580,000.00 0.00

1 294,291,600.00 294,291,600.00 2,729,942,640.00 0.89286 262,760,357.14 2,437,448,785.71

2 294,291,600.00 294,291,600.00 2,729,942,640.00 0.79719 234,607,461.73 2,176,293,558.67

3 294,291,600.00 294,291,600.00 2,729,942,640.00 0.71178 209,470,947.98 1,943,119,248.82

4 294,291,600.00 294,291,600.00 2,729,942,640.00 0.63552 187,027,632.12 1,734,927,900.73

5 294,291,600.00 441,437,400.00 735,729,000.00 2,729,942,640.00 0.56743 417,472,393.13 1,549,042,768.51

6 294,291,600.00 294,291,600.00 2,729,942,640.00 0.50663 149,097,283.26 1,383,073,900.45

7 294,291,600.00 294,291,600.00 2,729,942,640.00 0.45235 133,122,574.34 1,234,887,411.12

8 294,291,600.00 294,291,600.00 2,729,942,640.00 0.40388 118,859,441.38 1,102,578,045.64

9 294,291,600.00 294,291,600.00 2,729,942,640.00 0.36061 106,124,501.23 984,444,683.61

10 294,291,600.00 441,437,400.00 735,729,000.00 2,729,942,640.00 0.32197 236,885,047.38 878,968,467.51

11 294,291,600.00 294,291,600.00 2,729,942,640.00 0.28748 84,601,802.64 784,793,274.56

12 294,291,600.00 294,291,600.00 2,729,942,640.00 0.25668 75,537,323.78 700,708,280.86

13 294,291,600.00 294,291,600.00 2,729,942,640.00 0.22917 67,444,039.09 625,632,393.62

14 294,291,600.00 294,291,600.00 2,729,942,640.00 0.20462 60,217,892.05 558,600,351.45

15 294,291,600.00 441,437,400.00 735,729,000.00 2,729,942,640.00 0.18270 134,414,937.60 498,750,313.79

16 294,291,600.00 294,291,600.00 2,729,942,640.00 0.16312 48,005,334.86 445,312,780.17

17 294,291,600.00 294,291,600.00 2,729,942,640.00 0.14564 42,861,906.12 397,600,696.58

18 294,291,600.00 294,291,600.00 2,729,942,640.00 0.13004 38,269,559.04 355,000,621.95

19 294,291,600.00 294,291,600.00 2,729,942,640.00 0.11611 34,169,249.14 316,964,841.03

20 294,291,600.00 441,437,400.00 735,729,000.00 2,729,942,640.00 0.10367 76,270,645.41 283,004,322.34

21 294,291,600.00 294,291,600.00 2,729,942,640.00 0.09256 27,239,516.22 252,682,430.66

22 294,291,600.00 294,291,600.00 2,729,942,640.00 0.08264 24,320,996.62 225,609,313.09

23 294,291,600.00 294,291,600.00 2,729,942,640.00 0.07379 21,715,175.56 201,436,886.69

24 294,291,600.00 294,291,600.00 2,729,942,640.00 0.06588 19,388,549.60 179,854,363.12

25 294,291,600.00 441,437,400.00 735,729,000.00 2,729,942,640.00 0.05882 43,278,012.51 160,584,252.78

Jumlah 17,567,742,579.93 21,411,319,893.48

NPV 3,843,577,313.55BCR 1.22



Berkala 3%/5th

141

Kelayakan Ekonomi Embung Kembangan, Kondisi Biaya Normal dan Manfaat turun 10%Pola Tanam : Padi - Padi - Polowijo

Faktor Diskon = 15%



0 14,714,580,000.00 14,714,580,000 0 1.00000000 14,714,580,000.00 0.00

1 294,291,600 294,291,600 2,729,942,640 0.86956522 255,905,739.13 2,373,863,165.22

2 294,291,600 294,291,600 2,729,942,640 0.75614367 222,526,729.68 2,064,228,839.32

3 294,291,600 294,291,600 2,729,942,640 0.65751623 193,501,504.07 1,794,981,599.41

4 294,291,600 294,291,600 2,729,942,640 0.57175325 168,262,177.45 1,560,853,564.70

5 294,291,600 441,437,400 735,729,000 2,729,942,640 0.49717674 365,787,342.28 1,357,263,969.31

6 294,291,600 294,291,600 2,729,942,640 0.43232760 127,230,379.92 1,180,229,538.53

7 294,291,600 294,291,600 2,729,942,640 0.37593704 110,635,112.98 1,026,286,555.24

8 294,291,600 294,291,600 2,729,942,640 0.32690177 96,204,446.07 892,423,091.51

9 294,291,600 294,291,600 2,729,942,640 0.28426241 83,656,040.06 776,020,079.58

10 294,291,600 441,437,400 735,729,000 2,729,942,640 0.24718471 181,860,956.65 674,800,069.20

11 294,291,600 294,291,600 2,729,942,640 0.21494322 63,255,984.92 586,782,668.87

12 294,291,600 294,291,600 2,729,942,640 0.18690715 55,005,204.28 510,245,799.02

13 294,291,600 294,291,600 2,729,942,640 0.16252796 47,830,612.42 443,691,999.14

14 294,291,600 294,291,600 2,729,942,640 0.14132866 41,591,836.88 385,819,129.69

15 294,291,600 441,437,400 735,729,000 2,729,942,640 0.12289449 90,417,036.71 335,494,895.38

16 294,291,600 294,291,600 2,729,942,640 0.10686477 31,449,404.07 291,734,691.64

17 294,291,600 294,291,600 2,729,942,640 0.09292589 27,347,307.89 253,682,340.55

18 294,291,600 294,291,600 2,729,942,640 0.08080512 23,780,267.73 220,593,339.61

19 294,291,600 294,291,600 2,729,942,640 0.07026532 20,678,493.68 191,820,295.32

20 294,291,600 441,437,400 735,729,000 2,729,942,640 0.06110028 44,953,247.12 166,800,256.80

21 294,291,600 294,291,600 2,729,942,640 0.05313068 15,635,912.04 145,043,701.56

22 294,291,600 294,291,600 2,729,942,640 0.04620059 13,596,445.26 126,124,957.88

23 294,291,600 294,291,600 2,729,942,640 0.04017443 11,822,995.87 109,673,876.42

24 294,291,600 294,291,600 2,729,942,640 0.03493428 10,280,865.98 95,368,588.19

25 294,291,600 441,437,400 735,729,000 2,729,942,640 0.03037764 22,349,708.65 82,929,207.12

Jumlah 17,040,145,751.79 17,646,756,219.20

NPV 606,610,467.41BCR 1.036



Berkala 3%/5th

142

60


1 2 3 4 5 6 7 8

0 0 14,714,580,000 -14,714,580,000 1.00000000 -14,714,580,000 1.00000000 -14,714,580,000

1 2,729,942,640 294,291,600 2,435,651,040 0.86956522 2,117,957,426 0.85470085 2,081,753,026

2 2,729,942,640 294,291,600 2,435,651,040 0.75614367 1,841,702,110 0.73051355 1,779,276,090

3 2,729,942,640 294,291,600 2,435,651,040 0.65751623 1,601,480,095 0.62437056 1,520,748,795

4 2,729,942,640 294,291,600 2,435,651,040 0.57175325 1,392,591,387 0.53365005 1,299,785,295

5 2,729,942,640 735,729,000 1,994,213,640 0.49717674 991,476,627 0.45611115 909,583,081

6 2,729,942,640 294,291,600 2,435,651,040 0.43232760 1,052,999,159 0.38983859 949,510,771

7 2,729,942,640 294,291,600 2,435,651,040 0.37593704 915,651,442 0.33319538 811,547,668

8 2,729,942,640 294,291,600 2,435,651,040 0.32690177 796,218,645 0.28478237 693,630,485

9 2,729,942,640 294,291,600 2,435,651,040 0.28426241 692,364,040 0.24340374 592,846,569

10 2,729,942,640 735,729,000 1,994,213,640 0.24718471 492,939,113 0.20803738 414,870,987

11 2,729,942,640 294,291,600 2,435,651,040 0.21494322 523,526,684 0.17780973 433,082,452

12 2,729,942,640 294,291,600 2,435,651,040 0.18690715 455,240,595 0.15197413 370,155,942

13 2,729,942,640 294,291,600 2,435,651,040 0.16252796 395,861,387 0.12989242 316,372,600

14 2,729,942,640 294,291,600 2,435,651,040 0.14132866 344,227,293 0.11101916 270,403,932

15 2,729,942,640 735,729,000 1,994,213,640 0.12289449 245,077,859 0.09488817 189,227,284

16 2,729,942,640 294,291,600 2,435,651,040 0.10686477 260,285,288 0.08110100 197,533,736

17 2,729,942,640 294,291,600 2,435,651,040 0.09292589 226,335,033 0.06931709 168,832,253

18 2,729,942,640 294,291,600 2,435,651,040 0.08080512 196,813,072 0.05924538 144,301,071

19 2,729,942,640 294,291,600 2,435,651,040 0.07026532 171,141,802 0.05063708 123,334,249

20 2,729,942,640 735,729,000 1,994,213,640 0.06110028 121,847,010 0.04327955 86,308,675

21 2,729,942,640 294,291,600 2,435,651,040 0.05313068 129,407,790 0.03699107 90,097,340

22 2,729,942,640 294,291,600 2,435,651,040 0.04620059 112,528,513 0.03161630 77,006,274

23 2,729,942,640 294,291,600 2,435,651,040 0.04017443 97,850,881 0.02702248 65,817,328

24 2,729,942,640 294,291,600 2,435,651,040 0.03493428 85,087,722 0.02309614 56,254,126

25 2,729,942,640 735,729,000 1,994,213,640 0.03037764 60,579,498 0.01974029 39,366,349

606,610,467 -1,032,933,621

EIRR 15.74%

Analisa Economic Internal Rate of Return Embung Kembangan

Pola Tanam : Padi - Padi - Polowijo

Tahun Ke NVP NVP

Kondisi Biaya Normal dan Manfaat turun 10%

No Kondisi EIRR NPV (milyar) BCR

1 Normal 17.774% 6.223 1.354

2 Biaya proyek naik 10%, manfaat normal 16.184% 4.466 1.231

3 Biaya proyek normal, manfaat turun 10% 15.740% 3.844 1.219

Rekapitulasi Hasil Analisa Kelayakan dengan Tubuh Embung dari Timbunan

143

Lampiran 5. Data Tanah

berdasarkan hasil dari “analis pembangunan embung …repository.untag-sby.ac.id/8740/5/bab...

Documents