Homeanalisa harga satuan pekerjaan furniture excelanalisa harga satuan pekerjaan furniture excel

Analisa Harga Satuan Pekerjaan Furniture Excel Site

Let’s build a practical template for a "Built-in Wardrobe per m²."

Buat kolom-kolom berikut di Excel:

| Komponen | Contoh Isi | |----------|------------| | Nama Pekerjaan | Pembuatan Lemari Pakaian 1.5m x 2m | | Bahan (Material) | Multiplek 18mm, list plank, handle, cat, lem, paku | | Satuan | Lembar, meter, set, kg | | Koefisien | 2.5 lembar multiplek untuk 1 unit | | Harga Satuan Bahan | Rp 150.000/lembar | | Total Bahan | = koefisien × harga satuan | | Upah Tenaga | Tukang kayu (4 jam), helper (2 jam) | | Harga Satuan Upah | Rp 20.000/jam, Rp 15.000/jam | | Total Upah | (jam tukang × upah) + (jam helper × upah) | | Total Harga Satuan | Total Bahan + Total Upah | analisa harga satuan pekerjaan furniture excel

Date: [Current Date] Subject: Efficient Unit Price Calculation for Custom Furniture Software Tool: Microsoft Excel (2016/365 or newer) Let’s build a practical template for a "Built-in

  • Fitur Protect Sheet: Klik Review > Protect Sheet agar karyawan Anda tidak sengaja menghapus rumus =PRODUCT.
  • Tambahkan Kolom Satuan Alternatif: Terkadang tukang beli kayu per batang, ada yang per m3. Buat konversi otomatis (1 m3 = 40 lembar multipleks 18mm).
  • Analisa Waktu vs Output: Jangan hanya fokus material. Jika tukang lemot, biaya tenaga kerja membengkak. Buat kolom "Produktivitas (m2/hari)" untuk mengkalibrasi koefisien tenaga.

    • | A | B | C | D | E | F | G | H | I | |---|---|---|---|---|---|---|---|---| | No | Uraian Pekerjaan | Material Type | Satuan | Koefisien | Harga Satuan (Rp) | Jumlah (Rp) | Sumber Data | Keterangan | | 1 | Papan multiplek 18mm | Lembar | 0.25 | Rp 180,000 | Rp 45,000 | Supplier X | Badan lemari | | 2 | Lem krakibon | Kg | 0.10 | Rp 35,000 | Rp 3,500 | Toko Y | Perakitan | | 3 | Tukang kayu | OH | 0.75 | Rp 120,000 | Rp 90,000 | Standar UMK | - | | 4 | Finishing duco | m² | 1.20 | Rp 85,000 | Rp 102,000 | Subkon | - | Fitur Protect Sheet: Klik Review > Protect Sheet

    Total Harga Satuan (per unit furniture) = SUM(Jumlah) → Example: Rp 240,500

    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.

    Loading...