Hi Maxne,
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, such as identifying reasons for resignation, areas with high attrition rates, and various other aspects to facilitate decision-making. With the help of MIS, you can prepare numerous reports like annual attrition, region-wise attrition, region-wise manpower distribution, graphical representation of regional manpower status, and more.
You can also prepare similar reports at your end, as it will aid you in creating other formats as well. I am outlining the contents sheet-wise:
First Sheet-
Details of employees:
a. E. Code
b. Name of the 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, document the complete salary structure and include a column for post-revision salaries.
Third Sheet -
New Joinees:
List the names of new joiners for that month with details like CTC, Designation, DOB, etc.
Fourth Sheet -
Resigned employees:
List the employees who resigned during that particular month, including their name, designation, date of joining, date of resignation, and last working day.
Fifth Sheet -
Attrition rate:
Based on this MIS report, you can generate attrition reports, qualification analysis reports, team management reports, and more.
Regards,
Amit Seth