Dear Professionals, Can any body send me about How to prepare Leave, Absenteesm, Manpower Statement . If you’ve any format please send me. Thanks & Regards, Sridharan.K
From India, Madras
5From India, Madras
Hi Sridharan,
You may maintain the attendance in a simple Excel sheet only.. start with E-Code and Name of employee, then put the column for Designation and Date of Joining.. then onwards date and month.. below them mark Present, Absent or Leave or Holiday.. by this way only you may maintain it in a very simple way.. moreover at the end put the formula and calculate all the Absent and leaves taken in that month..
Hope it will help you to do the same..
Regards,
Amit Seth.
From India, Ahmadabad
You may maintain the attendance in a simple Excel sheet only.. start with E-Code and Name of employee, then put the column for Designation and Date of Joining.. then onwards date and month.. below them mark Present, Absent or Leave or Holiday.. by this way only you may maintain it in a very simple way.. moreover at the end put the formula and calculate all the Absent and leaves taken in that month..
Hope it will help you to do the same..
Regards,
Amit Seth.
From India, Ahmadabad
Hi Sridharan,
Manpower Information system is the complete information regarding the available Manpower..
It helps the Management in decision making.. like what are the reasons of resignation.. in which area attrition is high.. and so many things to help in decision making.. with the help of MIS you may prepare a lot of reports.. Like annual attrition.. region wise attrition.. region wise manpower.. graphical representation of regions manpower status.. and so on..
You may prepare the same at your end.As it will help you to prepare other such formats too.
I am describing you the contents with sheet wise..
First Sheet-
Details of employee
a. E.Code b. Name of employee
c. Date of birth d. Designation e. CTC
f. Address for communication
g.Permanent address h. Contact number
i. Blood group j. Maximum qualification
k. Extra qualification l.Total Experience
Second Sheet-
Salary structure
In this sheet write down the complete salary structure.. and make a column what is salary after any revision
Third Sheet -
New Joinees
In this sheet write down the name of New joinees of that month with detail
like
CTC,
Designation,
DOB n etc.
Forth Sheet -
Resigned employees
In this sheet write the name of employees who resigned during
that particular month with details like name, designation, date of joining,
Date of resignation, last working day.
Fifth sheet -
Attrition rate
Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports and so on can prepare a number of reports..
Regards,
Amit Seth.
From India, Ahmadabad
Manpower Information system is the complete information regarding the available Manpower..
It helps the Management in decision making.. like what are the reasons of resignation.. in which area attrition is high.. and so many things to help in decision making.. with the help of MIS you may prepare a lot of reports.. Like annual attrition.. region wise attrition.. region wise manpower.. graphical representation of regions manpower status.. and so on..
You may prepare the same at your end.As it will help you to prepare other such formats too.
I am describing you the contents with sheet wise..
First Sheet-
Details of employee
a. E.Code b. Name of employee
c. Date of birth d. Designation e. CTC
f. Address for communication
g.Permanent address h. Contact number
i. Blood group j. Maximum qualification
k. Extra qualification l.Total Experience
Second Sheet-
Salary structure
In this sheet write down the complete salary structure.. and make a column what is salary after any revision
Third Sheet -
New Joinees
In this sheet write down the name of New joinees of that month with detail
like
CTC,
Designation,
DOB n etc.
Forth Sheet -
Resigned employees
In this sheet write the name of employees who resigned during
that particular month with details like name, designation, date of joining,
Date of resignation, last working day.
Fifth sheet -
Attrition rate
Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports and so on can prepare a number of reports..
Regards,
Amit Seth.
From India, Ahmadabad
Hi Rahul,
Thanks for sharing this MIS format actually i am also looking out for such kind of reports to maintain employee records.There are more columns which i need to add on it once i will make my MIS report i will share that with everyone.
Regards
:D
From India, Mumbai
Thanks for sharing this MIS format actually i am also looking out for such kind of reports to maintain employee records.There are more columns which i need to add on it once i will make my MIS report i will share that with everyone.
Regards
:D
From India, Mumbai
Hi All,
I am a Tech Recruiter, have never been involved into Policy making, doing it for the first time. Can anyone please provide me some material on Absenteeism and Dress code.
You can also write me at
Thanks
Pooja
From India, Ghaziabad
I am a Tech Recruiter, have never been involved into Policy making, doing it for the first time. Can anyone please provide me some material on Absenteeism and Dress code.
You can also write me at
Thanks
Pooja
From India, Ghaziabad
Hi Amit, Thanks for your immediate reply to me. Please send me how to prepare Leave and Absenteeism Statement. If you’ve any format please send it to me. Thanks & Regards, Sridharan.K
From India, Madras
From India, Madras
Hi Amit, I read the material shared by you. its really very helpful. However, there's one confusion I am having about the sheet with salary structure. how do we have salary structures of different employees on one single sheet? Please reply asap.Thanks
From India, Pune
From India, Pune
Hi all,
Please tell me how do i change my profile from placement/recruitment to core hr. I have more than 4 years of exp out of which 2 years in placment. Currently i am working as placement co ordination but i want to change as in this org it is not posssible to shift to core hr.
thnx
From India, Delhi
Please tell me how do i change my profile from placement/recruitment to core hr. I have more than 4 years of exp out of which 2 years in placment. Currently i am working as placement co ordination but i want to change as in this org it is not posssible to shift to core hr.
thnx
From India, Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Manpower Planning Form(1).xls
Manpower Requirement Form.doc