Hi Manu,
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 many other aspects to assist in decision-making. With the help of MIS, you can prepare various reports such as annual attrition, region-wise attrition, region-wise manpower, graphical representation of regions' manpower status, and more.
You can prepare the same at your end. It will help you prepare other such formats as well.
I am describing the contents to you sheet-wise.
First Sheet -
Details of employees:
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 qualifications
l. Total Experience
Second Sheet -
Salary structure:
In this sheet, write down the complete salary structure and include a column for the salary after any revision.
Third Sheet -
New Joinees:
In this sheet, list the names of New joinees of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet -
Resigned employees:
In this sheet, list the names of employees who resigned during that particular month with details such as name, designation, date of joining, date of resignation, last working day.
Fifth Sheet -
Attrition rate:
Based on this MIS report, you can find out the attrition rate, qualification analysis reports, team management reports, and more can be prepared.
Regards,
Amit Seth.