HR data, recruitment, attendance, salary and social security, the most complete formula.

HR data, recruitment, attendance, salary and social security, the most complete formula.

First, the recruitment analysis formula

Situation: Suppose the company has 100 employees at the beginning of the month and recruits this month, 30 people come to apply, and 5 people are successfully admitted. Three employees left this month.

1, recruitment rate:

Number of successful applicants ÷ All applicants × 100%.

(30 applicants, 5 applicants, 5÷30x 100%= admission rate: 16.6%)

2. Average number of people per month:

(beginning of the month+end of the month) ÷2

There are 100 people at the beginning of the month and 102 people at the end of the month, so (100+ 102)÷2, the average number of people this month is 10 1.

3. Monthly employee turnover rate:

The total number of employees leaving the company in a whole month ÷ the average number of employees in a month x 100%.

Three people left this month, with an average monthly number of 10 1, so the employee turnover rate this month is 3 ÷ 10 100%: 2.9%.

4. Monthly new employee recruitment rate:

Total number of new employees in the whole month ÷ average number of employees per month x 100%

There are five new employees this month, and the average monthly number is 10 1, so the new employee rate this month is 5 ÷10/x100%: 4.9%.

5. Monthly employee retention rate:

Number of employees retained at the end of the month ÷ Number of employees at the beginning of the month x 100%

There are 102 employees at the end of the month and 100 employees at the beginning of the month, so: 102 ÷ 100% The employee retention rate this month is: 102%.

6. Monthly staff turnover rate:

Total number of employees leaving the company in the whole month ÷ Number of employees at the beginning of the month x 100%

Three employees left this month. There were 100 employees at the beginning of the month, so: 3÷ 100x 100%. The staff turnover rate this month is 3%.

7. Monthly employee visit rate:

Total number of employees who joined in the whole month ÷ Total number of employees who left the whole month x 100%.

There are 5 employees who have joined this month and 3 employees who have left this month, so: 5÷3x 100% The ratio of employees entering and leaving this month is: 166%.

Second, the statistical analysis formula of attendance

1, personal attendance:

Attendance days ÷ specified monthly working days x 100%

If the attendance is 20 days and the working day per month is 23 days, then the personal attendance rate of 20÷23x 100% is 86.9%.

2. Overtime intensity ratio:

Overtime in the current month ÷ Total working hours in the current month x 100%

Working overtime for 6 hours in that month, the total working time in that month is 184 hours (23 days *8 hours), and the overtime intensity ratio is 8÷ 184x 100%: 3.2%.

3. Attendance:

Number of employees on duty on that day ÷ Total number of enterprises on that day x 100%

There were 98 employees on duty that day, and the total number of enterprises on that day was 102, so the attendance rate of 98÷ 102x 100% employees was 96%.

4. Absence rate:

Number of employees absent on that day ÷ Total number of enterprises on that day x 100%

Four people were absent from work that day, and the total number of employees in the enterprise was 102, so: 4÷ 102x00%, and the absenteeism rate was 3.9%.

Three, wages and labor cost analysis formula

1, monthly salary:

Monthly salary ÷2 1.75 days x attendance days in the current month.

2. Monthly piece rate:

Piece rate x number of pieces produced in the current month

3. Usually overtime pay:

Monthly salary ÷2 1.75 days ÷8 hours x 1.5 times normal overtime.

4. Holiday overtime pay:

Monthly salary ÷2 1.75 days ÷8 hours × x overtime hours on holidays.

5. Overtime pay for statutory holidays:

Monthly salary ÷2 1.75 days ÷8 hours x3 times overtime hours on legal holidays.

6, direct production personnel salary ratio:

Total wages of direct production personnel ÷ total wages of enterprises x 100%

7, non-production personnel salary ratio:

Total wages of non-production personnel ÷ total wages of enterprises x 100%

8. Human resource expense ratio:

Total labor cost in a certain period ÷ total sales revenue in the same period x 100%.

9, the proportion of labor costs in the total cost of enterprises:

Total labor cost in a certain period ÷ total cost in the same period x 100%.

10, per capita labor cost:

Total labor cost in a certain period ÷ Number of employees with the same caliber in the same period.

1 1, 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%.

Fourth, the daily basic formula

1. Proportion of new employees = number of full-time employees/total number of on-the-job employees.

2. Vacancy rate = number of people who fill vacancies due to personnel turnover gap/total number of people on the job.

3. Turnover rate (active turnover rate/elimination rate) = number of turnover/total number of employees.

4. Resignation rate = number of resignees/total number of employees

5. Personnel cost rate = (per capita labor cost * total number of people)/total sales revenue in the same period.

6. Recruitment success rate = (number of applicants+number of applicants to be enrolled) (planned increase+temporary increase)

7. Staffing control rate = number of employees per month.

8. Turnover Rate = (Employee's Entry Rate+Turnover Rate) /2

9. Turnover rate = turnover times/((number at the beginning+number at the end) /2)

10. Employee enrollment rate = check-in number/enrollment number.

1 1. Resignation rate = number of resignees/number of employees at the beginning) x 100%

12. The calculation formula of employee's monthly salary is:

13. Daily salary = fixed monthly salary /2 1.75 days.

14. Payable salary of the current month = daily salary x effective working days of the current month x actual working days of the current month.

Remarks:

Working days in the current month = natural days in the current month-rest days in the current month

Effective working days of the current month = working days of the current month-all unpaid holidays

Adjustment and comparison of actual working days in the current month =2 1.75 days/working days in the current month.

As a production enterprise, we should also consider the labor productivity:

Labor productivity = sales revenue/total number of people

1. Proportion of new employees = number of full-time employees/total number of on-the-job employees.

2. Vacancy rate = number of people who fill vacancies due to personnel turnover gap/total number of people on the job.

3. Turnover rate (active turnover rate/elimination rate = turnover number/total number of employees)

4. Resignation rate = number of resignees/total number of employees

5. Personnel cost rate = (per capita labor cost * total number of people)/total sales revenue in the same period.

Verb (abbreviation of verb) cost-utility evaluation formula

1. Total cost utility = number of employees/total recruitment cost

2. Recruitment cost utility = number of applicants/expenses during recruitment.

3. Selection cost utility = number of people selected/expenses during the selection period.

4. Personnel employment utility = number of regular employees/expenses during employment.

5. Recruitment benefit-cost ratio = value created by all new employees for the organization/total recruitment cost.

Quantitative evaluation formula of intransitive verbs

1. Employment rate = number of employees/number of applicants * 100%

2. Recruitment completion rate = number of employees/planned number of employees * 100%

3. Application proportion = number of applicants/planned recruitment * 100%

4. Salary calculation = monthly salary /2 1.75* actual working days (excluding Saturday and Sunday)

5. Overtime rate: total overtime time/total attendance time.

6. Proportion of direct and indirect personnel: direct/indirect personnel

Seven, the system working time calculation formula

Annual working days: 365 days-104 days (rest days)-1 1 day (legal holidays) =250 days.

Seasonal working days: 250 days ÷4 seasons =62.5 days/season/

Monthly working days: 250 days ÷ 65438+February =20.83 days/month.

Calculation of working hours: the working days of month, quarter and year multiplied by 8 hours per day.

Eight, the daily wage, hourly wage calculation formula

According to Article 51 of the Labor Law, the employer shall pay wages according to law for statutory holidays, that is, 1 1 statutory holidays stipulated by the state are not excluded when converting daily wages and hourly wages. Accordingly, the conversion of daily wage and hourly wage is:

Daily wage = monthly wage income ÷ paid days per month.

Hourly wage = monthly wage income ÷ (paid days per month x8 hours).

Paid days per month =(365 days-104 days) ÷ 65438+February =2 1.75 days.

Nine. Social security calculation formula

According to the latest pension calculation method, employee retirement pension consists of two parts: pension = basic pension and ten personal account pension.

1. Personal account pension = personal account deposit ÷ payment months (50 years old 195, 55 years old 170, 60 years old 139, no longer unified)

2. Basic pension = (the average monthly salary of employees in the province last year+the average monthly payment salary of myself) ÷2 times the payment period x 1%= the province last year.

The average monthly salary of on-the-job employees (1+ my average payment index) ÷2 times the payment period x 1%.

3. My indexed monthly average payment salary = last year's average monthly salary of employees in the whole province x my average payment index.

4. Personal pension = basic pension+personal account pension = basic pension ten personal account storage139

5. As can be seen from the above formula, under the condition of the same payment period, the level of basic pension depends on the average individual payment index, which is the historical average of the ratio of its actual payment base to the average social wage. The lower limit is 0.6 and the upper limit is 3.

Therefore, in the two kinds of calculation of pension, no matter what the situation, the higher the payment base and the longer the payment period, the higher the pension.

6. Average contribution index: your contribution base/local social wage. Suppose you choose the social wage 100% as the base, then the index is 1, and if you choose 60%, it is 0.6.

(Note: The above formula may be different due to policy adjustment or the actual situation of each company, for reference only)