50 formulas commonly used in human resource data analysis

50 formulas commonly used in human resource data analysis

HR often needs to process data, such as enrollment rate, turnover rate and overtime calculation. Although the calculation of a single data is not troublesome in daily work, when dozens or hundreds of data are accumulated together, it is really easy to get confused and even make calculation errors. Nowadays, Bian Xiao is anxious about human resources. He has compiled 100 commonly used human resources calculation formulas. HR can be added to favorites for use at any time, or printed and posted next to the computer for query at any time.

1. Common calculation formula for recruitment analysis: 1. Recruitment rate: number of successful applicants ÷ all applicants × 100%. 2. Average number of employees per month: (number at the beginning of the month+number at the end of the month) ÷23. Monthly employee turnover rate: the total number of employees who left in the current month ÷ the average number of employees per month × 100% 4. Monthly new employee recruitment rate: the total number of employees in the current month × 100% 5. Monthly employee turnover rate: the total number of employees leaving the company in the whole month ÷ the number of employees at the beginning of the month × 100% 7. Monthly employee turnover ratio: the total number of employees in the whole month ÷ the total number of employees in the whole month × 100% 2. The commonly used statistical analysis formula of attendance is 1. Personal attendance rate: attendance days ÷. Overtime intensity ratio: overtime hours in the current month ÷ total working hours in the current month × 100% 3. Attendance rate: the number of employees participating in the day ÷ the total number of enterprises on the day × 100% 4. Absence rate: the number of employees absent on that day ÷ the total number of enterprises on that day × 100% 3. Monthly salary: monthly salary ÷2 1.75 days × attendance days of the month 2. Monthly piece rate: piece rate × number of pieces manufactured in the current month 3. Overtime at ordinary times: monthly salary ÷2 1.75 days ÷8 hours ×65438+ 0.5 times of ordinary overtime hours. Overtime pay for legal holidays: the monthly salary is ÷2 1.75 days ÷8 hours × 3 times of overtime time for legal holidays. 6. Wage ratio of direct production personnel: total wages of direct production personnel × total wages of enterprises × 100%. 7. Wage ratio of non-productive personnel: total wages of non-productive personnel × total wages of enterprises. Expense rate of human resources: total labor cost in a certain period ÷ total sales revenue in the same period × 100% 9. The proportion of labor cost to the total cost of the enterprise: total labor cost in a certain period ÷ total cost in the same period × 100%, and per capita labor cost: total labor cost in a certain period ÷ employees with the same caliber in the same period. Labor cost profit rate: the total profit of the enterprise in a certain period ÷ the total labor cost of the enterprise in the same period × 100% 4. Training statistical analysis formula Training attendance: actual training attendance ÷ planned training attendance × 100% V. Summary of HR common basic formulas 1. New employee ratio = number of employees who have become regular employees/total number of employees on the job 2. Total number of employees. Turnover rate (active turnover rate/elimination rate) = number of turnovers/total number of employees 4. Turnover rate = turnover rate/((number at the beginning+number at the end) /2)5. Resignation rate = number of resignees/(number of employees at the beginning+number of employees) × 100% 6. Turnover rate = number of turns/. Total sales revenue in the same period is 8. Recruitment compliance rate = (number of registered employees+number of applicants to be registered)/(number of planned additions+number of temporary additions) 9. Staffing control rate = monthly staffing/number of employees 10. Turnover rate = (employee's enrollment rate+turnover rate) /2 1 1. Employee enrollment rate = registration. The number of employees at the beginning is 65,438+02. The calculation formula of employee's monthly salary is: daily salary = fixed monthly salary /2 1.75 days 13, monthly salary = effective working day x actual working day of the month +04, working day of the month = natural days of the month-rest day of the month +05. Effective working days of the current month = working days of the current month-full unpaid leave 16, actual working days of the current month =2 1.75 days/working days of the current month: 17, and labor productivity of production enterprises = sales revenue/total number of employees. Intransitive verb cost-benefit evaluation 1, total cost-benefit = number of employees/total recruitment cost 2. Select Cost Utility = Select Headcount/Select Period Expense 4. Personnel employment utility = number of regular employees/recruitment period fee 5. Recruitment revenue-cost ratio = value created by all new employees for the organization/total recruitment cost 7. Quantitative evaluation 1, employment rate = number of employees/number of applicants * 100%2. Recruitment completion rate = number of employees/planned recruitment. Proportion of applicants = number of applicants/number of planned recruits * 100%4. Salary calculation = monthly salary /2 1.75* actual working days (excluding Saturday and Sunday) 6. Overtime rate: total overtime time/total attendance time 7. Proportion of direct and indirect personnel: direct/indirect personnel 8. Calculation of system working time 65438+. Annual working days: 365 days-104 days (rest days)-1day (legal holidays) = 250 days 2, seasonal working days: 250 days ÷4 seasons = 62.5 days/quarter /3, and monthly working days: 250 days ÷. . 7. Paid days per month = (365 days-104 days) ÷ 65438+February = 2 1.75 days. Calculation method of social security According to the latest calculation method of pension, the retirement pension of employees consists of two parts: pension = basic pension+personal account pension.

1, personal account pension = personal account storage ÷ months (the number of months is determined according to the retirement age and the average life expectancy of the population at that time. Calculated months are slightly equal to (average life expectancy-retirement age) X 12. At present, 50 years old is 195, 55 years old is 170, and 60 years old is 139. No longer unified is 120) 2. Basic pension = (last year's average monthly salary of employees in the province+my average monthly payment salary) ÷2× payment period × 1%= last year's average monthly salary of employees in the province (1+ my average monthly payment index) ÷2× payment period ×6543. 4. Personal pension = basic pension+personal account pension = basic pension+personal account deposit139.

5. The average payment index means that you paid according to the base of last year 1000, and the average social wage in that year was 2000, so your index in that year was 0.5. It is easy to calculate the average annual contribution, and then you can calculate the amount of pension yourself.