Cost-Benefit Analysis

profileD_AS87
USW1_MHRM_6401_WK03_Form_2_5_YieldRatiosEachStepRecruitmentProcess_RecruitmentCostNurseHired_StVincentsHospital_2015_2016.xlsx
Home>Human Resource Management homework help>Cost-Benefit Analysis

Sheet1

Form Wu2.5 Yield Ratios at Selected Steps in the Process and Cost per Nurse Hired per St. Vincent's Hospital, 2015-2016
Applicant to Potentially Qualified Yield Ratio
Amy Puderbaugh: Amy Puderbaugh: Number of Applicant/Potentially Qualified		 Applicant to Offered Job Yield Ratio
Amy Puderbaugh: Amy Puderbaugh: Number of Applicants/Qualified and Offered Job		 Applicant to Accepted Job Yield Ratio
Amy Puderbaugh: Amy Puderbaugh: Number of Applicants/Accepted Job		 Applicant to One Year Survival Yield Ratio
Amy Puderbaugh: Amy Puderbaugh: Number of Applicants/One Year Survival 		Above Average Rating Applicant to Above Average Rating Yield Ratio
Amy Puderbaugh: Amy Puderbaugh: Number of Applicants/Above Average Rating		 Total Recruitment Costs Avg. Cost Per Nurse Hired
Amy Puderbaugh: Amy Puderbaugh: Total Recruitment Costs/Accepted Job
Number of Applicants Potentially Qualified Invitation for Interview Qualified and Offered Job Accepted Job One-Year Survival
Recruitment Source
1. Internet Applications ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
2. Walk Ins ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
3. Employee Referrals ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
4. Newspaper Ads ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
5. Journal Ads ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
6. Educational Institutions ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Junior colleges ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Hospital-based schools ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
University programs ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
7. Private Employment Agency ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
8. Public Employment Agency ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
9. Direct Mail ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
10. Job Fair ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
11. State Nursing Assoc. Meeting ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Totals
Amy Puderbaugh: Amy Puderbaugh: Total Columns
Amy Puderbaugh: Amy Puderbaugh: Number of Applicant/Potentially Qualified
Amy Puderbaugh: Amy Puderbaugh: Number of Applicants/Qualified and Offered Job
Amy Puderbaugh: Amy Puderbaugh: Number of Applicants/Accepted Job
Amy Puderbaugh: Amy Puderbaugh: Number of Applicants/One Year Survival
Amy Puderbaugh: Amy Puderbaugh: Number of Applicants/Above Average Rating		 0 0 ERROR:#DIV/0! 0 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0!