answer 2 questions hc management

Use the spreadsheet template and assumptions to complete the proposed FY2020 budget. Include formulas for calculating all affected columns in the Excel template.Assumptions

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

QUESTIONS

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 or decrease in the use of outsourced coding services from FY2018 to FY2019?

HIM Operating Budget Template Quantity FY2019 1 2 3 2 4 8 8 8 1 2 1 Positions 89,000 HIM Director 77,000 HIM Coding Supervisor 63,000 Data Quality Specialist 52,000 Application Specialist 40,500 Release of Information Coordinator 31,000 Coder I 36,000 Coder II 42,000 Coder III 22,000 Electronic Management Clerk 26,500 Document Imaging Specialist 48,500 Transcription Supervisor Subtotal: Expenses Outsourced Services Licenses/Software Educational Items Office Supplies Transcription Coding 3M Encoder, Abstracting, CAC Licenses Code Books $200 Webinars $ 89 National and State Meetings Travel AHIMA Dues $185 CAC Specialist Certification $225 Office Supplies Operating Expenses subtotal: Revenue Physician Office Coding Contract ROI Copying Fees Revenue/Income Subtotal: Total Operating Budget Expenses: Total Revenue/Income: Total HIM Budget: Fiscal Year 2020 Benefits (24% of Total FY2020 Salaries/Wages salaries) Sal/Wages/Ben 91,225 21,894 113,119 155,925 37,422 193,347 193,725 46,494 240,219 106,600 25,584 132,184 166,050 39,852 205,902 254,200 61,008 315,208 295,200 70,848 366,048 344,400 82,656 427,056 22,550 5,412 27,962 54,300 13,032 67,332 49,713 11,931 61,644 1,733,888 416,133 2,150,021 148,750 120,750 165,825 1200 534 9500 1110 1125 19800 468,594 34000 12000 46,000 2,202,482 46000 2,156,482 HIM Operating Budget Template Quantity Salary FY2019 Positions 1 89,000 HIM Director 1 77,000 HIM Coding Supervisor 3 63,000 Data Quality Specialist 2 52,000 Application Specialist 4 40,500 Release of Information Coordinator 6 31,000 Coder I 6 36,000 Coder II 6 42,000 Coder III 3 22,000 Electronic Management Clerk 2 26,500 Document Imaging Specialist 1 48,500 Transcription Supervisor Subtotal: Expenses Outsourced Services Transcription Coding 3M Encoder, Abstracting, CAC Licenses Educational Items Code Books Webinars National and State Meetings Travel AHIMA Dues Office Supplies Office Supplies Operating Expenses Subtotal: Revenue Physician Office Coding Contract ROI Copying Fees Total Revenue/Income: Total Operating Budget Expenses: Total Income: Total HIM Budget: Fiscal Year 2019 Benefits (22% of Total Sal/Wages/Ben FY2019 Salaries/Wages salaries) 89,000 19,580 108,580 77,000 16,940 93,940 189,000 41,580 230,580 104,000 22,880 126,880 162,000 35,640 197,640 186,000 40,920 226,920 216,000 47,520 263,520 252,000 55,440 307,440 66,000 14,520 80,520 53,000 11,660 64,660 48,500 10,670 59,170 1,442,500 317,350 1,759,850 175,000 105,000 150,750 5,000 1,000 10,000 875 18,000 465,625 32,000 11,000 43,000 2,225,475 43,000 2,182,475 HIM Operating Budget Template Quantity FY2018 Positions 1 87,000 HIM Director 1 75,000 HIM Coding Supervisor 3 60,000 Data Quality Specialist 2 50,000 Application Specialist 4 40,000 Release of Information Coordinator 3 30,000 Coder I 4 35,000 Coder II 3 40,000 Coder III 4 20,000 Electronic Management Clerk 2 25,000 Document Imaging Specialist 1 47,000 Transcription Supervisor Subtotals: Outsourced Services Transcription Coding Licenses/Software 3M Encoder and Abstracting Licenses Educational Items Code Books Webinars National and State Meetings AHIMA Dues Office Supplies Office Supplies Operating Expenses Subtotal Revenue Physician Office Coding Contract ROI Copying Fees Total Revenue/Income Total Operating Expenses: Total Income/Revenue: Total HIM Budget: Fiscal Year 2018 Benefits (22% of Total FY2018 Salaries/Wages salaries) Sal/Wages/Ben 87,000 19,140 106,140 75,000 16,500 91,500 180,000 39,600 219,600 100,000 22,000 122,000 160,000 35,200 195,200 90,000 19,800 109,800 140,000 30,800 170,800 120,000 26,400 146,400 80,000 17,600 97,600 50,000 11,000 61,000 47,000 10,340 57,340 1,129,000 248,380 1,377,380 250,000 75,000 150,000 2,000 500 6,000 825 16,000 500,325 30,000 10,000 40,000 1,877,705 40,000 1,837,705