Job vacancy rate calculator is a free excel template. It covers the computation of HR Metrics in excel format. Job vacancy rates are essential parameter for HR personnel, executive and professionals to consider while evaluating the performance of a business.
Meaning of job vacancy
Job vacancy is a simple HR or say, business concept. It means the number of unfilled/empty posts for which a company is actively looking for resources inside or outside organization. Thus, it includes all the vacant positions for which recruitment plan and process is in place.
Meaning of job vacancy rate
Job Vacancy Rate means the percentage of empty posts against the total number of the approved posts at a specific time of a company, department, or group.
Thus, the total number of approved posts is the sum of the no. of working employees and empty job posts at the end of the given period.
Formula to calculate job vacancy rate
Job vacancy rate is also termed as JVR. JVR is computed by computing percentage of job vacancies or empty posts against the total number of approved posts i.e. occupied posts & job vacancies.
JVR = [ Number of job vacancies / (Number of occupied posts + Job Vacancies) ] *100
Download and use job vacancy rate calculator template in excel
You can use this job vacancy rate calculator to compute simple job vacancy rate or for monthly analytics dashboards for your HR Manager. Basic preliminary information that you will require is number of vacant posts and authorized posts.
Now, Let us discuss on the how to download and use the HR metrics template in Excel format. To download and use this free HR Metrics excel template, follow the steps below –
- Firstly, You should have Microsoft Office/ Microsoft Excel installed in your system.
- After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software.
- Once extracted, you can open the file using Excel and start entering data or customizing the template.
- Furthermore, To download fonts and typefaces compatible with Microsoft Excel > Calligraphic.net