LAMPIRAN
Lampiran 1. Perhitungan Biaya Variabel Tiap WTP
Nilai Total
Uraian
(Rp/per bulan)
gaji pegawai
1,266,000.00
bahan kimia
17,000,000.00
perbaikan dan perawatan
5,000,000.00
Listrik *
35,000,000.00
* Listrik WTP Sungai Cihideung Rp. 9,000,000.00, WTP Sungai Ciapus Rp. 26,000,000.00 (biaya listrik PLN)
Jumlah
Rincian Gaji Pegawai
(Rp)
Pokok
400,000.00
Uang makan
147,000.00
Lembur
719,000.00 1,266,000.00
TOTAL
Waktu Kerja
Kapasitas
Penggunaan
Jumlah
per hari
Produksi
Listrik per
Pegawai
(jam)
(l/s)
jam (kWh)
(orang)
Cihideung 1-4
18.5
32.17
1,341.672
Cihideung 5 (UF System)
5.5
7.92
608.289
Ciapus Asrama TPB
20
18.69
961.990
2
20
12.55
768.817
4
WTP
Ciapus Perumahan Dosen dan Asrama lain ο·
6
Perhitungan biaya variabel untuk WTP Cihideung 5 :
Gaji Pegawai = =
πππ πππππ πππ πΆπβππππ’ππ 5 π₯ππ’πππβ πππππ€ππ πππ πΆπβππππ’πππ₯ππππ πππ πππππ π‘ππ‘ππ πππ πππππ πππ πΆπβππππ’ππ 5.5 π₯6π₯π
π. 1,266,000/ππ’πππ = π
π. 612,474.10/ππ’πππ 18.5π₯4 + 5.5
43
Bahan Kimia Perbandingan harga dan pemakaian bahan kimia : Jenis bahan kimia
Kiriman per 2 bulan (kg)
Harga
Perbandingan
Pemakaian
Pemakaian
(Rp)
harga
WTP Cihideung 1-4
WTP Cihideung 5
PAC
3,800
3,850
0.28
14kg/250 liter/hari
14kg/250 liter/3hari
Tawas
-
3,350
0.30
-
-
Kaporit
585
28,650
0.40
6/7 bagian
1/7 bagian
NaOH
160
4,800
0.02
6/7 bagian
1/7 bagian
HCl
75
3,600
0.01
6/7 bagian
1/7 bagian
Contoh perhitungan biaya NaOH : 1 π₯ππππππππππππ βππππ π₯ ππππ¦π π‘ππ‘ππ ππβπππππππ 7 1 = π₯0.02 π₯ π
π. 17,000,000.00 = π
π. 48,571.43/ππ’πππ 7 =
Biaya Maintenance = =
πππ πππππ πππ πΆπβππππ’ππ 5 π₯ππππ¦π π‘ππ‘ππ πππππ‘πππππππππ ππ’πππ π‘ππ‘ππ πππ πππππ πππ 5.5 πππ 18.5π₯4 + 5.5 + 20 + 20 πππ
π₯π
π. 5,000,000.00/ππ’πππ = π
π. 230,125.52/ππ’πππ
Biaya Listrik =
ππβ πππ π‘πππ πππ πΆπβππππ’ππ 5 π₯π‘ππ‘ππ πππ π‘πππ πππ πΆπβππππ’πππππ ππ’πππ π‘ππ‘ππ ππβ πππ π‘πππ πππ πΆπβππππ’ππ
=
608.289 π₯π
π. 9,500,000.00/ππ’πππ = π
π. 2,963,518.49/ππ’πππ 1,341.672 + 608.289
Rincian Biaya Variabel Tiap WTP per Tahun : Uraian
WTP Cihideung 1-4
WTP Cihideung 5
WTP Asrama TPB
WTP Perumdos dan Asrama lain
Rp/tahun Gaji Pegawai
84,845,886.79
6,306,113.21
60,768,000.00
30,384,000.00
Bahan Kimia
114,822,857.14
19,137,142.86
51,340,000.00
20,740,000.00
Maintenance
37,154,811.72
2,761,506.28
10,041,841.00
10,041,841.00
Listrik
78,437,778.07
35,562,221.93
173,410,999.33
138,589,000.67
315,261,333.72
63,766,984.27
295,560,840.34
199,754,841.67
Total
44
Lampiran 2. Rincian Pendapatan Tiap WTP Pendapatan Tiap WTP (Unit Usaha dalam Kampus) WTP Uraian
CIHIDEUNG
CIAPUS Perumdos &
WTP 1-4
WTP 5
Asrama TPB
Jam Kerja (menit)
4440
330
1200
1200
Kapasitas Produksi (L/s)
32.17
7.92
18.69
12.55
Pendapatan Profit dari Struk (Rp/bln)
48,743,440.46
Asrama lain Total Pendapatan
4,693,786.84
Pendapatan Profit per WTP (Rp/bln)
39,113,905.70
9,629,534.76
2,808,158.65
1,885,628.20
53,437,227.30
Pendapatan Profit per WTP (Rp/tahun)
469,366,868.42
115,554,417.09
33,697,903.76
22,627,538.37
641,246,727.66
Contoh perhitungan pendapatan tiap WTP : Pendapatan WTP Cihideung 5 per tahun =
πππππ ππ‘ππ πππππ’ππ π πππ πΆπβππππ’ππ 5 π₯ ππππππππ‘ππ πππ πΆπβππππ’ππ πππ ππ’πππ π₯ 12 π‘ππ‘ππ πππππ ππ‘ππ πππππ’ππ π πππ πΆπβππππ’ππ
=
7.92 π/π π₯ π
π. 48,743,440.46/bulan π₯ 12ππ’πππ 40.09 π/π
= Rp. 115,554,417.09/tahun
45
Lampiran 3. Analisis Biaya dan Titik Impas WTP Cihideung UF System 1. Analisis Biaya Tetap Spesifikasi Penyusutan Investasi WTP Harga awal (Rp) Harga akhir (Rp) Umur ekonomis (tahun)
Rp/tahun
1,500,000,000.00 150,000,000.00 20
Bunga Modal 15%/tahun
67,500,000.00 118,125,000.00
Biaya Tetap (BT)
185,625,000.00
2. Analisis Biaya dan Titik Impas Spesifikasi Kapasitas produksi WTP (kW) Harga jual air bersih (S) Biaya Tidak Tetap (BTT) Gaji Pegawai Bahan Kimia Maintenance Listrik Total Biaya Tidak Tetap (BTT) Biaya Total (B) Biaya Pokok Produksi (BP) Pendapatan per tahun (I) Keuntungan Titik Impas
Perhitungan
BT+BTT B : kW kW*S I-B BT : ((kW*S) β BTT)
Satuan m3/tahun Rp
Nilai 56,430 4,500
Rp/tahun Rp/tahun Rp/tahun Rp/tahun Rp/tahun Rp/tahun Rp/ m3 Rp/tahun Rp/tahun m3/tahun
6,306,113.21 19,137,142.86 2,761,506.28 35,526,221.93 63,776,984.27 249,391,984.27 4,419.49 253,935,000.00 4,543,015.73 0.98
46
Lampiran 4. Analisis Kelayakan WTP Cihideung UF System (NPV, IRR, dan B/C) Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Biaya (C) 1,500,000,000.00 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27
Keuntungan (B) 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00 253,935,000.00
B-C (1,500,000,000.00) 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73 190,168,015.73
DF 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 0.3759 0.3269 0.2843 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 0.0929 0.0808 0.0703 0.0611 NPV
NPV 15% (1,500,000,000.00) 165,363,491.94 143,794,340.81 125,038,556.57 108,729,179.63 94,547,112.22 82,214,880.63 71,491,200.54 62,166,261.02 54,057,618.27 47,006,624.34 40,875,325.73 35,543,761.50 30,907,618.54 26,876,190.03 23,370,599.90 20,322,260.89 17,671,531.21 15,366,548.80 13,362,216.35 11,619,318.50 (309,675,353.87)
NPV (DF 15%) = Rp -309,675,353.87 IRR = 11.17 % B/C (DF 15%) = 0.83
47
Lampiran 5. Analisis Sensitivitas WTP Cihideung UF System dengan Kenaikan Harga Jual Air Bersih 5% Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Biaya (C) 1,500,000,000.00 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27
Keuntungan (B) 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00 266,631,750.00
B-C (1,500,000,000.00) 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73 202,864,765.73
DF 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 0.3759 0.3269 0.2843 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 0.0929 0.0808 0.0703 0.0611 NPV
NPV 15% (1,500,000,000.00) 176,404,144.11 153,394,907.92 133,386,876.45 115,988,588.22 100,859,641.93 87,704,036.46 76,264,379.53 66,316,851.77 57,666,827.62 50,145,067.50 43,604,406.52 37,916,875.24 32,971,195.86 28,670,605.09 24,930,960.95 21,679,096.48 18,851,388.24 16,392,511.51 14,254,357.84 12,395,093.77 (230,202,186.98)
NPV (DF 15%) = Rp -230,202,186.98 IRR = 12.19% B/C (DF 15%) = 0.88
48
Lampiran 6. Analisis Sensitivitas WTP Cihideung UF System dengan Kenaikan Harga Jual Air Bersih 10% Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Biaya (C) 1,500,000,000.00 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27
Keuntungan (B) 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00 279,328,500.00
B-C (1,500,000,000.00) 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73 215,561,515.73
DF 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 0.3759 0.3269 0.2843 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 0.0929 0.0808 0.0703 0.0611 NPV
NPV 15% (1,500,000,000.00) 187,444,796.28 162,995,475.03 141,735,195.68 123,247,996.24 107,172,170.64 93,193,191.87 81,037,558.14 70,467,441.86 61,276,036.40 53,283,509.92 46,333,486.88 40,289,988.59 35,034,772.69 30,465,019.73 26,491,321.51 23,035,931.74 20,031,244.99 17,418,473.91 15,146,499.05 13,170,868.74 (150,729,020.09)
NPV (DF 15%) = Rp -150,729,020.09 IRR = 13.17% B/C (DF 15%) = 0.92
49
Lampiran 7. Analisis Sensitivitas WTP Cihideung UF System dengan Kenaikan Harga Jual Air Bersih 12% Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Biaya (C) 1,500,000,000.00 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27
Keuntungan (B) 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00 284,407,200.00
B-C (1,500,000,000.00) 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73 220,640,215.73
DF 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 0.3759 0.3269 0.2843 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 0.0929 0.0808 0.0703 0.0611 NPV
NPV 15% (1,500,000,000.00) 191,861,057.15 166,835,701.87 145,074,523.37 126,151,759.45 109,697,182.13 95,388,854.03 82,946,829.59 72,127,677.90 62,719,719.92 54,538,886.88 47,425,119.03 41,239,233.94 35,860,203.42 31,182,785.59 27,115,465.73 23,578,665.85 20,503,187.70 17,828,858.87 15,503,355.54 13,481,178.73 (118,939,753.33)
NPV (DF 15%) = Rp -118,939,753.33 IRR = 13.58% B/C (DF 15%) = 0.94
50
Lampiran 8. Analisis Sensitivitas WTP Cihideung UF System dengan Kenaikan Harga Jual Air Bersih 14% Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Biaya (C) 1,500,000,000.00 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27
Keuntungan (B) 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00 289,485,900.00
B-C (1,500,000,000.00) 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73 225,718,915.73
DF 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 0.3759 0.3269 0.2843 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 0.0929 0.0808 0.0703 0.0611 NPV
NPV 15% (1,500,000,000.00) 196,277,318.02 170,675,928.72 148,413,851.06 129,055,522.66 112,222,193.62 97,584,516.19 84,856,101.03 73,787,913.94 64,163,403.43 55,794,263.85 48,516,751.17 42,188,479.28 36,685,634.16 31,900,551.44 27,739,609.95 24,121,399.96 20,975,130.40 18,239,243.82 15,860,212.02 13,791,488.71 (87,150,486.58)
NPV (DF 15%) = Rp -87,150,486.58 IRR = 13.99% B/C (DF 15%) = 0.95
51
Lampiran 9. Analisis Sensitivitas WTP Cihideung UF System dengan Kenaikan Harga Jual Air Bersih 15% Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Biaya (C) 1,500,000,000.00 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27
Keuntungan (B) 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00 292,025,250.00
B-C (1,500,000,000.00) 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73 228,258,265.73
DF 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 0.3759 0.3269 0.2843 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 0.0929 0.0808 0.0703 0.0611 NPV
NPV 15% (1,500,000,000.00) 198,485,448.46 172,596,042.14 150,083,514.90 130,507,404.26 113,484,699.36 98,682,347.27 85,810,736.76 74,618,031.96 64,885,245.18 56,421,952.33 49,062,567.25 42,663,101.95 37,098,349.52 32,259,434.37 28,051,682.06 24,392,767.01 21,211,101.75 18,444,436.30 16,038,640.26 13,946,643.71 (71,255,853.20)
NPV (DF 15%) = Rp -71,255,853.20 IRR = 14.14 % B/C (DF 15%) = 0.96
52
Lampiran 10. Analisis Sensitivitas WTP Cihideung UF System dengan Kenaikan Harga Jual Air Bersih 16% Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Biaya (C) 1,500,000,000.00 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27
Keuntungan (B) 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00 294,564,600.00
B-C (1,500,000,000.00) 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73 230,797,615.73
DF 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 0.3759 0.3269 0.2843 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 0.0929 0.0808 0.0703 0.0611 NPV
NPV 15% (1,500,000,000.00) 200,693,578.89 174,516,155.56 151,753,178.75 131,959,285.87 114,747,205.10 99,780,178.35 86,765,372.48 75,448,149.98 65,607,086.94 57,049,640.82 49,608,383.32 43,137,724.63 37,511,064.89 32,618,317.30 28,363,754.17 24,664,134.06 21,447,073.10 18,649,628.78 16,217,068.50 14,101,798.70 (55,361,219.82)
NPV (DF 15%) = Rp -55,361,219.82 IRR = 14.34 % B/C (DF 15%) = 0.97
53
Lampiran 11. Analisis Sensitivitas WTP Cihideung UF System dengan Kenaikan Harga Jual Air Bersih 18% Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Biaya (C) 1,500,000,000.00 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27
Keuntungan (B) 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00 299,643,300.00
B-C (1,500,000,000.00) 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73 235,876,315.73
DF 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 0.3759 0.3269 0.2843 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 0.0929 0.0808 0.0703 0.0611 NPV
NPV 15% (1,500,000,000.00) 205,109,839.76 178,356,382.40 155,092,506.44 134,863,049.08 117,272,216.59 101,975,840.51 88,674,643.92 77,108,386.02 67,050,770.45 58,305,017.78 50,700,015.46 44,086,969.97 38,336,495.63 33,336,083.15 28,987,898.39 25,206,868.17 21,919,015.80 19,060,013.74 16,573,924.99 14,412,108.69 (23,571,953.07)
NPV (DF 15%) = Rp -23,571,953.07 IRR = 14.73 % B/C (DF 15%) = 0.98
54
Lampiran 12. Analisis Sensitivitas WTP Cihideung UF System dengan Kenaikan Harga Jual Air Bersih 20% Tahun ke0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Biaya (C) 1,500,000,000.00 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27 63,776,984.27
Keuntungan (B) 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00 304,722,200.00
B-C (1,500,000,000.00) 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73 240,955,015.73
DF 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 0.3759 0.3269 0.2843 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 0.0929 0.0808 0.0703 0.0611 NPV
NPV 15% (1,500,000,000.00) 209,526,100.63 182,196,609.24 158,431,834.13 137,766,812.28 119,797,228.07 104,171,502.67 90,583,915.37 78,768,622.06 68,494,453.96 59,560,394.75 51,791,647.61 45,036,215.31 39,161,926.36 34,053,849.01 29,612,042.62 25,749,602.27 22,390,958.50 19,470,398.70 16,930,781.47 14,722,418.67 8,217,313.69
NPV (DF 15%) = Rp 8,217,313.69 IRR = 15.10 % B/C (DF 15%) = 1.00
55