This workbook analyses vacancy ratios, vacancy ratios by recruitment activity, recruitment activity ratios, and hires versus openings summary for recruitment within your enterprise.

Parameters

The workbook does not use parameters.

Worksheets

This workbook has the following worksheets:

• Vacancy Ratios

• Vacancy Ratios by Recruitment Activity

• Recruitment Activity Ratios

• Hires versus Openings Summary

Vacancy Ratios Worksheet

Business Questions

How successful is my recruitment?

Worksheet headings and calculations

This worksheet uses the following calculations:

• Hires/Offers

  Populates the Hires / Offers column with the percentage of hires who are employed as of the system date, against the number of open offers as of the system date.

• Vacancy/Offers

  Populates the Hires / Openings column with the percentage of vacancy hires, against the number of openings.

• Hires/Openings

  Populates the Hires / Openings column with the percentage of hires who are employed as of the system date, against the number of initial openings.

• Vacancy Hires

  Populates the Hires column with the number of applicants who have been made an offer for a vacancy.

Vacancy Ratios by Recruitment Activity Worksheet

Business Questions

How many applicants are there at each recruitment stage?

Worksheet headings and calculations

This worksheet uses the following calculations:

• Recruitment Activity Vacancy Hires/Openings

  Populates the Hires / Openings column with the percentage of recruitment activity hires, against the number of openings.

• Recruitment Activity Vacancy Offers/Recruitment Activity Vacancy Hires

  Populates the Hires / Opening column with the percentage of hires, against the number of offers made.

• Recruitment Activity Vacancy HiresPopulates the Hires column with the number of applicants that have been hired into the vacancy from the recruitment activity.

• Recruitment Activity Vacancy OffersPopulates the Offers column with the number of applicants that have been made offers via the recruitment activity.

• Cost per Hire

  Populates the Cost per Hire column with the actual cost of recruitment activity divided by the number of successful recruitments using that activity.

Recruitment Activity Ratios Worksheet

Business Questions

How successful is my recruitment?

How much does my recruitment cost?

Worksheet headings and calculations

This worksheet uses the following calculations:

• Recruitment Activity Hires/Recruitment Activity Offers

  Populates the Hires / Opening column with the percentage of hires, against the number of offers made.

• Recruitment Activity OffersPopulates the Offers column with the number of offers made from a recruitment activity.

• Cost per Hire

  Populates the Cost per Hire column with the actual cost of recruitment activity divided by the number of successful recruitments using that activity.

• Recruitment Activity HiresPopulates the Recruitment Activity Hires column with the number of hires a recruitment activity has achieved.

Hires versus Openings Summary Worksheet

Business Questions

How successful is my recruitment?

Worksheet headings and calculations

This worksheet uses the following calculations:

• Recruitment Activity Vacancy Hires/Openings

  Populates the Hires / Offers column with the percentage of recruitment activity hires, against the number of openings.