Refernsi hydroponic paprika smkn1 bumr pangan

Page 1

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


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.