request for proposal. Why would you not consider the other two vendors? Are Coders Turnaround Are Coders Are Coders Familiar w/ Familiar w/ What Coding Services are Provided? Payment? Time Certified? 3M? CAC?* Yes No Yes No Yes No Inpatient Outpatient Emergency Ancillary Per Per Chart Hour Vendor 1 48 hours X X X X X X X X Vendor 2 48 hours X X X X X X X X Vendor 3 24 hours X X X X X X X X Vendor 4 72 hours X X X X X X X X Vendor 5 48 hours X X X X X X X X CAC - Computer Assisted Coding 2. Assume you want to go with Vendor 1 after RFPs evaluated. Now you must perform a cost-benefit analysis to see if it is feasible to entirely outsource. Create an Excel spreadsheet calculations. Their pricing structure is $5 per inpatient chart, $3 per outpatient chart, $1.75 for each ER, and $1 per ancillary account. Base your calculations on average daily accounts for each patient type listed below: Inpatient 70 Outpatient 75 ER 185 Ancillary 360 Case Study Citation: FOLEY, D. (2017). HEALTH INFORMATION MANAGEMENT CASE STUDIES. S.I.; NIELSEN BOOKDATA. Note to students: DO NOT share this course assignment with any person/entity. Please be reminded that you have 'agreed' to the BHIS Code of Conduct at the beginning of the course which outlines the Academic Integrity policy of the university (i.e. altering or transmitting without authorization, academic information or records). Unit 5 RevCyc-CD....pptx Unit 5 RevCyc-CD...pptx Epic 83.F AQI 55