ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
JOB ENTRANCE TEST PAYSLIP FORMAT
2
3
4
Employee IDNamePositionBasic SalaryBonusSocial Security (Employer)Social Security (Employee)Health Insurance (Employer)Health Insurance (Employee)Income Tax BonusTransport BonusLoan Deduction / Salary AdvanceGross SalaryNet Salary
5
K01AgusMarketing Rp 4.200.000 Rp 500.000 Rp 294.000 Rp 210.000 Rp 126.000 Rp 84.000 Rp 336.000 Rp - Rp 898.576 Rp 5.036.000 Rp 3.843.424
6
K02SusiDirectors Rp 7.000.000 Rp 3.000.000 Rp 490.000 Rp 350.000 Rp 210.000 Rp 140.000 Rp 560.000 Rp 420.000 Rp 669.771 Rp 10.980.000 Rp 9.820.229
7
K03ZahraMarketing Rp 4.200.000 Rp 500.000 Rp 294.000 Rp 210.000 Rp 126.000 Rp 84.000 Rp 336.000 Rp - Rp 154.626 Rp 5.036.000 Rp 4.587.374
8
K04FaizHR Rp 5.500.000 Rp 1.000.000 Rp 385.000 Rp 275.000 Rp 165.000 Rp 110.000 Rp 440.000 Rp 220.000 Rp 809.626 Rp 7.160.000 Rp 5.965.374
9
K05SalimAdmin Rp 4.000.000 Rp - Rp 280.000 Rp 200.000 Rp 120.000 Rp 80.000 Rp 320.000 Rp - Rp 837.807 Rp 4.320.000 Rp 3.202.193
10
K06AniMarketing Rp 4.200.000 Rp 500.000 Rp 294.000 Rp 210.000 Rp 126.000 Rp 84.000 Rp 336.000 Rp - Rp 610.394 Rp 5.036.000 Rp 4.131.606
11
K07SyitaHR Rp 5.500.000 Rp 1.000.000 Rp 385.000 Rp 275.000 Rp 165.000 Rp 110.000 Rp 440.000 Rp 220.000 Rp 124.279 Rp 7.160.000 Rp 6.650.721
12
K08RamaMarketing Rp 4.200.000 Rp 500.000 Rp 294.000 Rp 210.000 Rp 126.000 Rp 84.000 Rp 336.000 Rp - Rp 361.261 Rp 5.036.000 Rp 4.380.739
13
K09MaksumAdmin Rp 4.000.000 Rp - Rp 280.000 Rp 200.000 Rp 120.000 Rp 80.000 Rp 320.000 Rp - Rp 162.308 Rp 4.320.000 Rp 3.877.692
14
K10ZhaMarketing Rp 4.200.000 Rp 500.000 Rp 294.000 Rp 210.000 Rp 126.000 Rp 84.000 Rp 336.000 Rp - Rp 356.221 Rp 5.036.000 Rp 4.385.779
15
16
17
Reference Table
18
No.PositionBasic Salary0 = FALSE
19
1 = TRUE
20
1Directors Rp 7.000.000
21
2HR Rp 5.500.000
22
3Marketing Rp 4.200.000
23
4Admin Rp 4.000.000
24
25
26
FILLING INSTRUCTIONS:
27
1. Basic Salary: Using Vlookup formula taken from Reference Table
28
2. Bonus :
29
- Directors : Rp 3.000.000
30
- HR : Rp 1.000.000
31
- Marketing : Rp 500.000
32
3. Employment BPJS :
33
- Company : 7% of Basic Salary
34
- Employee : 5% of Basic Salary
35
4. Health BPJS :
36
- Company : 3% of Basic Salary
37
- Employee : 2% of Basic Salary
38
5. Income Tax Bonus : 8% of Basic Salary
39
6. Transport Bonus :
40
- Directors : 6% of Basic Salary
41
- HR : 4% of Basic Salary
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100