excel paket pekerjaan infrastruktur

63
Volume Pekerjaan Proyek Cluster The Elysium Garden Lokasi : Lippo Cikarang Selatan - Bekasi Perencana : D_Pavillion Architecture And Interior Volume Paving Block (V) = 8528.79 Panjang Drainase (P) = 1399.798 No Jenis Pekerjaan Perhitungan A V x 1 B List Batu bata 1 : 4 V x 0,2 x 2 C Plesteran List bata 1 : 4 V x 0,2 x 2 D Galian Tanah Kansteen E Galian Tanah Drainase 0,5 x 0,5 x P F Pasangan U-Ditch ( 50 x 50 x 120 ) P : 1,2 G Pasangan Manhole ( 50 x 60 ) P : 0,6 cm )

Upload: achmad-sukoco

Post on 30-Jan-2016

271 views

Category:

Documents


5 download

DESCRIPTION

Contoh Perhitungan Excel Paket Pekerjaan Infrastruktur (Durasi Pekerjaan)

TRANSCRIPT

Page 1: Excel Paket Pekerjaan Infrastruktur

Volume Pekerjaan Proyek Cluster The Elysium GardenLokasi : Lippo Cikarang Selatan - BekasiPerencana : D_Pavillion Architecture And Interior

Volume Paving Block (V) = 8528.79 m2Panjang Drainase (P) = 1399.798 m

No Jenis Pekerjaan Perhitungan VolumeA Paving Block ( t = 6 Cm ), urugan 5 cm V x 1 8528.79B List Batu bata 1 : 4 V x 0,2 x 2 3411.52C Plesteran List bata 1 : 4 V x 0,2 x 2 3411.52D Galian Tanah Kansteen 2 x ( 0,15 x 0,2 x V ) 511.73E Galian Tanah Drainase 0,5 x 0,5 x P 349.95F Pasangan U-Ditch ( 50 x 50 x 120 ) P : 1,2 1166.50G Pasangan Manhole ( 50 x 60 ) P : 0,6 2333.00

Page 2: Excel Paket Pekerjaan Infrastruktur

Satuanm2m2m2m3m3bhbh

Page 3: Excel Paket Pekerjaan Infrastruktur

Harga Satuan BahanLokasi : Lippo Cikarang Selatan - BekasiPerencana : D_Pavillion Architecture And Interior

DAFTAR HARGA BAHAN TAHUN 2015

NO JENIS MATERIAL

MATERIAL ALAM1 SEMEN PC ( HOLCIM )2 TANAH MERAH 3 PUPUK KANDANG4 PASIR- PASANG5 PASIR PUTIH6 PASIR BETON 7 SPLITE 1/28 BATU KALI ( belli stapelan di tempat)9 BATU-BATA CIKARANG

10 Block Celcon t = 10cm (MOU)11 SIRTU12 BASE COURSE13 SCREENING14 KANSTEN BETON 20X25X40

GRC 1x20x240POLYCARBONATE (210X118) = 1,2 S/D. 1,3 JT/LBR

PAVING1 Paving block warna abu-abu T = 8 CM2 Abu Batu

BESI BETON /BAJA :1 BESI-BETON SII ( KS TOBU) FULL

WIRE MESH M-6WIRE MESH M-8WIRE MESH M-10

2 KAWAT-BINDRAD3 PAKU CAMPUR4 PAKU SENG5 Hollow 4/4 Zincromate6 Hollow 2/4 Zincromate

AM - GROUTING :1 AM-50 (WARNA STANDARD)2 AM-54

MORTAR

Page 4: Excel Paket Pekerjaan Infrastruktur

1 Perekat Beton Ringan (PM110) @ 40 Kg - 3.15 kg/m3 blok tebal 100mm2 Pas. Bata merah & Plesteran Beton (PM210) @ 40 Kg - 20 kg/m2 ketebal 10mm2 Premium Plesteran Beton (PM200+) @ 40 Kg - 8 kg/m2 ketebal 5mm3 Acian (PM310) @ 40 Kg - 3 kg/m2 ketebal 2-3 mm4 Pas. Keramik, exterior & wet interior (PM410) @ 25 Kg - 5 kg/m2 ketebal 10mm5 Pas. Keramik, Dry interior (PM420) @ 25 Kg - 5 kg/m2 ketebal 10mm6 Grout (PM500) @ 25 kg7 Grout (PM500) @ 25 kg - Warna kusus (Quary Red, Green sand, blue star)8 Screed perata lantai (PM600) @ 40 kg - 1.2 kg/m2/mm

PEK. BAJA :1 BAJA2 Dinabolt M 10

READY MIX :READYMIX-K175 (slum 12) READYMIX-K225 (slum 12)

2 READYMIX-K250 (slum 12) 3 READYMIX-K275 (slum 12)

READYMIX-K300 (slum 12) READYMIX-K350 (slum 12) READYMIX-K400 (slum 12) READYMIX-K450 (slum 12)

KAYU / BEKISTING :Borneo Super

1 BALOK2 KASO3 Kayu Dolken Ø5-7 cm4 MULTIPELX 9MM 4X85 MULTIPLEX 12MM 4X86 MULTIPLEX 15MM 4X86 OLIE BEKAS U/ BEKISTING7 Plint Lantai 7.5 cm

Kamper u/ Kusen1 BALOK2 KASO3 PAPAN4 Triplek tebal 4 mm5 Lem kayu (kuning)

KERAMIK ROMAN

1 KERAMIK LANTAI- KERAMIK 20/20- KERAMIK 20/20 U/ KAMAR MANDI/TOILET- KERAMIK 30/30

Page 5: Excel Paket Pekerjaan Infrastruktur

- KERAMIK 40/40- KERAMIK 30 x 30 HOMOGENOUSE

2 KERAMIK DINIDING- KERAMIK 20/25 POLOS

3 NOSING / PLINT KERAMIK DINDING- Plin Keramik 10/30

PLAFOND1 Papan Gypsum 9 mm2 Papan Gypsum 12 mm3 Calsium Silicate

Papan GRC uk. 122x2444 Paku Skrup Gypsum5 Cotton plaster6 Compoun7 List Plafond 5x5 cm

CAT :1 ALKALI-PRIMER2 PLAMUR TEMBOK ICI3 CAT ICI WEATHERSILD4 CAT ICI EMULSION5 AMPLAS6 ROLL7 CAT UPOXY DUST PROOF ( FOSROC)8 CAT UPOXY ( Acid) @ 5kg9 DEMPUL

10 WOOD FILLER11 MENIE BESI12 CAT BESI/KAYU13 MINYAK CAT14 MELAMIC ULTRAN15 MELAMIC CLEAR16 THENER CAT IMPALA17 CAT ICI WEATHERSILD + Teksture

WATER PROOFING/WATERSTOP/EXPANTION JOINT

1 Flexible Cementitious Coating- Primer- CL-Pruf 507- CL-Fabric

2 MEMBRANE SHEET BITUTHENE 3000 3 SIKA4 WATERSTOP A-19 5 EXPANTION JOINT

SANITAIR :

Page 6: Excel Paket Pekerjaan Infrastruktur

1 CLOSET JONGKOK Ex. TOTO - CE72 CLOSET DUDUK Ex. TOTO - CW 420 J / SW 420 JP3 WASTAFEL Ex. TOTO - LW 38 V14 WASTAFEL Ex. TOTO - LW660CJ

WASTAFEL Ex. TOTO - LW7CJ5 URINOIR Ex. TOTO TYPE U 57 M6 HAND SPRAY Ex. TOTO - TB 19 CSMCR7 FLOOR DRAIN Ex. TOTO - TX 1 B8 TEMPAT TISSUE Ex. TOTO - TS 116DS9 DOUBLE ROBE HOOK Ex. TOTO - TS 118 WS

10 KRAN AIR Ex. TOTO - T 23 B1311 KRAN ANGSA Ex. TOTO - TX 109 LH12 KRAN AIR13 ZINK ST. STEEL 1 LOBANG (Meiwa)14 ZINK ST. STEEL 2 LOBANG (BLANCO)15 BUILT IN16 FAUCET ( T26-13- W/HOSE COUPLING)17 AUTOMATIC FLUSH VALVE ( TV150NWV12)18 KITCHEN SET19 TESTING PLUMBING20 TEMPAT SABUN S156 N21 Shower Set ex. TOTO TX 432 SDN SD2222 Bath tub FB 1700-7523 Roof Drain Ø 4"24 STOP KRAN KIT 1"25 STOP KRAN KIT 3/4"26 Glass blok warna putih27 Glass blok berwarna

DOOR & WINDOW :1 GLASS DOOR & FRAME ( SRIYADI ALUMINIUM)2 WOODEN DOOR & FRAME(SRI YADI)3 ALUM SLIDING WINDOW (SRIYADI)4 GLASS WINDOW & ALUM FRAME (SRIYADI)5 Louver Aluminium6 Kusen aluminium7 Mullion8 Caping curtain wall9 Rolling Door

10 Pintu Aluminium + Kaca 5 mm11 Railing Tangga Pipa BSP Ø 1.5 "12 Back Plate13 Engsel14 Door Closer15 Kunci tanam pintu16 Kunci pintu kamar mandi16 Ram buncis17 Engsel catchment

Page 7: Excel Paket Pekerjaan Infrastruktur

18 Skrup / fisher19 Stoper Pintu20 Pintu aluminium untuk kamar mandi21 Profil U

KACA + ACCESSORIES:1 KACA POLOS 5MM2 KACA CERMIN 6MM3 KARET4 Silikon

Septic Tank BioType BF - 03

1 Type BCF - 4 S (cap. 0.8 m3, Vol tanki 1.2 m3)2 Type BCF - 6 S (cap. 1.2 m3, Vol tanki 1.8 m3)3 Type BCF - 10 S (cap. 2 m3, Vol tanki 2.6 m3)

PIPA CARBONSTEEL SCHEDULE1 Dia. 1" 2 Dia. 3" 3 Dia. 4"

PIPA PVC ( WAVIN) 1 PIPA PVC "AW" DIA1/2" 2 PIPA PVC "AW" DIA3/4" 3 PIPA PVC "AW" DIA 1" 4 PIPA PVC "D" DIA 1-1/4" 5 PIPA PVC "D" DIA 1-1/2" 6 PIPA PVC "D" DIA 2" 7 PIPA PVC "D" DIA 2,5" 8 PIPA PVC "D" DIA 3" 9 PIPA PVC "D" DIA 4"

10 PIPA PVC "D" DIA 6" 11 PIPA PVC DIA 8"

PIPA ( EX. B.C.S ) 1 Medium Diameter besi 1/2" 2 Medium Diameter besi 3/4"

LISTRIK1 LAMPU TL MENTARI RW 3002 Kabel 2x2.5 NYM2 Kabel 3x2.5 NYM2 Kabel Tuvur2 Kabel Antena3 Kabel telepon4 Outlet telepon / Stop Kontak / Saklar

Page 8: Excel Paket Pekerjaan Infrastruktur

2 Medium Diameter besi 4"

AC1 AC Split 1 PK2 Exhaust fan3 Refrigerant,kabel insulation dll4 Freon , Alat bantu5 Braket AC

KARPET1 Karpet2 Underlayer

WALLPAPER1 Wallpaper2 Lem Perekat

MATERIAL ALAM

2 BATU PECAH UK. 5X7 10 HEBEL15 HOTMIX HRS 5 CM 16 PRIME COAT

TRIPLEX1 BALOK2 KASO6 MULTIPLEX 19MM 4X86 PINOLIX 9MM7 PINOLIX 12MM

1 READYMIX-K175 (slum 12)

5 Hilthi chemical + Rood Ø 20 mm

CAT

TIANG PANCANG 1 MOB DEMOB T. PANCANG2 TIANG PANCANG DIA 350MM3 ALAT PANCANG + UPAH DIA 3504 HANDLING TIANG PANCANG DIA 350

Page 9: Excel Paket Pekerjaan Infrastruktur

5 PENGELASAN TIANG PANCANG DIA 3506 MINI PILE 28X28X28 7 ALAT + UPAH MINI PILE8 PDA TEST9 DOLLY TEST

WATERPROOFING5 BITUMENOUS PAINT 6 GLASS WOOL - 1"X24 KG ( 1.2X30)7 ALUM. FOIL SINGLE SIDE (1.25X60)8 ROOF MESH DIA 1.2MMX75X75 (1.8X30M)

HARDENER2 Epoxi 700 mikron3 Bondek

ASS. KACA

3 ASBES PLAT 1X1X4MM

"WIRE MESH" 1 TIANG PAGAR BRC ( ELECTRO)2 PANEL BRC 175x240CM ( ELECTRO)3 ACCESSORIES4 Wire mesh M7

ATAP METAL :1 FLOOR DECK2 Zincalumn 0,45 TCT3 Talang Zincalumn4 Fascia caping

BAJA2 ACCESS PINTU BAJA ( RODA/REL KUNCI DLL)3 ST. LESS STEEL RAILING4 Tangga baja (C.200, Plat Bordes , Siku) + Railing Pipa BSP Ø 1.25"5 Angkur Ø 22 mm

FLOOR HARDENER :1 FLOOR HARDENER (Chapdur Natural/25 kg)

BORED PILE1 Mobilisasi dan demobilisasi2 Persiapan3 Pengeboran Tanah4 Beton Bored Pile K 250 Slump 16

Page 10: Excel Paket Pekerjaan Infrastruktur

PDA TEST1 Mobilisasi dan demobilisasi hammer untuk PDA test2 PDA test3 Pembuangan tanah/lumpur hasil pengeboran keluar lapangan kerja

Page 11: Excel Paket Pekerjaan Infrastruktur

DAFTAR HARGA BAHAN TAHUN 2015

SAT HARGA

0.00ZAK 40,500.00M3 50,000.00M3 90,000.00M3 250,000.00M3 175,000.00M3 175,000.00M3 188,000.00M3 120,000.00BH 300.00BH 6,120.00M3 110,000.00M3 140,000.00M3 155,000.00BH 15,000.00LBR 40,000.00

22.6857,319.22

m2 65,000.00m2 140,000.00

0.00KG 10,000.00LBR 493,000.00LBR 876,000.00LBR 0.00KG 15,000.00KG 14,000.00KG 15,000.00btg 23,000.00btg 18,000.00

KG 10,000.00LTR 32,500.00

Page 12: Excel Paket Pekerjaan Infrastruktur

ZAK 45,000.00ZAK 25,000.00ZAK 30,000.00ZAK 40,000.00ZAK 40,000.00ZAK 37,000.00ZAK 168,000.00ZAK 228,000.00ZAK 25,000.00

KG 14,500.00BH 800.00

M3 504,600.00M3 523,000.00M3 531,000.00M3 542,000.00M3 561,600.00M3 588,200.00M3 611,000.00M3 649,000.00

M3 1,700,000.00M3 1,700,000.00btg 20,000.00LBR 105,000.00LBR 135,000.00LBR 172,500.00LTR 1,500.00m1 20,000.00

M3 7,500,000.00M3 7,500,000.00M3 7,500,000.00lbr 65,000.00ltr 30,000.00

0.00

M2 55,500.00M2 55,500.00M2 55,500.00

Page 13: Excel Paket Pekerjaan Infrastruktur

M2 64,880.00M2 135,000.00

M2 55,500.00

BH 7,500.00

lbr 56,000.00lbr 70,200.00lbr 112,700.00lbr 205,000.00bh 200.00roll 15,000.00zak 87,900.00m1 6,000.00

GLN 95,500.00GLN 114,000.00GLN 198,900.00GLN 114,500.00LBR 1,500.00BH 25,000.00LT 150,000.00LT 87,000.00KG 30,000.00KG 15,000.00KG 35,000.00KG 60,000.00KG 15,000.00KG 25,000.00KG 25,000.00ltr 7,500.00m2 22,500.00

M2 6,500.00M2 12,000.00M2 10,000.00M2 70,000.00M2 32,500.00M' 76,650.00M' 40,000.00

Page 14: Excel Paket Pekerjaan Infrastruktur

BH 139,500.00BH 1,239,000.00BH 823,500.00BH 1,237,600.00BH 784,700.00BH 1,667,000.00BH 173,900.00BH 150,000.00BH 350,000.00BH 98,400.00BH 130,400.00BH 347,520.00BH 75,000.00BH 175,000.00BH 1,500,000.00M2 2,000,000.00BH 162,400.00BH 1,122,000.00LS 7,500,000.00LS 885,000.00BH 35,000.00BH 658,000.00BH 2,820,000.00BH 125,000.00BH 76,400.00BH 54,600.00BH 16,000.00BH 20,000.00

M2 1,450,000.00M2 1,350,000.00M2 875,000.00M2 875,000.00m1 30,000.00m1 90,000.00m1 125,000.00m1 35,000.00unit 5,520,000.00unit 1,200,000.00unit 618,750.00set 35,000.00set 25,000.00set 250,000.00set 65,000.00set 45,000.00set 50,000.00set 75,000.00

Page 15: Excel Paket Pekerjaan Infrastruktur

ls 15,000.00m1 25,000.00unit 600,000.00m1 20,000.00

0.00M2 70,000.00M2 90,000.00M1 15,000.00m1 7,500.00

Unit 2,242,500.00Unit 3,752,500.00Unit 4,626,500.00Unit 7,885,000.00

BT 200,000.00BT 780,000.00BT 1,110,000.00

BT 14,950.00BT 20,620.00BT 28,155.00BT 21,140.00BT 24,275.00BT 30,980.00BT 45,305.00BT 61,100.00BT 101,275.00BT 235,453.00BT 0.00

BT 90,000.00BT 110,000.00

unit 280,000.00m1 9,000.00m1 11,000.00m1 30,000.00m1 10,000.00m1 10,000.00bh 50,000.00

Page 16: Excel Paket Pekerjaan Infrastruktur

BT 700,000.00

unit 0.00unit 0.00

ls 0.00ls 0.00

set 0.00

m2 0.00m2 0.00

m2 0.00kg 0.00

0.00

M3 0.00M3 517,500.00M2 0.00M2 0.00

M3 0.00M3 0.00LBR 0.00LBR 0.00LBR 0.00

M3 0.00

titik 0.00

LS 0.00M 0.00M' 0.00M' 0.00

Page 17: Excel Paket Pekerjaan Infrastruktur

titik 0.00M 0.00M 0.00BH 0.00BH 0.00

LTR 0.00M2 0.00M2 0.00M2 0.00

M2 0.00m2 0.00

LBR 0.00

BH 0.00BH 0.00M' 0.00kg 0.00

m2' 0.00m2 0.00m2 0.00m' 0.00

0.00

M2 0.00KG 0.00

Unit 0.00BH 0.00

bag 52,500.000.00

m' 13,000.00m' 4,000.00m1 104,500.00m3 495,000.00

Page 18: Excel Paket Pekerjaan Infrastruktur

ls 3,000,000.00titik 6,000,000.00m3 50,000.00

Page 19: Excel Paket Pekerjaan Infrastruktur

Harga Satuan BahanLokasi : Lippo Cikarang Selatan - BekasiPerencana : D_Pavillion Architecture And Interior

Harga Satuan Bahan U-Ditch (Drainase Jalan)

Page 20: Excel Paket Pekerjaan Infrastruktur
Page 21: Excel Paket Pekerjaan Infrastruktur

Analisa Harga SatuanLokasi : Lippo Cikarang Selatan - BekasiPerencana : D_Pavillion Architecture And Interior

No Jenis Pekerjaan Koefisien Satuan

A

Paving Block ( t = 6 Cm ) K-250 m2BahanPaving blok Holand 6 cm K : 250 1.01 m2Pasir pasang 1 m3UpahPekerja 0.2 OrgTukang batu 0.3 OrgKepala tukang batu 0.03 OrgMandor 0.025 OrgPeralatan 0.05 lotJ u m l a h A

No Jenis Pekerjaan Koefisien Satuan

B

List Batu bata 1 : 4 m2BahanBata merah 70 BhP C (50 kg) 11.5 KgPasir pasang 0.043 M3UpahPekerja 0.32 OrgTukang batu 0.1 OrgKepala tukang batu 0.01 OrgMandor 0.015 OrgJ u m l a h B

No Jenis Pekerjaan Koefisien Satuan

C

Plesteran List bata 1 : 4 m2BahanP C (50 kg) 6.24 KgPasir 0.024 m3UpahPekerja 0.2 OrgTukang batu 0.15 OrgKepala Tukang 0.015 Org

Page 22: Excel Paket Pekerjaan Infrastruktur

C

Mandor 0.01 OrgJ u m l a h C

No Jenis Pekerjaan Koefisien Satuan

D

Galian Tanah Kansteen M3UpahPekerja 0.4 OrgMandor 0.04 OrgJ u m l a h D

No Jenis Pekerjaan Koefisien Satuan

E

Galian Tanah Drainase M3UpahPekerja 0.75 OrgMandor 0.025 OrgJ u m l a h E

No Jenis Pekerjaan Koefisien Satuan

F

Pasangan U-Ditch 50x50x120 m2BahanU-Ditch 1 bhUpahPekerja 0.25 OrgMandor 0.025 OrgJ u m l a h F

No Jenis Pekerjaan Koefisien Satuan

G

Pasangan Manhole 50x60 m2BahanManhole (Tutup U-Ditch) 1 bhUpahPekerja 0.25 OrgMandor 0.025 OrgJ u m l a h G

Page 23: Excel Paket Pekerjaan Infrastruktur

Harga Satuan Analisa Harga Satuan

Rp 8,528.79

Rp 50,000.00 Rp 50,500.00 Rp 110,000.00 Rp 110,000.00

Rp - Rp 45,000.00 Rp 9,000.00 Rp 50,000.00 Rp 15,000.00 Rp 55,000.00 Rp 1,650.00 Rp 60,000.00 Rp 1,500.00 Rp 15,000.00 Rp 750.00

Rp 188,400.00

Harga Satuan Analisa Harga Satuan

Rp 3,411.52

Rp 650.00 Rp 45,500.00 Rp 1,350.00 Rp 15,525.00 Rp 110,000.00 Rp 4,730.00

Rp - Rp 45,000.00 Rp 14,400.00 Rp 50,000.00 Rp 5,000.00 Rp 55,000.00 Rp 550.00 Rp 60,000.00 Rp 900.00

Rp 86,605.00

Harga Satuan Analisa Harga Satuan

Rp 3,411.52

Rp 1,350.00 Rp 8,424.00 Rp 110,000.00 Rp 2,640.00

Rp - Rp 45,000.00 Rp 9,000.00 Rp 50,000.00 Rp 7,500.00 Rp 55,000.00 Rp 825.00

Page 24: Excel Paket Pekerjaan Infrastruktur

Rp 60,000.00 Rp 600.00

Rp 28,989.00

Harga Satuan Analisa Harga Satuan

Rp 511.73

Rp 45,000.00 Rp 18,000.00 Rp 60,000.00 Rp 2,400.00

Rp 20,400.00

Harga Satuan Analisa Harga Satuan

Rp 349.95

Rp 45,000.00 Rp 33,750.00 Rp 60,000.00 Rp 1,500.00

Rp 35,250.00

Harga Satuan Analisa Harga Satuan

Rp 1,166.50

Rp 593,000.00 Rp 593,000.00 Rp -

Rp 45,000.00 Rp 11,250.00 Rp 60,000.00 Rp 1,500.00

Rp 605,750.00 Harga Satuan

Analisa Harga Satuan

Rp 2,333.00

Rp 196,000.00 Rp 196,000.00 Rp -

Rp 45,000.00 Rp 11,250.00 Rp 60,000.00 Rp 1,500.00

Rp 208,750.00

Total Rp 899,139.00 Dibulatkan Rp 899,000.00

Page 25: Excel Paket Pekerjaan Infrastruktur

Bill Of QuantityLokasi : Lippo Cikarang Selatan - BekasiPerencana : D_Pavillion Architecture And Interior

No Jenis Pekerjaan Koefisien Satuan Harga Satuan

A

Paving Block ( t = 6 Cm ) K-250 m2BahanPaving blok Holand 6 cm K : 250 1.01 m2 Rp 50,000.00 Pasir pasang 1 m3 Rp 110,000.00 UpahPekerja 0.2 Org Rp 45,000.00 Tukang batu 0.3 Org Rp 50,000.00 Kepala tukang batu 0.03 Org Rp 55,000.00 Mandor 0.025 Org Rp 60,000.00 Peralatan 0.05 lot Rp 15,000.00 J u m l a h A

No Jenis Pekerjaan Koefisien Satuan Harga Satuan

B

List Batu bata 1 : 4 m2BahanBata merah 70 Bh Rp 650.00 P C (50 kg) 11.5 Kg Rp 1,350.00 Pasir pasang 0.043 M3 Rp 110,000.00 UpahPekerja 0.32 Org Rp 45,000.00 Tukang batu 0.1 Org Rp 50,000.00 Kepala tukang batu 0.01 Org Rp 55,000.00 Mandor 0.015 Org Rp 60,000.00 J u m l a h B

No Jenis Pekerjaan Koefisien Satuan Harga Satuan

C

Plesteran List bata 1 : 4 m2BahanP C (50 kg) 6.24 Kg Rp 1,350.00 Pasir 0.024 m3 Rp 110,000.00 UpahPekerja 0.2 Org Rp 45,000.00 Tukang batu 0.15 Org Rp 50,000.00 Kepala Tukang 0.015 Org Rp 55,000.00 Mandor 0.01 Org Rp 60,000.00 J u m l a h C

Page 26: Excel Paket Pekerjaan Infrastruktur

No Jenis Pekerjaan Koefisien Satuan Harga Satuan

D

Galian Tanah Kansteen M3UpahPekerja 0.4 Org Rp 45,000.00 Mandor 0.04 Org Rp 60,000.00 J u m l a h D

No Jenis Pekerjaan Koefisien Satuan Harga Satuan

E

Galian Tanah Drainase M3UpahPekerja 0.75 Org Rp 45,000.00 Mandor 0.025 Org Rp 60,000.00 J u m l a h E

No Jenis Pekerjaan Koefisien Satuan Harga Satuan

F

Pasangan U-Ditch 50x50x120 m2BahanU-Ditch 1 bh Rp 593,000.00 UpahPekerja 0.25 Org Rp 45,000.00 Mandor 0.025 Org Rp 60,000.00 J u m l a h F

No Jenis Pekerjaan Koefisien Satuan Harga Satuan

G

Pasangan Manhole 50x60 m2BahanManhole (Tutup U-Ditch) 1 bh Rp 196,000.00 UpahPekerja 0.25 Org Rp 45,000.00 Mandor 0.025 Org Rp 60,000.00 J u m l a h G

Page 27: Excel Paket Pekerjaan Infrastruktur

Volume Biaya Total

8528.79

8614.08 Rp 430,703,895.00 8528.79 Rp 938,166,900.00

1705.76 Rp 76,759,110.00 2558.64 Rp 127,931,850.00

255.86 Rp 14,072,503.50 213.22 Rp 12,793,185.00 426.44 Rp 6,396,592.50

Rp 1,606,824,036.00

Volume Biaya Total

3411.52

238,806.12 Rp 155,223,978.00 39232.43 Rp 52,963,785.90

146.70 Rp 16,136,470.68

1091.69 Rp 49,125,830.40 341.15 Rp 17,057,580.00

34.12 Rp 1,876,333.80 51.17 Rp 3,070,364.40

Rp 295,454,343.18

Volume Biaya Total

3411.52

21287.86 Rp 28,738,610.78 81.88 Rp 9,006,402.24

682.30 Rp 30,703,644.00 511.73 Rp 25,586,370.00

51.17 Rp 2,814,500.70 34.12 Rp 2,046,909.60

Rp 98,896,437.32

Page 28: Excel Paket Pekerjaan Infrastruktur

Volume Biaya Total

511.73

204.69 Rp 9,211,093.20 20.47 Rp 1,228,145.76

Rp 10,439,238.96

Volume Biaya Total

349.95

262.46 Rp 11,810,795.63 8.75 Rp 524,924.25

Rp 12,335,719.88

Volume Biaya Total

1166.50

1166.50 Rp 691,733,511.67

291.62 Rp 13,123,106.25 29.16 Rp 1,749,747.50

Rp 706,606,365.42

Volume Biaya Total

2333.00

2333.00 Rp 457,267,346.67

583.25 Rp 26,246,212.50 58.32 Rp 3,499,495.00

Rp 487,013,054.17

Total Rp 3,217,569,194.92 Jasa (10%) Rp 321,756,919.49

Total Rp 3,539,326,114.41 Dibulatkan Rp 3,539,326,000.00

Page 29: Excel Paket Pekerjaan Infrastruktur

Durasi Pekerjaan Proyek Cluster The Elysium GardenLokasi : Lippo Cikarang Selatan - BekasiPerencana : D_Pavillion Architecture And Interior

NO JENIS PEKERJAAN TOTAL ( Rp )

SUB PEKERJAAN Pekerjaan Akses Jalan

1

Galian Tanah KansteenUpah

Pekerja Rp 9,211,093.20 Mandor Rp 1,228,145.76

2

Galian Tanah DrainaseUpah

Pekerja Rp 11,810,795.63 Mandor Rp 524,924.25

3

Paving Block ( t = 6 Cm ) K-250Upah

Pekerja Rp 76,759,110.00 Tukang batu Rp 127,931,850.00

Kepala tukang batu Rp 14,072,503.50 Mandor Rp 12,793,185.00

Peralatan Rp 6,396,592.50 List Batu bata 1 : 4

UpahPekerja Rp 49,125,830.40

Tukang batu Rp 17,057,580.00 Kepala tukang batu Rp 1,876,333.80

Mandor Rp 3,070,364.40

5

Plesteran List bata 1 : 4Upah

Pekerja Rp 30,703,644.00 Tukang batu Rp 25,586,370.00

Kepala Tukang Rp 2,814,500.70 Mandor Rp 2,046,909.60

Pekerjaan Drainase

6

Pasangan U-Ditch 50x50x120Upah

Pekerja Rp 13,123,106.25 Mandor Rp 1,749,747.50

7

Pasangan Manhole 50x60Upah

Page 30: Excel Paket Pekerjaan Infrastruktur

7Pekerja Rp 26,246,212.50 Mandor Rp 3,499,495.00

Total Biaya Rp 437,628,293.99

Volume Pekerjaan SDM M2

1 Pekerja Rp 1.00 1 Mandor Rp 1.00

PEKERJAAN BOUWPLANK1 Tukang Kayu Rp 1.00 1 Pekerja Rp 1.00 1 Kepala Tukang Rp 1.00 1 Mandor Rp 1.00

PEMBUATAN DIREKSI KEET70 Pekerja Rp 1.00

TOTAL DURASI

Page 31: Excel Paket Pekerjaan Infrastruktur

Volume Pekerjaan M2 Indeks M2 Hari Kec. Durasi

Pekerjaan Akses Jalan

511.73 1 0.4 2.50 205 19511.73 1 0.04 25.00 20 9.5

349.95 1 0.75 1.33 262 19349.95 1 0.025 40.00 9 9.5

8528.79 1 0.2 5.00 1706 488528.79 1 0.3 3.33 2559 488528.79 1 0.03 33.33 256 248528.79 1 0.025 40.00 213 248528.79 1 0.05 20.00 426 48

3411.52 1 0.32 3.13 1092 483411.52 1 0.1 10.00 341 483411.52 1 0.01 100.00 34 243411.52 1 0.015 66.67 51 24

3411.52 1 0.2 5.00 682 403411.52 1 0.15 6.67 512 403411.52 1 0.015 66.67 51 203411.52 1 0.01 100.00 34 20

Pekerjaan Drainase

1166.50 1 0.25 4.00 292 301166.50 1 0.025 40.00 29 15

Page 32: Excel Paket Pekerjaan Infrastruktur

2333.00 1 0.25 4.00 583 302333.00 1 0.025 40.00 58 15

Total Durasi

Indeks Hari Renc. Durasi Keb. SDM CheckRekapitulasi

SDM0.1 #REF! 8 #REF! #REF! #REF!

0.05 #REF! 4 #REF! #REF! #REF!PEKERJAAN BOUWPLANK

0.1 #REF! 2 #REF! #REF! #REF!0.1 #REF! 2 #REF! #REF! #REF!

0.01 #REF! 1 #REF! #REF! #REF!0.005 #REF! 1 #REF! #REF! #REF!

PEMBUATAN DIREKSI KEET0.1 #REF! 2 #REF! #REF! #REF!

TOTAL DURASI

Page 33: Excel Paket Pekerjaan Infrastruktur

Keb. SDM CheckRekapitulasi

SDM Durasi (Hari)Pekerjaan Akses Jalan

1911 511.73 192 511.73 10

1914 349.95 191 349.95 10

4836 8528.79 4853 8528.79 4811 8528.79 249 8528.79 249 8528.79 48

4823 3411.52 487 3411.52 481 3411.52 242 3411.52 24

4017 3411.52 4013 3411.52 403 3411.52 202 3411.52 20

Pekerjaan Drainase

3010 1166.50 302 1166.50 15

30

Page 34: Excel Paket Pekerjaan Infrastruktur

19 2333.00 3030

4 2333.00 15Total Durasi 234

RekapitulasiDurasi ( Hari )

8

2

212

Page 35: Excel Paket Pekerjaan Infrastruktur

Durasi Pekerjaan Proyek Cluster The Elysium GardenLokasi : Lippo Cikarang Selatan - Bekasi

Perencana : D_Pavillion Architecture And Interior

NO JENIS PEKERJAANTOTAL ( Rp ) BOBOT

SUB PEKERJAAN ( % )Pekerjaan Akses Jalan

1 Galian Tanah Kansteen Rp 10,439,238.96 0.322 Galian Tanah Drainase Rp 12,335,719.88 0.383 Paving Block ( t = 6 Cm ) K-250 Rp 1,606,824,036.00 49.944 List Batu bata 1 : 4 Rp 295,454,343.18 9.185 Plesteran List bata 1 : 4 Rp 98,896,437.32 3.07

Pekerjaan Drainase6 Pasangan U-Ditch 50x50x120 Rp 706,606,365.42 21.967 Pasangan Manhole 50x60 Rp 487,013,054.17 15.14

JUMLAH RAB FISIK Rp 3,217,569,194.92 100.00

Prosentase Harian (%)Prosentase Mingguan (%)Prosentase Bulanan (%)

Kumulatif (%)

Page 36: Excel Paket Pekerjaan Infrastruktur

SEPTEMBER9 10 11 12 13 14 15 16 17 18 19

0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.020.02 0.02 0.02 0.02 0.02 0.02

0.02 0.02 0.02 0.02 0.00 0.04 0.04 0.04 0.04 0.04 0.040.06 0.22

0.02 0.03 0.05 0.06 0.06 0.10 0.14 0.18 0.21 0.25 0.29

- -

Page 37: Excel Paket Pekerjaan Infrastruktur

0 20 40 60 80 100 120 -

20.00

40.00

60.00

80.00

100.00

120.00

Row 22

Page 38: Excel Paket Pekerjaan Infrastruktur

SEPTEMBER20 21 22 23 24 25 26 27 28 29 30

0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.020.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02

1.04 1.04 1.04

0.00 0.04 0.04 0.04 0.04 0.04 0.04 0.00 1.08 1.08 1.080.22

3.74 0.29 0.32 0.36 0.40 0.44 0.47 0.51 0.51 1.59 2.67 3.74

-

Page 39: Excel Paket Pekerjaan Infrastruktur

0 20 40 60 80 100 120 -

20.00

40.00

60.00

80.00

100.00

120.00

Row 22

Page 40: Excel Paket Pekerjaan Infrastruktur

OKTOBER1 2 3 4 5 6 7 8 9 10

0.02 0.02 0.021.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04

0.19 0.19 0.19 0.19 0.19 0.19

1.06 1.06 1.06 0.00 1.23 1.23 1.23 1.23 1.23 1.236.41 7.39

4.80 5.86 6.93 6.93 8.16 9.39 10.62 11.85 13.08 14.32

Page 41: Excel Paket Pekerjaan Infrastruktur

0 20 40 60 80 100 120 -

20.00

40.00

60.00

80.00

100.00

120.00

Row 22

Page 42: Excel Paket Pekerjaan Infrastruktur

OKTOBER11 12 13 14 15 16 17 18 19

1.04 1.04 1.04 1.04 1.04 1.04 1.040.19 0.19 0.19 0.19 0.19 0.19 0.190.08 0.08 0.08 0.08 0.08 0.08 0.08

0.73

0.00 1.31 1.31 1.31 1.31 1.31 1.31 0.00 2.047.85

14.32 15.62 16.93 18.24 19.55 20.86 22.17 22.17 24.21

Page 43: Excel Paket Pekerjaan Infrastruktur

OKTOBER20 21 22 23 24 25 26 27 28

1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.040.19 0.19 0.19 0.19 0.19 0.19 0.19 0.190.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08

0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.73

2.04 2.04 2.04 2.04 2.04 0.00 2.04 2.04 2.04

26.25 28.29 30.33 32.37 34.41 34.41 36.45 38.49 40.53

Page 44: Excel Paket Pekerjaan Infrastruktur

OKTOBER NOVEMBER29 30 31 1 2 3 4 5 6

1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.040.19 0.19 0.19 0.19 0.19 0.19 0.19 0.190.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08

0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.730.50 0.50 0.50 0.50 0.50

2.04 2.04 2.04 0.00 2.55 2.55 2.55 2.55 2.5512.2442.91

42.57 44.61 46.65 46.65 49.20 51.74 54.29 56.83 59.38

Page 45: Excel Paket Pekerjaan Infrastruktur

NOVEMBER7 8 9 10 11 12 13 14 15

1.04 1.04 1.04 1.04 1.04 1.04 1.040.19 0.19 0.19 0.19 0.19 0.19 0.190.08 0.08 0.08 0.08 0.08 0.08 0.08

0.73 0.73 0.73 0.73 0.73 0.73 0.730.50 0.50 0.50 0.50 0.50 0.50 0.50

2.55 0.00 2.55 2.55 2.55 2.55 2.55 2.55 0.0015.27 15.27

61.92 61.92 64.47 67.01 69.56 72.10 74.65 77.19 77.19

Page 46: Excel Paket Pekerjaan Infrastruktur

NOVEMBER16 17 18 19 20 21 22 23 24

1.04 1.04 1.04 1.04 1.04 1.040.19 0.19 0.19 0.19 0.19 0.19 0.19 0.190.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08

0.73 0.73 0.73 0.73 0.73 0.730.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50

2.55 2.55 2.55 2.55 2.55 2.55 0.00 0.77 0.7715.27

79.74 82.28 84.83 87.38 89.92 92.47 92.47 93.24 94.01

Page 47: Excel Paket Pekerjaan Infrastruktur

NOVEMBER DESEMBER25 26 27 28 29 30 1 2 3

0.19 0.19 0.19 0.190.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08

0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50

0.77 0.77 0.77 0.77 0.00 0.58 0.58 0.58 0.584.64

51.03 94.78 95.56 96.33 97.10 97.10 97.68 98.26 98.85 99.43

Page 48: Excel Paket Pekerjaan Infrastruktur

DESEMBER4 5 6 7 8 9 10 11

0.08 0.08

0.50 0.50

0.58 0.58 0.00 0.00 0.00 0.00 0.00 0.003.49

100.01 100.59 100.59 100.59 100.59 100.59 100.59 100.59

Page 49: Excel Paket Pekerjaan Infrastruktur

DESEMBER12 13 14 15 16 17 18 19

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00

100.59 100.59 100.59 100.59 100.59 100.59 100.59 100.59

Page 50: Excel Paket Pekerjaan Infrastruktur

DESEMBER20 21 22 23 24 25 26 27

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00

100.59 100.59 100.59 100.59 100.59 100.59 100.59 100.59

Page 51: Excel Paket Pekerjaan Infrastruktur

DESEMBER28 29 30 31

0.00 0.00 0.00 0.000.002.91

100.59 100.59 100.59 100.59