Recruitment at Salesteq Corporation = ROUND (number, num_digits) Assignment Purpose Where, Attracting employees by using different recruitment sources is an important aspect of human - number = number (or cell) that you are roundine. You may also use an Excel formula here, resource management. Analyzing the effects of different recruitment sources as well as the total strateay can assist in planning future recruitment strategics. In this assignment, you will - num_digits = the number of digits to which rumber should be rounded. analyze recruitment planning scenarios based on the recruitment experience of the Salesteq Corporation. As with any of the functions used in this assigrmment, Microsoft and YouTube have excellent tutorials that can assist you in using thern. File Needed: HR Recruting. xlsx Familiarize yourself with the spreadsheet before beginning your work. Part I-Results of Previous Recruitment Strategy Background Please refer to the data in the section of the Excel sheet titled "Recruitment Data by Source for Salesteq Corporation is a successful consumer products' company located in San Francisco. The Previous Year" to complete the calculations below, In this section, you will be looking company has been growing at a constant rate during the past three years. Productivity gains backwards at your interview strategy and success by calculating a number of key metrics. These have been realized through computerization of its services. Salesteq has strongly supported its are: personnel staff since people are viewed as a critical asset for the continued sucress of the company. 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. Emplayees are recruited from four sources: the web, newspapers, radio, and referrals. All recruits are interviewed and a selectian decision is made "by someone" based on the interview 2. Cost Per Hire. Calculate cost per hire by dividing the total cost for recruiting by source by score? Salestec's HR staff monitor the number of interviews they conduct by recruitment the number of hires. Calculate this for all sources. source. Additianally, recruitment data on the number of people hired, average performance of hires at the end of the first year, and total recruitment costs are collected. 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. In this assignment, you will be calculating a number of HR metrics pertaining to different areas of recruitment. These include metrics for assessing Salesteq's previous recruitment strategy, 4. Yield Ratio. Calculate yield ratio by dividing the number of hires from each source by the planned interview strategy, and actual us. forecasted recruitment. These computations will help number of interviews for each source. Calculate this for all sources. you to understand what assessments go into evaluating different areas of recruitment at an organization. 5. Total Performance. Calculate total performance by source by multiplying the number of hires by source by the average performance. Calculate this for all sources. Note 6. Probability of Quitting. Calculate an estimate the quitting probability for hires of each As you work through the assignment, please be sure to continually save your work after each source by dividing the number of quits in year 1 ie.g. the anticipated number of new hires section. Save your work as a new Excel file using your first initial and last name. For example, Joe Smith would be: who will quit within the first year) by the number of hires. Calculate this for all sources. "jsmith_HR_Recruiting-xlsx". Part II - Results of Planned Interview Strategy Calculations Please refer to the data in the sections of the Excel sheet titled "Interview 5trategy by Make sure you round all calculations perfarmed in the spreadsheet. After all, you can't have Recruitment 5ource" and "Results of Planried Interview Strategy" to complete the calculations 1/3 of a person. This will require the use of the ROUNDING function. Here is how to use this below. In this section, you will be forecasting your recruitment plans for the coming year. function
