How Do I Calculate Recruitment Success Rates in Excel as a Junior HR? Seeking Advice!

Query Regarding Recruitment Evaluation Format

I was wondering about the Recruitment Evaluation Format and how to calculate the percentage of hires or appointments in Microsoft Excel. I aim to evaluate the effectiveness of the recruitment process. My experience is at a junior level in the HR field, which is why I am seeking advice.

Best Regards,
Aung Khaing

The effectiveness of the recruitment process can be measured on the following counts:

a) Total recruitment expenses against total employee cost.
b) Cost per hire.
c) Number of vacancies filled within the specified turnaround time.
d) Number of newly joined employees who met their KRA within the first quarter or half-year.
e) Number of terminations of newly hired persons due to poor performance in the first six months.

If you measure the effectiveness of the recruitment process based on the above parameters, it is more than sufficient.

Thanks,

Dinesh V. Divekar