{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["ARAP savings calculator"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"ARAP savings calculator","index":0,"n_rows":203,"n_cols":10,"rows_kept":203,"merged":[[5,0,5,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,4],[28,0,28,4],[29,0,29,4],[30,0,30,4],[33,0,33,4],[34,0,34,4],[35,0,35,4],[36,0,36,4],[37,0,37,4],[38,0,38,4],[39,0,39,4],[40,0,40,4],[41,0,41,4],[44,0,44,4],[45,0,45,4],[46,0,46,4],[47,0,47,4],[48,0,48,4],[49,0,49,4],[50,0,50,4],[51,0,51,4],[52,0,52,4],[55,0,55,4],[56,0,56,4],[57,0,57,4],[58,0,58,4],[59,0,59,4],[60,0,60,4],[61,0,61,4],[64,0,64,4],[65,0,65,4],[66,0,66,4],[67,0,67,4],[68,0,68,4],[69,0,69,4],[70,0,70,4],[73,0,73,4],[74,0,74,4],[75,0,75,4],[76,0,76,4],[77,0,77,4],[78,0,78,4],[79,0,79,4],[84,0,84,4],[85,0,85,4],[86,0,86,4],[87,0,87,4],[88,0,88,4],[89,0,89,4],[101,0,101,4],[102,0,102,4],[105,0,105,4],[111,0,111,4],[132,0,132,4],[133,0,133,4],[145,0,145,4],[151,0,151,4],[163,0,163,4],[164,0,164,4],[168,0,168,4],[169,0,169,4],[170,0,170,4],[171,0,171,4],[172,0,172,4],[173,0,173,4],[174,0,174,4],[175,0,175,4],[179,0,179,4]],"flags":["formulas_cached_only"]}
["[Company Name]"]
["Automated resume and application processing (ARAP) savings calculator"]
["[Date]"]
[]
["Recruiting data worksheet"]
[]
[]
["Hiring practices"]
["How many employees are in your organization?",{"$nulls":8},{"v":20000,"d":"20,000"}]
["How many people did you hire during the last fiscal year?",{"$nulls":4},"Exempt",{"v":1100,"d":"1,100"},"Nonexempt",350,{"v":1450,"d":"1,450"}]
["How many people do you plan to hire during this fiscal year?",{"$nulls":4},"Exempt",{"v":1150,"d":"1,150"},"Nonexempt",450,{"v":1600,"d":"1,600"}]
["How many people do you plan to hire during the next fiscal year?",{"$nulls":4},"Exempt",{"v":1200,"d":"1,200"},"Nonexempt",600,{"v":1800,"d":"1,800"}]
["Is your organization's cost-per-hire information broken down by position, department, and region?",{"$nulls":8},"Yes"]
["What is your organization's hiring cycle time (in days)?",{"$nulls":8},64]
["What variables does your organization use to measure hiring cycle time?"]
["1.\n2.\n3."]
["How many resumes are processed annually?",{"$nulls":8},{"v":50000,"d":"50,000"}]
["How many applications are processed annually?",{"$nulls":8},{"v":50000,"d":"50,000"}]
["What is the approximate percentage of the total resumes that your organization received from each of the following sources?"]
["Unsolicited mail",{"$nulls":8},{"v":0.1,"d":"10.0%"}]
["Recruitment advertising (in publications such as newspapers and magazines)",{"$nulls":8},{"v":0.15,"d":"15.0%"}]
["Outside staffing firms",{"$nulls":8},{"v":0.15,"d":"15.0%"}]
["Career fairs",{"$nulls":8},{"v":0.1,"d":"10.0%"}]
["Campus recruitment",{"$nulls":8},{"v":0.15,"d":"15.0%"}]
["Internet advertising/posting boards",{"$nulls":8},{"v":0.25,"d":"25.0%"}]
["Employee referrals",{"$nulls":8},{"v":0.1,"d":"10.0%"}]
["Of the resumes received by your organization, what percentage are received:"]
["In paper form (this includes fax)?",{"$nulls":8},{"v":0.5,"d":"50.0%"}]
["Through an online application?",{"$nulls":8},{"v":0.25,"d":"25.0%"}]
["Through e-mail as an attached file?",{"$nulls":8},{"v":0.25,"d":"25.0%"}]
["What is the annual turnover rate for your organization?",{"$nulls":8},{"v":0.05,"d":"5.0%"}]
[]
["Annual staffing expenses"]
["How many FTEs in your organization are allocated to the processing of resumes and applications?",{"$nulls":8},7]
["What is the average, fully burdened, hourly rate paid to your employees who process resumes and applications?",{"$nulls":8},{"v":30,"d":"$30.00"}]
["How many documents (resumes and applications) can an employee\nprocess per day?",{"$nulls":8},75]
["How many hours per FTE are available annually to process documents?",{"$nulls":8},{"v":1446,"d":"1,446"}]
["If applicable, what are your HR department’s annual chargebacks to other departments for your recruitment services?",{"$nulls":8},{"v":0,"d":"$0"}]
["How much does your organization spend annually on outside staffing firms?"]
["Retained recruiting firms",{"$nulls":8},{"v":125000,"d":"$125,000"}]
["Contingent recruiting firms",{"$nulls":8},{"v":100000,"d":"$100,000"}]
["Temporary placement firms",{"$nulls":8},{"v":100000,"d":"$100,000"}]
[]
["Annual recruiting expenses—Advertising"]
["How much does your organization spend annually on recruitment advertising?"]
["Newspapers",{"$nulls":8},{"v":50000,"d":"$50,000"}]
["Advertising firms",{"$nulls":8},{"v":50000,"d":"$50,000"}]
["Internet advertising",{"$nulls":8},{"v":50000,"d":"$50,000"}]
["Magazines and periodicals",{"$nulls":8},{"v":25000,"d":"$25,000"}]
["How much does your organization spend annually on external job posting environments?"]
["Internet job boards",{"$nulls":8},{"v":25000,"d":"$25,000"}]
["Paper-based bulletin boards",{"$nulls":8},{"v":7500,"d":"$7,500"}]
["Kiosks",{"$nulls":8},{"v":25000,"d":"$25,000"}]
[]
["Annual recruiting expenses—Special programs and career fairs"]
["What types of special programs do you incorporate into your organization's recruitment efforts (for example, virtual job fairs, radio promotions, special public relations activities, recruiter attendance at trade shows, and recruiter attendance at local community events)?"]
["1.\n2.\n3."]
["How many of these special programs does your organization commit to annually?",{"$nulls":8},5]
["How much does your organization spend annually on these special programs and events?",{"$nulls":8},{"v":10000,"d":"$10,000"}]
["If your organization recruits internationally, what are the annual costs associated with visa attainment, legal matters, expatriate-related matters, and other efforts?"]
["How many career fairs does your organization attend annually?",{"$nulls":8},10]
["What is the average cost for attendance at these career fairs? \nInclude costs for registration, booth space, travel, lodging, meals, and other related expenses.",{"$nulls":8},{"v":10000,"d":"$10,000"}]
[]
["Annual recruiting expenses—Campus recruitment"]
["Is your organization actively involved in campus recruitment?",{"$nulls":8},"Yes"]
["On how many campuses is your organization involved in recruitment?",{"$nulls":8},40]
["What are the annual college recruitment costs?",{"$nulls":8},{"v":80000,"d":"$80,000"}]
["How many new hires result from these efforts?",{"$nulls":8},100]
["Does your organization have an active internship or co-op program on these campuses?",{"$nulls":8},"No"]
["How many interns and co-op students are hired annually?",{"$nulls":8},100]
["Do you plan to expand your organization's campus recruitment efforts to\nadditional campuses or strengthen relations with your current campuses?",{"$nulls":8},"Yes"]
[]
["Annual recruiting expenses—Other"]
["How much does your organization spend annually on travel, lodging, meals, and so on, associated with your recruitment efforts? This should include on-campus recruitment events, interviews, bringing candidates on-site for interviews, and other efforts.",{"$nulls":8},{"v":50000,"d":"$50,000"}]
["How much does your organization spend annually on relocation?",{"$nulls":8},{"v":100000,"d":"$100,000"}]
["How much does your organization spend annually on signing bonuses and other material perquisites?",{"$nulls":8},{"v":100000,"d":"$100,000"}]
["What is your organization's annual expenditure for third-party vendor services such as background checks, credit checks, prescreening services, and surveys?",{"$nulls":8},{"v":50000,"d":"$50,000"}]
["If your organization uses an employee referral program (ERP), what is the average payment to employees for each hire?",{"$nulls":8},{"v":750,"d":"$750"}]
["How many new hires result annually from your organization's employee referrals?",{"$nulls":8},100]
["If applicable, what are the annual IT chargebacks allocated to your \nHR department?",{"$nulls":8},{"v":0,"d":"$0"}]
["Annual cost per hire",{"$nulls":8},{"v":921.4896551724138,"d":"$921"}]
[]
["Potential savings calculations for ARAP"]
["In-house calculation"]
["Number of resumes and applications processed annually",{"$nulls":8},{"v":100000,"d":"100,000"}]
["Current number of FTEs allocated to this process in your organization",{"$nulls":8},7]
["Fully burdened hourly rate of FTEs allocated to this process",{"$nulls":8},{"v":30,"d":"$30.00"}]
["Annual cost to process these documents in-house",{"$nulls":8},{"v":303660,"d":"$303,660"}]
["Number of FTEs required to effectively meet your organization's annual document-processing needs",{"$nulls":8},{"v":5.532503457814661,"d":"5.53"}]
["Current cost per document processed",{"$nulls":8},{"v":3.0366,"d":"$3.04"}]
[]
["Outsourced calculation"]
["Cost per outsourced processing of each document",{"$nulls":8},{"v":2.5,"d":"$2.50"}]
["Annual cost of outsourcing",{"$nulls":8},{"v":250000,"d":"$250,000"}]
[]
["Resume-to-application ratio:"]
["Current percent ratio of resumes to applications",{"$nulls":8},{"v":0.5,"d":"50.0%"}]
["Current percent ratio of applications to resumes",{"$nulls":8},{"v":0.5,"d":"50.0%"}]
[]
["Potential savings opportunities for ARAP"]
["Staffing expenses"]
["Percentage of customers' internal processing costs typically reduced by using ARAP solutions",{"$nulls":8},{"v":0.25,"d":"25.0%"}]
["Potential cost savings by applying customers' typical internal processing cost reduction to your organization's current document-processing costs",{"$nulls":7},"Reduced annual costs:",{"v":227745,"d":"$227,745"}]
[{"$nulls":8},"Potential savings:",{"v":75915,"d":"$75,915"}]
["Annual cost for outside staffing firms",{"$nulls":8},{"v":325000,"d":"$325,000"}]
["Potential percentage of costs reduced by incorporating outside staffing firms into ARAP",{"$nulls":8},{"v":0.2,"d":"20.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":260000,"d":"$260,000"}]
[{"$nulls":8},"Potential savings:",{"v":65000,"d":"$65,000"}]
[]
["Advertising"]
["Annual cost for recruitment advertising",{"$nulls":8},{"v":175000,"d":"$175,000"}]
["Potential percentage of costs reduced by using ARAP solutions",{"$nulls":8},{"v":0.25,"d":"25.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":131250,"d":"$131,250"}]
[{"$nulls":8},"Potential savings:",{"v":43750,"d":"$43,750"}]
["Annual costs of external job postings",{"$nulls":8},{"v":57500,"d":"$57,500"}]
["Potential percentage of costs reduced by using ARAP solutions",{"$nulls":8},{"v":0.2,"d":"20.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":46000,"d":"$46,000"}]
[{"$nulls":8},"Potential savings:",{"v":11500,"d":"$11,500"}]
[]
["Special programs and career fairs"]
["Number of special recruitment programs attended annually by your organization",{"$nulls":8},5]
["Average cost of special recruitment programs",{"$nulls":8},{"v":2000,"d":"$2,000"}]
["Potential percentage of costs reduced by using ARAP solutions",{"$nulls":8},{"v":0.1,"d":"10.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":9000,"d":"$9,000"}]
[{"$nulls":8},"Potential savings:",{"v":1000,"d":"$1,000"}]
["Number of career fairs attended annually by your organization",{"$nulls":8},10]
["Average cost of career fairs",{"$nulls":8},{"v":1000,"d":"$1,000"}]
["Potential percentage of costs reduced by using ARAP solutions",{"$nulls":8},{"v":0.1,"d":"10.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":9000,"d":"$9,000"}]
[{"$nulls":8},"Potential savings:",{"v":1000,"d":"$1,000"}]
[]
["Campus recruiting"]
["Annual costs of college recruitment",{"$nulls":8},{"v":80000,"d":"$80,000"}]
["Potential percentage of costs reduced by using ARAP solutions",{"$nulls":8},{"v":0.2,"d":"20.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":64000,"d":"$64,000"}]
[{"$nulls":8},"Potential savings:",{"v":16000,"d":"$16,000"}]
[]
["Travel, lodging, meals, and other miscellaneous items"]
["Annual costs for travel, lodging, meals, and other miscellaneous items",{"$nulls":8},{"v":50000,"d":"$50,000"}]
["Potential percentage of costs reduced by using certain ARAP solutions",{"$nulls":8},{"v":0.1,"d":"10.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":45000,"d":"$45,000"}]
[{"$nulls":8},"Potential savings:",{"v":5000,"d":"$5,000"}]
[]
["Relocation"]
["Annual relocation costs",{"$nulls":8},{"v":100000,"d":"$100,000"}]
["Potential probability percentage of filling an opening with local candidate increased by using ARAP solutions",{"$nulls":8},{"v":0.25,"d":"25.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":75000,"d":"$75,000"}]
[{"$nulls":8},"Potential savings:",{"v":25000,"d":"$25,000"}]
[]
["Signing bonuses and perquisites"]
["Annual costs of signing bonuses and other perquisites",{"$nulls":8},{"v":100000,"d":"$100,000"}]
["Potential percentage of costs reduced by using ARAP solutions",{"$nulls":8},{"v":0.2,"d":"20.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":80000,"d":"$80,000"}]
[{"$nulls":8},"Potential savings:",{"v":20000,"d":"$20,000"}]
[]
["Third-party vendor services"]
["Annual costs of third-party vendor services",{"$nulls":8},{"v":50000,"d":"$50,000"}]
["Potential percentage of costs reduced by integrating third-party vendors into ARAP",{"$nulls":8},{"v":0.2,"d":"20.0%"}]
[{"$nulls":8},"Reduced annual costs:",{"v":40000,"d":"$40,000"}]
[{"$nulls":8},"Potential savings:",{"v":10000,"d":"$10,000"}]
[]
["Employee turnover"]
["Rate of employee turnover",{"$nulls":8},{"v":0.05,"d":"5.0%"}]
["Potential number of replacement hires reduced by using ARAP solutions ",{"$nulls":8},{"v":1000,"d":"1,000"}]
["Potential percentage of number of replacement hires reduced by using ARAP solutions",{"$nulls":8},{"v":0.1,"d":"10.0%"}]
[{"$nulls":8},"Potential savings:",{"v":92148.96551724138,"d":"$92,149"}]
[]
["Opportunity costs of open positions"]
["Your organization's current open-position cycle time (in days)",{"$nulls":8},64]
["Average per-day opportunity costs",{"$nulls":8},{"v":821,"d":"$821"}]
["Reducing the time to fill vacancies by:",{"$nulls":8},{"v":0.15,"d":"15.0%"}]
["Potential savings in this fiscal year by reducing the time to fill vacancies",{"$nulls":8},{"v":12610560,"d":"$12,610,560"}]
["Potential management time savings per hire by using ARAP solutions (in hours)",{"$nulls":8},2]
["Fully burdened hourly pay rate of managers during last fiscal year",{"$nulls":8},{"v":35,"d":"$35"}]
["Potential savings (based on last fiscal year's total number of hires and last fiscal year's fully burdened hourly pay rate for managers) by reducing the time to fill vacancies",{"$nulls":8},{"v":537600,"d":"$537,600"}]
[{"$nulls":8},"Potential savings:",{"v":13148160,"d":"$13,148,160"}]
[]
[]
["Summary of potential savings opportunity"]
["During the first year of use of ARAP solutions, your organization could realize the following savings based on your cost survey results",{"$nulls":8},{"v":13514473.965517242,"d":"$13,514,474"}]
["A breakdown of these cost savings is listed below:"]
[]
["Savings category",null,null,"Potential savings"]
["Automated resume and application processing",null,null,{"v":75915,"d":"$75,915"}]
["Outside staffing firms",null,null,{"v":65000,"d":"$65,000"}]
["Recruitment advertising",null,null,{"v":43750,"d":"$43,750"}]
["Special recruitment programs",null,null,{"v":1000,"d":"$1,000"}]
["Career fairs",null,null,{"v":1000,"d":"$1,000"}]
["External job postings",null,null,{"v":11500,"d":"$11,500"}]
["College recruitment",null,null,{"v":16000,"d":"$16,000"}]
["Travel, lodging, meals, and other items",null,null,{"v":5000,"d":"$5,000"}]
["Relocation",null,null,{"v":25000,"d":"$25,000"}]
["Signing bonuses and perquisites",null,null,{"v":20000,"d":"$20,000"}]
["Third-party vendor services",null,null,{"v":10000,"d":"$10,000"}]
[]
["Turnover",null,null,{"v":92148.96551724138,"d":"$92,149"}]
[]
["Subtotal",null,null,{"v":366313.9655172414,"d":"$366,314"}]
[]
["Add opportunity costs:"]
["Opportunity costs of open positions:",null,null,{"v":13148160,"d":"$13,148,160"}]
[]
["TOTAL OPPORTUNITY FOR SAVINGS",null,null,{"v":13514473.965517242,"d":"$13,514,474"}]