CTC Annexure

Hey friends ..I want to share a CTC Annexure in excel file where you just put Yearly CTC amount and your CTC monthly and yearly breakup will calculated.
So I just want input from you guys like the various CTC component.

Maharashtra Labor Welfare Fund (MLWF)

Hey Friends…

It is December month so don’t forget to consider MLWF

Maharashtra Labor Welfare Fund (MLWF)

The Maharashtra Labour Welfare Fund Act, 1953

• MLWF is effective from 1953.

• It is applicable to all the companies in the state that has 05 or more person employed, who are considered contract labours as per the Act.

• Includes all employee, including employee through contractor, except those working in the managerial or supervisory position and drawing wages more than Rs. 3,500/- per month

 

How to Calculate:-

• For employees who earn equal or less than Rs 3000

Rs 6 (Employee Contribution) Rs 18 (Employer Contribution) i.e. Rs 24 total Contribution.

This is excluding manager & person working as a supervisor drawing salary above Rs.3,500/-p.m.

• For employees who earn equal or greater than Rs 3000

Rs 12 (Employee Contribution) Rs 36 (Employer Contribution) i.e. Rs 48 total Contribution.

This is excluding manager & person working as a supervisor drawing salary above Rs.3,500/-p.m.

 Due and Payable:- Two times in a Financial year:-

• Due periodicity is 30^th June  and last date is 15^th of July
• Due periodicity is 31^st December and last date is 15^th of January

Useful Excel Trick in HR Payroll

Hey Friends...

As in HR there are some excel formula which makes our task easy.

Today will learn to know the exact years month and day from a specific date to till specific date.

Please follow... if you have any query please comment.

DOB	Today Date	Total Period
15-Aug-90	07-Dec-18	28Years 3Months 23Days

DOB	Today Date	Total Period
15-Aug-90	07-Dec-18	DATEDIF(A2,B2,"Y")&"Years "&DATEDIF(A2,B2,"YM")&"Months "&DATEDIF(A2,B2,"MD")&"Days "

Needs of Training in HR

1. Needs Assessment questionnaire
2. Employees opinions
3. Exit Interview
4. Employee Grievances
5. Accidents and Scrap
6. Change in Team or Technical procedure
7. Performance Appraisal
8. Observations
9. Assessment center
10. Employee skill Test