| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | Nama Karyawan | Jam Kerja | Kriteria | Upah | Bonus | Tunjangan | PPN (10%) | Gaji bersih | |
2 | 1 | Andre Al Akbar | 3 | Manager | 1.500.000 | 850000 | 765 | 1000765 | 2.350.765 |
3 | 2 | Artoni | 72 | Lembur | 200000 | 20000 | 10000 | 50000 | 180000 |
4 | 3 | Fajrul | 54 | Lembur | 146000 | 14600 | 7300 | 36500 | 131400 |
5 | 4 | Winda | 46 | Lembur | 122000 | 12200 | 6100 | 30500 | 109800 |
6 | 5 | Rudi | 17 | Lembur | 35000 | 3500 | 1750 | 8750 | 31500 |
7 | 6 | Wijaya | 57 | Lembur | 155000 | 15500 | 7750 | 38750 | 139500 |
8 | 7 | Pangestu | 12 | Lembur | 20000 | 2000 | 1000 | 5000 | 18000 |
9 | 8 | Dila | 78 | Lembur | 218000 | 21800 | 10900 | 54500 | 196200 |
10 | 9 | Renu | 52 | Lembur | 140000 | 14000 | 7000 | 35000 | 126000 |
11 | 10 | Farhan | 48 | Lembur | 128000 | 12800 | 6400 | 32000 | -1152850 |
12 | 11 | Krisna | 23 | Lembur | 2000000 | 140000 | 30000 | 5000 | 1300050 |
13 | 12 | Andika | 45 | Reguler | |||||
14 | 13 | Dzaky | 58 | Reguler | |||||
15 | 14 | Rania | 21 | Reguler | |||||
16 | 15 | Lia | 40 | Reguler | |||||
17 | 16 | Fadya | 24 | Reguler | |||||
18 | 17 | Zahnaz R | 65 | Reguler | |||||
19 | 18 | Rizky | 43 | Reguler | |||||
20 | 19 | Dumairoh | 21 | Reguler |