Excel XLSX | Diposting 25 Jul 2022 | 3 thn lalu
Authentication
digital resources
178x Tipe XLSX Ukuran file 0.05 MB Source: erwinkurnia15.files.wordpress.com
Sheet 1: AHS Pekerjaan Instalasi Listrik
| TABEL XI.1 | ||||||||
| ANALISA HARGA SATUAN (AHS) PEKERJAAN INSTALASI LISTRIK | ||||||||
| No. | Uraian Jenis pekerjaan | Sat. | Koeff. | Harga Sat. | Jumlah Harga | Jumlah Harga | ||
| Bahan / Upah / Alat | Bahan | Upah | Alat | Bahan + Upah | ||||
| Rp. | Rp. | Rp. | Rp. | Rp. | ||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| XI | PEKERJAAN INSTALASI LISTRIK | |||||||
| XI.1 | LAMPU PIJAR 20 S/D 100 WATT | |||||||
| Lampu pijar 25 s/d 100 watt | bh | 1.000 | Rp6,000.00 | Rp6,000.00 | - | - | ||
| Pekerja | Oh | 2.237 | Rp38,000.00 | Rp85,000.00 | ||||
| Mandor | Oh | 0.5 | Rp60,000.00 | Rp30,000.00 | ||||
| Jumlah | Rp6,000.00 | Rp115,000.00 | 121,000.00 | |||||
| XI.2 | LAMPU SL PHILIP 20 WATT | |||||||
| Lampu Sl philip 25 watt | bh | 1.000 | Rp32,000.00 | Rp32,000.00 | - | - | ||
| Pekerja | Oh | 2.237 | Rp38,000.00 | Rp85,000.00 | ||||
| Mandor | Oh | 0.5 | Rp60,000.00 | Rp30,000.00 | ||||
| Jumlah | Rp32,000.00 | Rp115,000.00 | 147,000.00 | |||||
| XI.3 | LAMPU DOWNLIGHT | |||||||
| Downlight + SL 25 watt philip | bh | 1.000 | Rp33,500.00 | Rp33,500.00 | - | - | ||
| Pekerja | Oh | 2.237 | Rp38,000.00 | Rp85,000.00 | ||||
| Mandor | Oh | 0.5 | Rp60,000.00 | Rp30,000.00 | ||||
| Jumlah | Rp33,500.00 | Rp115,000.00 | 148,500.00 | |||||
| XI.4 | LAMPU TAMAN | |||||||
| Lampu taman + tiang + lampu 1 buah | bh | 1.000 | Rp146,500.00 | Rp146,500.00 | - | - | ||
| Pekerja | Oh | 2.237 | Rp38,000.00 | Rp85,000.00 | ||||
| Mandor | Oh | 0.5 | Rp60,000.00 | Rp30,000.00 | ||||
| Jumlah | Rp146,500.00 | Rp115,000.00 | 261,500.00 | |||||
| XI.5 | STOP KONTAK | |||||||
| Stop kontak broko standard (1 phase) | bh | 1.000 | Rp13,500.00 | Rp13,500.00 | - | - | ||
| Pekerja | Oh | 2.237 | Rp38,000.00 | Rp85,000.00 | ||||
| Mandor | Oh | 0.5 | Rp60,000.00 | Rp30,000.00 | ||||
| Jumlah | Rp13,500.00 | Rp115,000.00 | 128,500.00 | |||||
| XI.6 | SAKLAR | |||||||
| Saklar broko tunggal standard | bh | 1.000 | Rp10,000.00 | Rp10,000.00 | - | - | ||
| Pekerja | Oh | 2.237 | Rp38,000.00 | Rp85,000.00 | ||||
| Mandor | Oh | 0.5 | Rp60,000.00 | Rp30,000.00 | ||||
| Jumlah | Rp10,000.00 | Rp115,000.00 | 125,000.00 | |||||
| XI.7 | KABEL NYM SUPREME 2 X 10 | |||||||
| Saklar broko tunggal standard | m' | 1.000 | Rp20,800.00 | Rp20,800.00 | - | - | ||
| Pekerja | Oh | 2.237 | Rp38,000.00 | Rp85,000.00 | ||||
| Mandor | Oh | 0.5 | Rp60,000.00 | Rp30,000.00 | ||||
| Jumlah | Rp20,800.00 | Rp115,000.00 | 135,800.00 | |||||
| TABEL XI.2 | ||||||
| RAB BAHAN PEKERJAAN INSTALASI LISTRIK | ||||||
| NO | URAIAN PEKERJAAN | VOL | SAT | HARGA SAT | JUMLAH HARGA | |
| BAHAN | Biaya Bahan Bid Price | Biaya Bahan Pelaksanaan | ||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| XI. PEKERJAAN INSTALASI LISTRIK | ||||||
| K.1 | Lampu Pijar 25 Watt | 2 | bh | Rp6,000 | Rp12,000.00 | Rp12,000.00 |
| K.2 | Lampu SL Philip 25 Watt | 6 | bh | Rp32,000 | Rp192,000.00 | Rp192,000.00 |
| K.3 | Lampu Downlight | 6 | bh | Rp33,500 | Rp201,000.00 | Rp201,000.00 |
| K.4 | Lampu Taman | 2 | bh | Rp146,500 | Rp293,000.00 | Rp293,000.00 |
| K.5 | Stop Kontak | 11 | bh | Rp13,500 | Rp148,500.00 | Rp148,500.00 |
| K.6 | Stop Kontak Dobel | 4 | bh | Rp13,500 | Rp54,000.00 | Rp54,000.00 |
| K.7 | Saklar | 8 | bh | Rp10,000 | Rp80,000.00 | Rp80,000.00 |
| K.8 | Kabel NYM supreme 2 x 10 | 100 | m' | Rp20,800 | Rp2,080,000.00 | Rp2,080,000.00 |
| Jumlah | Rp3,060,500 | Rp3,060,500 | ||||
| RAB UPAH PEKERJAAN INSTALASI LISTRIK | ||||||
| NO | URAIAN PEKERJAAN | VOL | SAT | HARGA SAT | JUMLAH HARGA | |
| UPAH | Biaya Upah Bid Price | Biaya Upah Pelaksanaan | ||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| XI. PEKERJAAN INSTALASI LISTRIK | ||||||
| K.1 | Lampu Pijar 25 Watt | 2 | bh | Rp115,000 | Rp230,000.00 | Rp207,000.00 |
| K.2 | Lampu SL Philip 25 Watt | 6 | bh | Rp115,000 | Rp690,000.00 | #NAME? |
| K.3 | Lampu Downlight | 6 | bh | Rp115,000 | Rp690,000.00 | #NAME? |
| K.4 | Lampu Taman | 2 | bh | Rp115,000 | Rp230,000.00 | #NAME? |
| K.5 | Stop Kontak | 11 | bh | Rp115,000 | Rp1,265,000.00 | #NAME? |
| K.6 | Stop Kontak Dobel | 4 | bh | Rp115,000 | Rp460,000.00 | #NAME? |
| K.7 | Saklar | 8 | bh | Rp115,000 | Rp920,000.00 | #NAME? |
| K.8 | Kabel NYM supreme 2 x 10 | 100 | m' | Rp115,000 | Rp11,500,000.00 | #NAME? |
| Jumlah | Rp15,985,000 | Rp14,386,500 | ||||
| TABEL XI.3 | |||||||
| KEBUTUHAN TENAGA KERJA | |||||||
| No. | Uraian Jenis pekerjaan | Sat. | Koeff. (Awal) | Koeff. (Akhir) | Volume | Sat | Kebutuhan Tenaga Kerja |
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 = 5 x 6 |
| XI | PEKERJAAN INSTALASI LISTRIK | ||||||
| XI.1 | LAMPU PIJAR 25 WATT | ||||||
| Pekerja | Oh | 2.237 | 2.013 | 2.000 | bh | 4.026 | |
| Mandor | Oh | 0.500 | 0.450 | 2.000 | bh | 0.900 | |
| Jumlah | 4.926 | ||||||
| XI.2 | LAMPU SL PHILIP 25 WATT | ||||||
| Pekerja | Oh | 2.237 | 2.013 | 6.000 | bh | 12.079 | |
| Mandor | Oh | 0.500 | 0.450 | 6.000 | bh | 2.700 | |
| Jumlah | 14.779 | ||||||
| XI.3 | LAMPU DOWNLIGHT | ||||||
| Pekerja | Oh | 2.237 | 2.013 | 6.000 | bh | 12.079 | |
| Mandor | Oh | 0.500 | 0.450 | 6.000 | bh | 2.700 | |
| Jumlah | 14.779 | ||||||
| XI.4 | LAMPU TAMAN | ||||||
| Pekerja | Oh | 2.237 | 2.013 | 2.000 | bh | 4.026 | |
| Mandor | Oh | 0.500 | 0.450 | 2.000 | bh | 0.900 | |
| Jumlah | 4.926 | ||||||
| XI.5 | STOP KONTAK | ||||||
| Pekerja | Oh | 2.237 | 2.013 | 11.000 | bh | 22.145 | |
| Mandor | Oh | 0.500 | 0.450 | 11.000 | bh | 4.950 | |
| Jumlah | 27.095 | ||||||
| XI.6 | STOP KONTAK DOBEL | ||||||
| Pekerja | Oh | 2.237 | 2.013 | 4.000 | bh | 8.053 | |
| Mandor | Oh | 0.500 | 0.450 | 4.000 | bh | 1.800 | |
| Jumlah | 9.853 | ||||||
| XI.7 | SAKLAR | ||||||
| Pekerja | Oh | 2.237 | 2.013 | 8.000 | bh | 16.105 | |
| Mandor | Oh | 0.500 | 0.450 | 8.000 | bh | 3.600 | |
| Jumlah | 19.705 | ||||||
| XI.8 | KABEL NYM SUPREME 2 X 10 | ||||||
| Pekerja | Oh | 2.237 | 2.013 | 100.000 | m' | 201.316 | |
| Mandor | Oh | 0.500 | 0.450 | 100.000 | m' | 45.000 | |
| Jumlah | 246.316 | ||||||
no reviews yet
Please Login to review.
