Offer Acceptance Rate Calculator is an excel template with predefine formulas to calculate percentage of offer acceptance of your organization. Enter only 2 details and it will calculate Offer Acceptance Rate for you.
This template can be useful to small business owners, HR assistants, HR professionals, HR consultants etc. to calculate Offer acceptance rate for their own company, client or customer.
Offer Acceptance Rate
The Offer Acceptance Rate is an HR metric that measures acceptability of your job offers and the efficiency of your recruitment process. It provides insights into how attractive is job offer for the vacant position is to applicants.
This metric is useful where there are competitive talent markets.
Formula To Calculate the Offer Acceptance Rate Benchmark
The formula to calculate the OAR is simple. It is the Number of offers accepted divided by Total Number of Job Offers issued by employer.
Offer Acceptance Rate Calculator Excel Template
We have create a simple and ready excel template to calculate the Offer Acceptance Rate for a particular job post or multiple job posts. Just enter the require information and it will automatically calculate the same for you.
How to use the Offer Acceptance Rate Calculator?
The details require to calculate the offer acceptance rate are Number of Job Offers accepted by the candidates and the total number of job offers issued.
There are 2 sections in this:
- Offer Acceptance Rate (General)
- Offer Acceptance Rate (Multiple Post)
1. Offer Acceptance Rate (General)
If there are multiple job posts in one section, for example; sales executive then you can calculate the Offer Acceptance rate using this section.
Enter the following :
Job Post
Location
Type
Number of Offers Accepted
Number of Offers Issued
This shows the nature of the job, whether it is an office job or a field job
2. Offer Acceptance Rate (Multiple Posts)
When your company has a big workforce and there are multiple job offers then this section can be useful to you offer acceptance rate by industry..
Similarly, enter the details in light blue colored cells. It will calculate the offer acceptance rate for the particular post and also as a whole for your whole recruitment process.