Excel | Analisa Harga Satuan Pekerjaan Furniture

Berisi harga satuan terbaru untuk material (kayu, HPL, lem, sekrup) dan upah tenaga kerja (tukang kayu, pembantu tukang, mandor). Analisa Harga Satuan (AHS): Tabel detail per item pekerjaan (misal: "Pembuatan 1

| A (Kode) | B (Uraian Pekerjaan) | C (Satuan) | D (Koefisien) | E (Harga Satuan/Rp) | F (Jumlah/Rp) | | :--- | :--- | :--- | :--- | :--- | :--- | | | Material | | | | | | | Multipleks 18mm | Lbr | 1.20 | Rp 300,000 | =D3*E3 | | | Multipleks 9mm (backing) | Lbr | 0.50 | Rp 150,000 | =D4*E4 | | | HPL 1.6mm | Lbr | 1.00 | Rp 380,000 | =D5*E5 | | | Lem Fox | Kg | 0.30 | Rp 45,000 | =D6*E6 | | | Paku & Skrup | Lot | 1.00 | Rp 25,000 | =D7*E7 | | T.01 | Tenaga Kerja | | | | | | | Tukang Kayu | OH | 1.50 | Rp 150,000 | =D9*E9 | | | Pekerja (Helper) | OH | 1.50 | Rp 100,000 | =D10*E10 | | P.01 | Peralatan | | | | | | | Sewa alat potong | Lot | 0.05 | Rp 200,000 | =D12*E12 | analisa harga satuan pekerjaan furniture excel

Create a separate sheet called "Library." List all your standard furniture items: Berisi harga satuan terbaru untuk material (kayu, HPL,