Hi Kuldeep,
MIS report is known as Management Information System regarding the Manpower status of a particular month, place, and overall. It helps management in decision-making, such as identifying reasons for resignation, areas with high attrition, and other factors crucial for decision-making. With the help of MIS, you can prepare various reports, including 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 similar formats as well.
I am describing the contents 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 include a column for salary after any revision.
Third Sheet -
New Joinees
In this sheet, list the names of new joiners 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 like name, designation, date of joining, date of resignation, last working day.
Fifth Sheet -
Attrition rate
Apart from this, you may include welfare activities conducted in that month, PF and ESI status on another sheet, and other relevant activities.
Based on this MIS report, you can derive attrition reports, qualification analysis reports, team management reports, and more.
Regards,
Amit Seth.