Thursday, 21 September, 2017
Prepared by Supriyanto
RESUME PROGRAM KEMITRAAN PAPRIKA SISTEM HIDROPONIK Greenhouse Population per GH Productivity per Plant Mortality
2 unit 1100 meter 2,5 10,0%
Prodction Capacity 51,9% 48,1%
4.950 kg 2.568 kg 2.382 kg 27.500 Rp/kg 45000 Rp/kg
Green Paprika Red Paprika Price of Green Paprika Price of Red Paprika Total Revenue Selling of Green Paprika Selling of Red Paprika
Electricity
Thursday, 21 September, 2017
177.817.332 70.608.479 107.208.853 PLN
39,7% 60,3%
Start
01-06-16
Week
22
Operating System
BUMR
Credit of Investment Credit of Working Capital ECONOMIC ANALYSIS Return On Investment Return On Sales Break Even Point
0% 0%
Production Cost per Unit
LAYAK 123,52% 21,19% 244.519.903 3.585,8 kg 115,24% 44.536
R/C RATIO NPV Internal Rate of Return (IRR) Pay Back Periode (PBP)
1,4 178.579.823 27,21% 2,51
Rp
SIKLUS
1 SIKLUS
VARIABLE COST
37,28%
Labor Seedling Preparation Cultivation Logistics / Material Seedling Preparation Cultivation FIXED COST Management Labor Marketing
7,46% 0,00% 7,46% 29,83% 9,19% 20,64% 62,72% 6,88% 19,50% 5,74%
Office Operation Transportation Depreciation INTEREST TAX
3,44% 1,72% 5,94% 0,00% 1,62%
Prepared by Supriyanto
Catatan : Harga paprika selama beberapa bulan terakhir berkisar anara: Paprika Hijau : 23.000 – 30.000 (rata-rata 27.500) Paprika Merah : 30.000 – 50.000 (rata-rata 40.000) Dengan variable produktifitas 2,25 kg/tanaman (kenyataannya belum pernah mencapai 2,5 – 3,0 kg/tanaman, dan tingkat kematian tanaman cukup tinggi >10% maka SMKN 1 Pacet harus mengoerasionalkan minimal 2 greenhouse untuk mencapai KELAYAKAN budidaya paprika dengan system hidroponik. Beban biaya tetap (fixed cost) terlalu berat apabila dibebankan hanya untuk produksi paprika 1 greenhouse, terutama beban biaya manajemen/supervisor dan biaya penyusutan (depresiation) meskipun sudah disusutkan selama 7 tahun (semula dicoba penyusutan selama 5 tahun).
Thursday, 21 September, 2017
Prepared by Supriyanto
FasilitasProduksi :
Fasilitas utama budidaya paprika secara organik pada SMKN 1 Pacet, Kabupaten Cianjur adalah :
□
Greenhouse dengan ukuran 8 x 37,5 m, sebanyak 9 unit dan 2 unit digunakan untuk paprika, 1 unit untuk pesemaian dan sisanya diguakan untuk praktek budidaya berbagai jenis tanaman sayuran.
□
Instalasi Fertigasi, terdiri dari toren penampungan larutan Nutrisi AB Mix, pompa pendorong yang dilengkapi filter, pipa distribusi ke masing-masing greenhouse dan jaringan pipa drip irigasi.
□
Gudang bahan baku, terutama untuk penyimpangan media tanam cocopeat, dan bahan kimia AB Mix.
Tenaga Kerja : □ Supervisor 1 orang tenaga tenaga berpengalaman di bidang hidropnik; □ Helper, 1 – 2 orang tenaga kerja honorer.
Thursday, 21 September, 2017
prepared by Supriyanto
Standard OpertingProcedures: A. Pembibitan □ Benih paprika direndam air hangat ± 1 jam, kemudian ditanam pada pottray 200 lubang dengan media cocopeat dan diperam dalam kotak perkecambahan (germination box) selama 1 – 2 hari. □ Setelah berkecambah dikeluarkan dari kotak perkecambahan dan disusun pada plantbed dalam greenhouse pesemaian. □ Dipelihara selama 1 miggu dilakukan pemeliharaan terutama penyiraman/penyemprotan dengan air bersih dengan menjaga kelemban media semai; □ Setelah keluar satu pasang daun, bibit dipindahkan ke dalam polybag dengan media cocopeat dan mulai disiram dengan nutrisi AB Mix dengan dosis 0,75 mg/liter. Setiap polybag disiram sebanyak 250 ml 2 kali per hari pada minggu ke-2 dan minggu ke-3;
Thursday, 21 September, 2017
prepared by Supriyanto
B. Budidaya □ Bibit paprika yang sudah siap tanam dipindahkan ke dalam polybag 30 x 30 dengan media tanam cocopeat yang telah dijenuhi air; □ Pemberian Nutrisi AB Mix melalui drip irigasi dengan dosis : Minggu-1 : 250 ml/polybag 2 kali sehari (0,75 mg/liter) Minggu-2 : 400 ml/polybag 2 kali sehari (1,20 mg/liter) Minggu-3 s/g 7 : 500 ml/polybag 2 kali sehari (1,50 mg/liter) Minggu-8 dst : 500 ml/polybag 2 kali sehari (2,50 mg/liter)
□ Pemasangan tali pada setiap batang tanaman, 28 roll/greenhouse; □ Setiap tanaman dipelihara 2 cabang, tunas lateral diwiwil (prunning) dan buah yang terbentuk pada setiap ruas disisakan 4 buah untuk produksi (Hijau 2 buah dan Merah 2 buah); □ Pengendalian Hama/Penyakit tanaman dilakukan dengan pestisida 2 kali per minggu; □ Panen mulai umur 65 hari atau 10 minggu setelah tanam dan dapat dipertahankan selama 24 minggu (6 bulan), dengan target 2,5 – 3,0 kg/tanaman.
Thursday, 21 September, 2017
A Frame Hydroponic System, prepared by Supriyanto
• Produktifitas tanaman tidak sesuai dengan yang diharapkan, masih dibawah 2,5 kg/tanaman.
Berdasarkan pengamatan di lapangan bahwa jarak tanam relatif terlalu rapat, apalagi dalam satu polybag diisi 2 tanaman. Jarak tanaman yang terlalu rapat akan menyebabkan terjadi kompetisi dalam penyerapan sinar matahari, akibatnya tanaman menjadi etiolasi (jarak antar ruas lebar dan tanaman tidak kuat batangnya) dan tidak tahan terhadap serangan penyakit (khususnya antraknosa) Perakaran tanaman yang berimpitan akan mengakibatkan serapan unsur menjadi terganggu, pada akhirnya produksi tanaman tidak akan optimal. • Tingkat kematian tanaman masih tinggi > 10%, hal ini terkait dengan sering terjadinya pelukaan tanaman karena aktifitas pruning dan panen serta factor lingkungan (temperature dan kelembaban yang tinggi di dalam greenhouse) yang mendukung perkembangan pathogen khususnya jamur.
Thursday, 21 September, 2017
Prepared by Supriyanto
Optimalisasi produksi masih bisa dilakukan dengan cara sebagai berikut:
□ Meningkatkan produktifitas tanaman minimal 2,5 kg.tanaman dengan cara mengatur ulang jarak tanam untuk meningkatkan intensitas cahaya matahari dan sirkulasi udara, serta mengatur pemberian nutrisi AB Mix yang lebih baik; □ Penanaman 1 tanaman/polybag dan pengaturan jarak tanam akan menciptakan kondisi lingkungan (agroklmat) yang lebih baik (sirkulasi udara lebih baik, intensitas cahaya lebih tinggi dan kelembaban lebih rendah). Kondisi ini dapat menekan perkembangan hama/penyakit sehingga prosentase kematian tanaman<10% ; □ Penerapan pewiwilan (pruning) yang lebih aman, harus dilakukan pada waktu siang hari (terik matahari) agar luka cepat kering untuk mencegah terjadinya infeksi patogen; □ Training ulang helper untuk lebih menguasai SOP dan pengendalian hama/penyakit tanaman paprika; □ Tambah operasional Greenhosue.
Thursday, 21 September, 2017
Prepared by Supriyanto
LAMPIRAN
seed
1
GH PREPARATION
Sa ni ta ti on Pl a ntbed Forma ti on Mul chi ng Steri l i za ti on
3
MEDIA PREPARATION
PLANTING
4
FERTIGATION
5
BRANCH SELECTION
6
STRING INSTALATION
7
PRUNNING
8
PEST-DISEASES CONTROL
9
HARVEST & PACKAGING
5 / 2017
4 / 2017
3 / 2017
2 / 2017
1 / 2017
-
-
-
-
-
seed
2.420
-
-
-
-
-
-
-
2.420
-
-
-
polybag
1.210
-
-
-
-
-
-
-
1.210
-
-
-
plant
4.840
-
-
-
-
-
-
-
-
4.840
-
-
polybag
2.420
-
-
-
-
-
-
-
-
2.420
-
-
plant
-
2.200
-
-
-
-
-
-
-
2.200
-
-
polybag
-
1.100
-
-
-
-
-
-
-
1.100
-
-
UNIT unit
5 / 2017
-
12
4 / 2017
2.420
-
2
-
-
-
-
-
-
-
2
-
-
-
1.100
-
-
-
-
-
-
-
1.100
-
-
-
2
-
-
-
-
-
-
-
2
-
-
-
1.100
-
-
-
-
-
-
-
1.100
-
-
-
2
-
-
-
-
-
-
-
2
-
-
-
10
-
-
-
-
-
-
-
10
-
-
-
2
-
-
-
-
-
-
-
2
-
-
-
10
-
-
-
-
-
-
-
10
-
-
-
2
-
-
-
-
-
-
-
-
2
-
-
10
-
-
-
-
-
-
-
-
10
-
-
plant
2.200
-
-
-
-
-
-
-
-
2.200
-
-
polybag
1.100
-
-
-
-
-
-
-
-
1.100
-
-
plant
-
2.200
-
-
-
-
-
-
-
2.200
-
-
polybag
-
1.100
-
-
-
-
-
-
-
1.100
-
-
plant
-
11.000
8.800
8.800
11.000
8.800
8.800
11.000
4.400
4.400
11.000
8.800
polybag
-
5.500
4.400
4.400
5.500
4.400
4.400
5.500
2.200
2.200
5.500
4.400
plant
-
2.200
-
-
-
-
-
-
-
-
2.200
-
polybag
-
1.100
-
-
-
-
-
-
-
-
1.100
-
plant
-
2.200
-
-
-
-
-
-
-
-
2.200
-
polybag
-
1.100
-
-
-
-
-
-
-
-
1.100
-
plant
-
4.400
8.800
8.800
11.000
8.800
8.800
6.600
-
-
8.800
8.800
polybag
-
2.200
4.400
4.400
5.500
4.400
4.400
3.300
-
-
4.400
4.400
plant
-
8
8
8
10
8
8
10
-
2
10
8
polybag
-
4.400
4.400
4.400
5.500
4.400
4.400
5.500
-
1.100
5.500
4.400
HIJAU
-
-
-
481
531
432
444
494
185
-
-
272
MERAH
-
-
-
309
518
432
432
506
185
-
-
99
TOTAL
-
-
-
790
1.049
864
876
1.000
370
-
-
370
GH GH GH GH pol yba g
2
12 / 2016
-
-
pol yba g 1.4
11 / 2016
-
-
pol yba g 1.3
10 / 2016
-
-
pol yba g 1.2
9 / 2016
-
polybag 1.1
12
-
3 / 2017
CULTIVATION
11
-
2 / 2017
NO
10
-
1 / 2017
DELIVERY
9
-
12 / 2016
4
8
-
11 / 2016
FERTIGATION
7
-
10 / 2016
3
6
12
9 / 2016
SOWING
5
2.420
tray 2
4
8 / 2016
SOWING MEDIA PREPARATION
7 / 2016
1
UNIT
3
7 / 2016
SEEDLING PREPARATION
2
6 / 2016
NO
1
8 / 2016
FLOW PROCESS
6 / 2016
A
Thursday, 21 September, 2017
Prepared by Supriyanto
A
PRODUCTION
1
SOWING & WATERING
2 3
B
C
5 / 2017
4 / 2017
3 / 2017
2 / 2017
1 / 2017
12 / 2016
11 / 2016
10 / 2016
UNIT
9 / 2016
DESCRIPTION
7 / 2016
NO
8 / 2016
COST OF PRODUCTION & REVENUE PROJECTION (Seedling preparation - planting - harvest) 6 / 2016
D
seed
2.420
-
-
-
-
-
-
-
2.420
-
-
-
polybag
1.210
-
-
-
-
-
-
-
1.210
-
-
-
plant
-
2.200
-
-
-
-
-
-
-
2.200
-
-
polybag
-
1.100
-
-
-
-
-
-
-
1.100
-
-
HIJAU
-
-
-
481
531
432
444
494
185
-
-
272
MERAH
-
-
-
309
518
432
432
506
185
-
-
99
TOTAL
-
-
-
790
1.049
864
876
1.000
370
-
-
370
REVENUE
Rp
-
-
-
27.126.246,88
37.927.369,08
31.323.254,36
31.662.718,20
36.353.491,27
13.424.251,87
-
-
11.912.094,76
Paprika Selling
PLANTING HARVEST & PACKAGING
Rp
-
-
-
27.126.247
37.927.369
31.323.254
31.662.718
36.353.491
13.424.252
-
-
11.912.095
Hijau
Rp
-
-
-
13.239.090
14.596.945
11.881.234
12.220.698
13.578.554
5.091.958
-
-
7.468.204
Merah
Rp
-
-
-
13.887.157
23.330.424
19.442.020
19.442.020
22.774.938
8.332.294
-
-
4.443.890
COST PRODUCTION
Rp
30.005.352,73
3.938.943,77
3.789.662,41
3.990.279,37
4.987.881,79
3.990.318,46
3.990.324,97
4.981.855,73
16.846.230,49
20.217.019,87
4.987.328,02
3.990.057,86
Seedling Preparation
Rp
7.432.662,73
-
-
-
-
-
-
-
11.766.863,84
19.646,17
-
-
Labor
Rp
-
-
-
-
-
-
-
-
-
-
-
-
Logistics / Material
Rp
7.432.662,73
-
-
-
-
-
-
-
11.766.863,84
19.646,17
-
-
Cultivation
Rp
22.572.690,00
3.938.943,77
3.789.662,41
3.990.279,37
4.987.881,79
3.990.318,46
3.990.324,97
4.981.855,73
5.079.366,65
20.197.373,71
4.987.328,02
3.990.057,86
Labor
Rp
1.200.000,00
1.500.000,00
1.200.000,00
1.200.000,00
1.500.000,00
1.200.000,00
1.200.000,00
1.500.000,00
1.200.000,00
1.200.000,00
1.500.000,00
1.200.000,00
Logistics / Material
Rp
21.372.690,00
2.438.943,77
2.589.662,41
2.790.279,37
3.487.881,79
2.790.318,46
2.790.324,97
3.481.855,73
3.879.366,65
18.997.373,71
3.487.328,02
2.790.057,86
D
GROSS PROFIT/LOST
Rp
(30.005.352,73)
(3.938.943,77)
(3.789.662,41)
23.135.967,51
32.939.487,29
27.332.935,90
27.672.393,23
31.371.635,54
(3.421.978,62)
(20.217.019,87)
(4.987.328,02)
7.922.036,90
E
ACCUMULATION
Rp
(30.005.352,73)
(33.944.296,49)
(37.733.958,91)
(14.597.991,39)
18.341.495,90
45.674.431,80
73.346.825,03
104.718.460,58
101.296.481,95
81.079.462,08
76.092.134,07
84.014.170,97
A Frame Hydroponic System, prepared by Supriyanto
Thursday, 21 September, 2017
COST OF PRODUCTION & REVENUE PROJECTION (Seedling preparation - planting - harvest) NO A
STAGE
1
B
D E G
SOWING & WATERING
2
PLANTING
3
HARVEST & PACKAGING
6 / 2016
7 / 2016
8 / 2016
9 / 2016
10 / 2016
11 / 2016
12 / 2016
1 / 2017
2 / 2017
3 / 2017
4 / 2017
5 / 2017
seed
2.420
-
-
-
-
-
-
-
2.420
-
-
polybag
1.210
-
-
-
-
-
-
-
1.210
-
-
-
-
2.200,00
-
-
-
-
-
-
-
2.200,00
-
-
-
1.100,00 -
-
481,42 308,60 790,02
530,80 518,45 1.049,25
432,04 432,04 864,09
444,39 432,04 876,43
493,77 506,11 999,88
185,16 185,16 370,32
1.100,00 -
-
271,57 98,75 370,32
Rp
-
-
-
27.126.246,88
37.927.369,08
31.323.254,36
31.662.718,20
36.353.491,27
13.424.251,87
-
-
11.912.094,76
Rp Rp Rp
-
-
-
27.126.247 13.239.090 13.887.157
37.927.369 14.596.945 23.330.424
31.323.254 11.881.234 19.442.020
31.662.718 12.220.698 19.442.020
36.353.491 13.578.554 22.774.938
13.424.252 5.091.958 8.332.294
-
-
11.912.095 7.468.204 4.443.890
plant polybag HIJAU MERAH TOTAL
REVENUE 1
C
UNIT
PRODUCTION
Paprika Selling Hijau Merah
COST PRODUCTION
-
Rp
37.541.037,25
11.474.628,29
11.325.346,94
11.525.963,89
12.523.566,31
11.526.002,98
11.526.009,50
12.517.540,25
24.381.915,02
27.752.704,39
12.523.012,54
11.525.742,38
1
Variable Cost 1.1 Labor Seedling Preparation Cultivation 1.2 Logistics / Material Seedling Preparation Cultivation
Rp Rp Rp Rp Rp Rp Rp
30.005.352,73 1.200.000,00 1.200.000,00 28.805.352,73 7.432.662,73 21.372.690,00
3.938.943,77 1.500.000,00 1.500.000,00 2.438.943,77 2.438.943,77
3.789.662,41 1.200.000,00 1.200.000,00 2.589.662,41 2.589.662,41
3.990.279,37 1.200.000,00 1.200.000,00 2.790.279,37 2.790.279,37
4.987.881,79 1.500.000,00 1.500.000,00 3.487.881,79 3.487.881,79
3.990.318,46 1.200.000,00 1.200.000,00 2.790.318,46 2.790.318,46
3.990.324,97 1.200.000,00 1.200.000,00 2.790.324,97 2.790.324,97
4.981.855,73 1.500.000,00 1.500.000,00 3.481.855,73 3.481.855,73
16.846.230,49 1.200.000,00 1.200.000,00 15.646.230,49 11.766.863,84 3.879.366,65
20.217.019,87 1.200.000,00 1.200.000,00 19.017.019,87 19.646,17 18.997.373,71
4.987.328,02 1.500.000,00 1.500.000,00 3.487.328,02 3.487.328,02
3.990.057,86 1.200.000,00 1.200.000,00 2.790.057,86 2.790.057,86
2
Fixed Cost 2.1 Management 2.2 Labor Supervisor Helper 2.3 Marketing 2.4 Office Operation 2.5 Transportation 2.6 Depreciation
Rp Rp Rp Rp Rp Rp Rp Rp Rp
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
7.535.684,52 1.200.000,00 3.400.000,00 1.600.000,00 1.800.000,00 1.000.000,00 600.000,00 300.000,00 1.035.684,52
Rp Rp Rp Rp Rp
(37.541.037,25) (37.541.037,25) (37.541.037,25)
(11.474.628,29) (11.474.628,29) (11.474.628,29)
(11.325.346,94) (11.325.346,94) (11.325.346,94)
15.600.282,99 15.600.282,99 1.560.028,30 14.040.254,69
25.403.802,77 25.403.802,77 2.540.380,28 22.863.422,49
19.797.251,38 19.797.251,38 1.979.725,14 17.817.526,24
20.136.708,71 20.136.708,71 2.013.670,87 18.123.037,84
23.835.951,02 23.835.951,02 2.383.595,10 21.452.355,92
(10.957.663,15) (10.957.663,15) (10.957.663,15)
(27.752.704,39) (27.752.704,39) (27.752.704,39)
(12.523.012,54) (12.523.012,54) (12.523.012,54)
386.352,38 386.352,38 38.635,24 347.717,14
EARN BEFORE INTEREST & TAX INTEREST EARN BEFORE TAX TAX EARN AFTER TAX
10%
Thursday, 21 September, 2017
Prepared by Supriyanto
PROFIT (LOST) PROJECTION NO A
B
STAGE
TAHUN-2
TAHUN-3
TAHUN-4
7 kg/ha
2020
TAHUN-5
plant
2.420
1.210
1.210
2.420
1.210
plant
2.200
1.100
1.100
2.200
1.100
kg
2.839
4.012
3.691
2.568
3.580
Red Paprika
kg
2.481
3.642
3.506
2.382
3.209
Total
kg
5.320
7.653
7.197
4.950
6.789
189.729.426
274.194.202
259.257.793
177.817.332
242.870.948
78.076.683
110.325.748
101.499.688
70.608.479
98.444.514
Selling of Red Paprika
111.652.743
163.868.454
157.758.105
107.208.853
144.426.434
COST PRODUCTION
196.143.470
161.515.598
161.515.598
161.515.598
161.515.598
1 Biaya Variabel
105.715.255
71.087.384
71.087.384
71.087.384
71.087.384
1.1. Labor
15.600.000
15.600.000
15.600.000
15.600.000
15.600.000
-
-
-
-
-
15.600.000
15.600.000
15.600.000
15.600.000
15.600.000
REVENUE
1.2. Logistics / Material
90.115.255
55.487.384
55.487.384
55.487.384
55.487.384
Seedling Preparation
19.219.173
19.219.173
19.219.173
19.219.173
19.219.173
Cultivation
70.896.083
36.268.211
36.268.211
36.268.211
36.268.211
90.428.214
90.428.214
90.428.214
90.428.214
90.428.214
2.1 Management
14.400.000
14.400.000
14.400.000
14.400.000
14.400.000
2.2 Labor
40.800.000
40.800.000
40.800.000
40.800.000
40.800.000
2.3 Marketing
12.000.000
12.000.000
12.000.000
12.000.000
12.000.000
7.200.000
7.200.000
7.200.000
7.200.000
7.200.000
2 Biaya Tetap
2.4 Office Operation 2.5 Transportation 2.6 Depreciation EARN BEFORE INTEREST & TAX
-
INTEREST EARN BEFORE TAX TAX F
TAHUN-1
6
2019
2 Planting 3 Harvest Green Paprika
Cultivation
E
2018
Production
Seedling Preparation
D
2017
1 Seedling Preparation
Selling of Green Paprika C
5
2016
EARN AFTER TAX
Thursday, 21 September, 2017
10% -
3.600.000
3.600.000
3.600.000
3.600.000
3.600.000
12.428.214
12.428.214
12.428.214
12.428.214
12.428.214
6.414.043
112.678.604
97.742.195
16.301.733
81.355.349
-
-
-
-
-
6.414.043
112.678.604
97.742.195
16.301.733
81.355.349
-
11.267.860
9.774.219
1.630.173
8.135.535
6.414.043
101.410.743
87.967.975
14.671.560
73.219.814
Prepared by Supriyanto
PARAMETER
NO
RATA-RATA
TH-1
TH-2
TH-3
TH-4
TH-5
1 RETURN ON INVESTMENT (ROI)
87,8%
56%
125%
112,6%
45,9%
99,5%
2 PROFIT ON SALES
41,3%
15,3%
55,5%
53,5%
31,0%
51,1%
3 BREAK EVEN POINT (Rp)
Rp Green Paprika Rp Red Paprika Rp
BREAK EVEN POINT (Kg)
72.027.420 Rp 195.942.998 Rp 104.977.640 Rp 117.216.953 Rp (181.484.126) Rp 123.483.634 30.014.744 Rp 136.065.923 Rp
70.443.794 Rp
82.041.921 Rp (226.117.410) Rp
87.639.491
42.012.676 Rp
34.533.846 Rp
35.175.032 Rp
35.844.143
59.877.074 Rp
44.633.284 Rp
2.349 kg
4.948 kg
1.444 kg
1.490 kg
2.324 kg
1.538 kg
Green Paprika
1.236 kg
2.640 kg
757 kg
764 kg
1.206 kg
811 kg
Red Paprika
1.113 kg
2.307 kg
687 kg
726 kg
1.119 kg
727 kg
BREAK EVEN POINT (%)
44,9%
103,3%
21,0%
23,0%
52,2%
25,2%
4 PRODUCTION COST/UNIT
5 R/C RATIO
Thursday, 21 September, 2017
Green Paprika Rp
18.113 / kg Rp
27.681 / kg Rp
12.820 / kg Rp
13.634 / kg Rp
21.979 / kg Rp
14.452 / kg
Red Paprika Rp
18.113 / kg Rp
27.681 / kg Rp
12.820 / kg Rp
13.634 / kg Rp
21.979 / kg Rp
14.452 / kg
2,0
1,2
2,6
2,5
1,5
2,3
Prepared by Supriyanto
PARAMETER
NO
RATA-RATA
TH-1
TH-2
TH-3
TH-4
TH-5
123,5%
85%
168%
153,3%
73,7%
137,3%
21,2%
-3,4%
37,0%
33,9%
8,3%
30,1%
244.519.903 Rp
422.649.580 Rp
177.893.938 Rp
184.862.110 Rp
247.236.980 Rp
189.956.908
71.578.033 Rp
72.373.703 Rp
98.173.935 Rp
76.996.510
1 RETURN ON INVESTMENT (ROI) 2 PROFIT ON SALES 3 BREAK EVEN POINT (Rp)
Rp Green Paprika Rp Red Paprika
Rp
BREAK EVEN POINT (Kg)
98.609.844
Rp
173.927.039 Rp
145.910.059
Rp
248.722.541
Rp
106.315.904
Rp
112.488.407
Rp
149.063.046
Rp
112.960.397
6.828 kg
11.852 kg
4.965 kg
5.132 kg
6.882 kg
5.310 kg
Green Paprika
3.586 kg
6.325 kg
2.603 kg
2.632 kg
3.570 kg
2.800 kg
Red Paprika
3.242 kg
5.527 kg
2.363 kg
2.500 kg
3.313 kg
2.510 kg
BREAK EVEN POINT (%) 4 PRODUCTION COST/UNIT
115,2%
222,8%
64,9%
71,3%
139,0%
78,2%
Green Paprika Rp
27.367 / kg
Rp
36.867 / kg
Rp
21.104 / kg
Rp
22.443 / kg
Rp
32.629 / kg
Rp
23.790 / kg
Red Paprika Rp
27.367 / kg
Rp
36.867 / kg
Rp
21.104 / kg
Rp
22.443 / kg
Rp
32.629 / kg
Rp
23.790 / kg
5 R/C RATIO
1,4
1,0
1,7
1,6
1,1
1,5
Green Paprika Proportion
52,3%
53,4%
52,4%
51,3%
51,9%
52,7%
Green Paprika Proportion
47,7%
46,6%
47,6%
48,7%
48,1%
47,3%
A Frame Hydroponic System, prepared by Supriyanto
Thursday, 21 September, 2017
CASHFLOW PROJECTION 2016
2017
2018
2019
2020
TAHUN-0
TAHUN-1
TAHUN-2
TAHUN-3
TAHUN-4
TAHUN-5
146.355.328
189.729.426
274.194.202
259.257.793
177.817.332
283.079.876
189.729.426
274.194.202
259.257.793
177.817.332
242.870.948
78.076.683
110.325.748
101.499.688
70.608.479
98.444.514
111.652.743
163.868.454
157.758.105
107.208.853
144.426.434
-
-
-
-
-
-
-
-
-
-
-
189.729.426
274.194.202
259.257.793
177.817.332
283.079.876
CASH OUT FLOW
146.355.328
196.143.470
168.703.459
167.209.818
161.515.598
165.571.133
Investment
102.350.000 44.005.328
196.143.470
161.515.598
161.515.598
161.515.598
161.515.598
37.733.959
105.715.255
71.087.384
71.087.384
71.087.384
71.087.384
6.271.369
90.428.214
90.428.214
90.428.214
90.428.214
90.428.214
NO
URAIAN CASH IN FLOW Total Selling Selling Green Paprika Selling Red Paprika Own Capital
146.355.328
Investment
102.350.000
Interest During Construction
-
Working Capital
44.005.328
Provition
-
Credit
Investment
-
Interest During Construction
-
Working Capital
-
Salvage
40.208.929 CASH IN FLOW FOR IRR
Operational Cost Variable Cost Fixed Cost Provition Expence
-
IDC Expence
-
Interest
-
-
-
-
-
Tax
-
7.187.860
5.694.219
-
4.055.535
196.143.470
168.703.459
167.209.818
161.515.598
165.571.133
NET CASHFLOW
CASH OUT FLOW FOR IRR
- -
6.414.043
105.490.743
92.047.975
16.301.733
117.508.743
CIMMULATIVE CASHFLOW
- -
6.414.043
99.076.700
191.124.675
207.426.408
324.935.151
CIMMULATIVE CASHFLOW - SALVAGE
- -
6.414.043
99.076.700
191.124.675
207.426.408
284.726.223
146.355.328 -
6.414.043
105.490.743
92.047.975
16.301.733
117.508.743
CASHFLOW FOR IRR -
146.355.328
Discount Factor (,0%)
1,0000
1,0000
1,0000
1,0000
1,0000
Present Value -
146.355.328 -
6.414.043
105.490.743
92.047.975
16.301.733
117.508.743
Cummulative -
146.355.328 -
152.769.371 -
47.278.628
44.769.347
61.071.080
178.579.823
NPV
1,0000
178.579.823
Internal Rate of Return (IRR)
27%
Pay Back Periode (PBP)
2,51
Thursday, 21 September, 2017
TAHUN
Prepared by Supriyanto