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
Acknowledge(0)
Amend(0)
From United Arab Emirates, Abu Dhabi
Acknowledge(0)Amend(0)
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 for 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. It will help you to prepare other such formats too.
I am describing 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 for the salary after any revision.
Third Sheet -
New Joinees: In this sheet, write down the name of New joinees of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet-
Resigned employees: In this sheet, write the names 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
Acknowledge(0)Amend(0)
508MIS 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 for 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. It will help you to prepare other such formats too.
I am describing 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 for the salary after any revision.
Third Sheet -
New Joinees: In this sheet, write down the name of New joinees of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet-
Resigned employees: In this sheet, write the names 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
Acknowledge(0)Amend(0)
Hi Amit,
The format you are using and which I used while I was in India is the same. One thing I would like to add is the first sheet, showing our Manpower Budget. This sheet will include the Budgeted figure, Actual figure, positive or negative variance, and the reasons for that in the notes column.
Bibhutosh Bhadauria
From Australia, Balwyn
Acknowledge(0)Amend(0)
The format you are using and which I used while I was in India is the same. One thing I would like to add is the first sheet, showing our Manpower Budget. This sheet will include the Budgeted figure, Actual figure, positive or negative variance, and the reasons for that in the notes column.
Bibhutosh Bhadauria
From Australia, Balwyn
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Emplyee Database Management.xls
Employee Management.docx