Analisa Harga Satuan Pekerjaan Furniture Excel – Bonus Inside
The formula is simple, yet the execution is complex:
| 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 | analisa harga satuan pekerjaan furniture excel
= Material_Cost + Labor_Cost + Equipment_Cost = 7,848,600 + 1,260,000 + 592,430 = Rp 9,701,030 The formula is simple, yet the execution is
: Access the Dinas Pekerjaan Umum (PUPR) for the latest AHSP regulations. The formula is simple
Ensure this is calculated at the very end of the subtotal. 🛠️ Structuring Your Excel Sheet
