0% found this document useful (0 votes)
46 views21 pages

Bonus Calculation

The document outlines the steps for calculating employee bonuses based on eligibility, maximum wage ceilings, and applicable bonus rates. It includes specific wage ceilings for different categories of employment and provides examples of bonus calculations for various employees across different states. Additionally, it lists the required information for annual bonus calculations and provides minimum wage data for several months.

Uploaded by

anand.steel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
46 views21 pages

Bonus Calculation

The document outlines the steps for calculating employee bonuses based on eligibility, maximum wage ceilings, and applicable bonus rates. It includes specific wage ceilings for different categories of employment and provides examples of bonus calculations for various employees across different states. Additionally, it lists the required information for annual bonus calculations and provides minimum wage data for several months.

Uploaded by

anand.steel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Bonus Calculation Steps

Find the Eligibility of Employee for Bonus


Step 1 If Basic + DA is <= RS21000 p.m
If Basic + DA is > RS21000 p.m

Find the maximum wage ceiling for Bonus Calculation


Heighest of the Following
Step 2
- Rs. 7000, or
- Minimum wage of the state for the scheduled employment

Find Bonus Wage


Step 3 - If Basic + DA is <= Max. Wage Ceiling, then Take Basic + DA as Bonus Wage
- If Basic + DA is > Max. Wage Ceiling, then Take Max. Wage ceiling as Bonus Wage

Step 4 Apply Rate of Bonus on the above Bonus Wage


Basic + DA 11000

Eligibility

Eligible

Max Wage Ceiling Punjab (M.W)


Czatagory Amount
8000 Unskilled 8000
Semi Skilled 8500
Highly Skilled 11000
Bonu Wage
Rate of Bonus 8.33%
8000

Bonus ₹ 666.40
Requirements for Annual Bonus calculation
1 Employee Basic details ([Link] / Employee Name / Date of Joining)
2 State of Posting
3 Minimum Wage of the State
4 Category of employee (Unskilled, Semi-Skilled, Skilled, Highly-Skilled, etc.)
5 Fixed Basic +DA from April to March
6 Paid Basic +DA from April to March on the basis of employee Attendance
7 Rate of Bonus (8.33% - 20%)
Bonus Calculation

Find the Eligibility of Employee for Bonus


Step 1 If Basic + DA is <= RS21000 p.m
If Basic + DA is > RS21000 p.m

Find the maximum wage ceiling for Bonus Calculation


Heighest of the Following
Step 2
- Rs. 7000, or
- Minimum wage of the state for the scheduled employment

Find Bonus Wage


- If Basic + DA is <= Max. Wage Ceiling, then Take Basic + DA
Step 3 as Bonus Wage
- If Basic + DA is > Max. Wage Ceiling, then Take Max. Wage ceiling
as Bonus Wage

Step 4 Apply Rate of Bonus on the above Bonus Wage


Basic + DA Punjab
Czatagory Amount
Eligibility Unskilled 8000
Semi Skilled 8500
Highly Skilled 11000

Max Wage Ceiling Rate of Bonus 8.33%

Bonu Wage

Bonus ₹ -
Minimum Wage (

Rate of Bonus 20%


State Unskilled Semi-Skilled
Delhi 15492 17069
Haryana 9458 9931
Uttar Pradesh 9078 9985

Apr-20

Date of Empoloyment Minimum Basic + DA


[Link] [Link] Name Joining State Catagory Wage (Fixed)
1 IM/001 Dummy 1 5/2/2018 Delhi Unskilled 15492 16000
2 IM/002 Dummy 2 5/3/2018 Haryana Highly Skilled 12071 22000
3 IM/003 Dummy 3 5/4/2018 Haryana Unskilled 9458 10000
4 IM/004 Dummy 4 5/5/2018 Delhi Skilled 18797 19000
5 IM/005 Dummy 5 5/6/2018 Delhi Skilled 18797 19000
6 IM/006 Dummy 6 5/7/2018 Delhi Unskilled 15492 15500
7 IM/007 Dummy 7 5/8/2018 Uttar Pradesh Unskilled 9078 9500
8 IM/008 Dummy 8 5/9/2018 Delhi Non-Matriculate 17069 17100
9 IM/009 Dummy 9 5/10/2018 Uttar Pradesh Unskilled 9078 9100
10 IM/010 Dummy 10 5/11/2018 Uttar Pradesh Unskilled 9078 9100
Total 134411 146300
Minimum Wage (April 2020)
Matriculate
Highly Non- but not Graduate &
Skilled Skilled Matriculate Graduate Above
18797 0 17069 18797 20430
10949 12071 9931 10428 10949
11185 0 0 0 0

Apr-20
Step 1 Step 2 30 Step 3 Step 4

Bonus Max Wage Basic + DA Bonus Bonus


Eligibility Ceiling Days Present (Paid) Wage Calculated State
Eligible 15492 30 16000 15492 3098 Delhi
Not Eligible 0 30 22000 0 0 Haryana
Eligible 9458 30 10000 9458 1892 Haryana
Eligible 18797 25 15833 15833 3167 Delhi
Eligible 18797 30 19000 18797 3759 Delhi
Eligible 15492 21 10850 10850 2170 Delhi
Eligible 9078 30 9500 9078 1816 Uttar Pradesh
Eligible 17069 30 17100 17069 3414 Delhi
Eligible 9078 30 9100 9078 1816 Uttar Pradesh
Eligible 9078 30 9100 9078 1816 Uttar Pradesh
122339 286 138483 114733 22948 Total
Minimum Wage (May 2020)
Matriculate
Highly Non- but not Graduate
State Unskilled Semi-Skilled Skilled Skilled Matriculate Graduate & Above
Delhi 15492 17069 18797 0 17069 18797 20430
Haryana 9458 9931 10949 12071 9931 10428 10949
Uttar Pradesh 9078 9985 11185 0 0 0 0

May-20
Step 1 Step 2 31 Step 3
Max
Empoloyment Minimum Basic + DA Bonus Wage Basic + DA Bonus
Catagory Wage (Fixed) Eligibility Ceiling Days Present (Paid) Wage
Unskilled 15492 16000 Yes 15492 31 16000 15492
Highly Skilled 12071 22000 No 0 31 22000 0
Unskilled 9458 10000 Yes 9458 31 10000 9458
Skilled 18797 19000 Yes 18797 31 19000 18797
Skilled 18797 19000 Yes 18797 31 19000 18797
Unskilled 15492 15500 Yes 15492 25 12500 12500
Unskilled 9078 9500 Yes 9078 31 9500 9078
Non-Matriculate 17069 17100 Yes 17069 31 17100 17069
Unskilled 9078 9100 Yes 9078 30 8806 8806
Unskilled 9078 9100 Yes 9078 31 9100 9078
Total 134411 146300 122339 303 143006 119075
Minimum Wage (June 2020)

Highly Non-
State Unskilled Semi-Skilled Skilled Skilled Matriculate
Delhi 15492 17069 18797 0 17069
Haryana 9458 9931 10949 12071 9931
Uttar Pradesh 9078 9985 11185 0 0

Jun-20
Step 4 Step 1 Step 2 30
Bonus Max
Calculate Empoloyment Minimum Basic + DA Bonus Wage
d State Catagory Wage (Fixed) Eligibility Ceiling Days Present
3098 Delhi Unskilled 15492 16000 Yes 15492 30
0 Haryana Highly Skilled 12071 22000 No 0 30
1892 Haryana Unskilled 9458 10000 Yes 9458 30
3759 Delhi Skilled 18797 19000 Yes 18797 25
3759 Delhi Skilled 18797 19000 Yes 18797 30
2500 Delhi Unskilled 15492 15500 Yes 15492 21
1816 Uttar Pradesh Unskilled 9078 9500 Yes 9078 30
3414 Delhi Non-Matriculate 17069 17100 Yes 17069 30
1761 Uttar Pradesh Unskilled 9078 9100 Yes 9078 30
1816 Uttar Pradesh Unskilled 9078 9100 Yes 9078 30
23815 Total 134411 146300 122339 286
Minimum Wage (July 2020)
Matriculate
but not Graduate
Graduate & Above State Unskilled Semi-Skilled Skilled
18797 20430 Delhi 15492 17069 18797
10428 10949 Haryana 9458 9931 10949
0 0 Uttar Pradesh 9078 9985 11185

Jul-20
30 Step 3 Step 4 Step 1
Bonus
Basic + DA Bonus Calculate Empoloyment Minimum Basic + DA Bonus
(Paid) Wage d State Catagory Wage (Fixed) Eligibility
16000 15492 3098 Delhi Unskilled 15492 16000 Yes
22000 0 0 Haryana Highly Skilled 12071 22000 No
10000 9458 1892 Haryana Unskilled 9458 10000 Yes
15833 15833 3167 Delhi Skilled 18797 19000 Yes
19000 18797 3759 Delhi Skilled 18797 19000 Yes
10850 10850 2170 Delhi Unskilled 15492 15500 Yes
9500 9078 1816 Uttar Pradesh Unskilled 9078 9500 Yes
17100 17069 3414 Delhi Non-Matriculate 17069 17100 Yes
9100 9078 1816 Uttar Pradesh Unskilled 9078 9100 Yes
9100 9078 1816 Uttar Pradesh Unskilled 9078 9100 Yes
138483 114733 22947 Total 134411 146300
um Wage (July 2020) Minimum
Matriculate
Highly Non- but not Graduate
Skilled Matriculate Graduate & Above State Unskilled
0 17069 18797 20430 Delhi 15492
12071 9931 10428 10949 Haryana 9458
0 0 0 0 Uttar Pradesh 9078

Jul-20 A
Step 2 31 Step 3 Step 4
Max
Wage Basic + DA Bonus Bonus Empoloyment Minimum
Ceiling Days Present (Paid) Wage Calculated State Catagory Wage
15492 31 16000 15492 3098 Delhi Skilled 18797
0 31 22000 0 0 Haryana Highly Skilled 12071
9458 31 10000 9458 1892 Haryana Unskilled 9458
18797 25 15323 15323 3065 Delhi Skilled 18797
18797 31 19000 18797 3759 Delhi Skilled 18797
15492 21 10500 10500 2100 Delhi Unskilled 15492
9078 31 9500 9078 1816 Uttar Pradesh Unskilled 9078
17069 31 17100 17069 3414 Delhi Non-Matriculate 17069
9078 31 9100 9078 1816 Uttar Pradesh Unskilled 9078
9078 31 9100 9078 1816 Uttar Pradesh Unskilled 9078
122339 294 137623 113873 22775 Total 137716
Minimum Wage (Aug 2020)
Matriculate
Highly Non- but not Graduate
Semi-Skilled Skilled Skilled Matriculate Graduate & Above
17069 18797 0 17069 18797 20430
9931 10949 12071 9931 10428 10949
9985 11185 0 0 0 0

Aug-20
Step 1 Step 2 31 Step 3 Step 4
Max
Basic + DA Bonus Wage Basic + DA Bonus Bonus
(Fixed) Eligibility Ceiling Days Present (Paid) Wage Calculated State
16000 Yes 18797 31 16000 16000 3200 Delhi
22000 No 0 31 22000 0 0 Haryana
10000 Yes 9458 31 10000 9458 1892 Haryana
19000 Yes 18797 25 15323 15323 3065 Delhi
19000 Yes 18797 31 19000 18797 3759 Delhi
15500 Yes 15492 21 10500 10500 2100 Delhi
9500 Yes 9078 31 9500 9078 1816 Uttar Pradesh
17100 Yes 17069 31 17100 17069 3414 Delhi
9100 Yes 9078 31 9100 9078 1816 Uttar Pradesh
9100 Yes 9078 31 9100 9078 1816 Uttar Pradesh
146300 125644 294 137623 114381 22876 Total
Minimum Wage (Sep 2020)
Matriculate
Highly Non- but not Graduate
State Unskilled Semi-Skilled Skilled Skilled Matriculate Graduate & Above
Delhi 15492 17069 18797 0 17069 18797 20430
Haryana 9458 9931 10949 12071 9931 10428 10949
Uttar Pradesh 9078 9985 11185 0 0 0 0

Sep-20
Step 1 Step 2 30 Step 3
Max
Empoloyment Minimum Basic + DA Bonus Wage Basic + DA Bonus
Catagory Wage (Fixed) Eligibility Ceiling Days Present (Paid) Wage
Unskilled 15492 16000 Yes 15492 30 16000 15492
Highly Skilled 12071 22000 No 0 30 22000 0
Unskilled 9458 10000 Yes 9458 30 10000 9458
Skilled 18797 19000 Yes 18797 25 15833 15833
Skilled 18797 19000 Yes 18797 30 19000 18797
Unskilled 15492 15500 Yes 15492 21 10850 10850
Unskilled 9078 9500 Yes 9078 30 9500 9078
Non-Matriculate 17069 17100 Yes 17069 30 17100 17069
Unskilled 9078 9100 Yes 9078 30 9100 9078
Unskilled 9078 9100 Yes 9078 30 9100 9078
Total 134411 146300 122339 286 138483 114733
Minimum Wage (Oct 2020)

Highly Non-
State Unskilled Semi-Skilled Skilled Skilled Matriculate
Delhi 15492 17069 18797 0 17069
Haryana 9458 9931 10949 12071 9931
Uttar Pradesh 9078 9985 11185 0 0

Oct-20
Step 4 Step 1 Step 2 31
Bonus Max
Calculate Empoloyment Minimum Basic + DA Bonus Wage
d State Catagory Wage (Fixed) Eligibility Ceiling Days Present
3098 Delhi Unskilled 15492 16000 Yes 15492 31
0 Haryana Highly Skilled 12071 22000 No 0 31
1892 Haryana Unskilled 9458 10000 Yes 9458 31
3167 Delhi Skilled 18797 19000 Yes 18797 25
3759 Delhi Skilled 18797 19000 Yes 18797 31
2170 Delhi Unskilled 15492 15500 Yes 15492 21
1816 Uttar Pradesh Unskilled 9078 9500 Yes 9078 31
3414 Delhi Non-Matriculate 17069 17100 Yes 17069 31
1816 Uttar Pradesh Unskilled 9078 9100 Yes 9078 31
1816 Uttar Pradesh Unskilled 9078 9100 Yes 9078 31
22947 Total 134411 146300 122339 294
Minimum Wage (Nov 2020)
Matriculate
but not Graduate
Graduate & Above State Unskilled Semi-Skilled Skilled
18797 20430 Delhi 15492 17069 18797
10428 10949 Haryana 9458 9931 10949
0 0 Uttar Pradesh 9078 9985 11185

Nov-20
31 Step 3 Step 4 Step 1
Bonus
Basic + DA Bonus Calculate Empoloyment Minimum Basic + DA Bonus
(Paid) Wage d State Catagory Wage (Fixed) Eligibility
16000 15492 3098 Delhi Unskilled 15492 16000 Yes
22000 0 0 Haryana Highly Skilled 12071 22000 No
10000 9458 1892 Haryana Unskilled 9458 10000 Yes
15323 15323 3065 Delhi Skilled 18797 19000 Yes
19000 18797 3759 Delhi Skilled 18797 19000 Yes
10500 10500 2100 Delhi Unskilled 15492 15500 Yes
9500 9078 1816 Uttar Pradesh Unskilled 9078 9500 Yes
17100 17069 3414 Delhi Non-Matriculate 17069 17100 Yes
9100 9078 1816 Uttar Pradesh Unskilled 9078 9100 Yes
9100 9078 1816 Uttar Pradesh Unskilled 9078 9100 Yes
137623 113873 22775 Total 134411 146300
um Wage (Nov 2020) Minimum
Matriculate
Highly Non- but not Graduate
Skilled Matriculate Graduate & Above State Unskilled
0 17069 18797 20430 Delhi 15492
12071 9931 10428 10949 Haryana 9458
0 0 0 0 Uttar Pradesh 9078

Nov-20 D
Step 2 30 Step 3 Step 4
Max Bonus
Wage Basic + DA Bonus Calculate Empoloyment Minimum
Ceiling Days Present (Paid) Wage d State Catagory Wage
15492 30 16000 15492 3098 Delhi Unskilled 15492
0 30 22000 0 0 Haryana Highly Skilled 12071
9458 30 10000 9458 1892 Haryana Unskilled 9458
18797 25 15833 15833 3167 Delhi Skilled 18797
18797 30 19000 18797 3759 Delhi Skilled 18797
15492 21 10850 10850 2170 Delhi Unskilled 15492
9078 30 9500 9078 1816 Uttar Pradesh Unskilled 9078
17069 30 17100 17069 3414 Delhi Non-Matriculate 17069
9078 30 9100 9078 1816 Uttar Pradesh Unskilled 9078
9078 30 9100 9078 1816 Uttar Pradesh Unskilled 9078
122339 286 138483 114733 22947 Total 134411
Minimum Wage (Dec 2020)
Matriculate
Highly Non- but not Graduate
Semi-Skilled Skilled Skilled Matriculate Graduate & Above
17069 18797 0 17069 18797 20430
9931 10949 12071 9931 10428 10949
9985 11185 0 0 0 0

Dec-20
Step 1 Step 2 31 Step 3 Step 4
Max Bonus
Basic + DA Bonus Wage Basic + DA Bonus Calculate
(Fixed) Eligibility Ceiling Days Present (Paid) Wage d State
16000 Yes 15492 31 16000 15492 3098 Delhi
22000 No 0 31 22000 0 0 Haryana
10000 Yes 9458 31 10000 9458 1892 Haryana
19000 Yes 18797 25 15323 15323 3065 Delhi
19000 Yes 18797 31 19000 18797 3759 Delhi
15500 Yes 15492 21 10500 10500 2100 Delhi
9500 Yes 9078 31 9500 9078 1816 Uttar Pradesh
17100 Yes 17069 31 17100 17069 3414 Delhi
9100 Yes 9078 31 9100 9078 1816 Uttar Pradesh
9100 Yes 9078 31 9100 9078 1816 Uttar Pradesh
146300 122339 294 137623 113873 22775 Total
Minimum Wage (Jan 2021)
Matriculate
Highly Non- but not Graduate
State Unskilled Semi-Skilled Skilled Skilled Matriculate Graduate & Above
Delhi 15492 17069 18797 0 17069 18797 20430
Haryana 9458 9931 10949 12071 9931 10428 10949
Uttar Pradesh 9078 9985 11185 0 0 0 0

Jan-21
Step 1 Step 2 31 Step 3
Max
Empoloyment Minimum Basic + DA Bonus Wage Basic + DA Bonus
Catagory Wage (Fixed) Eligibility Ceiling Days Present (Paid) Wage
Unskilled 15492 16000 Yes 15492 31 16000 15492
Highly Skilled 12071 22000 No 0 31 22000 0
Unskilled 9458 10000 Yes 9458 31 10000 9458
Skilled 18797 19000 Yes 18797 25 15323 15323
Skilled 18797 19000 Yes 18797 31 19000 18797
Unskilled 15492 15500 Yes 15492 21 10500 10500
Unskilled 9078 9500 Yes 9078 31 9500 9078
Non-Matriculate 17069 17100 Yes 17069 31 17100 17069
Unskilled 9078 9100 Yes 9078 31 9100 9078
Unskilled 9078 9100 Yes 9078 31 9100 9078
Total 134411 146300 122339 294 137623 113873
Minimum Wage (Feb 2021)

Highly Non-
State Unskilled Semi-Skilled Skilled Skilled Matriculate
Delhi 15492 17069 18797 0 17069
Haryana 9458 9931 10949 12071 9931
Uttar Pradesh 9078 9985 11185 0 0

Feb-21
Step 4 Step 1 Step 2 28
Bonus Max
Calculate Empoloyment Minimum Basic + DA Bonus Wage
d State Catagory Wage (Fixed) Eligibility Ceiling Days Present
3098 Delhi Unskilled 15492 16000 Yes 15492 28
0 Haryana Highly Skilled 12071 22000 No 0 28
1892 Haryana Unskilled 9458 10000 Yes 9458 28
3065 Delhi Skilled 18797 19000 Yes 18797 25
3759 Delhi Skilled 18797 19000 Yes 18797 28
2100 Delhi Unskilled 15492 15500 Yes 15492 21
1816 Uttar Pradesh Unskilled 9078 9500 Yes 9078 28
3414 Delhi Non-Matriculate 17069 17100 Yes 17069 28
1816 Uttar Pradesh Unskilled 9078 9100 Yes 9078 28
1816 Uttar Pradesh Unskilled 9078 9100 Yes 9078 28
22775 Total 134411 146300 122339 270
Minimum Wage (Mar 2021)
Matriculate
but not Graduate
Graduate & Above State Unskilled Semi-Skilled Skilled
18797 20430 Delhi 15492 17069 18797
10428 10949 Haryana 9458 9931 10949
0 0 Uttar Pradesh 9078 9985 11185

Mar-21
28 Step 3 Step 4 Step 1

Basic + DA Bonus Bonus Empoloyment Minimum Basic + DA Bonus


(Paid) Wage Calculated State Catagory Wage (Fixed) Eligibility
16000 15492 3098 Delhi Unskilled 15492 16000 Yes
22000 0 0 Haryana Highly Skilled 12071 22000 No
10000 9458 1892 Haryana Unskilled 9458 10000 Yes
16964 16964 3393 Delhi Skilled 18797 19000 Yes
19000 18797 3759 Delhi Skilled 18797 19000 Yes
11625 11625 2325 Delhi Unskilled 15492 15500 Yes
9500 9078 1816 Uttar Pradesh Unskilled 9078 9500 Yes
17100 17069 3414 Delhi Non-Matriculate 17069 17100 Yes
9100 9078 1816 Uttar Pradesh Unskilled 9078 9100 Yes
9100 9078 1816 Uttar Pradesh Unskilled 9078 9100 Yes
140389 116639 23328 Total 134411 146300
um Wage (Mar 2021)
Matriculate
Highly Non- but not Graduate
Skilled Matriculate Graduate & Above
0 17069 18797 20430
12071 9931 10428 10949
0 0 0 0

Mar-21
Step 2 31 Step 3 Step 4
Max Total
Wage Basic + DA Bonus Bonus Annual
Ceiling Days Present (Paid) Wage Calculated Bonus
15492 31 16000 15492 3098 37282
0 31 22000 0 0 0
9458 31 10000 9458 1892 22700
18797 25 15323 15323 3065 38207
18797 31 19000 18797 3759 45112
15492 21 10500 10500 2100 26105
9078 31 9500 9078 1816 21788
17069 31 17100 17069 3414 40966
9078 31 9100 9078 1816 21733
9078 31 9100 9078 1816 21788
122339 294 137623 113873 22775 275680

You might also like