How To Prepare Manpower, Leave, Absenteesm Statement

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

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.

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.

Dear
please see attached file
Rahul

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

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 [Login to view]
Thanks
Pooja

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

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

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

hi this is sharik
i need urgently a format for manpower information system and wat all thingd can be calculated and analysed from it except attrition joining separation retention
and wat are other attributes that can be analyzed..
plz help me out for project