HR MIS Report Format
I have attached HR MIS report format in excel.
| MONTHLY HR MIS REPORT | |||||||||||
| MAN POWER PLANNING REPORT | |||||||||||
| MANPOWER DEMANDED IN TOTAL | MAN POWER REQUIREMENT PROVIDED IN TOTAL | MAN POWER DEFICENCY IN TOTAL | |||||||||
| RECRUITMENT REPORT | |||||||||||
| NEW RECRUITS IN TOTAL | DEPARTMENT WITH MAXIMUM RECRUITS | DEPARTMENT WITH MINIMUM RECRUITS | |||||||||
| ABSENTISM REPORT | |||||||||||
| ABSENTISM IN TOTAL | DEPARTMENT WITH MAXIMUM ABSENTISM | DEPARTMENT WITH MINIMUM ABSENTISM | |||||||||
| LATE COMING REPORT | |||||||||||
| LATE COMING IN TOTAL | DEPARTMENT WITH MAXIMUM LATE COMING | DEPARTMENT WITH MINIMUM LATE COMING | |||||||||
| ATTRITION REPORT | |||||||||||
| TOTAL NUMBER OF EMPLOYEE WHO LEFT | DEPARTMENT WITH MAXIMUM ATTRITION | DEPARTMENT WITH MINIMUM ATTRITION | |||||||||
| OVER-TIME REPORT | |||||||||||
| TOTAL OVER-TIME PERFORMED BY EMPLOYEES | DERPARTMENT WITH MAXIMUM OVER-TIME PERFORMED | DEPARTMENT WITH MINIMUM OVER TIME PERFORMED | |||||||||
| SALARY REPORT | |||||||||||
| TOTAL SALARY PAID | DEPARTMENT WITH MAXIMUM SALARY DEDUCTION | DEPARTMENT WITH MINIMUM SALARY DEDUCTION | |||||||||
| SALARY PAID THROUGH SALARY ACCOUNT | SALARY PAID THROUGH CHEQUES | AMOUNT PAID TO CONSULTANTS | |||||||||
| CROSS CHEQUE | |||||||||||
| BEARER CHEQUE | |||||||||||
| QUOTE ONLY TOTAL FIGURES IN ABOVE TABLE | |||||||||||
Daily and Monthly Hr MIS Report in Excel
Find enclosed herewith HR MIS :
1. Daily Deployment Report
a. Manpower Shortfall
b. Physical Absenteeism
2.Monthly MIS
a. Workers recruitment
b. Fresher’s Trainee (batch wise)
c. Attrition Rate,bi-Monthly
d. Attrition and Absenteeism Trends
e. Man days Analysis
f. Wages
h.Expenses
i. Staff Joining,Left/Transfer
Hopefully, you will find it usefull.
Daily & Monthly HR MIS Format
I have Attached Daily & Monthly HR MIS Format
| Attendance | FABRIC | CUTTING | JACKET STITCHING | TR PLATINUM | WAIST COAT | FAB. Q.C & CUTTING Q.C& W.C Q.C | QC – JACKET | QC- TROUSER | MTM | PRESSING – JACKET | PRESSING -TROUSER | TRAINING | PACKING | MAINTENANCE | STORES | SECURITY | ADMIN | RECEPTION | HOUSE KEEPING | EDP | SECURITY GUARD | JAVED (HOUSE KEEP.) | Total |  
|
|||||||||
| ON ROLL | Regular | 6 | 44 | 166 | 80 | 24 | 12 | 19 | 15 | 4 | 36 | 12 | 16 | 20 | 7 | 3 | 3 | 3 | 1 | 8 | 0 | 3 | 11 | 493 | |||||||||
| Trial | 0 | 0 | 4 | 5 | 2 | 0 | 0 | 0 | 7 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 41 | ||||||||||
| Total | 6 | 44 | 170 | 85 | 26 | 12 | 19 | 15 | 11 | 36 | 12 | 38 | 20 | 7 | 3 | 3 | 3 | 1 | 9 | 0 | 3 | 11 | 534 | ||||||||||
| SANCTION | 5 | 43 | 156 | 72 | 23 | 11 | 17 | 11 | 17 | 28 | 12 | 25 | 19 | 7 | 2 | 3 | 3 | 1 | 10 | 1 | 3 | 12 | 481 | ||||||||||
| Daily Dep. | Regular | 5 | 32 | 110 | 60 | 21 | 9 | 13 | 10 | 4 | 31 | 12 | 12 | 15 | 4 | 1 | 3 | 3 | 0 | 5 | 0 | 2 | 7 | 359 | |||||||||
| Trial | 0 | 0 | 4 | 5 | 2 | 0 | 14 | 0 | 4 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | ||||||||||
| E R (MANDAYS ) | 0 | 0 | 2.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3.75 | ||||||||||
| Total | 5 | 32 | 116 | 65 | 23 | 9 | 27 | 10 | 8 | 31 | 12 | 28 | 16.5 | 4 | 1 | 3 | 3 | 0 | 5 | 0 | 2 | 7 | 407.75 | ||||||||||
| Analysis | Shortfall | 0 | -11 | -42 | -7 | 0 | -2 | 10 | -1 | -9 | 3 | 0 | 3 | -4 | -3 | -1 | 0 | 0 | -1 | -5 | -1 | -1 | -5 | -77 | |||||||||
| Absent | 0 | 5 | 42 | 15 | 2 | 2 | 4 | 5 | 3 | 3 | 0 | 7 | 4 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 97 | |||||||||||
| Leave | 1 | 7 | 14 | 5 | 1 | 1 | 1 | 0 | 0 | 2 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36 | ||||||||||
| Phy Abs % | 17 | 27 | 33 | 24 | 12 | 0 | 26 | 33 | 27 | 14 | 0 | 26 | 25 | 43 | 67 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | ||||||||||
MIS Report
Please find attach herewith MIS Report on Hotel Project.
Categories: MIS Report Tags: MIS, Report
Categories: HR, MIS Report Tags: HR, MIS
Monthly HR MIS Report
Uploading a model Monthly HR MIS Report.
Recruitment & Monthly Head Count MIS
Please find attached Recruitment MIS.
Categories: Recruitment Format Tags: MIS, Recruitment
MIS Reports for HR
Find enclosed the formats for MIS Reports of HR Deptt.