Excel XLS | Diposting 26 Dec 2021 | 3 thn lalu
Authentication
digital resources
655x Tipe XLS Ukuran file 0.03 MB
Sheet 1: RAB
| No. | Keterangan | Volume | Satuan | Harga Satuan | Harga Total | ||
| A. | Biaya Pendirian Kolam (ukuran 4 x 2 x 1,3 m) | ||||||
| 1. | Bambu | 1 | 10 | 40 | set.batang.kolam | 20,000 | 8,000,000 |
| 2. | Bambu kulit anyaman ( 4 x 1,3 m) | 1 | 2 | 40 | set.lembar.kolam | 90,000 | 7,200,000 |
| 3. | Bambu kulit anyaman ( 2 x 1,3 m) | 1 | 2 | 40 | set.lembar.kolam | 45,000 | 3,600,000 |
| 4. | Terpal ( 7 x 5 m ) | 1 | 1 | 40 | set.lembar.kolam | 250,000 | 10,000,000 |
| 5. | Sekam padi | 1 | 4 | 40 | set.karung.kolam | 7,500 | 1,200,000 |
| 6. | Pompa kolam (60 watt) | 1 | 1 | 40 | set.buah.kolam | 120,000 | 4,800,000 |
| 7. | Kabel dan alat listrik (steker, jack) | 1 | 3 | 40 | set.buah.kolam | 20,000 | 2,400,000 |
| 8. | Tali tambang | 1 | 2 | 40 | set.kilogram.kolam | 42,500 | 3,400,000 |
| 9. | Tali rafia | 1 | 1 | 40 | set.roll.kolam | 5,000 | 200,000 |
| 10. | Paku | 1 | 2 | 40 | set.kilogram.kolam | 14,000 | 1,120,000 |
| 11. | Palu | 1 | 2 | 5 | set.buah.kelompok | 20,000 | 200,000 |
| 12. | Gergaji | 1 | 2 | 5 | set.buah.kelompok | 40,000 | 400,000 |
| 13. | Komsumsi tenaga kerja pasang kolam | 10 | 2 | 5 | hari.orang.kelompok | 25,000 | 2,500,000 |
| Total A | 45,020,000 | ||||||
| B. | Biaya Bibit Ikan Lele | ||||||
| 1. | Bibit lele pembesaran (ukuran 5-7 cm) | 1 | 3000 | 40 | set.ekor.kolam | 125 | 15,000,000 |
| 15,000,000 | |||||||
| C. | Biaya Perlengkapan Treatment Kolam | ||||||
| 1. | Probiotik (X-Tro) | 1 | 1 | 40 | set.buah.kolam | 45,000 | 1,800,000 |
| 2. | Pupuk urea (non subsidi) | 1 | 0.25 | 40 | set.kilogram.kolam | 4,000 | 40,000 |
| 3. | Dolomit (kapur pertanian) | 1 | 1 | 40 | set.kilogram.kolam | 2,000 | 80,000 |
| Total C | 1,920,000 | ||||||
| D. | Biaya Peralatan Kolam | ||||||
| 1. | Ember | 1 | 1 | 40 | set.buah.kolam | 25,000 | 1,000,000 |
| 2. | Jaring ikan kecil | 1 | 2 | 5 | set.buah.kelompok | 15,000 | 150,000 |
| 3. | Jaring ikan besar | 1 | 2 | 5 | set.buah.kelompok | 30,000 | 300,000 |
| 4. | Timbangan gram | 1 | 1 | 5 | set.buah.kelompok | 200,000 | 1,000,000 |
| 5. | Senter | 1 | 2 | 5 | set.buah.kelompok | 20,000 | 200,000 |
| 6. | Selang | 1 | 0.5 | 40 | set.roll.kolam | 165,000 | 3,300,000 |
| 7. | Alat tulis (notes, bolpen) | 1 | 2 | 5 | set.buah.kelompok | 10,000 | 100,000 |
| Total D | 6,050,000 | ||||||
| E. | Biaya Bahan Pakan Lele | ||||||
| 1. | Pakan bulan pertama (Hi-pro-vite FF-999) | 1 | 2 | 40 | bulan.karung 10 kg.kolam | 112,000 | 8,960,000 |
| 2. | Pakan bulan kedua (Hi-pro-vite 781-2) | 1 | 3 | 40 | bulan.karung 30 kg.kolam | 209,000 | 25,080,000 |
| 3. | Pakan bulan ketiga (Hi-pro-vite 781-3) | 1 | 4 | 40 | bulan.karung 30 kg.kolam | 201,000 | 32,160,000 |
| Total E | 66,200,000 | ||||||
| F. | Biaya Tetap | ||||||
| 1. | Biaya listrik | 1 | 3 | 40 | set.bulan.kolam | 15,000 | 1,800,000 |
| 2. | Biaya PDAM | 1 | 3 | 40 | set.bulan.kolam | 7,500 | 900,000 |
| Total F | 2,700,000 | ||||||
| G. | Biaya Lain-lain | ||||||
| 1. | Biaya tak terduga (10%) | 13,689,000 | |||||
| Total G | 13,689,000 | ||||||
| GRAND TOTAL (A+B+C+D+E+F+G) | 150,579,000 | ||||||
| No. | Keterangan | Volume | Satuan | Harga Satuan | Harga Total | ||||
| A. | Total Pendapatan (1 periode panen) | ||||||||
| 1. | Panen ikan lele (1 kg = 10 ekor) | 300 | x | 40 | kilogram.kolam | 10,000 | 120,000,000 | ||
| Total A | 120,000,000 | ||||||||
| B. | Beban Biaya (1 periode panen) | ||||||||
| 1. | Biaya Bibit Ikan Lele | 3000 | x | 40 | ekor.kolam | 125 | 15,000,000 | ||
| 2. | Biaya Perlengkapan Treatment Kolam | 1 | x | 40 | set.kolam | 48,000 | 1,920,000 | ||
| 3. | Biaya Bahan Pakan Lele | 1 | x | 40 | set.kolam | 1,655,000 | 66,200,000 | ||
| 4. | Biaya Tetap (Listrik & PDAM) | 1 | x | 40 | set.kolam | 67,500 | 2,700,000 | ||
| Total B | 85,820,000 | ||||||||
| PERKIRAAN PENDAPATAN BERSIH (A-B) | 34,180,000 | ||||||||
| No. | Keterangan | Prosentase | Pendapatan | Pendapatan | Pendapatan | BEP | BEP | ||
| 1 Periode Panen | Per Bulan | Per Orang | (Bulan) | (Tahun) | |||||
| (A-B) x C | (D/3) | (E1¸10) | ((RAB-B)/E3) | (G3¸12) | |||||
| C | D | E | F | G | H | ||||
| 1. | Pendapatan Kelompok | 70% | 23,926,000 | 7,975,333 | 797,533 | - | - | ||
| 2. | Kas | 5% | 1,709,000 | 569,667 | - | - | - | ||
| 3. | Break Event Point | 25% | 8,545,000 | 2,848,333 | - | 22.7 | 1.9 | ||
| 1.89% | |||||||||
| 22.7% | |||||||||
no reviews yet
Please Login to review.
