No Tags Found!

sridharan
5

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
Amitmhrm
496

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
Amitmhrm
496

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
rahul wagh
8

Dear please see attached file Rahul
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls mis_report_1__832.xls (35.0 KB, 1822 views)

mili123
2

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
HR Recruiter
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
sridharan
5

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
Reetu Gaur
4

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
rainasy
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
mohammedsharik
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

From India, Pune
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.