No Tags Found!

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)

Acknowledge(0)
Amend(0)

Ya pooja just try to simplify the mis, You should put some exel formula. otherwise it makes more complicated.
From India, Mumbai
Acknowledge(0)
Amend(0)

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)

Acknowledge(1)
Amend(0)

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
Acknowledge(0)
Amend(0)

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.