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
Acknowledge(3)
Amend(0)
28Thanks,
Pooja
From India, Indore
Acknowledge(3)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)
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
Acknowledge(1)
Amend(0)
From India, Mumbai
Acknowledge(1)Amend(0)
Key Result Areas
1. Manpower Planning
- Manpower Planning
- Tracker Updation
- NA
- NA
2. Recruitment & Selection
- Second Round
- Salary Negotiation
- Employee Orientation
- Joining Formalities
- List Of New Joinees
- Employee Referral Report
- NA
- Preliminary Round
3. Attendance Management
- NA
- Attendance Report
- NA
4. Leave Management
- NA
- Leave Report
- NA
5. Training & Development
- Skill Matrix
- Training Plan
- Training Record
- NA
- NA
6. Administration
- Stationery Procurement
- Canteen Management
- Overtime Record
- Shift Record
- Courier Record
- Housekeeping
- Visitor Facilities
- Bills Processing
- Issuing ID Cards
- Calls Management
7. Compensation & Benefits
- Salary Report
- Salary Slips
- Deciding Salary Structure
- Advances Track Record
- Salary Sheet Updation
- Leave Encashment
- Medi Claim
- NA
8. Welfare Activities
- Newsletter
- Reward Management
- Social Networking Sites Updation
- Any One Activity
- Friday Funday
9. Health & Safety
- Safety Audit
- Safety Reports
- Supplier Safety Audits
- ESI Accident Register Updation
- NA
10. Labour Law & IR
- ESI & PF Deduction Record
- Returns On Time
- Labour Law Register Updation
- Deals with ESI, PF Dept. & Labour Law Inspector & Contractor
- Govt. Salary Sheet
- Attendance Register
11. Policy Formulation
- Policies in written
- NA
- NA
12. Performance Appraisal
- Setting Up KRAs & communicating with Staff Members
- Monthly Review
- NA
- NA
From India, Indore
Acknowledge(0)Amend(0)
1. Manpower Planning
- Manpower Planning
- Tracker Updation
- NA
- NA
2. Recruitment & Selection
- Second Round
- Salary Negotiation
- Employee Orientation
- Joining Formalities
- List Of New Joinees
- Employee Referral Report
- NA
- Preliminary Round
3. Attendance Management
- NA
- Attendance Report
- NA
4. Leave Management
- NA
- Leave Report
- NA
5. Training & Development
- Skill Matrix
- Training Plan
- Training Record
- NA
- NA
6. Administration
- Stationery Procurement
- Canteen Management
- Overtime Record
- Shift Record
- Courier Record
- Housekeeping
- Visitor Facilities
- Bills Processing
- Issuing ID Cards
- Calls Management
7. Compensation & Benefits
- Salary Report
- Salary Slips
- Deciding Salary Structure
- Advances Track Record
- Salary Sheet Updation
- Leave Encashment
- Medi Claim
- NA
8. Welfare Activities
- Newsletter
- Reward Management
- Social Networking Sites Updation
- Any One Activity
- Friday Funday
9. Health & Safety
- Safety Audit
- Safety Reports
- Supplier Safety Audits
- ESI Accident Register Updation
- NA
10. Labour Law & IR
- ESI & PF Deduction Record
- Returns On Time
- Labour Law Register Updation
- Deals with ESI, PF Dept. & Labour Law Inspector & Contractor
- Govt. Salary Sheet
- Attendance Register
11. Policy Formulation
- Policies in written
- NA
- NA
12. Performance Appraisal
- Setting Up KRAs & communicating with Staff Members
- Monthly Review
- NA
- NA
From India, Indore
Acknowledge(0)Amend(0)
Dear Pooja, optimizing HR functions with an MIS sheet and Excel formulas in a manufacturing plant can significantly enhance efficiency and productivity. Here are some practical steps to make your MIS sheet more effective:
- Firstly, ensure your MIS sheet captures essential HR metrics such as attendance, leave balances, training history, and performance evaluations for all 400 employees in the manufacturing plant.
- Utilize Excel formulas to automate calculations for salary structures, leave encashment, and PF deductions to minimize manual errors and streamline payroll processes.
- Implement a training plan section in the MIS sheet to track employee skill development and identify areas for improvement.
- Create a section for new joinees to monitor their onboarding progress, including ID card issuance, salary negotiation details, and orientation schedules.
- Regularly update the salary sheet on the MIS with accurate information to facilitate transparent communication regarding compensation.
- To ensure compliance with labor laws, refer to the Factory Act and Rules specific to your location in Indore, India, when drafting policies related to employee management, leave policies, and termination procedures.
Taking these steps will help you leverage the power of data analytics and automation to optimize HR functions and drive organizational success. If you encounter any specific challenges or need further guidance, feel free to ask for assistance.
From India, Gurugram
Acknowledge(0)Amend(0)
- Firstly, ensure your MIS sheet captures essential HR metrics such as attendance, leave balances, training history, and performance evaluations for all 400 employees in the manufacturing plant.
- Utilize Excel formulas to automate calculations for salary structures, leave encashment, and PF deductions to minimize manual errors and streamline payroll processes.
- Implement a training plan section in the MIS sheet to track employee skill development and identify areas for improvement.
- Create a section for new joinees to monitor their onboarding progress, including ID card issuance, salary negotiation details, and orientation schedules.
- Regularly update the salary sheet on the MIS with accurate information to facilitate transparent communication regarding compensation.
- To ensure compliance with labor laws, refer to the Factory Act and Rules specific to your location in Indore, India, when drafting policies related to employee management, leave policies, and termination procedures.
Taking these steps will help you leverage the power of data analytics and automation to optimize HR functions and drive organizational success. If you encounter any specific challenges or need further guidance, feel free to ask for assistance.
From India, Gurugram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
HR Job Functions.doc
Excel Functions Dictionary.xls