Kasus 4b

MEMBUAT REKAP GAJI KARYAWAN
No.	NAMA	NIP	STATUS	JML. ANAK	GRADE	GJ. POKOK	TUNJANGAN					JUMLAH TUNJANGAN	GJ. KOTOR	TASPEN	ASURANSI	PAJAK	GAJI BERSIH
							ISTRI/SUAMI	ANAK	JABATAN	TRANSPORT	UANG MKN			5%	2%	15%
1	Endiartono	10110	Kawin	1	1	Rp5,000,000	Rp1,500,000	Rp500,000	Rp1,000,000	Rp250,000	Rp150,000	Rp3,400,000	Rp8,400,000	Rp420,000	Rp168,000	Rp1,260,000	Rp6,552,000
2	Hendrawan Ali	10111	Tidak kawin	0	4	Rp2,000,000		Rp-	Rp400,000	Rp100,000	Rp60,000	Rp560,000	Rp2,560,000	Rp128,000	Rp51,200	Rp384,000	Rp1,996,800
3	Randy Suwandi	10112	Kawin	4	3	Rp2,500,000	Rp750,000	Rp1,000,000	Rp500,000	Rp125,000	Rp75,000	Rp2,450,000	Rp4,950,000	Rp247,500	Rp99,000	Rp742,500	Rp3,861,000
4	Adhitya Samudra	10113	Kawin	2	2	Rp3,500,000	Rp1,050,000	Rp700,000	Rp700,000	Rp175,000	Rp105,000	Rp2,730,000	Rp6,230,000	Rp311,500	Rp124,600	Rp934,500	Rp4,859,400
5	Agung Mulyono	10114	Kawin	0	3	Rp2,500,000	Rp750,000	Rp-	Rp500,000	Rp125,000	Rp75,000	Rp1,450,000	Rp3,950,000	Rp197,500	Rp79,000	Rp592,500	Rp3,081,000
6	Andy Setiawan	10115	Tidak kawin	0	4	Rp2,000,000		Rp-	Rp400,000	Rp100,000	Rp60,000	Rp560,000	Rp2,560,000	Rp128,000	Rp51,200	Rp384,000	Rp1,996,800
7	Sarah Noordeviana	10116	Tidak kawin	0	4	Rp2,000,000		Rp-	Rp400,000	Rp100,000	Rp60,000	Rp560,000	Rp2,560,000	Rp128,000	Rp51,200	Rp384,000	Rp1,996,800
8	Ayu Anandhika	10117	Kawin	5	4	Rp2,000,000	Rp600,000	Rp1,000,000	Rp400,000	Rp100,000	Rp60,000	Rp2,160,000	Rp4,160,000	Rp208,000	Rp83,200	Rp624,000	Rp3,244,800
9	Ernawati	10118	Tidak kawin	0	3	Rp2,500,000		Rp-	Rp500,000	Rp125,000	Rp75,000	Rp700,000	Rp3,200,000	Rp160,000	Rp64,000	Rp480,000	Rp2,496,000
10	Rudolf Sakilangit	10119	Tidak kawin	0	4	Rp2,000,000		Rp-	Rp400,000	Rp100,000	Rp60,000	Rp560,000	Rp2,560,000	Rp128,000	Rp51,200	Rp384,000	Rp1,996,800
11	Herry Endarto	10120	Tidak kawin	0	3	Rp2,500,000		Rp-	Rp500,000	Rp125,000	Rp75,000	Rp700,000	Rp3,200,000	Rp160,000	Rp64,000	Rp480,000	Rp2,496,000
12	Rianto Suherman	10121	Kawin	5	4	Rp2,000,000	Rp600,000	Rp1,000,000	Rp400,000	Rp100,000	Rp60,000	Rp2,160,000	Rp4,160,000	Rp208,000	Rp83,200	Rp624,000	Rp3,244,800
13	Debby Andalusia	10122	Tidak kawin	0	2	Rp3,500,000		Rp-	Rp700,000	Rp175,000	Rp105,000	Rp980,000	Rp4,480,000	Rp224,000	Rp89,600	Rp672,000	Rp3,494,400

GRADE	GJ. POKOK	TUNJANGAN
		ISTRI/SUAMI	ANAK	JABATAN	TRANSPORT	UANG MKN
1	5000000	1500000	500000	1000000	250000	150000
2	3500000	1050000	350000	700000	175000	105000
3	2500000	750000	250000	500000	125000	75000
4	2000000	600000	200000	400000	100000	60000
5	1000000	300000	100000	200000	50000	30000