nishasraj
Hi, What are most the important parameters to set up a MIS for a company with employee strength of 300. what all fields should a master data contain? regards, Nisha
From United Arab Emirates, Abu Dhabi
Amitmhrm
496

Hi Nisha,

MIS report is known as Management Information System... regarding the Manpower status of a particular month, place and overall..

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
Bibhutosh Bhadauria
3

Hi Amit,
The format you are using and which i used while i was in India is same, one thing i like to add which will be first sheet, showing our Manpower Budget, which will include Budgeted figure, Actual figure and positive or negative variance and the reason for that in the notes column.
Bibhutosh Bhadauria

From Australia, Balwyn
srirenu1983
Hi, Employee database contain Emp Number, Emp Name, Location, Gender, DOJ, Offer letter code, HR manager name, Submitted documents
From India, Bangalore
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.