Based on the case study and image of the Excel file (unable to upload so please show in a table format in response) below, fill all blue fields and show math appropriate calculations in the right column E.

CASE STUDY DATA

Larson Property Management Company

Supplemental Case Material

Building a Business Case

• The system that Larson has chosen to support their recruiting process costs $15,000 each quarter for use of the application.
• The initial implementation costs to the vendor who will help with project management is $50,000
• Maintenance fees are included in the quarterly licensing fee, but any major changes to the system will cost the company on average an additional $25,000
• The internal recruiting team's average cost (fully loaded to include benefits, bonus, and retirement) is $52 per hour for each recruiter.
• Hiring managers are making $75 per hour in average fully loaded costs
• Every day a sales position goes unfilled, the average revenue lost per day to the company is $20,000.
• The company plans to implement system training for users the first year that will cost $40,000 to develop and deliver. After the first year, they estimate that ongoing training for new users and for new functionality will cost the company only 37.5% of first year training costs each year
• To take advantage of the new system, the company plans to hire 2 more recruiters that will support the organizations recruiting needs. Each recruiter will cost $95,000 fully loaded.
• The company currently spends $750,000 per year on fees to external search firms to help them find talent. It is estimated by HR that the new system will cut the reliance on external search and save the company 30% on fees the first year, and half their fees for year 2, and after that they think fees will be less than $200,000 a year.
• The efficiencies that the new system will provide allow the company to eliminate three administrative positions; each fully loaded costing $52,000 a year.

Related Information to Consider

• The organization thinks they will be adding the employee referral functionality in year two and the onboarding functionality in year 3.
• The HR recruiting team currently spends 15 hours a week gathering data and pulling together reports that are used to track and measure the recruiting activity. The new system's reporting capabilities will cut the time for data gathering and reporting to a half hour per week.
• Because of the new systems functional capability to route requisitions, candidate files, and interview materials to the hiring managers, they will spend on average, 2 hours less per opening to support this process. There are 40 hiring managers that fill on average 10 requisitions per year.
• New applicant tracking functionality of the new system will allow the company to reassign an HR resource that has been supporting Affirmative Action Reporting to another position that will support workforce planning. It is estimated that the new workforce planning that will take place because of the added attention that results from the reassignment of this resource, along with a sales assessment selection tool that is a part of the new system will effectively cut an average of 10 days out of the time to fill.
• The organization plans to hire 5 sales individuals per year for the next 3 years

AutoSave OFF Business Case Analysis for Cost Justification on ATS - Assignment 2-1 Q Home Insert Draw Page Layout Formulas Data Review View Share Comments Calibri (Body) 11 AA ab Wrap Text v General Insert x Delete v Paste BIUV DV Av E E Merge & Center v $ ~ % 9 Conditional Format Cell Format v X v Sort & Find & Ideas Sensitivity Formatting as Table Styles Filter Select D32 X V fx A B C D E F G H W N Business Case Analysis Points For cells highlighted, show your math for your answers in this column Costs Year : Year 2 Year 3 6 System Licensing Fee $60,000 Implementation Costs SO 8 Additional System Module Cost 9 System Training $15,000 10 Recruiters NHNPP 11 $60,000 $15,000 $0 12 13 Benefits (Savings) 14 Time for Reporting 15 Time of Hiring Managers 16 Search Fee Costs $375,000 17 Time to Fill Savings 18 Administrative Resource Savings NNNNN 19 $375,000 20 21 Cost/(Savings) Net $60,000 -$360,000 SO 22 Recommendation (highlight correct 23 answer) Based on the cost/benefit analysis, my recommendation whether to purchase 24 the ATS Yes No 25 20 26 27 28 29 30 31 32 33 34 Sheet1 Sheet2 Sheet3 + 1 - + 100%