: Calculated based on the time (usually in man-days or OH/Orang Hari) required by specific workers, such as carpenters ( Tukang Kayu ), head carpenters ( Kepala Tukang ), painters, and foremen ( Mandor ).
| 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
| No | Uraian Pekerjaan | Koefisien | Satuan | Harga Satuan (Rp) | Jumlah (Rp) | | :--- | :--- | :--- | :--- | :--- | :--- | | A | | | | | | | 1 | Multiplek 18mm | 0.8 | Lbr | 280,000 | 224,000 | | 2 | Multiplek 12mm | 0.5 | Lbr | 180,000 | 90,000 | | 3 | HPL Tacon 0.8mm | 2.3 | M² | 125,000 | 287,500 | | 4 | Cat Duco | 0.3 | Kg | 85,000 | 25,500 | | 5 | Handle Tarik | 2 | Buah | 15,000 | 30,000 | | B | TENAGA | | | | | | 6 | Tukang Kayu | 1.5 | OH | 150,000 | 225,000 | | 7 | Pengecat | 0.8 | OH | 130,000 | 104,000 | | | TOTAL BASIS | | | | Rp 986,000 | | | Overhead (10%) | | | | Rp 98,600 | | | Profit (15%) | | | | Rp 147,900 | | | HARGA JUAL (Eksisting) | | | | Rp 1,232,500 | | | PPN 11% (optional) | | | | Rp 135,575 | : Calculated based on the time (usually in
Higher daily rate for assembly and precision. head carpenters ( Kepala Tukang )