Hi,
I am sharing a MIS sheet. Please give me more input or ideas. I am working in a manufacturing plant where total manpower is 400. So this is the first step I would like to do in my section. Please help me make it more effective.
Thanks
Pooja

From India, Indore
Attached Files (Download Requires Membership)
File Type: xls Copy of Employee Master Data( M I S ).xls (205.0 KB, 2681 views)

Ya pooja just try to simplify the mis, You should put some exel formula. otherwise it makes more complicated.
From India, Mumbai
Pooja , just fin find my attach and practice it on your own pc .Then put your workplace.
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls EXCEL_Formulas2.xls (1.51 MB, 1095 views)

Key Result Areas





S. No Function Key result Areas

Miss. Pooja Sharma Mr. Kailash Tiwari Mr. Roshan Chouhan

1 Manpower Planning 1. Manpower Planing 2. Tracker Updation NA NA

2 Recruitment & Selection 1. Second round 2. Salary Negotiation, 3. Employee Orientation 4. Joining Formalities 5. List Of New joinee. 6. Employee Refferal Report NA 1. Primilary Round

3 Attendance Management NA Attendance Report NA

4 Leave Management NA Leave Report NA

5 Training & Development 1.Skill Metrix, 2. Training Plan, 3. Training Record NA NA

6 Adminstration 2. Stationary Procurement 3. Canteen management 1. Overtime Record, 2. Shift Record 1. Courier Record 3. House Keeping, 4. Visitor Facilities 5. Bills Processing, 6. Issuing ID Cards 7. Calls Management 8.

7 Compensation & Benefits 1. Salary Report, 2. Salary Slips, 3. Deciding Salary Structure 4. Advances Track Record 1. Salary Sheet Updation, 2. Leave encashment 3. Medi Claim, NA

8 Welfare Acitivities Newsletter , Reward Management Social Networking Sites Updation Any One activity Friday Funday

9 Health & Safety 1. Safety Audit, 2. Safety Reports, 3. Suppliar Safety Audits, 1. ESI Accident Register Updation NA

10 Labour Law & IR 1. ESI & PF deduction Record, 2. Returns On Time 3. Labour Law Register Updation, 4. Deals with ESI , PF Deptt. & labour Law Inspector & Contractor 1. Govt. Salary Sheet, 1. Attendance Register

11 Policy Formulation Policies in written NA NA

12 Performance Appraisal 1. Setting Up KRA's & communicating with Staff Members 2. Monthly Review NA NA

From India, Indore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.