Analisa Harga Satuan Pekerjaan Furniture Excel (Pro 2025)

| Component | Material | Coefficient (per m²) | Total Qty for 7.2 m² | Unit | Unit Price (IDR) | Total Cost (IDR) | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | Body (18mm) | Plywood Meranti | 1.1 m² | 7.92 | Sheet (1 sheet = 2.88 m²) | 285,000 | 2,257,200 | | Back (9mm) | Plywood Far | 1.05 m² | 7.56 | Sheet | 180,000 | 1,360,800 | | HPL Laminate | Tacon | 1.2 m² | 8.64 | Sheet | 350,000 | 3,024,000 | | Edge Banding | 1mm ABS | 4.5 m | 32.4 | Meter | 8,000 | 259,200 | | Handle | Alum. Sliding | 1 | 1 | Set | 450,000 | 450,000 | | Hinge | Soft-close | 6 | 6 | Pair | 35,000 | 210,000 | | Drawer Slide | 45kg | 3 | 3 | Set | 85,000 | 255,000 | | Glue | PVAc | 0.15 | 1.08 | Kg | 30,000 | 32,400 |

This article is a deep dive into creating, optimizing, and utilizing Excel-based unit price analysis specifically for the furniture industry. By the end, you will understand how to build a dynamic, error-proof system that accounts for materials, labor, overhead, and profit. In Indonesian construction and manufacturing standards (SNI), Analisa Harga Satuan (AHS) is the breakdown of cost components required to produce one unit of output. For furniture, "one unit" could be 1 m² of built-in wardrobe, 1 unit of a study desk, or 1 linear meter of kitchen set cabinet. analisa harga satuan pekerjaan furniture excel

| No | Uraian Pekerjaan | Koefisien | Satuan | Harga Satuan (Rp) | Jumlah (Rp) | | :--- | :--- | :--- | :--- | :--- | :--- | | | BAHAN (Materials) | | | | | | 1 | Plywood 18mm | 1.1 | Lembar | 285,000 | 313,500 | | 2 | Plywood 12mm (drawers) | 0.6 | Lembar | 230,000 | 138,000 | | 3 | HPL Tacon | 1.2 | Lembar | 350,000 | 420,000 | | 4 | Lem/Glue | 0.1 | Kg | 30,000 | 3,000 | | 5 | Paku & Sekrup | 1 | Lot | 15,000 | 15,000 | | | Subtotal Bahan | | | | 889,500 | | B | TENAGA (Labor) | | | | | | 1 | Tukang Kayu | 0.5 | OH | 150,000 | 75,000 | | 2 | Pekerja | 0.5 | OH | 100,000 | 50,000 | | | Subtotal Tenaga | | | | 125,000 | | C | PERALATAN (Tools) | 10% | x Bahan | | 88,950 | | D | Total DHP (Direct Cost) | A+B+C | | | 1,103,450 | | E | Overhead + Profit (20%) | | | | 220,690 | | F | Harga Satuan (Unit Price) | D+E | | | 1,324,140 | | Component | Material | Coefficient (per m²)

This is your cost per wardrobe. To move from a "static calculation" to a professional "Analisa Harga Satuan template," use these Excel features: 1. Data Validation for Dropdown Menus In your "Component" column, use Data Validation > List referring to your Master Data tab. This prevents typos like "Plywood" vs "Ply wood." 2. XLOOKUP / VLOOKUP for Automated Pricing In your "Unit Price" column, use: =XLOOKUP([@Material], MasterData[Material_Code], MasterData[Effective_Price]) Now, when plywood prices rise, update only the Master Data tab. Every AHS updates instantly. 3. Conditional Formatting for Waste Alerts If a coefficient is over 1.15 (15% waste), highlight it in red. This flags inefficient designs. To move from a "static calculation" to a