daily overtime wage auto-monitoring sheet for eps worker

16
Daily Overtime Wage Auto-Monitoring Sheet for EPS W Objective: 1) To help EPS workers simplify their monthly monitoring on daily overtime and night differential if a 2) To help verify EPS worker's actual gross and net salary income against employer's payslip or actual How to use the auto-monitoring table: 6) All other information such as total ovetime wage, total night differential wage, and month gross sala 9) To make a new worksheet for the next month, copy the existing worksheet and rename it according to cu Created by: Don 1) Under Sat/Sun/Holiday column, put letter "sat" on the blank cell if working day is Saturday while put working day is Sunday and other holidays. If weekdays, leave it blank. Refer to example in the 1st row… 2) Under 40hrs/44hrs column, if working day is Saturday , put number "44" on the blank cell if the compa workweek while put number "40" if the company is under 40-hrs workweek system. If other days, leave it blank. in the 1st row... 3) Under time-in and time-out column , input your actual time-in and time-out daily time record. If daysh table while if nightshift use the right table. 3) Be sure to input/type your time-in / time-out in a 24-hour clock format (military time format) . Refer to e 4) Under the breaktime column , input your number of hours break in a day. If your breaktime is less than hour mode not in minutes mode. For example, 30mins = 0.5hr , 15mins. = 0.15hrs . 5) Under the ND work hrs column , input the night differential worked hours on the specified column if ap 7) For month net salary income, manually compute it using applicable salary deductibles. Refer to import 8) OPTIONAL! If your company is just implementing 40-hrs workweek system , within 3-years from its implem your month gross salary with 16,440won (16hrs OT in a month at 0.25% OT salary only) to get your final month ne

Post on 18-Nov-2014

13 views

Category:

Documents


3 download

DESCRIPTION

Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker. This excel file monitoring is programmed to automatically calculate the overtime and night differential wages according to time-in and time-out input.

TRANSCRIPT

Page 1: Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker

Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker

Objective:

1) To help EPS workers simplify their monthly monitoring on daily overtime and night differential if applicable.

2) To help verify EPS worker's actual gross and net salary income against employer's payslip or actual salary without payslip.

How to use the auto-monitoring table:

6) All other information such as total ovetime wage, total night differential wage, and month gross salary are automatically calculated.

9) To make a new worksheet for the next month, copy the existing worksheet and rename it according to current applicable month.

Created by: Dondave Jabay, 07/01/2010

1) Under Sat/Sun/Holiday column, put letter "sat" on the blank cell if working day is Saturday while put letter "sh" if working day is Sunday and other holidays. If weekdays, leave it blank. Refer to example in the 1st row…

2) Under 40hrs/44hrs column, if working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. If other days, leave it blank. Refer to example in the 1st row...

3) Under time-in and time-out column, input your actual time-in and time-out daily time record. If dayshift use the left table while if nightshift use the right table.

3) Be sure to input/type your time-in / time-out in a 24-hour clock format (military time format). Refer to example in the first row of the table.

4) Under the breaktime column, input your number of hours break in a day. If your breaktime is less than 1-hr, input it in hour mode not in minutes mode. For example, 30mins = 0.5hr, 15mins. = 0.15hrs.

5) Under the ND work hrs column, input the night differential worked hours on the specified column if applicable.

7) For month net salary income, manually compute it using applicable salary deductibles. Refer to important notes directly below the table.

8) OPTIONAL! If your company is just implementing 40-hrs workweek system, within 3-years from its implementation, deduct your month gross salary with 16,440won (16hrs OT in a month at 0.25% OT salary only) to get your final month net salary.

Page 2: Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker

Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker8:00

2010 Minimum Wage Computation / Total (Won) Month: Eaxample - May No. of Days Work: 29

Minimum Wage/Hour 4,110 Total Overtime Wage (Won) = 1,135,782

209hrs x 4110won = 858,990 Total Night Differential Wage (Won) = 53,430

226hrs x 4110won = 928,860 Gross Salary (40-Hrs Work Week) (Won) = 2,048,202

Overtime Rate/Hour 1hr x 4110won x 150% = 6,156 Gross Salary (44-Hrs Work Week) (Won) = 2,118,072

Night Differential/Hour 1hr x 4110won x 50% = 2,055 =

Dayshift Nightshift

Day Time-in Time-out Breaktime Total OT Day Time-in Time-out Breaktime Total OT

Ex. sat 44 9:00 23:00 14.00 1 9.0 55,404 1.0 2,055 Ex. sh 20:00 9:00 13.00 1 12.0 73,872 7.0 14,385

1 sat 40 8:30 17:30 9.00 1 8.0 49,248 0 1 0.00 -8.0 -49,248 02 sh 9:30 15:30 6.00 6.0 36,936 0 2 0.00 -8.0 -49,248 03 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 3 0.00 -8.0 -49,248 04 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 4 0.00 -8.0 -49,248 05 sh 8:30 20:00 11.50 1.5 10.0 61,560 0 5 0.00 -8.0 -49,248 06 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 6 0.00 -8.0 -49,248 07 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 7 0.00 -8.0 -49,248 08 sat 40 8:30 15:30 7.00 1 6.0 36,936 0 8 0.00 -8.0 -49,248 09 sh 8:30 17:30 9.00 1 8.0 49,248 0 9 0.00 -8.0 -49,248 010 8:30 20:00 11.50 1.5 2.0 12,312 0 10 0.00 -8.0 -49,248 011 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 11 0.00 -8.0 -49,248 012 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 12 0.00 -8.0 -49,248 013 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 13 0.00 -8.0 -49,248 014 8:30 22:00 13.50 1.5 4.0 24,624 0 14 0.00 -8.0 -49,248 015 sat 40 8:30 22:00 13.50 1.5 12.0 73,872 0 15 0.00 -8.0 -49,248 016 0.00 -8.0 -49,248 0 16 0.00 -8.0 -49,248 017 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 17 0.00 -8.0 -49,248 018 8:30 22:00 13.50 1.5 4.0 24,624 0 18 0.00 -8.0 -49,248 019 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 19 0.00 -8.0 -49,248 020 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 20 0.00 -8.0 -49,248 021 sh 8:30 22:30 14.00 1.5 12.5 76,950 0.5 1,028 21 0.00 -8.0 -49,248 022 sat 40 8:30 19:30 11.00 1.5 9.5 58,482 0 22 0.00 -8.0 -49,248 023 sh 8:30 19:00 10.50 1.5 9.0 55,404 0 23 0.00 -8.0 -49,248 024 8:30 22:30 14.00 1.5 4.5 27,702 0.5 1,028 24 0.00 -8.0 -49,248 025 8:30 23:00 14.50 1.5 5.0 30,780 1.0 2,055 25 0.00 -8.0 -49,248 026 8:30 20:00 11.50 1.5 2.0 12,312 0 26 0.00 -8.0 -49,248 027 8:30 20:00 11.50 1.5 2.0 12,312 0 27 0.00 -8.0 -49,248 028 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 28 0.00 -8.0 -49,248 029 sat 40 8:30 17:30 9.00 1 8.0 49,248 0 29 0.00 -8.0 -49,248 030 0.00 -8.0 -49,248 0 30 0.00 -8.0 -49,248 031 8:30 0:00 15.50 1.5 6.0 36,936 2.0 4,110 31 0.00 -8.0 -49,248 0

Overall Total 376.50 40 184.5 1,135,782 26.0 53,430 Overall Total 0.00 0 0.0 0 0.0 0

Important Notes:

Created by: Dondave Jabay, 07/01/2010

Note: For Companies under 40-Hrs WorkweekIf your company has just implemented the 40-Hrs Workweek System (currently changed from 44-hrs), within 3-yrs from its implementation, the first 4-hrs OT salary per week shall only have 0.25% additional overtime charge. Therefore, since 1-

month has 4-weeks, so 16,440won (4hrs x 4weeks x 4,110won x 0.25%) shall be deducted from your Gross Salary.

Net Salary = Gross Salary ─ 16,440won ─ other expected deductions

Monthly Basic Wage(40-Hrs Work Week)

Monthly Basic Wage(44-Hrs Work Week)

Net Salary (Gross Salary ─ all applicable deductions)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

I.) Expected Net Salary = Gross Salary ─ Kukmin (국민연금), Health Insurance (건강보험), Income Tax (소득세), Resident Tax (주민세), & Employment Insurance (고용보험 - Optional)II.) Expected Deductions (As of 2010):

1) Kukmin (국민연금) = average monthly salary x 4.5% (uniform deduction monthly but will be changed by NPS Office after 1-year according to average monthly salary during the previous year)

2) Health Insurance (건강보험) = average monthly salary x 2.665% (uniform deduction monthly will be changed after 1-year, normally in the month of April the following year due to overtime affecting the monthly average salary)

3) Income Tax (소득세) = gross monthly salary x 0.7% ~ 0.8%. Or use the Monthly Withholding Tax Auto Calculator at NTS website… You may click below url…

http://www.nts.go.kr/eng/help/help_56.asp?top_code=H001&sub_code=HS05&ssub_code=HSE54) Resident Tax (주민세) = Monthly Income Tax x 10%

5) Employment Insurance (고용보험 - Optional) = average monthly salary x 0.45%

6) Return Cost Insurance (출국보험) = only 400,000won shall be deducted by Samsung Insurance Company per sojourn period… It could be one time deduction or distributed monthly.

B12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
C12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
S12
ND = Night Differential
W12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
X12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
AN12
ND = Night Differential
Page 3: Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker

Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker8:00

2010 Minimum Wage Computation / Total (Won) Month: No. of Days Work:

Minimum Wage/Hour 4,110 Total Overtime Wage (Won) = 0

209hrs x 4110won = 858,990 Total Night Differential Wage (Won) = 0

226hrs x 4110won = 928,860 Gross Salary (40-Hrs Work Week) (Won) = 858,990

Overtime Rate/Hour 1hr x 4110won x 150% = 6,156 Gross Salary (44-Hrs Work Week) (Won) = 928,860

Night Differential/Hour 1hr x 4110won x 50% = 2,055 =

Dayshift Nightshift

Day Time-in Time-out Breaktime Total OT Day Time-in Time-out Breaktime Total OT

Ex. sat 44 9:00 23:00 14.00 1 9.0 55,404 1.0 2,055 Ex. sh 20:00 9:00 13.00 1 12.0 73,872 7.0 14,385

1 0.00 -8.0 -49,248 0 1 0.00 -8.0 -49,248 02 0.00 -8.0 -49,248 0 2 0.00 -8.0 -49,248 03 0.00 -8.0 -49,248 0 3 0.00 -8.0 -49,248 04 0.00 -8.0 -49,248 0 4 0.00 -8.0 -49,248 05 0.00 -8.0 -49,248 0 5 0.00 -8.0 -49,248 06 0.00 -8.0 -49,248 0 6 0.00 -8.0 -49,248 07 0.00 -8.0 -49,248 0 7 0.00 -8.0 -49,248 08 0.00 -8.0 -49,248 0 8 0.00 -8.0 -49,248 09 0.00 -8.0 -49,248 0 9 0.00 -8.0 -49,248 010 0.00 -8.0 -49,248 0 10 0.00 -8.0 -49,248 011 0.00 -8.0 -49,248 0 11 0.00 -8.0 -49,248 012 0.00 -8.0 -49,248 0 12 0.00 -8.0 -49,248 013 0.00 -8.0 -49,248 0 13 0.00 -8.0 -49,248 014 0.00 -8.0 -49,248 0 14 0.00 -8.0 -49,248 015 0.00 -8.0 -49,248 0 15 0.00 -8.0 -49,248 016 0.00 -8.0 -49,248 0 16 0.00 -8.0 -49,248 017 0.00 -8.0 -49,248 0 17 0.00 -8.0 -49,248 018 0.00 -8.0 -49,248 0 18 0.00 -8.0 -49,248 019 0.00 -8.0 -49,248 0 19 0.00 -8.0 -49,248 020 0.00 -8.0 -49,248 0 20 0.00 -8.0 -49,248 021 0.00 -8.0 -49,248 0 21 0.00 -8.0 -49,248 022 0.00 -8.0 -49,248 0 22 0.00 -8.0 -49,248 023 0.00 -8.0 -49,248 0 23 0.00 -8.0 -49,248 024 0.00 -8.0 -49,248 0 24 0.00 -8.0 -49,248 025 0.00 -8.0 -49,248 0 25 0.00 -8.0 -49,248 026 0.00 -8.0 -49,248 0 26 0.00 -8.0 -49,248 027 0.00 -8.0 -49,248 0 27 0.00 -8.0 -49,248 028 0.00 -8.0 -49,248 0 28 0.00 -8.0 -49,248 029 0.00 -8.0 -49,248 0 29 0.00 -8.0 -49,248 030 0.00 -8.0 -49,248 0 30 0.00 -8.0 -49,248 031 0.00 -8.0 -49,248 0 31 0.00 -8.0 -49,248 0

Overall Total 0.00 0 0.0 0 0.0 0 Overall Total 0.00 0 0.0 0 0.0 0

Important Notes:

Created by: Dondave Jabay, 07/01/2010

Note: For Companies under 40-Hrs WorkweekIf your company has just implemented the 40-Hrs Workweek System (currently changed from 44-hrs), within 3-yrs from its implementation, the first 4-hrs OT salary per week shall only have 0.25% additional overtime charge. Therefore, since 1-

month has 4-weeks, so 16,440won (4hrs x 4weeks x 4,110won x 0.25%) shall be deducted from your Gross Salary.

Net Salary = Gross Salary ─ 16,440won ─ other expected deductions

Monthly Basic Wage(40-Hrs Work Week)

Monthly Basic Wage(44-Hrs Work Week)

Net Salary (Gross Salary ─ all applicable deductions)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

I.) Expected Net Salary = Gross Salary ─ Kukmin (국민연금), Health Insurance (건강보험), Income Tax (소득세), Resident Tax (주민세), & Employment Insurance (고용보험 - Optional)II.) Expected Deductions (As of 2010):

1) Kukmin (국민연금) = average monthly salary x 4.5% (uniform deduction monthly but will be changed by NPS Office after 1-year according to average monthly salary during the previous year)

2) Health Insurance (건강보험) = average monthly salary x 2.665% (uniform deduction monthly will be changed after 1-year, normally in the month of April the following year due to overtime affecting the monthly average salary)

3) Income Tax (소득세) = gross monthly salary x 0.7% ~ 0.8%. Or use the Monthly Withholding Tax Auto Calculator at NTS website… You may click below url…

http://www.nts.go.kr/eng/help/help_56.asp?top_code=H001&sub_code=HS05&ssub_code=HSE54) Resident Tax (주민세) = Monthly Income Tax x 10%

5) Employment Insurance (고용보험 - Optional) = average monthly salary x 0.45%

6) Return Cost Insurance (출국보험) = only 400,000won shall be deducted by Samsung Insurance Company per sojourn period… It could be one time deduction or distributed monthly.

B12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
C12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
S12
ND = Night Differential
W12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
X12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
AN12
ND = Night Differential
Page 4: Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker

Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker8:00

2010 Minimum Wage Computation / Total (Won) Month: No. of Days Work:

Minimum Wage/Hour 4,110 Total Overtime Wage (Won) = 0

209hrs x 4110won = 858,990 Total Night Differential Wage (Won) = 0

226hrs x 4110won = 928,860 Gross Salary (40-Hrs Work Week) (Won) = 858,990

Overtime Rate/Hour 1hr x 4110won x 150% = 6,156 Gross Salary (44-Hrs Work Week) (Won) = 928,860

Night Differential/Hour 1hr x 4110won x 50% = 2,055 =

Dayshift Nightshift

Day Time-in Time-out Breaktime Total OT Day Time-in Time-out Breaktime Total OT

Ex. sat 44 9:00 23:00 14.00 1 9.0 55,404 1.0 2,055 Ex. sh 20:00 9:00 13.00 1 12.0 73,872 7.0 14,385

1 0.00 -8.0 -49,248 0 1 0.00 -8.0 -49,248 02 0.00 -8.0 -49,248 0 2 0.00 -8.0 -49,248 03 0.00 -8.0 -49,248 0 3 0.00 -8.0 -49,248 04 0.00 -8.0 -49,248 0 4 0.00 -8.0 -49,248 05 0.00 -8.0 -49,248 0 5 0.00 -8.0 -49,248 06 0.00 -8.0 -49,248 0 6 0.00 -8.0 -49,248 07 0.00 -8.0 -49,248 0 7 0.00 -8.0 -49,248 08 0.00 -8.0 -49,248 0 8 0.00 -8.0 -49,248 09 0.00 -8.0 -49,248 0 9 0.00 -8.0 -49,248 010 0.00 -8.0 -49,248 0 10 0.00 -8.0 -49,248 011 0.00 -8.0 -49,248 0 11 0.00 -8.0 -49,248 012 0.00 -8.0 -49,248 0 12 0.00 -8.0 -49,248 013 0.00 -8.0 -49,248 0 13 0.00 -8.0 -49,248 014 0.00 -8.0 -49,248 0 14 0.00 -8.0 -49,248 015 0.00 -8.0 -49,248 0 15 0.00 -8.0 -49,248 016 0.00 -8.0 -49,248 0 16 0.00 -8.0 -49,248 017 0.00 -8.0 -49,248 0 17 0.00 -8.0 -49,248 018 0.00 -8.0 -49,248 0 18 0.00 -8.0 -49,248 019 0.00 -8.0 -49,248 0 19 0.00 -8.0 -49,248 020 0.00 -8.0 -49,248 0 20 0.00 -8.0 -49,248 021 0.00 -8.0 -49,248 0 21 0.00 -8.0 -49,248 022 0.00 -8.0 -49,248 0 22 0.00 -8.0 -49,248 023 0.00 -8.0 -49,248 0 23 0.00 -8.0 -49,248 024 0.00 -8.0 -49,248 0 24 0.00 -8.0 -49,248 025 0.00 -8.0 -49,248 0 25 0.00 -8.0 -49,248 026 0.00 -8.0 -49,248 0 26 0.00 -8.0 -49,248 027 0.00 -8.0 -49,248 0 27 0.00 -8.0 -49,248 028 0.00 -8.0 -49,248 0 28 0.00 -8.0 -49,248 029 0.00 -8.0 -49,248 0 29 0.00 -8.0 -49,248 030 0.00 -8.0 -49,248 0 30 0.00 -8.0 -49,248 031 0.00 -8.0 -49,248 0 31 0.00 -8.0 -49,248 0

Overall Total 0.00 0 0.0 0 0.0 0 Overall Total 0.00 0 0.0 0 0.0 0

Important Notes:

Created by: Dondave Jabay, 07/01/2010

Note: For Companies under 40-Hrs WorkweekIf your company has just implemented the 40-Hrs Workweek System (currently changed from 44-hrs), within 3-yrs from its implementation, the first 4-hrs OT salary per week shall only have 0.25% additional overtime charge. Therefore, since 1-

month has 4-weeks, so 16,440won (4hrs x 4weeks x 4,110won x 0.25%) shall be deducted from your Gross Salary.

Net Salary = Gross Salary ─ 16,440won ─ other expected deductions

Monthly Basic Wage(40-Hrs Work Week)

Monthly Basic Wage(44-Hrs Work Week)

Net Salary (Gross Salary ─ all applicable deductions)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

I.) Expected Net Salary = Gross Salary ─ Kukmin (국민연금), Health Insurance (건강보험), Income Tax (소득세), Resident Tax (주민세), & Employment Insurance (고용보험 - Optional)II.) Expected Deductions (As of 2010):

1) Kukmin (국민연금) = average monthly salary x 4.5% (uniform deduction monthly but will be changed by NPS Office after 1-year according to average monthly salary during the previous year)

2) Health Insurance (건강보험) = average monthly salary x 2.665% (uniform deduction monthly will be changed after 1-year, normally in the month of April the following year due to overtime affecting the monthly average salary)

3) Income Tax (소득세) = gross monthly salary x 0.7% ~ 0.8%. Or use the Monthly Withholding Tax Auto Calculator at NTS website… You may click below url…

http://www.nts.go.kr/eng/help/help_56.asp?top_code=H001&sub_code=HS05&ssub_code=HSE54) Resident Tax (주민세) = Monthly Income Tax x 10%

5) Employment Insurance (고용보험 - Optional) = average monthly salary x 0.45%

6) Return Cost Insurance (출국보험) = only 400,000won shall be deducted by Samsung Insurance Company per sojourn period… It could be one time deduction or distributed monthly.

B12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
C12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
S12
ND = Night Differential
W12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
X12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
AN12
ND = Night Differential
Page 5: Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker

Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker8:00

2010 Minimum Wage Computation / Total (Won) Month: No. of Days Work:

Minimum Wage/Hour 4,110 Total Overtime Wage (Won) = 0

209hrs x 4110won = 858,990 Total Night Differential Wage (Won) = 0

226hrs x 4110won = 928,860 Gross Salary (40-Hrs Work Week) (Won) = 858,990

Overtime Rate/Hour 1hr x 4110won x 150% = 6,156 Gross Salary (44-Hrs Work Week) (Won) = 928,860

Night Differential/Hour 1hr x 4110won x 50% = 2,055 =

Dayshift Nightshift

Day Time-in Time-out Breaktime Total OT Day Time-in Time-out Breaktime Total OT

Ex. sat 44 9:00 23:00 14.00 1 9.0 55,404 1.0 2,055 Ex. sh 20:00 9:00 13.00 1 12.0 73,872 7.0 14,385

1 0.00 -8.0 -49,248 0 1 0.00 -8.0 -49,248 02 0.00 -8.0 -49,248 0 2 0.00 -8.0 -49,248 03 0.00 -8.0 -49,248 0 3 0.00 -8.0 -49,248 04 0.00 -8.0 -49,248 0 4 0.00 -8.0 -49,248 05 0.00 -8.0 -49,248 0 5 0.00 -8.0 -49,248 06 0.00 -8.0 -49,248 0 6 0.00 -8.0 -49,248 07 0.00 -8.0 -49,248 0 7 0.00 -8.0 -49,248 08 0.00 -8.0 -49,248 0 8 0.00 -8.0 -49,248 09 0.00 -8.0 -49,248 0 9 0.00 -8.0 -49,248 010 0.00 -8.0 -49,248 0 10 0.00 -8.0 -49,248 011 0.00 -8.0 -49,248 0 11 0.00 -8.0 -49,248 012 0.00 -8.0 -49,248 0 12 0.00 -8.0 -49,248 013 0.00 -8.0 -49,248 0 13 0.00 -8.0 -49,248 014 0.00 -8.0 -49,248 0 14 0.00 -8.0 -49,248 015 0.00 -8.0 -49,248 0 15 0.00 -8.0 -49,248 016 0.00 -8.0 -49,248 0 16 0.00 -8.0 -49,248 017 0.00 -8.0 -49,248 0 17 0.00 -8.0 -49,248 018 0.00 -8.0 -49,248 0 18 0.00 -8.0 -49,248 019 0.00 -8.0 -49,248 0 19 0.00 -8.0 -49,248 020 0.00 -8.0 -49,248 0 20 0.00 -8.0 -49,248 021 0.00 -8.0 -49,248 0 21 0.00 -8.0 -49,248 022 0.00 -8.0 -49,248 0 22 0.00 -8.0 -49,248 023 0.00 -8.0 -49,248 0 23 0.00 -8.0 -49,248 024 0.00 -8.0 -49,248 0 24 0.00 -8.0 -49,248 025 0.00 -8.0 -49,248 0 25 0.00 -8.0 -49,248 026 0.00 -8.0 -49,248 0 26 0.00 -8.0 -49,248 027 0.00 -8.0 -49,248 0 27 0.00 -8.0 -49,248 028 0.00 -8.0 -49,248 0 28 0.00 -8.0 -49,248 029 0.00 -8.0 -49,248 0 29 0.00 -8.0 -49,248 030 0.00 -8.0 -49,248 0 30 0.00 -8.0 -49,248 031 0.00 -8.0 -49,248 0 31 0.00 -8.0 -49,248 0

Overall Total 0.00 0 0.0 0 0.0 0 Overall Total 0.00 0 0.0 0 0.0 0

Important Notes:

Created by: Dondave Jabay, 07/01/2010

Note: For Companies under 40-Hrs WorkweekIf your company has just implemented the 40-Hrs Workweek System (currently changed from 44-hrs), within 3-yrs from its implementation, the first 4-hrs OT salary per week shall only have 0.25% additional overtime charge. Therefore, since 1-

month has 4-weeks, so 16,440won (4hrs x 4weeks x 4,110won x 0.25%) shall be deducted from your Gross Salary.

Net Salary = Gross Salary ─ 16,440won ─ other expected deductions

Monthly Basic Wage(40-Hrs Work Week)

Monthly Basic Wage(44-Hrs Work Week)

Net Salary (Gross Salary ─ all applicable deductions)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

I.) Expected Net Salary = Gross Salary ─ Kukmin (국민연금), Health Insurance (건강보험), Income Tax (소득세), Resident Tax (주민세), & Employment Insurance (고용보험 - Optional)II.) Expected Deductions (As of 2010):

1) Kukmin (국민연금) = average monthly salary x 4.5% (uniform deduction monthly but will be changed by NPS Office after 1-year according to average monthly salary during the previous year)

2) Health Insurance (건강보험) = average monthly salary x 2.665% (uniform deduction monthly will be changed after 1-year, normally in the month of April the following year due to overtime affecting the monthly average salary)

3) Income Tax (소득세) = gross monthly salary x 0.7% ~ 0.8%. Or use the Monthly Withholding Tax Auto Calculator at NTS website… You may click below url…

http://www.nts.go.kr/eng/help/help_56.asp?top_code=H001&sub_code=HS05&ssub_code=HSE54) Resident Tax (주민세) = Monthly Income Tax x 10%

5) Employment Insurance (고용보험 - Optional) = average monthly salary x 0.45%

6) Return Cost Insurance (출국보험) = only 400,000won shall be deducted by Samsung Insurance Company per sojourn period… It could be one time deduction or distributed monthly.

B12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
C12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
S12
ND = Night Differential
W12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
X12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
AN12
ND = Night Differential
Page 6: Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker

Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker8:00

2010 Minimum Wage Computation / Total (Won) Month: No. of Days Work:

Minimum Wage/Hour 4,110 Total Overtime Wage (Won) = 0

209hrs x 4110won = 858,990 Total Night Differential Wage (Won) = 0

226hrs x 4110won = 928,860 Gross Salary (40-Hrs Work Week) (Won) = 858,990

Overtime Rate/Hour 1hr x 4110won x 150% = 6,156 Gross Salary (44-Hrs Work Week) (Won) = 928,860

Night Differential/Hour 1hr x 4110won x 50% = 2,055 =

Dayshift Nightshift

Day Time-in Time-out Breaktime Total OT Day Time-in Time-out Breaktime Total OT

Ex. sat 44 9:00 23:00 14.00 1 9.0 55,404 1.0 2,055 Ex. sh 20:00 9:00 13.00 1 12.0 73,872 7.0 14,385

1 0.00 -8.0 -49,248 0 1 0.00 -8.0 -49,248 02 0.00 -8.0 -49,248 0 2 0.00 -8.0 -49,248 03 0.00 -8.0 -49,248 0 3 0.00 -8.0 -49,248 04 0.00 -8.0 -49,248 0 4 0.00 -8.0 -49,248 05 0.00 -8.0 -49,248 0 5 0.00 -8.0 -49,248 06 0.00 -8.0 -49,248 0 6 0.00 -8.0 -49,248 07 0.00 -8.0 -49,248 0 7 0.00 -8.0 -49,248 08 0.00 -8.0 -49,248 0 8 0.00 -8.0 -49,248 09 0.00 -8.0 -49,248 0 9 0.00 -8.0 -49,248 010 0.00 -8.0 -49,248 0 10 0.00 -8.0 -49,248 011 0.00 -8.0 -49,248 0 11 0.00 -8.0 -49,248 012 0.00 -8.0 -49,248 0 12 0.00 -8.0 -49,248 013 0.00 -8.0 -49,248 0 13 0.00 -8.0 -49,248 014 0.00 -8.0 -49,248 0 14 0.00 -8.0 -49,248 015 0.00 -8.0 -49,248 0 15 0.00 -8.0 -49,248 016 0.00 -8.0 -49,248 0 16 0.00 -8.0 -49,248 017 0.00 -8.0 -49,248 0 17 0.00 -8.0 -49,248 018 0.00 -8.0 -49,248 0 18 0.00 -8.0 -49,248 019 0.00 -8.0 -49,248 0 19 0.00 -8.0 -49,248 020 0.00 -8.0 -49,248 0 20 0.00 -8.0 -49,248 021 0.00 -8.0 -49,248 0 21 0.00 -8.0 -49,248 022 0.00 -8.0 -49,248 0 22 0.00 -8.0 -49,248 023 0.00 -8.0 -49,248 0 23 0.00 -8.0 -49,248 024 0.00 -8.0 -49,248 0 24 0.00 -8.0 -49,248 025 0.00 -8.0 -49,248 0 25 0.00 -8.0 -49,248 026 0.00 -8.0 -49,248 0 26 0.00 -8.0 -49,248 027 0.00 -8.0 -49,248 0 27 0.00 -8.0 -49,248 028 0.00 -8.0 -49,248 0 28 0.00 -8.0 -49,248 029 0.00 -8.0 -49,248 0 29 0.00 -8.0 -49,248 030 0.00 -8.0 -49,248 0 30 0.00 -8.0 -49,248 031 0.00 -8.0 -49,248 0 31 0.00 -8.0 -49,248 0

Overall Total 0.00 0 0.0 0 0.0 0 Overall Total 0.00 0 0.0 0 0.0 0

Important Notes:

Created by: Dondave Jabay, 07/01/2010

Note: For Companies under 40-Hrs WorkweekIf your company has just implemented the 40-Hrs Workweek System (currently changed from 44-hrs), within 3-yrs from its implementation, the first 4-hrs OT salary per week shall only have 0.25% additional overtime charge. Therefore, since 1-

month has 4-weeks, so 16,440won (4hrs x 4weeks x 4,110won x 0.25%) shall be deducted from your Gross Salary.

Net Salary = Gross Salary ─ 16,440won ─ other expected deductions

Monthly Basic Wage(40-Hrs Work Week)

Monthly Basic Wage(44-Hrs Work Week)

Net Salary (Gross Salary ─ all applicable deductions)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

I.) Expected Net Salary = Gross Salary ─ Kukmin (국민연금), Health Insurance (건강보험), Income Tax (소득세), Resident Tax (주민세), & Employment Insurance (고용보험 - Optional)II.) Expected Deductions (As of 2010):

1) Kukmin (국민연금) = average monthly salary x 4.5% (uniform deduction monthly but will be changed by NPS Office after 1-year according to average monthly salary during the previous year)

2) Health Insurance (건강보험) = average monthly salary x 2.665% (uniform deduction monthly will be changed after 1-year, normally in the month of April the following year due to overtime affecting the monthly average salary)

3) Income Tax (소득세) = gross monthly salary x 0.7% ~ 0.8%. Or use the Monthly Withholding Tax Auto Calculator at NTS website… You may click below url…

http://www.nts.go.kr/eng/help/help_56.asp?top_code=H001&sub_code=HS05&ssub_code=HSE54) Resident Tax (주민세) = Monthly Income Tax x 10%

5) Employment Insurance (고용보험 - Optional) = average monthly salary x 0.45%

6) Return Cost Insurance (출국보험) = only 400,000won shall be deducted by Samsung Insurance Company per sojourn period… It could be one time deduction or distributed monthly.

B12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
C12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
S12
ND = Night Differential
W12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
X12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
AN12
ND = Night Differential
Page 7: Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker

Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker8:00

2010 Minimum Wage Computation / Total (Won) Month: No. of Days Work:

Minimum Wage/Hour 4,110 Total Overtime Wage (Won) = 0

209hrs x 4110won = 858,990 Total Night Differential Wage (Won) = 0

226hrs x 4110won = 928,860 Gross Salary (40-Hrs Work Week) (Won) = 858,990

Overtime Rate/Hour 1hr x 4110won x 150% = 6,156 Gross Salary (44-Hrs Work Week) (Won) = 928,860

Night Differential/Hour 1hr x 4110won x 50% = 2,055 =

Dayshift Nightshift

Day Time-in Time-out Breaktime Total OT Day Time-in Time-out Breaktime Total OT

Ex. sat 44 9:00 23:00 14.00 1 9.0 55,404 1.0 2,055 Ex. sh 20:00 9:00 13.00 1 12.0 73,872 7.0 14,385

1 0.00 -8.0 -49,248 0 1 0.00 -8.0 -49,248 02 0.00 -8.0 -49,248 0 2 0.00 -8.0 -49,248 03 0.00 -8.0 -49,248 0 3 0.00 -8.0 -49,248 04 0.00 -8.0 -49,248 0 4 0.00 -8.0 -49,248 05 0.00 -8.0 -49,248 0 5 0.00 -8.0 -49,248 06 0.00 -8.0 -49,248 0 6 0.00 -8.0 -49,248 07 0.00 -8.0 -49,248 0 7 0.00 -8.0 -49,248 08 0.00 -8.0 -49,248 0 8 0.00 -8.0 -49,248 09 0.00 -8.0 -49,248 0 9 0.00 -8.0 -49,248 010 0.00 -8.0 -49,248 0 10 0.00 -8.0 -49,248 011 0.00 -8.0 -49,248 0 11 0.00 -8.0 -49,248 012 0.00 -8.0 -49,248 0 12 0.00 -8.0 -49,248 013 0.00 -8.0 -49,248 0 13 0.00 -8.0 -49,248 014 0.00 -8.0 -49,248 0 14 0.00 -8.0 -49,248 015 0.00 -8.0 -49,248 0 15 0.00 -8.0 -49,248 016 0.00 -8.0 -49,248 0 16 0.00 -8.0 -49,248 017 0.00 -8.0 -49,248 0 17 0.00 -8.0 -49,248 018 0.00 -8.0 -49,248 0 18 0.00 -8.0 -49,248 019 0.00 -8.0 -49,248 0 19 0.00 -8.0 -49,248 020 0.00 -8.0 -49,248 0 20 0.00 -8.0 -49,248 021 0.00 -8.0 -49,248 0 21 0.00 -8.0 -49,248 022 0.00 -8.0 -49,248 0 22 0.00 -8.0 -49,248 023 0.00 -8.0 -49,248 0 23 0.00 -8.0 -49,248 024 0.00 -8.0 -49,248 0 24 0.00 -8.0 -49,248 025 0.00 -8.0 -49,248 0 25 0.00 -8.0 -49,248 026 0.00 -8.0 -49,248 0 26 0.00 -8.0 -49,248 027 0.00 -8.0 -49,248 0 27 0.00 -8.0 -49,248 028 0.00 -8.0 -49,248 0 28 0.00 -8.0 -49,248 029 0.00 -8.0 -49,248 0 29 0.00 -8.0 -49,248 030 0.00 -8.0 -49,248 0 30 0.00 -8.0 -49,248 031 0.00 -8.0 -49,248 0 31 0.00 -8.0 -49,248 0

Overall Total 0.00 0 0.0 0 0.0 0 Overall Total 0.00 0 0.0 0 0.0 0

Important Notes:

Created by: Dondave Jabay, 07/01/2010

Note: For Companies under 40-Hrs WorkweekIf your company has just implemented the 40-Hrs Workweek System (currently changed from 44-hrs), within 3-yrs from its implementation, the first 4-hrs OT salary per week shall only have 0.25% additional overtime charge. Therefore, since 1-

month has 4-weeks, so 16,440won (4hrs x 4weeks x 4,110won x 0.25%) shall be deducted from your Gross Salary.

Net Salary = Gross Salary ─ 16,440won ─ other expected deductions

Monthly Basic Wage(40-Hrs Work Week)

Monthly Basic Wage(44-Hrs Work Week)

Net Salary (Gross Salary ─ all applicable deductions)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

I.) Expected Net Salary = Gross Salary ─ Kukmin (국민연금), Health Insurance (건강보험), Income Tax (소득세), Resident Tax (주민세), & Employment Insurance (고용보험 - Optional)II.) Expected Deductions (As of 2010):

1) Kukmin (국민연금) = average monthly salary x 4.5% (uniform deduction monthly but will be changed by NPS Office after 1-year according to average monthly salary during the previous year)

2) Health Insurance (건강보험) = average monthly salary x 2.665% (uniform deduction monthly will be changed after 1-year, normally in the month of April the following year due to overtime affecting the monthly average salary)

3) Income Tax (소득세) = gross monthly salary x 0.7% ~ 0.8%. Or use the Monthly Withholding Tax Auto Calculator at NTS website… You may click below url…

http://www.nts.go.kr/eng/help/help_56.asp?top_code=H001&sub_code=HS05&ssub_code=HSE54) Resident Tax (주민세) = Monthly Income Tax x 10%

5) Employment Insurance (고용보험 - Optional) = average monthly salary x 0.45%

6) Return Cost Insurance (출국보험) = only 400,000won shall be deducted by Samsung Insurance Company per sojourn period… It could be one time deduction or distributed monthly.

B12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
C12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
S12
ND = Night Differential
W12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
X12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
AN12
ND = Night Differential
Page 8: Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker

Daily Overtime Wage Auto-Monitoring Sheet for EPS Worker8:00

2010 Minimum Wage Computation / Total (Won) Month: No. of Days Work:

Minimum Wage/Hour 4,110 Total Overtime Wage (Won) = 0

209hrs x 4110won = 858,990 Total Night Differential Wage (Won) = 0

226hrs x 4110won = 928,860 Gross Salary (40-Hrs Work Week) (Won) = 858,990

Overtime Rate/Hour 1hr x 4110won x 150% = 6,156 Gross Salary (44-Hrs Work Week) (Won) = 928,860

Night Differential/Hour 1hr x 4110won x 50% = 2,055 =

Dayshift Nightshift

Day Time-in Time-out Breaktime Total OT Day Time-in Time-out Breaktime Total OT

Ex. sat 44 9:00 23:00 14.00 1 9.0 55,404 1.0 2,055 Ex. sh 20:00 9:00 13.00 1 12.0 73,872 7.0 14,385

1 0.00 -8.0 -49,248 0 1 0.00 -8.0 -49,248 02 0.00 -8.0 -49,248 0 2 0.00 -8.0 -49,248 03 0.00 -8.0 -49,248 0 3 0.00 -8.0 -49,248 04 0.00 -8.0 -49,248 0 4 0.00 -8.0 -49,248 05 0.00 -8.0 -49,248 0 5 0.00 -8.0 -49,248 06 0.00 -8.0 -49,248 0 6 0.00 -8.0 -49,248 07 0.00 -8.0 -49,248 0 7 0.00 -8.0 -49,248 08 0.00 -8.0 -49,248 0 8 0.00 -8.0 -49,248 09 0.00 -8.0 -49,248 0 9 0.00 -8.0 -49,248 010 0.00 -8.0 -49,248 0 10 0.00 -8.0 -49,248 011 0.00 -8.0 -49,248 0 11 0.00 -8.0 -49,248 012 0.00 -8.0 -49,248 0 12 0.00 -8.0 -49,248 013 0.00 -8.0 -49,248 0 13 0.00 -8.0 -49,248 014 0.00 -8.0 -49,248 0 14 0.00 -8.0 -49,248 015 0.00 -8.0 -49,248 0 15 0.00 -8.0 -49,248 016 0.00 -8.0 -49,248 0 16 0.00 -8.0 -49,248 017 0.00 -8.0 -49,248 0 17 0.00 -8.0 -49,248 018 0.00 -8.0 -49,248 0 18 0.00 -8.0 -49,248 019 0.00 -8.0 -49,248 0 19 0.00 -8.0 -49,248 020 0.00 -8.0 -49,248 0 20 0.00 -8.0 -49,248 021 0.00 -8.0 -49,248 0 21 0.00 -8.0 -49,248 022 0.00 -8.0 -49,248 0 22 0.00 -8.0 -49,248 023 0.00 -8.0 -49,248 0 23 0.00 -8.0 -49,248 024 0.00 -8.0 -49,248 0 24 0.00 -8.0 -49,248 025 0.00 -8.0 -49,248 0 25 0.00 -8.0 -49,248 026 0.00 -8.0 -49,248 0 26 0.00 -8.0 -49,248 027 0.00 -8.0 -49,248 0 27 0.00 -8.0 -49,248 028 0.00 -8.0 -49,248 0 28 0.00 -8.0 -49,248 029 0.00 -8.0 -49,248 0 29 0.00 -8.0 -49,248 030 0.00 -8.0 -49,248 0 30 0.00 -8.0 -49,248 031 0.00 -8.0 -49,248 0 31 0.00 -8.0 -49,248 0

Overall Total 0.00 0 0.0 0 0.0 0 Overall Total 0.00 0 0.0 0 0.0 0

Important Notes:

Created by: Dondave Jabay, 07/01/2010

Note: For Companies under 40-Hrs WorkweekIf your company has just implemented the 40-Hrs Workweek System (currently changed from 44-hrs), within 3-yrs from its implementation, the first 4-hrs OT salary per week shall only have 0.25% additional overtime charge. Therefore, since 1-

month has 4-weeks, so 16,440won (4hrs x 4weeks x 4,110won x 0.25%) shall be deducted from your Gross Salary.

Net Salary = Gross Salary ─ 16,440won ─ other expected deductions

Monthly Basic Wage(40-Hrs Work Week)

Monthly Basic Wage(44-Hrs Work Week)

Net Salary (Gross Salary ─ all applicable deductions)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

Sat / Sun /

Holiday40hrs/ 44hrs

Total Work Hrs

OT Salary (Won)

ND Work Hrs (10PM~6AM)

ND Salary (Won)

I.) Expected Net Salary = Gross Salary ─ Kukmin (국민연금), Health Insurance (건강보험), Income Tax (소득세), Resident Tax (주민세), & Employment Insurance (고용보험 - Optional)II.) Expected Deductions (As of 2010):

1) Kukmin (국민연금) = average monthly salary x 4.5% (uniform deduction monthly but will be changed by NPS Office after 1-year according to average monthly salary during the previous year)

2) Health Insurance (건강보험) = average monthly salary x 2.665% (uniform deduction monthly will be changed after 1-year, normally in the month of April the following year due to overtime affecting the monthly average salary)

3) Income Tax (소득세) = gross monthly salary x 0.7% ~ 0.8%. Or use the Monthly Withholding Tax Auto Calculator at NTS website… You may click below url…

http://www.nts.go.kr/eng/help/help_56.asp?top_code=H001&sub_code=HS05&ssub_code=HSE54) Resident Tax (주민세) = Monthly Income Tax x 10%

5) Employment Insurance (고용보험 - Optional) = average monthly salary x 0.45%

6) Return Cost Insurance (출국보험) = only 400,000won shall be deducted by Samsung Insurance Company per sojourn period… It could be one time deduction or distributed monthly.

B12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
C12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
S12
ND = Night Differential
W12
Note: Put letter "sat" on the blank cell if working day is Saturday. Put letter "sh" if working day is Sunday and other holidays. Refer to example in the 1st row… If weekdays, leave it blank.
X12
Note: If working day is Saturday, put number "44" on the blank cell if the company is under 44-hrs workweek while put number "40" if the company is under 40-hrs workweek system. Refer to example in the 1st row… If other days, leave it blank.
AN12
ND = Night Differential