Hi,

I am sharing a MIS sheet. Please give me more input or ideas. I am working in a manufacturing plant where the total manpower is 400. So, this is the first step I would like to take 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, 2691 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, 1100 views)


Key Result Areas

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

2. Recruitment & Selection
- 1. Second Round
- 2. Salary Negotiation
- 3. Employee Orientation
- 4. Joining Formalities
- 5. List Of New Joinees
- 6. Employee Referral Report
- NA
- 1. Preliminary Round

3. Attendance Management
- NA
- Attendance Report
- NA

4. Leave Management
- NA
- Leave Report
- NA

5. Training & Development
- 1. Skill Matrix
- 2. Training Plan
- 3. Training Record
- NA
- NA

6. Administration
- 1. Stationery Procurement
- 2. Canteen Management
- 1. Overtime Record
- 2. Shift Record
- 1. Courier Record
- 3. Housekeeping
- 4. Visitor Facilities
- 5. Bills Processing
- 6. Issuing ID Cards
- 7. Calls Management

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 Activities
- Newsletter
- Reward Management
- Social Networking Sites Updation
- Any One Activity
- Friday Funday

9. Health & Safety
- 1. Safety Audit
- 2. Safety Reports
- 3. Supplier 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 Dept. & 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 KRAs & communicating with Staff Members
- 2. Monthly Review
- NA
- NA

From India, Indore

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.