Get documents about "Calculator Salary
Description
a sample template to create Salary calculation, Overtime, jobs location ect
Shared by: TutehWisnayana
Categories
Tags
-
Stats
- views:
- 25
- posted:
- 2/21/2013
- language:
- Unknown
- pages:
- 378
Document Sample
NAMA PEKERJA NO DIVISI ALAMAT NO.KTP T.T.LAHIR NO.TELP / HP
NANO K.01/OCT10 Tegal 640.514.300169 CLICK FOR EDIT DATA
Rudi.G K.05
Sikin K.06 Tegal 33.7602.270153.0007
Ali K.07 KEEE 640.514.300169 45
Riki K.08 33.2812.200289.0413
Aji K.09
Maksus K.10
Tio K.11
Rosidin K.02/OCT10 Pandeglang 36.0120.110161.0001 [0878.77941408]
Roni K.12 Tegal 11.5304.250266.0001
ZAINAL K.13 33.2812.190378.7007
Sorihi K.14
Tio.A K.15
Daryo K.16
Sahwani K.17
Wandi K.18
Hambali
Udin K.03/OCT10 Tegal 33.7602.210570.003 21/05/1970
Rudi.K K.19 Tegal 33.2812.061081.15568
Yanto K.20 33.7604.130483.0002
Tanali K.21 33.2812.181276.10071
Jamroni K.22 33.2809.251078.4379
Slamet
Toni K.04/OCT10 Tegal 33.2812.231170.2051 [0878.82217074]
Taan K.23 33.2812.010363.0921
Nursidik K.24
Warnoto K.25
Riyono K.26
Rohman K.27
Joko K.28
Saidi K.29
Tarwo K.30
Kusmianto K.31
Aris K.32 Pemalang 33.2710.040774.0021
Taroji
Tasripin
ALEXANDAR F.24/OCT11 Cengkareng 31.7301.170876.0012 [0815.11854096]
Pahru F.25 Bogor 32.0339.120582.03827
Farid F.26 Bogor 32.0339.020880.06820
Ujang F.27 Bogor
Kiwong F.28 Bekasi 32.1609.140592.0002
Yusup F.29 Bogor
Muhtadin F.30 Bogor
Hengki F.31
Pandi F.32
Fazri F.33
Arif F.34
Uce F.35 Bogor 32.0139.101281.0003
Komarudin F.36 Bogor
Solihin F.37 Bogor
Sahrul F.38 Bogor
F.39 Bogor 32.0339.200399.19381
munuh F.40
Mashym F.01/OCT10 Karangmulya.Tgr 36.711.240255.0001 [0813.88906933]
Nasir F.02 Karangmulya.Tgr 36.7112.071161.0003
Komar F.03 Sepatan.Tgr 36.0330.151070.0002
ToTon F.04 Serang 36.0429.061078.0063
Alim F.05 Bogor 32.0339.300875.0611
Mayar F.06 Kembangan.JakBar 09.5208.040677.0324
Ucok F.07 Bogor 32.0339.120481.04179
Sunah F.08 Bogor 32.0339.2003/3608/28779
Naen F.09 Bogor 32.0139.070785.0005
Kenda F.10 Bogor 32.0139.170485.0005 [0858.11358651]
JayAdi F.11
Rohim F.12 Bogor 32.0139.161058.0002
Ibad F.13
Ijul F.14 Bogor 32.0339.230388.04142
Hendi F.15
Saef F.16
Apay F.17
Bisri F.18
Junet F.19 Bogor 32.0139.120965.0003
Herdi F.20 Bogor 32.0339.020880.06820
Zakaria F.21
Soleh F.22
Palin F.23
YADHI SS.01/OCT10
Tarno SS.02 Tigaraksa Tgr 32190.12012.2337263
Sarijo SS.03 Kebumen 130283/000316
Yono SS.04 Kebumen 33.0507.200781.0001
Sarto SS.05 Kebumen 33.0507251081.0001
Parno SS.06 Tegal 33.2806.311273.3106
Nanang SS.07 Pandeglang 36.0120.080489.0001
Wagimin SS.08
Andri SS.09
Turno SS.10
Sutar SS.11 Kebumen 33.0507.0812810039
Turijan SS.12
Senen SS.13 Kebumen 030777/000330
Puri SS.14
Suprih SS.15 Magelang 11.1910.060575.0057
Anto SS.16 Kebumen 33.0507.0501900003 [0819.03908388]
Apen SS.17
Ijan SS.18
Wilan SS.19
Jio SS.20
Naryo SS.21
jul (Dul) SS.22 Pandeglang 3601.20220477.0001
Sudarman SS.23
Anto.B SS.24
Gito SS.25
Djoko SS.26
Parijo SS.27
Karim SS.28 Kebumen 33.0507.240889.0037 [0878.8626409]
Wardi SS.29 Jambi 474.4/5.063/pelum/2008
Ahmad SS.30
Sarif SS.31 Pandeglang 36.0119.100581.0001
Sagino SS.32
Sajun (Ajum) SS.33 teluk Naga.Tgr 32.1913.2012000108
Haryono SS.34 Surabaya 35.7818.100866.0000
Yanto.BESI B.01/OCT10 BanjarNegara 33.0405.011071.0004 [0812.18836339]
Yono BESI B.02 Banyumas 33.0219.030174.0002 [0812.19182324]
Ratno B.03 Kebumen 33.0507.040284.0002
DARSO B.04 Banyumas 33.0212.050674.0003 [021.95051681]
NURDIN B.05 Pakuhaji.Tgr 36.0315.240684.0003 [021.90513367]
NEMAN B.06
SYSWADI B.07
ASTO B.08
Suratin B.09
TIDAK AKTIF:…………………………………….
Yanto Bogor 32.0115.030780.0003
Riyono Tegal 180578/0276
HaSAN 453 Tegal 270372/09784 BOGOR 211055
Asnawi K.11 281/160275
Agus K.12 33.2812.120379.7162
Slamet K.14 33.7602.151064.0003
Kasmuri K.15
Nuri K.17 465/070363
Makno K.19
Sorihi K.20
Teguh K.21
Dirman K.22
Hartoyo K.24
Ahmad K.25
Pendi K.26 33.7602.230784.0001
Cahyadi K.27
Nasir K.30
Sopi K.32
Oni K.33
Iwan K.34
Keci K.35
Zami K.36
Karso K.37
Icus K.38
Nursidik K.39
Yusup K.40
Warnoto K.41
Riyono K.42
Hasan K.43
Lihun K.45
Halimi K.46
Rofik 250868/000223
Maksus 27/051273
Rustam 33.2812.120467.0616
STATUS MULAI
JABATAN STD.GAJI INFO +(-)
Tinggal KERJA
Tukang Ahli Rp 85,000 boleh juga
Rp 70,000
Rp 70,000
Tukang Ahli Rp 70,000
Rp 65,000
Rp 65,000
Rp 70,000
Rp 70,000
Mess Dadap Mandor Kayu Rp 85,000
Rp 70,000
Rp 67,500
Rp 67,500
Rp 65,000
Rp 70,000
Rp 70,000
Rp 70,000
Rp 70,000
Mess Dadap Mandor Kayu Rp 85,000
Rp 70,000
Rp 70,000
Rp 67,500
Rp 70,000
Rp 70,000
Mandor Kayu Rp 85,000
Rp 70,000
Rp 70,000
Rp 70,000
Rp 70,000
Rp 65,000
Rp 70,000
Rp 70,000
Rp 70,000
Rp 70,000
Rp 70,000
Rp 65,000
Rp 70,000
Cengkareng Mandor Finish Rp 85,000
Rp 60,000
Rp 58,000
Rp 67,500
Rp 51,000
Rp 62,500
Rp 51,000
Rp 67,500
Rp 67,500
Rp 67,500
Rp 48,000
Rp 67,500
Rp 62,500
Rp 67,500
karangmulya Mandor Finish Rp 90,000
Karangmulya Rp 68,000
sepatan Rp 68,000
Mess Dadap Rp 58,000
Mess Dadap Rp 56,000
Kembangan Rp 56,000
Rp 63,000
Rp 68,000
Rp 51,000
Mess Dadap Rp 51,000
Rp 56,000
Rp 68,000
Rp 63,000
Rp 48,000
Rp 45,000
Rp 48,000
Rp 60,000
Rp 65,000
Rp 48,000
Rp 90,000
Rp 65,000
Rp 60,000
Rp 60,000
Rp 60,000
Rp 71,000
Rp 60,000
Rp 60,000
Rp 45,000
Rp 60,000
Rp 60,000
Rp 60,000
Rp 60,000
Rp 45,000
Rp 60,000
Rp 60,000
Rp 45,000
Rp 55,000
Rp 45,000
Rp 60,000
Tlk.Naga
Mess Dadap MANDOR BESI Rp 90,000
Mess Dadap Rp 65,000
Mess Dadap Rp 62,500
Mess Dadap Rp 65,000
Pakuhaji Rp 62,500
Rp 55,000
Rp 57,500
Rp 55,000
Rp 65,000
PT. IDEA KREATAMA MANDIRI
WORKERCOST_ESTIMATOR
WORKERCOST_ESTIMATOR Digunakan untuk menghitung Ongkos tukang & Mandor
Perhitungan hanya berlaku untuk Mandor Dan Tukang yang bekerja Harian. Besaran Upah dihitung sesuai dengan Rumus. Penginput Data Cukup
Meng Absen Kehadiran Mandor Dan Tukangnya, Kemudian Data dimasukan kedalam Tabel Data. Format Form WORKERCOST_ESTIMATOR Akan
secara Otomatis Menghitung Hasilnya CREATOR:
Sir.Twotech@yahoo.com
ESTIMASI UPAH PEKERJA DILARANG MENGHAPUS ATAU MEMASUKAN KOLOM BARU KEDALAM TABLE DAN HALAMAN APLIKASI
RUMUS UPAH LEMBUR Jam Kerja Normal : 8 jam/Hari
Upah/hari Lmbr.22oo 24.oo 1.oo 2.oo 3.oo 4.oo 5.oo 6.oo 7.oo Estimate 1.Hari 1.00 2.00 3.00
45000 45000 45000 10125.00 23625 37125.00 50625 64125.00 77625 91125.00 45000 100125.00 113625.00 127125.00
48000 48000 48000 10800.00 25200 39600.00 54000 68400.00 82800 97200.00 48000 106800.00 121200.00 135600.00
51000 51000 51000 11475.00 26775 42075.00 57375 72675.00 87975 103275.00 51000 113475.00 128775.00 144075.00
55000 55000 55000 12375.00 28875 45375.00 61875 78375.00 94875 111375.00 55000 122375.00 138875.00 155375.00
56000 56000 56000 12600.00 29400 46200.00 63000 79800.00 96600 113400.00 56000 124600.00 141400.00 158200.00
57500 57500 57500 12937.50 30188 47437.50 64687.5 81937.50 99188 116437.50 57500 127937.50 145187.50 162437.50
58000 58000 58000 13050.00 30450 47850.00 65250 82650.00 100050 117450.00 58000 129050.00 146450.00 163850.00
60000 60000 60000 13500.00 31500 49500.00 67500 85500.00 103500 121500.00 60000 133500.00 151500.00 169500.00
62500 62500 62500 14062.50 32813 51562.50 70312.5 89062.50 107813 126562.50 62500 139062.50 157812.50 176562.50
63000 63000 63000 14175.00 33075 51975.00 70875 89775.00 108675 127575.00 63000 140175.00 159075.00 177975.00
65000 65000 65000 14625.00 34125 53625.00 73125 92625.00 112125 131625.00 65000 144625.00 164125.00 183625.00
67500 67500 67500 15187.50 35438 55687.50 75937.5 96187.50 116438 136687.50 67500 150187.50 170437.50 190687.50
68000 68000 68000 15300.00 35700 56100.00 76500 96900.00 117300 137700.00 68000 151300.00 171700.00 192100.00
70000 70000 70000 15750.00 36750 57750.00 78750 99750.00 120750 141750.00 70000 155750.00 176750.00 197750.00
71000 71000 71000 15975.00 37275 58575.00 79875 101175.00 122475 143775.00 71000 157975.00 179275.00 200575.00
85000 85000 125000 0.00 0 0.00 0 0.00 0 0.00 85000 210000.00 210000.00 210000.00
90000 90000 125000 0.00 0 0.00 0 0.00 0 0.00 90000 215000.00 215000.00 215000.00
95000 95000 125000 0.00 0 0.00 0 0.00 0 0.00 95000 220000.00 220000.00 220000.00
100000 100000 125000 0.00 0 0.00 0 0.00 0 0.00 100000 225000.00 225000.00 225000.00
<<<<<<<ASUMSI Total.Upah. Total.Upah. Total.Upah.
8 8 8 1.80 4.2 6.60 9 11.40 13.8 16.20 JAM KERJA 1.oo 2.oo 3.oo
9 9 9 1.80 4.2 6.60 9 11.40 13.8 16.20
10 10 10 1.80 4.2 6.60 9 11.40 13.8 16.20
11 11 11 1.80 4.2 6.60 9 11.40 13.8 16.20
12 12 12 1.80 4.2 6.60 9 11.40 13.8 16.20
13 13 13 1.80 4.2 6.60 9 11.40 13.8 16.20
14 14 14 1.80 4.2 6.60 9 11.40 13.8 16.20
Mulailah Dengan Memasukan Data Index dengan merubah Data Contoh (Sample),Sesuai data terkini.
Perhitungan Waktu
Jam 22.oo = 8 jam
start Jam 24.oo = 8 jam
3.oo = Upah x 0,15x 5,5 Jam
from here 1.oo = Upah x 0.15x 1,5 Jam
2.oo = Upah x 0,15x 3,5 Jam
INDEX DATA FORM.KALKULASI RANGE 0.00 INDEX DATA TRANSLA
DESEMBER.2011 Periode Laporan
TGL:03/12/11 s/d 09/12/11 Periode Absensi
9-Dec-11 Tgl.Absen
JUMLAH UPAH MGG.KE.2 TEAM NANO Hapus Data Lama
JUMLAH UPAH MGG.KE.2 TEAM ROSHIDIN
JUMLAH UPAH MGG.KE.2 TEAM UDIN
JUMLAH UPAH MGG.KE.2 TEAM TONI
Jml.Upah Anggota Divisi
JUMLAH UPAH MGG.KE.2 TEAM ALEX
JUMLAH UPAH MGG.KE.2 TEAM MASHYM
JUMLAH UPAH MGG.KE.2 TEAM YADHI
JUMLAH UPAH MGG.KE.2 TEAM YANTO
TOTAL UPAH MGG.2.DIV_KAYU SIMPAN DATA (Back_Up)
TOTAL UPAH MGG.2.DIV_FINISHING
Jml.Upah Per.DIVISI
TOTAL UPAH MGG.2.DIV_S/S
TOTAL UPAH MGG.2.DIV_BESI
TOTAL UPAH / MINGGU KE.2 SEMUA DIVISI: Total.Upah Semua Divisi
JAM KERJA NORMAL & LEMBUR
INFORMASI LEMBUR TAMBAHAN
INFORMASI LEMBUR DI LUAR PABRIK
MINGGU.KE : 2
TOTAL UPAH YANG HARUS DIBAYAR
JAM KERJA DIVISI: "NARTO/NANO"
JAM KERJA DIVISI: "ROSHIDIN"
JAM KERJA DIVISI :"UDIN"
JAM KERJA DIVISI: "TONI" JAM KERJA DIVISI
JAM KERJA DIVISI: "ALEX"
JAM KERJA DIVISI: "MASYIM"
JAM KERJA DIVISI: "YADHI"
JAM KERJA DIVISI: "YANTO"
D SAVE_DRIVE (Drive, Lokasi Penyimpanan Data Back_UP)
HRD2011_DEC09 NAMA & NO.FILE (Nama Folder Back_Up Pada Drive Simpan)
DESEMBER.2011 USE THIS SIGN : R 1/2 TO FILL BLANK KOLOM BELOW
DIVISI KERJA : Kayu (K) MANDOR. : Narto.(P.Nano) MINGGU.KE : 2
Sabtu Minggu Senin Selasa Rabu Kamis Jum'at
No.P PROYEK YG
ek
Nama
DITANGANI
8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº
K.01/OCT10 NANO
K.05 Rudi.G
K.06 Sikin
K.07 Ali
K.08 Riki
K.09 Aji
K.10 Maksus
K.11 Tio
0 0
0 0
0 0
0 0
DIVISI KERJA : Kayu (K) MANDOR. : Roshidin MINGGU.KE : 2
No.P PROYEK YG Sabtu Minggu Senin Selasa Rabu Kamis Jum'at
ek
Nama
DITANGANI
8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº
K.02/OCT10Rosidin
K.12 Roni
K.13 ZAINAL
K.14 Sorihi
K.15 Tio.A
K.16 Daryo
K.17 Sahwani
K.18 Wandi
0 Hambali
0 0
0
0
DIVISI KERJA : Kayu (K) MANDOR. : Udin MINGGU.KE : 2
No.P PROYEK YG Sabtu Minggu Senin Selasa Rabu Kamis Jum'at
ek
Nama
DITANGANI
8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº
K.03/OCT10 Udin
K.19 Rudi.K
K.20 Yanto
K.21 Tanali
K.22 Jamroni
0 Slamet
0 0
0 0
0 0
DIVISI KERJA : Kayu (K) MANDOR. :TONI MINGGU.KE : 2
No.P PROYEK YG Sabtu Minggu Senin Selasa Rabu Kamis Jum'at
ek
Nama
DITANGANI
8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº
K.04/OCT10 Toni
Taan
Nursidik
Warnoto
Riyono
Rohman
Joko
Saidi
Tarwo
Kusmianto
Aris
Taroji
Tasripin
0
0
DIVISI KERJA : Finishing (F) MANDOR. : Alekandar.(Alex) MINGGU.KE : 2
No.P PROYEK YG Sabtu Minggu Senin Selasa Rabu Kamis Jum'at
ek
Nama
DITANGANI
8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº
ALEXANDAR
F.24/OCT11
Pahru
Farid
Ujang
Kiwong
Yusup
Muhtadin
Hengki
Pandi
Fazri
Arif
Uce
Komarudin
Solihin
Sahrul
0
munuh
DIVISI KERJA : Finishing (F) MANDOR. : P.Mashym MINGGU.KE : 2
No.P PROYEK YG Sabtu Minggu Senin Selasa Rabu Kamis Jum'at
ek
Nama
DITANGANI
8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº
F.01/OCT10Mashym
Nasir
Komar
ToTon
Alim
Mayar
Ucok
Sunah
Naen
Kenda
JayAdi
Rohim
Ibad
Ijul
Hendi
Saef
Apay
Bisri
Junet
Herdi
DIVISI KERJA : StainlessSteel (SS) MINGGU.KE : 2
PROYEK YG Sabtu Minggu Senin Selasa Rabu Kamis Jum'at
No.P
ek
Nama
DITANGANI
8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº
SS.0
1/OC YADHI
T10
Tarno
Sarijo
Yono
Sarto
Parno
Nanang
Wagimin
Andri
Turno
Sutar
Turijan
Senen
Puri
Suprih
Anto
Apen
Ijan
Wilan
Jio
Naryo
DIVISI KERJA : Las Besi DESEMBER.2011
No.P PROYEK YG Sabtu Minggu Senin Selasa Rabu Kamis Jum'at
ek
Nama
DITANGANI 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº Lmbr. 8ºº-17ºº
B.01/OCT10
Yanto.BESI
Yono BESI
Ratno
DARSO
NURDIN
NEMAN
SYSWADI
ASTO
Suratin
0
0
#N/A
4.00 5.00 6.00 7.00
140625.00 154125.00 167625 181125.00
150000.00 164400.00 178800 193200.00
159375.00 174675.00 189975 205275.00
171875.00 188375.00 204875 221375.00
175000.00 191800.00 208600 225400.00
179687.50 196937.50 214187.5 231437.50
181250.00 198650.00 216050 233450.00
187500.00 205500.00 223500 241500.00
195312.50 214062.50 232812.5 251562.50
196875.00 215775.00 234675 253575.00
203125.00 222625.00 242125 261625.00
210937.50 231187.50 251437.5 271687.50
212500.00 232900.00 253300 273700.00
218750.00 239750.00 260750 281750.00
221875.00 243175.00 264475 285775.00
210000.00 210000.00 210000 210000.00
215000.00 215000.00 215000 215000.00
220000.00 220000.00 220000 220000.00
225000.00 225000.00 225000 225000.00
Total.Upah.4 Total.Upah. Total.Upah. Total.Upah.
.oo 5.oo 6.oo 7.oo
erhitungan Waktu Lembur
4.oo = Upah x 0,15x 7.5 Jam
5.oo = Upah x 0,15x 9,5 Jam
6.oo = Upahx 0,15x11,5 Jam
7.oo = Upahx 0,15x13,5 Jam
DATA TRANSLATE
TGL:03/12/11 s/d 09/12/11 URAIAN.1
CHECK JAM
Jum'at JAM KERJA NORMAL & LEMBUR CHECK
CHECK LEMBUR NORMAL
JAM.1.s/d Std.GAJI
Lmbr. Normal Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo
Lmbr. Lmbr. Lmbr Lmbr. Lmbr. Lmbr.
2.oo 3.oo .4.oo 5.oo 6.oo 7.oo
22.00 24.00 R 1/2 7.oo
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0
TGL:01/10/11 s/d 07/10/11
CHECK JAM
JAM KERJA NORMAL & LEMBUR CHECK
Jum'at CHECK LEMBUR NORMAL
JAM.1.s/d Std.GAJI
Lmbr. Normal Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo
Lmbr. Lmbr. Lmbr Lmbr. Lmbr. Lmbr.
2.oo 3.oo .4.oo 5.oo 6.oo 7.oo
22.00 24.00 R 1/2 7.oo
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TGL:01/10/11 s/d 07/10/11
CHECK JAM
JAM KERJA NORMAL & LEMBUR CHECK
Jum'at CHECK LEMBUR NORMAL
JAM.1.s/d Std.GAJI
Lmbr. Normal Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo
Lmbr. Lmbr. Lmbr Lmbr. Lmbr. Lmbr.
2.oo 3.oo .4.oo 5.oo 6.oo 7.oo
22.00 24.00 R 1/2 7.oo
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TGL:01/10/11 s/d 07/10/11
CHECK JAM
JAM KERJA NORMAL & LEMBUR CHECK
Jum'at CHECK LEMBUR NORMAL
JAM.1.s/d Std.GAJI
Lmbr. Normal Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo
Lmbr. Lmbr. Lmbr Lmbr. Lmbr. Lmbr.
2.oo 3.oo .4.oo 5.oo 6.oo 7.oo
22.00 24.00 R 1/2 7.oo
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TGL:01/10/11 s/d 07/10/11
CHECK JAM
JAM KERJA NORMAL & LEMBUR CHECK
Jum'at CHECK LEMBUR NORMAL
JAM.1.s/d Std.GAJI
Lmbr. Normal Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo
Lmbr. Lmbr. Lmbr Lmbr. Lmbr. Lmbr.
2.oo 3.oo .4.oo 5.oo 6.oo 7.oo
22.00 24.00 R 1/2 7.oo
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TGL:01/10/11 s/d 07/10/11
CHECK JAM
JAM KERJA NORMAL & LEMBUR CHECK
Jum'at CHECK LEMBUR NORMAL
JAM.1.s/d Std.GAJI
Lmbr. Normal Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo
Lmbr. Lmbr. Lmbr Lmbr. Lmbr. Lmbr.
2.oo 3.oo .4.oo 5.oo 6.oo 7.oo
22.00 24.00 R 1/2 7.oo
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TGL:01/10/11 s/d 07/10/11
CHECK JAM
JAM KERJA NORMAL & LEMBUR CHECK
Jum'at CHECK LEMBUR NORMAL
JAM.1.s/d Std.GAJI
Lmbr. Normal
Lmbr
22.oo
Lmbr 24.oo Lmbr.1.oo
Lmbr. Lmbr. Lmbr Lmbr. Lmbr. Lmbr.
2.oo 3.oo .4.oo 5.oo 6.oo 7.oo
22.00 24.00 R 1/2 7.oo
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TGL:01/10/11 s/d 07/10/11
CHECK JAM
JAM KERJA NORMAL & LEMBUR CHECK
Jum'at CHECK LEMBUR NORMAL
JAM.1.s/d Std.GAJI
Lmbr. Normal Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo
Lmbr. Lmbr. Lmbr Lmbr. Lmbr. Lmbr.
2.oo 3.oo .4.oo 5.oo 6.oo 7.oo
22.00 24.00 R 1/2 7.oo
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Buat Laporan Di Lembar Baru
HAPUS DATA LAMA
AIAN.1 INFORMASI LEMBUR DI LUAR PABRIK
DATA LEMBUR.1 DATA LEMBUR.2
DATA LEMBUR.3 DATA LEMBUR.4 DATA LEMBUR.5
GROUP NANO
LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR
(LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR)
3 3.00 5.00 5
DATA LEMBUR.1 DATA LEMBUR.2
DATA LEMBUR.3 DATA LEMBUR.4 DATA LEMBUR.5
GROUP ROSHIDIN
LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR
(LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR)
DATA LEMBUR.1 DATA LEMBUR.2
DATA LEMBUR.3 DATA LEMBUR.4 DATA LEMBUR.5
GROUP UDIN
LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR
(LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR)
DATA LEMBUR.1 DATA LEMBUR.2
DATA LEMBUR.3 DATA LEMBUR.4 DATA LEMBUR.5
GROUP TONI
LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR
(LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR)
DATA LEMBUR.1 DATA LEMBUR.2
DATA LEMBUR.3 DATA LEMBUR.4 DATA LEMBUR.5
GROUP ALEX
LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR
(LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR)
DATA LEMBUR.1 DATA LEMBUR.2
DATA LEMBUR.3 DATA LEMBUR.4 DATA LEMBUR.5
GROUP MASIM
LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR
(LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR)
DATA LEMBUR.1 DATA LEMBUR.2
DATA LEMBUR.3 DATA LEMBUR.4 DATA LEMBUR.5
GROUP YADHI
LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR
(LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR)
DATA LEMBUR.1 DATA LEMBUR.2 DATA LEMBUR.3 DATA LEMBUR.4 DATA LEMBUR.5
GROUP YANTO
LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR
(LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR) (LEMBUR)
PABRIK
JAM KERJA LEMBUR
DATA LEMBUR.5 DATA LEMBUR.6 DATA LEMBUR.7
LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo Lmbr.2.oo Lmbr.3.oo Lmbr.4.oo Lmbr.5.oo Lmbr.6.oo
(LEMBUR) (LEMBUR)
3.00 4.00 6.00 7 7 0 0 3 1 2 1
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
JAM KERJA LEMBUR
DATA LEMBUR.5 DATA LEMBUR.6 DATA LEMBUR.7
LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo Lmbr.2.oo Lmbr.3.oo Lmbr.4.oo Lmbr.5.oo Lmbr.6.oo
(LEMBUR) (LEMBUR)
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
JAM KERJA LEMBUR
DATA LEMBUR.5 DATA LEMBUR.6 DATA LEMBUR.7
LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo Lmbr.2.oo Lmbr.3.oo Lmbr.4.oo Lmbr.5.oo Lmbr.6.oo
(LEMBUR) (LEMBUR)
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
JAM KERJA LEMBUR
DATA LEMBUR.5 DATA LEMBUR.6 DATA LEMBUR.7
LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo Lmbr.2.oo Lmbr.3.oo Lmbr.4.oo Lmbr.5.oo Lmbr.6.oo
(LEMBUR) (LEMBUR)
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
JAM KERJA LEMBUR
DATA LEMBUR.5 DATA LEMBUR.6 DATA LEMBUR.7
LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo Lmbr.2.oo Lmbr.3.oo Lmbr.4.oo Lmbr.5.oo Lmbr.6.oo
(LEMBUR) (LEMBUR)
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
JAM KERJA LEMBUR
DATA LEMBUR.5 DATA LEMBUR.6 DATA LEMBUR.7
LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo Lmbr.2.oo Lmbr.3.oo Lmbr.4.oo Lmbr.5.oo Lmbr.6.oo
(LEMBUR) (LEMBUR)
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
JAM KERJA LEMBUR
DATA LEMBUR.5 DATA LEMBUR.6 DATA LEMBUR.7
LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo Lmbr.2.oo Lmbr.3.oo Lmbr.4.oo Lmbr.5.oo Lmbr.6.oo
(LEMBUR) (LEMBUR)
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
DATA LEMBUR.5 DATA LEMBUR.6 DATA LEMBUR.7 JAM KERJA LEMBUR
LOKASI KERJA LOKASI KERJA
TGL JAM.LBR TGL JAM.LBR TGL JAM.LBR Lmbr.22.oo Lmbr 24.oo Lmbr.1.oo Lmbr.2.oo Lmbr.3.oo Lmbr.4.oo Lmbr.5.oo Lmbr.6.oo
(LEMBUR) (LEMBUR)
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
CHECK LEMBUR
CHECK JAM
Lmbr.7.oo 22.00 24.00
1.oo s/d 7.oo
0 0 0 65.4
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
CHECK LEMBUR
CHECK JAM
Lmbr.7.oo 22.00 24.00
1.oo s/d 7.oo
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
CHECK LEMBUR
CHECK JAM
Lmbr.7.oo 22.00 24.00
1.oo s/d 7.oo
0 0 0 0
0
0 0 0
#VALUE!
0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 #VALUE!
CHECK LEMBUR
CHECK JAM
Lmbr.7.oo 22.00 24.00
1.oo s/d 7.oo
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 #VALUE!
0 0 0 #VALUE!
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
CHECK LEMBUR
CHECK JAM
Lmbr.7.oo 22.00 24.00
1.oo s/d 7.oo
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
CHECK LEMBUR
CHECK JAM
Lmbr.7.oo 22.00 24.00
1.oo s/d 7.oo
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
CHECK LEMBUR
CHECK JAM
Lmbr.7.oo 22.00 24.00
1.oo s/d 7.oo
0 0 0
0
0
0 0 0
0 0 0 #REF!
0 0 0
#REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
0 0 0 #REF!
#REF!
0 0 0
0 0 0 #REF!
CHECK LEMBUR
CHECK JAM
Lmbr.7.oo 22.00 24.00
1.oo s/d 7.oo
0 0 0 #REF!
0 0 0 #REF!
#REF!
0 0 0
0 0 0
#REF!
0 0 0 #REF!
#REF!
0 0 0
0 0 0 0
0 0 0 0
0 0 0 #VALUE!
0 0 0 0
0 0 0 #VALUE!
DESEMBER.2011
DIVISI KERJA : Kayu (K) MANDOR. : NANO MINGGU.KE : 2
Jml Hr. lmbr
Nama Pekerja Mandor Upah / Hari Lmbr 22.oo 1. oo 2.oo 3.oo 4.oo 5.oo 6.oo 7.oo Upah Harian
Kerja 24.oo
NANO Rp 85,000 0 0 0 0 0 0 0 0 0 0 -
Rudi.G Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Sikin Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
NANO
Ali Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Riki Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
Aji Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
Maksus NANO Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Tio Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
JUMLAH UPAH MGG.KE.2 TEAM NANO -
DIVISI KERJA : Kayu (K) MANDOR. : ROSHIDIN MINGGU.KE : 2
Jml Hr. lmbr
Nama Pekerja Mandor Upah / Hari Lmbr 22.oo 1. oo 2.oo 3.oo 4.oo 5.oo 6.oo 7.oo Upah Harian
Kerja 24.oo
Rosidin Rp 85,000 0 0 0 0 0 0 0 0 0 0 -
Roni Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
ZAINAL Rp 67,500 0 0 0 0 0 0 0 0 0 0 -
Sorihi Rp 67,500 0 0 0 0 0 0 0 0 0 0 -
ROSHIDIN
Tio.A Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
Daryo Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Sahwani Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Wandi Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Hambali Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
JUMLAH UPAH MGG.KE.2 TEAM ROSHIDIN -
DIVISI KERJA : Kayu (K) MANDOR. : UDIN MINGGU.KE : 2
Jml Hr. lmbr
Nama Pekerja Mandor Upah / Hari Lmbr 22.oo 1. oo 2.oo 3.oo 4.oo 5.oo 6.oo 7.oo Upah Harian
Kerja 24.oo
Udin Rp 85,000 0 0 0 0 0 0 0 0 0 0 -
Rudi.K Rp 67,500 0 0 0 0 0 0 0 0 0 0 -
Yanto Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Tanali Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Jamroni UDIN Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Slamet Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
JUMLAH UPAH MGG.KE.2 TEAM UDIN -
DIVISI KERJA : Kayu (K) MANDOR. : TONI MINGGU.KE : 2
Jml Hr. lmbr
Nama Pekerja Mandor Upah / Hari Lmbr 22.oo 1. oo 2.oo 3.oo 4.oo 5.oo 6.oo 7.oo Upah Harian
Kerja 24.oo
Toni Rp 85,000 0 0 0 0 0 0 0 0 0 0 -
Taan Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Nursidik Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Warnoto Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Riyono Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Rohman Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
Joko Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Saidi TONI Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Tarwo Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Kusmianto Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Aris Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
Taroji Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
Tasripin Rp 70,000 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
JUMLAH UPAH MGG.KE.2 TEAM TONI -
DIVISI KERJA : Kayu (K) MANDOR. : ALEX MINGGU.KE : 2
Jml Hr. lmbr
Nama Pekerja Mandor Upah / Hari Lmbr 22.oo 1. oo 2.oo 3.oo 4.oo 5.oo 6.oo 7.oo Upah Harian
Kerja 24.oo
ALEXANDAR Rp 85,000 0 0 0 0 0 0 0 0 0 0 -
Pahru Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Farid Rp 58,000 0 0 0 0 0 0 0 0 0 0 -
Ujang Rp 67,500 0 0 0 0 0 0 0 0 0 0 -
Kiwong Rp 51,000 0 0 0 0 0 0 0 0 0 0 -
Yusup Rp 62,500 0 0 0 0 0 0 0 0 0 0 -
Muhtadin Rp 51,000 0 0 0 0 0 0 0 0 0 0 -
Hengki ALEX Rp 67,500 0 0 0 0 0 0 0 0 0 0 -
Pandi Rp 67,500 0 0 0 0 0 0 0 0 0 0 -
Fazri Rp 67,500 0 0 0 0 0 0 0 0 0 0 -
Arif Rp 48,000 0 0 0 0 0 0 0 0 0 0 -
Uce Rp 67,500 0 0 0 0 0 0 0 0 0 0 -
Komarudin Rp 62,500 0 0 0 0 0 0 0 0 0 0 -
Solihin Rp 67,500 0 0 0 0 0 0 0 0 0 0 -
Sahrul Rp - 0 0 0 0 0 0 0 0 0 0 -
JUMLAH UPAH MGG.KE.2 TEAM ALEX -
DIVISI KERJA : Kayu (K) MANDOR. : MASYIM MINGGU.KE : 2
Jml Hr. lmbr
Nama Pekerja Mandor Upah / Hari Lmbr 22.oo 1. oo 2.oo 3.oo 4.oo 5.oo 6.oo 7.oo Upah Harian
Kerja 24.oo
Mashym Rp 90,000 0 0 0 0 0 0 0 0 0 0 -
Nasir Rp 68,000 0 0 0 0 0 0 0 0 0 0 -
Komar Rp 68,000 0 0 0 0 0 0 0 0 0 0 -
ToTon Rp 58,000 0 0 0 0 0 0 0 0 0 0 -
Alim Rp 56,000 0 0 0 0 0 0 0 0 0 0 -
Mayar Rp 56,000 0 0 0 0 0 0 0 0 0 0 -
Ucok Rp 63,000 0 0 0 0 0 0 0 0 0 0 -
Sunah Rp 68,000 0 0 0 0 0 0 0 0 0 0 -
MASHYM
Naen Rp 51,000 0 0 0 0 0 0 0 0 0 0 -
Kenda Rp 51,000 0 0 0 0 0 0 0 0 0 0 -
JayAdi Rp 56,000 0 0 0 0 0 0 0 0 0 0 -
Rohim Rp 68,000 0 0 0 0 0 0 0 0 0 0 -
Ibad Rp 63,000 0 0 0 0 0 0 0 0 0 0 -
Ijul Rp 48,000 0 0 0 0 0 0 0 0 0 0 -
Hendi Rp 45,000 0 0 0 0 0 0 0 0 0 0 -
Saef Rp 48,000 0 0 0 0 0 0 0 0 0 0 -
Apay Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Bisri Rp - 0 0 0 0 0 0 0 0 0 0 -
Junet Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
Herdi Rp 48,000 0 0 0 0 0 0 0 0 0 0 -
JUMLAH UPAH MGG.KE.2 TEAM MASHYM -
DIVISI KERJA : Kayu (K) MANDOR. : YADHI MINGGU.KE : 2
Jml Hr. lmbr
Nama Pekerja Mandor Upah / Hari Lmbr 22.oo 1. oo 2.oo 3.oo 4.oo 5.oo 6.oo 7.oo Upah Harian
Kerja 24.oo
YADHI Rp 90,000 0 0 0 0 0 0 0 0 0 0 -
Tarno Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
Sarijo Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Yono Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Sarto Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Parno Rp 71,000 0 0 0 0 0 0 0 0 0 0 -
Nanang Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Wagimin Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Andri Rp 45,000 0 0 0 0 0 0 0 0 0 0 -
Turno Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Sutar YADHI Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
YADHI
Turijan Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Senen Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Puri Rp 45,000 0 0 0 0 0 0 0 0 0 0 -
Suprih Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Anto Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Apen Rp 45,000 0 0 0 0 0 0 0 0 0 0 -
Ijan Rp 55,000 0 0 0 0 0 0 0 0 0 0 -
Wilan Rp 45,000 0 0 0 0 0 0 0 0 0 0 -
Jio Rp 60,000 0 0 0 0 0 0 0 0 0 0 -
Naryo Rp - 0 0 0 0 0 0 0 0 0 0 -
JUMLAH UPAH MGG.KE.2 TEAM YADHI -
DIVISI KERJA : Kayu (K) MANDOR. : YANTO MINGGU.KE : 2
Jml Hr. lmbr
Nama Pekerja Mandor Upah / Hari Lmbr 22.oo 1. oo 2.oo 3.oo 4.oo 5.oo 6.oo 7.oo Upah Harian
Kerja 24.oo
Yanto.BESI Rp 90,000 0 0 0 0 0 0 0 0 0 0 -
Yono BESI Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
Ratno Rp 62,500 0 0 0 0 0 0 0 0 0 0 -
DARSO Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
NURDIN Rp 62,500 0 0 0 0 0 0 0 0 0 0 -
NEMAN Rp 55,000 0 0 0 0 0 0 0 0 0 0 -
YANTO
SYSWADI Rp 57,500 0 0 0 0 0 0 0 0 0 0 -
ASTO Rp 55,000 0 0 0 0 0 0 0 0 0 0 -
Suratin Rp 65,000 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
0 Rp - 0 0 0 0 0 0 0 0 0 0 -
JUMLAH UPAH MGG.KE.2 TEAM YANTO -
TOTAL UPAH / MINGGU KE.2 SEMUA DIVISI: -
TGL:03/12/11 s/d 09/12/11 URAIAN.1 : DESEMBER.2011 DIVISI KAYU : NANO
Rp.Lmbr Lmbr lmbr
Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah Nama Pekerja Lokasi Lembur Upah / Hari 1. oo
22.oo 22.oo 24.oo
- 0 0 -
- 0 0 -
- 0 0 -
- 0 0 -
- 0 0 -
- 0 0 -
- 0 0 -
- 0 0 -
- 0 0 -
- 0 0 -
- 0 0 -
- 0 0 -
- - - - #REF!
TOTAL UPAH MGG.2.DIV_KAYU
TGL:03/12/11 s/d 09/12/11 URAIAN.1 : 0 DIVISI KAYU : NANO
Rp.Lmbr Lmbr lmbr
Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah Nama Pekerja Lokasi Lembur Upah / Hari 1. oo
22.oo 22.oo 24.oo
- - 0 -
- - 0 -
- - 0 -
- - 0 -
- - 0 -
- - 0 -
- - 0 -
- - 0 -
- - 0 -
- - 0 -
- - 0 -
- - 0 -
- - - - #REF!
TGL:03/12/11 s/d 09/12/11 URAIAN.1 : DIVISI KERJA DIVISI KAYU : NANO
Rp.Lmbr Lmbr lmbr
Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah Nama Pekerja Lokasi Lembur Upah / Hari 1. oo
22.oo 22.oo 24.oo
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - - #REF!
TGL:03/12/11 s/d 09/12/11 URAIAN.1 : 0 DIVISI KAYU : NANO
Rp.Lmbr Lmbr lmbr
-
Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah Nama Pekerja Lokasi Lembur Upah / Hari 1. oo
22.oo 22.oo 24.oo
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - - - #REF!
TGL:03/12/11 s/d 09/12/11 URAIAN.1 : 0 DIVISI KAYU : NANO
Rp.Lmbr Lmbr lmbr
Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah Nama Pekerja Lokasi Lembur Upah / Hari 1. oo
22.oo 22.oo 24.oo
- - - -
- - - -
TOTAL UPAH MGG.2.DIV_FINISHING
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - - #REF!
TGL:03/12/11 s/d 09/12/11 URAIAN.1 : DIVISI KERJA DIVISI KAYU : NANO
TOTAL UPA
Rp.Lmbr Lmbr lmbr
Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah Nama Pekerja Lokasi Lembur Upah / Hari 1. oo
22.oo 22.oo 24.oo
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
-
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - - #REF!
TGL:03/12/11 s/d 09/12/11 URAIAN.1 : DIVISI KERJA DIVISI KAYU : NANO
Rp.Lmbr Lmbr lmbr
Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah Nama Pekerja Lokasi Lembur Upah / Hari 1. oo
22.oo 22.oo 24.oo
TOTAL UPAH MGG.2.DIV_S/S
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - - #REF!
TGL:03/12/11 s/d 09/12/11 URAIAN.1 : DIVISI KERJA DIVISI KAYU : NANO
TOTAL UPAH MGG.2.DIV_BESI
Rp.Lmbr Lmbr lmbr
Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah Nama Pekerja Lokasi Lembur Upah / Hari 1. oo
22.oo 22.oo 24.oo
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - - #REF!
- - - -
JUMLAH UPAH MGG.KE.2 TEAM UDIN
Rp.Lmbr Rp.Lmbr. Lmbr Total Upah
2.oo 3.oo 4.oo 5.oo 6.oo
22.oo 24.oo 1.oo-7.oo Lembur
TOTAL UPAH YANG HARUS DIBAYAR
Rp.Lmbr Rp.Lmbr. Lmbr Total Upah
2.oo 3.oo 4.oo 5.oo 6.oo
22.oo 24.oo 1.oo-7.oo Lembur
0
Rp.Lmbr Rp.Lmbr. Lmbr Total Upah
2.oo 3.oo 4.oo 5.oo 6.oo
22.oo 24.oo 1.oo-7.oo Lembur
0
Rp.Lmbr Rp.Lmbr. Lmbr Total Upah
2.oo 3.oo 4.oo 5.oo 6.oo
22.oo 24.oo 1.oo-7.oo Lembur
0
Rp.Lmbr Rp.Lmbr. Lmbr Total Upah
2.oo 3.oo 4.oo 5.oo 6.oo
22.oo 24.oo 1.oo-7.oo Lembur
0
Rp.Lmbr Rp.Lmbr. Lmbr Total Upah
2.oo 3.oo 4.oo 5.oo 6.oo
22.oo 24.oo 1.oo-7.oo Lembur
#REF!
Rp.Lmbr Rp.Lmbr. Lmbr Total Upah
2.oo 3.oo 4.oo 5.oo 6.oo
22.oo 24.oo 1.oo-7.oo Lembur
0
Rp.Lmbr Rp.Lmbr. Lmbr Total Upah
2.oo 3.oo 4.oo 5.oo 6.oo
22.oo 24.oo 1.oo-7.oo Lembur
BUKTI KALKULASI UPAH MINGGUAN
RINCIAN KALKULASI UPAH (Judul Laporan )
DIVISI KERJA : Kayu (K) MINGGU.KE : 2 TGL:03/12/11 s/d 09/12/11 DIBAYAR
Rp.Lmbr Rp.Lmbr.24.o Lmbr 1.oo-
-
Nama Pekerja Mandor Upah / Hari Upah Harian Total Upah
22.oo o 7.oo
NANO 85000 - - - - -
Rudi.G 70000 - - - - -
Sikin 70000 - - - - -
Ali 70000 - - - - -
NANO
Riki 65000 - - - - -
Aji 65000 - - - - -
Maksus 70000 - - - - -
Tio 70000 - - - - -
0 0 - - - - -
0 0 - - - - -
0 0 - - - - -
0 0 - - - - -
TOTAL RINCIAN UPAH TUKANG >>>>>> - - - - -
DATA KEHADIRAN & LEMBUR
JML. KERJA LEMBUR. LEMBUR. LEMBUR TOTAL JAM
Nama Pekerja PROYEK
TGL. ABSEN NORMAL 22.oo 24.oo 1.oo-7.oo KERJA Keterangan
0 0 0 0 0 0
NANO
Rudi.G 0 0 0 0 0 0 Lmb.Jam6.oo x 1
Sikin 0 0 0 0 0 0 Lmb.Jam6.oo x 3
Ali 0 0 0 0 0 0
Riki 0 0 0 0 0 0 Lmb.Jam6.oo x 4
40886
Aji 0 0 0 0 0 0
Maksus 0 0 0 0 0 0 Lmb.Jam6.oo x 4
Tio 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
TOTAL JAM ABSEN TEAM NANO >>>>> 0 0 0 0 0 -
RATA2 BIAYA/JAM (Average Cost Per Hour) : #DIV/0!
CATATAN : MANDOR ADMIN FINANCE
DESEMBER.2011
Tgl. Tgl. Tgl.
SIMPAN DATA (Back_Up) No.Laporan : D Save_Drive : D
INFORMASI LEMBUR DI LUAR PABRIK
Rp.Lmbr.24.o Lmbr 1.oo- Lembur sdh Lembur Belum
Nama Pekerja Lokasi Lembur Upah / Hari Rp.Lmbr 22.oo Total Upah
o 7.oo Dibayar Dibayar
0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
RUMUS UPAH LEMBUR
Upah/hari Lmbr.22oo 24.oo 1.oo 2.oo 3.oo
45000 45000 45000 10125 23625 37125
48000 48000 48000 10800 25200 39600
51000 51000 51000 11475 26775 42075
56000 56000 56000 12600 29400 46200
57500 57500 57500 12937.5 30187.5 47437.5
58000 58000 58000 13050 30450 47850
60000 60000 60000 13500 31500 49500
62500 62500 62500 14062.5 32812.5 51562.5
63000 63000 63000 14175 33075 51975
65000 65000 65000 14625 34125 53625
67500 67500 67500 15187.5 35437.5 55687.5
68000 68000 68000 15300 35700 56100
70000 70000 70000 15750 36750 57750
71000 71000 71000 15975 37275 58575
85000 85000 125000 0 0 0
90000 90000 125000 0 0 0
95000 95000 95000 21375 49875 78375
100000 100000 100000 22500 52500 82500
8 8 8 1.8 4.2 6.6
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
RUMUS UPAH LEMBUR Jam Kerja Normal : 8 jam/Hari
4.oo 5.oo 6.oo 7.oo Keterangan
50625 64125 77625 91125
54000 68400 82800 97200 Perhitungan Waktu Lembur
57375 72675 87975 103275
63000 79800 96600 113400 Jam 22.oo = 8 jam
64687.5 81937.5 99187.5 116437.5 Jam 24.oo = 16 jam
65250 82650 100050 117450 1.oo = Upah x 0.15x 1,5 Jam
67500 85500 103500 121500 2.oo = Upah x 0,15x 3,5 Jam
70312.5 89062.5 107812.5 126562.5 3.oo = Upah x 0,15x 5,5 Jam
70875 89775 108675 127575
73125 92625 112125 131625 4.oo = Upah x 0,15x 7.5 Jam
75937.5 96187.5 116437.5 136687.5 5.oo = Upah x 0,15x 9,5 Jam
76500 96900 117300 137700
78750 99750 120750 141750
79875 101175 122475 143775
0 0 0 0 6.oo = Upahx 0,15x11,5 Jam
0 0 0 0 7.oo = Upahx 0,15x13,5 Jam
106875 135375 163875 192375
112500 142500 172500 202500
9 11.4 13.8 16.2 <<<<<<<ASUMSI JAM KERJA
BUKTI KALKULASI UPAH
MINGGUAN
RINCIAN KALKULASI UPAH
DIVISI KERJA : Kayu (K) MINGGU.KE : 2 TGL:03/12/11 s/d 09/12/11 DIBAYAR
-
Nama Pekerja Mandor Upah / Hari Upah Harian Rp.Lmbr 22.oo Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah
Rosidin Rp 85,000 Rp - Rp - Rp - Rp - -
Roni Rp 70,000 Rp - Rp - Rp - Rp - -
ZAINAL Rp 67,500 Rp - Rp - Rp - Rp - -
Sorihi Rp 67,500 Rp - Rp - Rp - Rp - -
ROSHIDIN
Tio.A Rp 65,000 Rp - Rp - Rp - Rp - -
Daryo Rp 70,000 Rp - Rp - Rp - Rp - -
Sahwani Rp 70,000 Rp - Rp - Rp - Rp - -
Wandi Rp 70,000 Rp - Rp - Rp - Rp - -
Hambali Rp 70,000 Rp - Rp - Rp - Rp - -
0 Rp - Rp - Rp - Rp - Rp - -
0 Rp - Rp - Rp - Rp - Rp - -
0 Rp - Rp - Rp - Rp - Rp - -
TOTAL RINCIAN UPAH TUKANG >>>>>> Rp - Rp - Rp - Rp - -
DATA KEHADIRAN & LEMBUR
JAM KERJA LEMBUR
Nama Pekerja PROYEK
PERIODE ABSEN NORMAL LEMBUR. 22.oo LEMBUR. 24.oo 1.oo-7.oo TOTAL JAM KERJA Keterangan
Rosidin 0 0 0 0 0 0 Lmb.Jam6.oo x 4
Roni 0 0 0 0 0 0
ZAINAL 0 0 0 0 0 0
Sorihi 0 0 0 0 0 0
Tio.A 0 0 0 0 0 0
40886
Daryo 0 0 0 0 0 0 Lmb.Jam6.oo x 3
Sahwani 0 0 0 0 0 0
Wandi 0 0 0 0 0 0
Hambali 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
TOTAL JAM ABSEN TEAM ROSHIDIN >>>>>> 0 0 0 0 0 -
RATA2 BIAYA/JAM (Average Cost Per Hour) : #DIV/0!
CATATAN : MANDOR ADMIN FINANCE
DESEMBER.2011
Tgl. Tgl. Tgl.
INFORMASI LEMBUR DI LUAR PABRIK
Lembur sdh Lembur Belum
Nama Pekerja Lokasi Lembur Upah / Hari Rp.Lmbr 22.oo Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah
Dibayar Dibayar
RUMUS UPAH LEMBUR
Upah/hari Lmbr.22oo 24.oo 1.oo 2.oo 3.oo 4.oo 5.oo
45000 45000 45000 10125 23625 37125 50625 64125
48000 48000 48000 10800 25200 39600 54000 68400
51000 51000 51000 11475 26775 42075 57375 72675
56000 56000 56000 12600 29400 46200 63000 79800
57500 57500 57500 12937.5 30187.5 47437.5 64687.5 81937.5
58000 58000 58000 13050 30450 47850 65250 82650
60000 60000 60000 13500 31500 49500 67500 85500
62500 62500 62500 14062.5 32812.5 51562.5 70312.5 89062.5
63000 63000 63000 14175 33075 51975 70875 89775
65000 65000 65000 14625 34125 53625 73125 92625
67500 67500 67500 15187.5 35437.5 55687.5 75937.5 96187.5
68000 68000 68000 15300 35700 56100 76500 96900
70000 70000 70000 15750 36750 57750 78750 99750
71000 71000 71000 15975 37275 58575 79875 101175
85000 85000 125000 0 0 0 0 0
90000 90000 125000 0 0 0 0 0
95000 95000 95000 21375 49875 78375 106875 135375
100000 100000 100000 22500 52500 82500 112500 142500
8 8 8 1.8 4.2 6.6 9 11.4
H LEMBUR Jam Kerja Normal : 8 jam/Hari
6.oo 7.oo Keterangan
77625 91125
82800 97200 Perhitungan Waktu Lembur
87975 103275
96600 113400 Jam 22.oo = 8 jam
99187.5 116437.5 Jam 24.oo = 16 jam
100050 117450 1.oo = Upah x 0.15x 1,5 Jam
103500 121500 2.oo = Upah x 0,15x 3,5 Jam
107812.5 126562.5 3.oo = Upah x 0,15x 5,5 Jam
108675 127575
112125 131625 4.oo = Upah x 0,15x 7.5 Jam
116437.5 136687.5 5.oo = Upah x 0,15x 9,5 Jam
117300 137700
120750 141750
122475 143775
0 0 6.oo = Upahx 0,15x11,5 Jam
0 0 7.oo = Upahx 0,15x13,5 Jam
163875 192375
172500 202500
13.8 16.2 <<<<<<<ASUMSI JAM KERJA
BUKTI KALKULASI UPAH
MINGGUAN
RINCIAN KALKULASI UPAH
DIVISI KERJA : Kayu (K) MINGGU.KE : 2 TGL:03/12/11 s/d 09/12/11 DIBAYAR
Rp.Lmbr Rp.Lmbr.24.o Lmbr 1.oo-
-
Nama Pekerja Mandor Upah / Hari Upah Harian Total Upah
22.oo o 7.oo
Udin Rp 85,000 Rp - - - - Rp -
Rudi.K Rp 67,500 Rp - - - - Rp -
Yanto Rp 70,000 Rp - - - - Rp -
Tanali Rp 70,000 Rp - - - - Rp -
UDIN
Jamroni Rp 70,000 Rp - - - - Rp -
Slamet Rp 70,000 Rp - - - - Rp -
0 Rp - Rp - - - - Rp -
0 Rp - Rp - - - - Rp -
Rp
0 Rp - Rp - - - - Rp -
TOTAL RINCIAN UPAH TUKANG >>>>>> - - - - -
DATA KEHADIRAN & LEMBUR
JAM KERJA LEMBUR. LEMBUR. LEMBUR TOTAL JAM
Nama Pekerja PROYEK
PERIODE ABSEN NORMAL 22.oo 24.oo 1.oo-7.oo KERJA Keterangan
Udin 0 0 0 0 - -
Rudi.K 0 0 0 0 - -
Yanto 0 0 0 0 - -
Tanali 0 0 0 0 - -
6
Jamroni 0 0 0 0 - -
88
40
Slamet 0 0 0 0 - -
0 0 0 0 0 - -
0 0 0 0 0 - -
0 0 0 0 0 - -
TOTAL JAM ABSEN TEAM UDIN >>>>>> 0 0 0 0 0 -
RATA2 BIAYA/JAM (Average Cost Per Hour) : #DIV/0!
CATATAN : MANDOR ADMIN FINANCE
DESEMBER.2011
Tgl. Tgl. Tgl.
INFORMASI LEMBUR DI LUAR PABRIK
Rp.Lmbr.24.o Lmbr 1.oo- Lembur sdh Lembur Belum
Nama Pekerja Lokasi Lembur Upah / Hari Rp.Lmbr 22.oo Total Upah
o 7.oo Dibayar Dibayar
BUKTI KALKULASI UPAH
MINGGUAN
RINCIAN KALKULASI UPAH
DIVISI KERJA : Kayu (K) MINGGU.KE : 2 TGL:03/12/11 s/d 09/12/11 DIBAYAR
Upah
Nama Pekerja Mandor Upah / Hari Rp.Lmbr 22.oo Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah
-
Mingguan
Toni Rp 85,000 Rp - - - - -
Taan Rp 70,000 Rp - - - - -
Nursidik Rp 70,000 Rp - - - - -
Warnoto Rp 70,000 Rp - - - - -
Riyono Rp 70,000 Rp - - - - -
Rohman Rp 65,000 Rp - - - - -
Joko Rp 70,000 Rp - - - - -
Saidi TONI Rp 70,000 Rp - - - - -
Tarwo Rp 70,000 Rp - - - - -
Kusmianto Rp 70,000 Rp - - - - -
Aris Rp 70,000 Rp - - - - -
Taroji Rp 65,000 Rp - - - - -
Tasripin Rp 70,000 Rp - - - - -
0 Rp - Rp - - - - -
0
Rp
Rp - Rp - - - - -
TOTAL RINCIAN UPAH TUKANG >>>>>> Rp - Rp - Rp - Rp - Rp -
DATA KEHADIRAN & LEMBUR
PERIODE JAM KERJA LEMBUR. LEMBUR 1.oo-
Nama Pekerja PROYEK
ABSEN NORMAL LEMBUR. 22.oo 24.oo 7.oo TOTAL JAM KERJA Keterangan
Toni 0 0 0 0 0 0
Taan 0 0 0 0 0 0
Nursidik 0 0 0 0 0 0
Warnoto 0 0 0 0 0 0
Riyono 0 0 0 0 0 0
Rohman 0 0 0 0 0 0
40886
Joko 0 0 0 0 0 0
Saidi 0 0 0 0 0 0
Tarwo 0 0 0 0 0 0
Kusmianto 0 0 0 0 0 0
Aris 0 0 0 0 0 0
Taroji 0 0 0 0 0 0
Tasripin 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
TOTAL JAM ABSEN TEAM UDIN >>>>>> - - - - -
-
RATA2 BIAYA/JAM (Average Cost Per Hour) : #DIV/0!
CATATAN : MANDOR ADMIN FINANCE
DESEMBER.2011
Tgl. Tgl. Tgl.
INFORMASI LEMBUR DI LUAR PABRIK
Lmbr 1.oo- Lembur sdh Lembur Belum
Nama Pekerja Lokasi Lembur Upah / Hari Rp.Lmbr 22.oo Rp.Lmbr.24.oo Total Upah
7.oo Dibayar Dibayar
BUKTI KALKULASI UPAH
MINGGUAN
RINCIAN KALKULASI UPAH
DIVISI KERJA : Kayu (K) MINGGU.KE : 2 TGL:03/12/11 s/d 09/12/11 DIBAYAR
Lmbr 1.oo-
-
Nama Pekerja Mandor Upah / Hari Upah Mingguan Rp.Lmbr 22.oo Rp.Lmbr.24.oo Total Upah
7.oo
ALEXANDAR Rp 85,000 Rp - Rp - Rp - Rp - Rp -
Pahru Rp 60,000 Rp - Rp - Rp - Rp - Rp -
Farid Rp 58,000 Rp - Rp - Rp - Rp - Rp -
Ujang Rp 67,500 Rp - Rp - Rp - Rp - Rp -
Kiwong Rp 51,000 Rp - Rp - Rp - Rp - Rp -
Yusup Rp 62,500 Rp - Rp - Rp - Rp - Rp -
ALEX
Muhtadin Rp 51,000 Rp - Rp - Rp - Rp - Rp -
Hengki Rp 67,500 Rp - Rp - Rp - Rp - Rp -
Pandi Rp 67,500 Rp - Rp - Rp - Rp - Rp -
Fazri Rp 67,500 Rp - Rp - Rp - Rp - Rp -
Arif Rp 48,000 Rp - Rp - Rp - Rp - Rp -
Uce Rp 67,500 Rp - Rp - Rp - Rp - Rp -
Komarudin Rp 62,500 Rp - Rp - Rp - Rp - Rp -
Solihin Rp 67,500 Rp - Rp - Rp - Rp - Rp -
Rp
Sahrul Rp - Rp - Rp - Rp - Rp - Rp -
TOTAL RINCIAN UPAH TUKANG >>>>>> Rp - Rp - Rp - Rp - -
DATA KEHADIRAN & LEMBUR
JAM KERJA LEMBUR. LEMBUR TOTAL JAM
Nama Pekerja PROYEK
PERIODE ABSEN NORMAL LEMBUR. 22.oo 24.oo 1.oo-7.oo KERJA Keterangan
ALEXANDAR 0 0 0 0 0 0
Pahru 0 0 0 0 0 0
Farid 0 0 0 0 0 0
Ujang 0 0 0 0 0 0
Kiwong 0 0 0 0 0 0
Yusup 0 0 0 0 0 0
40886
Muhtadin 0 0 0 0 0 0
Hengki 0 0 0 0 0 0
Pandi 0 0 0 0 0 0
Fazri 0 0 0 0 0 0
Arif 0 0 0 0 0 0
Uce 0 0 0 0 0 0
Komarudin 0 0 0 0 0 0
Solihin 0 0 0 0 0 0
Sahrul 0 0 0 0 0 0
TOTAL JAM ABSEN TEAM ROSHIDIN >>>>>> - - - - -
-
RATA2 BIAYA/JAM (Average Cost Per Hour) : #DIV/0!
CATATAN : MANDOR ADMIN FINANCE
DESEMBER.2011
Tgl. Tgl. Tgl.
INFORMASI LEMBUR DI LUAR PABRIK
Lembur sdh Lembur Belum
Nama Pekerja Lokasi Lembur Upah / Hari Rp.Lmbr 22.oo Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah
Dibayar Dibayar
BUKTI KALKULASI UPAH MINGGUAN
RINCIAN KALKULASI UPAH
DIVISI KERJA : Kayu (K) MINGGU.KE : 2 TGL:03/12/11 s/d 09/12/11 DIBAYAR
Nama Pekerja Mandor Upah / Hari Upah Mingguan Rp.Lmbr 22.oo Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah
-
Mashym Rp 90,000 Rp - Rp - Rp - Rp - Rp -
Nasir Rp 68,000 Rp - Rp - Rp - Rp - Rp -
Komar Rp 68,000 Rp - Rp - Rp - Rp - Rp -
ToTon Rp 58,000 Rp - Rp - Rp - Rp - Rp -
Alim Rp 56,000 Rp - Rp - Rp - Rp - Rp -
Mayar Rp 56,000 Rp - Rp - Rp - Rp - Rp -
Ucok Rp 63,000 Rp - Rp - Rp - Rp - Rp -
Sunah Rp 68,000 Rp - Rp - Rp - Rp - Rp -
masyim
Naen Rp 51,000 Rp - Rp - Rp - Rp - Rp -
Kenda Rp 51,000 Rp - Rp - Rp - Rp - Rp -
JayAdi Rp 56,000 Rp - Rp - Rp - Rp - Rp -
Rohim Rp 68,000 Rp - Rp - Rp - Rp - Rp -
Ibad Rp 63,000 Rp - Rp - Rp - Rp - Rp -
Ijul Rp 48,000 Rp - Rp - Rp - Rp - Rp -
Hendi Rp 45,000 Rp - Rp - Rp - Rp - Rp -
Saef Rp 48,000 Rp - Rp - Rp - Rp - Rp -
Apay Rp 60,000 Rp - Rp - Rp - Rp - Rp -
Bisri Rp - Rp - Rp - Rp - Rp - Rp -
Junet Rp 65,000 Rp - Rp - Rp - Rp - Rp -
Rp
Herdi Rp 48,000 Rp - Rp - Rp - Rp - Rp -
TOTAL RINCIAN UPAH TUKANG >>>>>> Rp - Rp - Rp - Rp - Rp -
DATA KEHADIRAN & LEMBUR
PERIODE JAM KERJA LEMBUR. LEMBUR
Nama Pekerja PROYEK
ABSEN NORMAL LEMBUR. 22.oo 24.oo 1.oo-7.oo TOTAL JAM KERJA Keterangan
Mashym 0 0 0 0 0 0
Nasir 0 0 0 0 0 0
Komar 0 0 0 0 0 0
ToTon 0 0 0 0 0 0
Alim 0 0 0 0 0 0
Mayar 0 0 0 0 0 0
Ucok 0 0 0 0 0 0
6 OKTOBER 2011
Sunah 0 0 0 0 0 0
Naen 0 0 0 0 0 0
Kenda 0 0 0 0 0 0
JayAdi 0 0 0 0 0 0
Rohim 0 0 0 0 0 0
Ibad 0 0 0 0 0 0
Ijul 0 0 0 0 0 0
Hendi 0 0 0 0 0 0
Saef 0 0 0 0 0 0
Apay 0 0 0 0 0 0
Bisri 0 0 0 0 0 0
Junet 0 0 0 0 0 0
Herdi 0 0 0 0 0 0
TOTAL JAM ABSEN TEAM ROSHIDIN >>>>>> - - - - -
-
RATA2 BIAYA/JAM (Average Cost Per Hour) : #DIV/0!
CATATAN : MANDOR ADMIN FINANCE
DESEMBER.2011
Tgl. Tgl. Tgl.
INFORMASI LEMBUR DI LUAR PABRIK
Lembur sdh Lembur Belum
Nama Pekerja Lokasi Lembur Upah / Hari Rp.Lmbr 22.oo Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah
Dibayar Dibayar
BUKTI KALKULASI UP
MINGGUAN
RINCIAN KALKULASI UPAH
DIVISI KERJA : Kayu (K) MINGGU.KE : 2 TGL:03/12/11 s/d 09/12/11
Upah Rp.Lmbr Rp.Lmbr.24.o
Nama Pekerja Mandor Upah / Hari Lmbr 1.oo-7.oo
Mingguan 22.oo o
YADHI Rp 90,000 Rp - - - -
Tarno Rp 65,000 Rp - - - -
Sarijo Rp 60,000 Rp - - - -
Yono Rp 60,000 Rp - - - -
Sarto Rp 60,000 Rp - - - -
Parno Rp 71,000 Rp - - - -
Nanang Rp 60,000 Rp - - - -
Wagimin Rp 60,000 Rp - - - -
Andri Rp 45,000 Rp - - - -
YADHI
Turno Rp 60,000 Rp - - - -
Sutar Rp 60,000 Rp - - - -
Turijan Rp 60,000 Rp - - - -
Senen Rp 60,000 Rp - - - -
Puri Rp 45,000 Rp - - - -
Suprih Rp 60,000 Rp - - - -
Anto Rp 60,000 Rp - - - -
Apen Rp 45,000 Rp - - - -
Ijan Rp 55,000 Rp - - - -
Wilan Rp 45,000 Rp - - - -
Jio Rp 60,000 Rp - - - -
Naryo Rp - Rp - - - -
TOTAL RINCIAN UPAH TUKANG >>>>>> - - - -
DATA KEHADIRAN & LEMBUR
PERIODE JAM KERJA LEMBUR. LEMBUR. LEMBUR 1.oo-
Nama Pekerja PROYEK
ABSEN NORMAL 22.oo 24.oo 7.oo
YADHI 0 - - - -
Tarno 0 - - - -
Sarijo 0 - - - -
Yono 0 - - - -
Sarto 0 - - - -
Parno 0 - - - -
Nanang 0 - - - -
Wagimin 0 - - - -
Andri 0 - - - -
40886
Turno 0 - - - -
Sutar 0 - - - -
Turijan 0 - - - -
Senen 0 - - - -
Puri 0 - - - -
Suprih 0 - - - -
Anto 0 - - - -
Apen 0 - - - -
Ijan 0 - - - -
Wilan 0 - - - -
Jio 0 - - - -
Naryo 0 - - - -
TOTAL JAM ABSEN TEAM ROSHIDIN >>>>>> - - - -
RATA2 BIAYA/JAM (Average Cost Per Hour) :
CATATAN : MANDOR
DESEMBER.2011
Tgl.
INFORMASI LEMBUR DI LUAR PABRIK
Rp.Lmbr Rp.Lmbr.24.o Lmbr 1.oo-
Nama Pekerja Lokasi Lembur Upah / Hari Total Upah
22.oo o 7.oo
BUKTI KALKULASI UPAH
MINGGUAN
d 09/12/11 DIBAYAR
Total Upah
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Rp
-
-
TOTAL JAM KERJA Keterangan
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
#DIV/0!
ADMIN FINANCE
Tgl. Tgl.
K
Lembur sdh Lembur Belum
Dibayar Dibayar
BUKTI KALKULASI UPAH
MINGGUAN
RINCIAN KALKULASI UPAH
DIVISI KERJA : Kayu (K) MINGGU.KE : 2 TGL:03/12/11 s/d 09/12/11 DIBAYAR
-
Nama Pekerja Mandor Upah / Hari Upah Mingguan Rp.Lmbr 22.oo Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah
Yanto.BESI Rp 90,000 Rp - - - - Rp -
Yono BESI Rp 65,000 Rp - - - - Rp -
Ratno Rp 62,500 Rp - - - - Rp -
DARSO Rp 65,000 Rp - - - - Rp -
YANTHO
NURDIN Rp 62,500 Rp - - - - Rp -
NEMAN Rp 55,000 Rp - - - - Rp -
SYSWADI Rp 57,500 Rp - - - - Rp -
ASTO Rp 55,000 Rp - - - - Rp -
Suratin Rp 65,000 Rp - - - - Rp -
0 Rp - Rp - - - - Rp -
0 Rp - Rp - - - - Rp -
Rp
0 Rp - Rp - - - - Rp -
TOTAL RINCIAN UPAH TUKANG >>>>>> Rp - Rp - Rp - Rp - Rp -
DATA KEHADIRAN & LEMBUR
JAM KERJA LEMBUR. LEMBUR 1.oo- TOTAL JAM
Nama Pekerja PROYEK
PERIODE ABSEN NORMAL LEMBUR. 22.oo 24.oo 7.oo KERJA Keterangan
Yanto.BESI 0 0 0 0 0 0
Yono BESI 0 0 0 0 0 0
Ratno 0 0 0 0 0 0
DARSO 0 0 0 0 0 0
NURDIN 0 0 0 0 0 0
40886
NEMAN 0 0 0 0 0 0
SYSWADI 0 0 0 0 0 0
ASTO 0 0 0 0 0 0
Suratin 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
TOTAL JAM ABSEN TEAM ROSHIDIN >>>>>> - - - - -
-
RATA2 BIAYA/JAM (Average Cost Per Hour) : #DIV/0!
CATATAN : MANDOR ADMIN FINANCE
DESEMBER.2011
Tgl. Tgl. Tgl.
INFORMASI LEMBUR DI LUAR PABRIK
Lembur sdh Lembur Belum
Nama Pekerja Lokasi Lembur Upah / Hari Rp.Lmbr 22.oo Rp.Lmbr.24.oo Lmbr 1.oo-7.oo Total Upah
Dibayar Dibayar
