HLTH INFO SUPERVISOR  hit 1060 Review the following case study and…

riverafam77 HLTH INFO SUPERVISOR  hit 1060 Review the following case study and…HLTH INFO SUPERVISOR hit 1060Review the following case study and the attached Excel spreadsheet template to calculate variances as indicated in the scenario. Use the spreadsheet template and assumptions to complete the proposed FY2020 budget. Include formulas for calculating all affected columns in the Excel template. Please design a budget justification for presentation to a budget committee.Image transcription textHIM Operating Budget Template Fiscal Year 2018 Benefits (22%of Total Quantity FY2018 Positions FY2018 Salaries/Wagesalaries) Sal/Wages/Ben 87,000 HIM Director 87,000 … Show more… Show moreImage transcription textHIM Operating Budget Template Fiscal Year 2019 Benefits (22%of Total Quantity Salary FY2019 Positions FY2019Salaries/Wages salaries) Sal/Wages/Ben 1 89,000 HI… Show more… Show moreImage transcription textHIM Operating Budget Template Fiscal Year 2020 Benefits (24%of Total Quantity FY2019 Positions FY2020 Salaries/Wagessalaries) Sal/Wages/Ben 1 89,000 HIM Director 77,00… Show more… Show more(round to the nearest tenth)What is the percentage of increase or decrease in the total salaries/wages/benefits for the entire HIM department from FY2018 to FY2019?What is the percentage of increase or decrease in the coders’ total salaries/wages/benefits for all coding positions combined (I, II, III) from FY2018 to FY2019?What is the percentage of increase or decrease in the use of outsourced coding services from FY2018 to FY2019?What is the percentage of increase or decrease in the use of outsourced transcription services from FY2018 to FY2019?What is the percentage of increase in the ROI copying fees from FY2018 to FY2019?What is the percentage of increase in the physician office coding contract from FY2018 to FY2019?Over the past two years, the HIM department coding section has been centralizing coding within the facility. The HIM coding section implemented a new computer-assisted coding product in FY2019. Now that the CAC product is fully operational, the coding section is taking over the remainder of coding for the entire hospital. By the end of FY2020 all hospital and physician coding will be performed by the HIM coding section.University Hospital went live with an EHR for ambulatory and inpatient medical records on March 1, 2018. Prior to this, all records were scanned into a document imaging product by HIM staff. In addition, all progress notes and history and physicals are now completed within the EHR.All employees will receive a flat 2.5 percent increase in salary or wage for FY2020.The total cost for benefits for all employees is 24 percent which is added after the 2.5 percent increase in salary and wage for FY2020.One new coding supervisor will be hired.Two additional coders for each level—coder I, coder II and coder III—will be hired for a total of six new coders.The CAC product requires that organizations designate specific individuals to receive a CAC specialist certification. The two coding supervisors and three data quality specialists will receive this certification. The cost per year, per individual is $225. Add this as a line item to the budget.The number of electronic management clerks will be reduced by two.Outsourced coding expenses are expected to increase by 15 percent from FY2019.Outsourced transcription services are expected to decrease by 10 percent from FY2019.Travel to national and state meetings will be reduced by 5 percent from FY2019.Office supplies expenses will increase by 10 percent from FY2019.University Hospital pays AHIMA dues for the HIM director, all HIM coding managers, and all data quality specialists. The level of dues is Active Membership with credential. This includes four CEU credits. Research this cost.The HIM department will purchase six AHIMA live webinars to provide CEUs for employees. Research this cost.All CAC licensing fees will increase by 10 percent from FY2019.Apply the percentage of increase calculated for the ROI copying fees and the physician office coding contract from FY2018 to FY2019 to FY2020.The HIM director, all coding managers and all data quality specialists will need a set of ICD-10-CM, ICD-10- PCS, and CPT code books for hospital billing/coding. Coders do not need a set of books as coding resources are available within the encoding system. Research this cost. Assume the basic AHIMA membership price for books and find the most economical way to purchase the books. Use the most recent price available.Please analyze the variance analysis between the FY2018 and FY2019 budgets.Please analyze FY2020 budget using the attached Excel spreadsheet.  All totals must be finalized.BusinessBusiness – Other