PART II (80 POINTS): Case Study While the scenario below refers to an urban teaching hospital, the setting may easily be changed to a physician office, long-term care facility or ambulatory care center. The staff members and data collection metrics may be changed as appropriate to match the health care setting. Instructions Review the following case study and Excel spreadsheet template found on ahimapress.org 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. Write a budget justification for presentation to a budget committee. Scenario As the director of HIM at University Hospital, you are responsible for developing the annual operating budget for the HIM department. You have met with your coding and transcription supervisors to discuss their area needs and get input on projected volume statistics for the upcoming fiscal year. In addition, you have access to the past two years of budget data. It is now time to develop the operating budget for FY2020. You have been instructed by the budget department to use the spreadsheet provided to submit your FY2020 budget. You will attach a written budget justification of your finalized budget to the University Hospital budget review committee. Calculate the following: (round to the nearest tenth) 1. What is the percentage of increase or decrease in the total salaries/wages/benefits for the entire HIM department from FY2018 to FY2019? 2. 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? 3. What is the percentage of increase or decrease in the use of outsourced coding services from FY2018 to FY2019? 4. What is the percentage of increase or decrease in the use of outsourced transcription services from FY2018 to FY2019? 5. What is the percentage of increase in the ROI copying fees from FY2018 to FY2019? 6. What is the percentage of increase in the physician office coding contract from FY2018 to FY2019?