ABCEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQ
1
Tabel 1. Arus uang Usahatani kopi
2
3
Keterangan
Satuan
Tahun
4
12345678910111213141516171819202122232425
5
I Investasi
6
Lahan Rp 10,000,000.00 - - - - - - - - - - - - - - - - - - - - - - - -
7
Bibit kopi Rp 450,000.00 - - - - - - - - - - - - - - - - - - - - - - - -
8
Tanaman pelindung:
9
1. Bibit dadap Rp#REF! - - - - - - - - - - - - - - - - - - - - - - - -
10
2. Bibit jengkol Rp#REF! - - - - - - - - - - - - - - - - - - - - - - - -
11
Tanaman tumpangsari:
12
1. Bibit pisang Rp#REF! - - - - - - - - - - - - - - - - - - - - - - - -
13
2. Bibit lada Rp#REF! - - - - - - - - - - - - - - - - - - - - - - - -
14
3. Bibit kakao Rp#REF! - - - - - - - - - - - - - - - - - - - - - - - -
15
Total investasi #REF! - - - - - - - - - - - - - - - - - - - - - - - - #REF!
16
II Biaya-Biaya (Cost)
17
Biaya bibit dan alat
18
1. Bibit kopi Rp - 112,500.00 84,375.00 - - - - - - - - - - - - - - - - - - - - - -
19
2. Bangunan
20
Pondok jaga Rp 766,667.00 - - - - - - - - - - 766,667.00 - - - - - - - - - - 766,667.00 - -
21
3. Alat-alat pertanian
22
a) Cangkul Rp 61,544.00 - - 61,544.00 - - 61,544.00 - - 61,544.00 - - 61,544.00 - - 61,544.00 - - 61,544.00 - - 61,544.00 - - 61,544.00
23
b) Sengkuit Rp 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00 45,336.00
24
c) Arit/sabit Rp 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00 41,536.00
25
d) Tembilang Rp 27,222.00 - - - - - - - - - - - - - - - - - - - - - - - -
26
e) Golok Rp 56,914.00 - - 56,914.00 - - 56,914.00 - - 56,914.00 - - 56,914.00 - - 56,914.00 - - 56,914.00 - - 56,914.00 - - 56,914.00
27
f) Garu Rp 23,571.00 - - 23,571.00 - - 23,571.00 - - 23,571.00 - - 23,571.00 - - 23,571.00 - - 23,571.00 - - 23,571.00 - - 23,571.00
28
g) Gembor Rp 91,875.00 - - - - - - - - - 91,875.00 - - - - - - - - - 91,875.00 - - - -
29
h) Sprayer Rp 185,918.00 - - - - - - - - - 185,918.00 - - - - - - - - - 185,918.00 - - - -
30
i) Pisau stek Rp - - - - - 22,107.00 - - - 22,107.00 - - - 22,107.00 - - - 22,107.00 - - - 22,107.00 - - -
31
j) Tangga kaki tiga Rp - - 44,857.00 - - - - 44,857.00 - - - - 44,857.00 - - - - 44,857.00 - - - - 44,857.00 - -
32
k) Ginjar Rp - - 43,011.00 - - - - 43,011.00 - - - - 43,011.00 - - - - 43,011.00 - - - - 43,011.00 - -
33
l) Alas jemur Rp - - 173,000.00 - 173,000.00 - 173,000.00 - 173,000.00 - 173,000.00 - 173,000.00 - 173,000.00 - 173,000.00 - 173,000.00 - 173,000.00 - 173,000.00 - 173,000.00
34
m) Gunting pangkas Rp - - 62,727.00 - - 62,727.00 - - 62,727.00 - - 62,727.00 - - 62,727.00 - 62,727.00 - - 62,727.00 - - 62,727.00 - -
35
4. Batang "entrys" Rp - - - - - 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00 159,819.00
36
Total biaya bibit dan alat 1,300,583.00 199,372.00 494,842.00 228,901.00 259,872.00 331,525.00 561,720.00 334,559.00 482,418.00 410,827.00 697,484.00 1,076,085.00 649,588.00 268,798.00 482,418.00 388,720.00 482,418.00 356,666.00 561,720.00 309,418.00 697,484.00 410,827.00 1,336,953.00 246,691.00 561,720.00 13,131,609.00
37
Biaya Operasional
38
1. Pupuk
39
a) Urea Rp 123,911.00 123,911.00 141,258.54 152,410.53 244,104.67 244,104.67 244,104.67 244,104.67 244,104.67 244,104.67 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65 266,408.65
40
b) SP-36 Rp 165,614.85 194,841.00 194,841.00 194,841.00 224,067.15 224,067.15 224,067.15 224,067.15 224,067.15 224,067.15 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50 292,261.50
41
c) KCl Rp 233,171.15 274,319.00 274,319.00 274,319.00 282,548.57 282,548.57 282,548.57 282,548.57 282,548.57 282,548.57 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85 315,466.85
42
d) Kandang Rp 100,000.00 110,700.00 125,000.00 125,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00 241,250.00
43
2. Obat-obatan
44
a) Pestisida:
45
1) Insektisida Rp - - 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77 12,407.77
46
2) Herbisida Rp 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62 34,179.62
47
3) Hipotan Rp 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00 78,200.00
48
b) Biomikro Rp 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00
49
3. Tenaga Kerja
50
a) Persiapan lahan
51
1) Penebangan Rp 870,000.00 - - - - - - - - - - - - - - - - - - - - - - - -
52
2) Pembersihan lahan Rp 480,000.00 - - - - - - - - - - - - - - - - - - - - - - - -
53
b) Penanaman kopi
54
1) Pengajiran Rp 90,000.00 - - - - - - - - - - - - - - - - - - - - - - - -
55
2) Pelubangan Rp 285,000.00 - - - - - - - - - - - - - - - - - - - - - - - -
56
3) Tanam Rp 75,000.00 - - - - - - - - - - - - - - - - - - - - - - - -
57
c) Penaman tanaman pelindung
Rp 75,000.00 - - - - - - - - - - - - - - - - - - - - - - - -
58
d) Pemeliharaan
59
1) Penyulaman Rp 30,000.00 60,000.00 165,000.00 - - - - - - - - - - - - - - - - - - - - - -
60
2) Wiwilan Rp - 90,000.00 285,000.00 225,000.00 180,000.00 180,000.00 180,000.00 180,000.00 180,000.00 180,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00
61
3) Penyiangan Rp 75,000.00 120,000.00 120,000.00 345,000.00 300,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00
62
4) Okulasi Rp - - - - - 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00
63
5) Pemupukan
64
I) Urea, SP-36, & KCl Rp 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00
65
ii) Kandang Rp 210,000.00 90,000.00 90,000.00 90,000.00 90,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00
66
e) Pegendalian HPT 60,000.00 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00
67
f) Panen
68
1) Pemetikan Rp - - 220,000.00 357,500.00 357,500.00 357,500.00 357,500.00 357,500.00 357,500.00 357,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00 412,500.00
69
2) Penjemuran Rp - - 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00 360,000.00
70
4. Pasca Panen
71
a) Potongan penggilingan Rp - - 158,913.36 171,062.16 182,547.51 193,369.39 203,527.80 213,022.75 221,854.24 230,022.26 237,526.82 244,367.92 250,545.55 256,059.72 260,910.42 265,097.66 268,621.44 271,481.75 273,678.60 275,211.98 276,081.90 276,288.36 275,831.35 274,710.88 272,926.95
72
Total biaya operasional 3,050,076.62 1,271,150.62 2,354,119.28 2,514,920.08 2,640,555.28 2,801,377.16 2,811,535.58 2,821,030.53 2,829,862.02 2,838,030.04 3,110,201.21 3,117,042.31 3,123,219.94 3,128,734.10 3,133,584.81 3,137,772.05 3,141,295.83 3,144,156.14 3,146,352.99 3,147,886.37 3,148,756.29 3,148,962.75 3,148,505.74 3,147,385.27 3,145,601.33 73,002,114.33
73
Pajak tanah ha 23,151.62 24,009.09 27,953.44 27,953.44 27,953.44 30,868.83 30,868.83 30,868.83 30,868.83 30,868.83 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78 32,240.78
74
Total biaya+pajak Rp#REF! 1,494,531.71 2,876,914.73 2,771,774.52 2,928,380.73 3,163,771.00 3,404,124.41 3,186,458.36 3,343,148.85 3,279,725.87 3,839,925.99 4,225,368.09 3,805,048.72 3,429,772.88 3,648,243.59 3,558,732.83 3,655,954.60 3,533,062.92 3,740,313.77 3,489,545.15 3,878,481.07 3,592,030.53 4,517,699.52 3,426,317.05 3,739,562.11 #REF!
75
III Penerimaan (benefit)
76
1) Kopi kering giling Rp - - 5,297,111.90 5,702,072.13 6,084,916.89 7,445,646.19 8,084,260.02 9,100,758.40 9,395,141.30 9,667,408.75 10,917,560.73 10,145,597.25 10,351,518.31 10,535,323.91 10,697,014.04 10,836,588.70 10,954,047.91 11,049,391.65 11,122,619.93 10,173,732.75 9,202,730.10 9,209,611.99 9,194,378.42 9,157,029.38 9,097,564.88
77
2) Penerimaan diluar usaha
78
a) Lada Rp - - - 2,576,626.09 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13 2,576,631.13
79
b) Pisang Rp - - 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63 1,053,161.63
80
c) Jengkol Rp - - - - - 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87 235,593.87
81
d) Kakao Rp - - - 378,765.47 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34 378,740.34
82
Total penerimaan diluar usaha Rp - - 1,053,161.63 4,008,553.19 4,008,533.09 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96 4,244,126.96
83
Total penerimaan Rp - - 6,350,273.53 9,710,625.32 10,093,449.98 10,689,773.15 11,028,386.98 11,344,885.35 11,639,268.26 11,911,535.71 12,161,687.69 12,389,724.21 12,595,645.27 12,779,450.86 12,941,140.99 13,080,715.66 13,198,174.87 13,293,518.61 13,366,746.89 13,417,859.70 13,446,857.06 13,453,738.95 13,438,505.37 13,401,156.34 13,341,691.84
84
IVEAT (Earning After Tax)Rp#REF!-1,494,531.713,473,358.806,938,850.797,165,069.257,526,002.157,624,262.578,158,426.998,296,119.418,631,809.848,321,761.708,164,356.138,790,596.559,349,677.989,292,897.419,521,982.839,542,220.269,760,455.699,626,433.129,928,314.559,568,375.999,861,708.428,920,805.859,974,839.299,602,129.72
85
VI Sisa
86
1. Lahan & kopi Rp - - - - - - - - - - - - - - - - - - - - - - - - 30,000,000.00
87
2. Bangunan* Rp
88
Pondok jaga Rp - - - - - - - - - - - - - - - - - - - - - - - - 557,576.00
89
3. Alat-alat pertanian*
90
a) Cangkul Rp - - - - - - - - - - - - - - - - - - - - - - - - 41,029.32
91
b) Sengkuit Rp - - - - - - - - - - - - - - - - - - - - - - - - -
92
c) Arit/sabit Rp - - - - - - - - - - - - - - - - - - - - - - - - -
93
d) Tembilang Rp - - - - - - - - - - - - - - - - - - - - - - - - -
94
e) Golok Rp - - - - - - - - - - - - - - - - - - - - - - - - 37,942.68
95
f) Garu Rp - - - - - - - - - - - - - - - - - - - - - - - - 15,714.00
96
g) Gembor Rp - - - - - - - - - - - - - - - - - - - - - - - - 45,937.50
97
h) Sprayer Rp - - - - - - - - - - - - - - - - - - - - - - - - 92,955.00
98
i) Pisau stek Rp - - - - - - - - - - - - - - - - - - - - - - - - -
99
j) Tangga kaki tiga Rp - - - - - - - - - - - - - - - - - - - - - - - - 17,942.80
100
k) Ginjar Rp - - - - - - - - - - - - - - - - - - - - - - - - 17,204.40