Human Resources Chapter 9 Homework Calculate This For All Sources part Results Planned Interview Strategy please Refer The

Unlock access to all the studying documents.

View Full Document

Johnson, Human Resource Information Systems, 5e

SAGE Publishing, 2021

Recruitment at Salesteq Corporation

Assignment Purpose

Attracting employees by using different recruitment sources is an important aspect of human

resource management. Analyzing the effects of different recruitment sources as well as the

total strategy can assist in planning future recruitment strategies. In this assignment, you will

analyze recruitment planning scenarios based on the recruitment experience of the Salesteq

Corporation.

File Needed: HR Recruting.xlsx

Familiarize yourself with the spreadsheet before beginning your work.

Background

Salesteq Corporation is a successful consumer products’ company located in San Francisco. The

company has been growing at a constant rate during the past three years. Productivity gains

have been realized through computerization of its services. Salesteq has strongly supported its

personnel staff since people are viewed as a critical asset for the continued success of the

company.

Note

As you work through the assignment, please be sure to continually save your work after each

section. Save your work as a new Excel file using your first initial and last name. For example,

Joe Smith would be:

“jsmith_HR_Recruiting.xlsx”.

Calculations

Make sure you round all calculations performed in the spreadsheet. After all, you can’t have

1/3 of a person. This will require the use of the ROUNDING function. Here is how to use this

function:

Johnson, Human Resource Information Systems, 5e

SAGE Publishing, 2021

Part I – Results of Previous Recruitment Strategy

Please refer to the data in the section of the Excel sheet titled “Recruitment Data by Source for

Previous Year” to complete the calculations below. In this section, you will be looking

backwards at your interview strategy and success by calculating a number of key metrics. These

are:

1. Cost Per Interview. Calculate cost per interview by dividing the total cost for recruiting

for each source by the number of interviews. Calculate this for all sources.

2. Cost Per Hire. Calculate cost per hire by dividing the total cost for recruiting by source by

the number of hires. Calculate this for all sources.

3. Percent Offers. Calculate percent offers by dividing the number of offers extended to

candidates for each source by the number of interviews. Calculate this for all sources.

Part II – Results of Planned Interview Strategy

Please refer to the data in the sections of the Excel sheet titled “Interview Strategy by

Recruitment Source” and “Results of Planned Interview Strategy” to complete the calculations

below. In this section, you will be forecasting your recruitment plans for the coming year.

Johnson, Human Resource Information Systems, 5e

SAGE Publishing, 2021

1. Number of Offers. To obtain the number offers, multiply the number of interviews by the

percent offers received last year. Do this for each recruitment source.

2. Number of Hires. To obtain this figure, multiply the number of interviews for newspapers by

the yield ratio from last year. Do this for each recruitment source.

Question: Now that the calculations for Part III are complete, can this organization use

historical data to make projections about future recruiting needs?

Part III – Totals for Actual vs. Forecasted Recruitment

Please refer to the data in the section of the Excel sheet titled “Totals for Actual vs. Forecasted

1. Set all your data for all sources in the “Interview strategy by Recruitment Source” to zero.

Next, increase the number of interviews from Part II for the recruitment source with the

highest historical yield ratio until the FORECASTED number of hires in the FORECASTED

column (e.g. cell F58) equals the ACTUAL number of hires (D58).

Question: What is the interview source? How many interviews were required?

Before continuing, reset your data to the original forecasted number of interviews.

Johnson, Human Resource Information Systems, 5e

SAGE Publishing, 2021

2. Further analysis indicated that 65 percent of Salesteq minority recruits are attracted by

radio. Assume that a minimum of 70 interviews are needed for those who apply due to

3. Next imagine that because of budget cutbacks, Salesteq will only budget $6,500 for the

next year’s recruitment budget. Explain your strategy for this scenario.

Question: What are the advantages and disadvantages of this recruitment planning model?

Explain.