CH04 Case Study_Answer Key (1)

xlsx

School

Pikes Peak Community College *

*We aren’t endorsed by this school

Course

MISC

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

xlsx

Pages

6

Uploaded by MateFog22094

Report
HIM Operating Budget Template Fiscal Year 2020 Quantity FY2019 Salary Positions FY2020 Salaries/Wages 1 89,000 HIM Director 91,225 2 77,000 HIM Coding Supervisor 157,850 3 63,000 Data Quality Specialists 193,725 2 52,000 Application Specialists 106,600 4 40,500 Release of Information Coordinators 166,050 8 31,000 Coders I 254,200 8 36,000 Coders II 295,200 8 42,000 Coders III 344,400 1 22,000 Electronic Management Clerks 22,550 2 26,500 Document Imaging Specialists 54,325 1 48,500 Transcription Supervisor 49,713 Subtotal: 1,735,838 Outsourced Services Transcription 157,500 Coding 120,750 Licenses/Software 3M Encoder and Abstracting Licenses 165,825 Educational Items Books Quantity = 6@298 1788 Webinars Quantity = 6 @89 534 National and State Meetings Travel 9500 AHIMA Dues Quantity 6 x 185 1110 AHIMA Approved Trainer = 5x 225 1125 Office Supplies 19800 Operating Expenses subtotal: 477,932 Revenue Physician Office Coding Contract 34144 ROI Copying Fees 12,100 Revenue/Income Subtotal: 46244 Total Operating Budget Expenses: 2,630,371 Total Revenue/Income: 46244 Total HIM Budget: 2,584,127 Calculate the following: (round to the nearest tenth) 1.       What is the percentage of increase or decrease in the total sa Answer: FY19 1,759,850 – FY18 1,377,380 × 100 = 27.8% increase in sala 2.       What is the percentage of increase or decrease in the coders’ Answer: FY19 797,880 - FY18 427,000 × 100 = 86.9% increase in co FY18 427,000 3.       What is the percentage of increase or decrease in the use of o
FY18 75 Answer: FY19 105,000 – FY18 75,000 × 100 = 40% increase in the use of 4.       What is the percentage of increase or decrease in the use of o Answer = FY19 175,000 – FY18 250,000 × 100 = 30% decrease in the use of tran 5.       What is the percentage of increase in the ROI copying fees f Answer = FY19 11,000 – FY18 10,000 × 100 = 10% increase in the ROI cop 6.       What is the percentage of increase in the physician office cod Answer = FY19 32,000 – FY18 30,000 × 100 = 6.7% increase in the physic
21,894 113,119 37,884 195,734 46,494 240,219 25,584 132,184 39,852 205,902 61,008 315,208 70,848 366,048 82,656 427,056 5,412 27,962 13,038 67,363 11,931 61,644 416,601 2,152,439 175000x.10 = 17,5000= 175,000-17500 150750 x .10 = 15,075+150,750 10,000*.95 = 9,500 5% decrease 18,000*1.10 = 19,800 10% increase 6.7% increase from FY2018 to FY2019 this same increase applied here 10% increase from FY2018 to FY2019 this same increase applied here FY18 1,377,38 Benefits (24% of salaries) Total Salaries/Wages/Be nefits alaries/wages/benefits for the entire HIM department from FY2018 to FY2019? aries ’ total salaries/wages/benefits for all coding positions combined (I, II, III) from FY2018 to FY2019? oders’ salaries outsourced coding services from FY2018 to FY2019?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
5,000 FY18 250,000 FY18 10,000 FY18 30,000 coding outsourced services outsourced transcription services from FY2018 to FY2019? nscription services rom FY2018 to FY2019? pying fees ding contract from FY2018 to FY2019? cian office coding contract
HIM Operating Budget Template Fiscal Year 2019 Quantity FY2019 Salary Positions FY2019 Salaries/Wages 1 89,000 HIM Director 89,000 19,580 108,580 1 77,000 HIM Coding Supervisor 77,000 16,940 93,940 3 63,000 Data Quality Specialists 189,000 41,580 230,580 2 52,000 Application Specialists 104,000 22,880 126,880 4 40,500 Release of Information Coordinators 162,000 35,640 197,640 6 31,000 Coders I 186,000 40,920 226,920 6 36,000 Coders II 216,000 47,520 263,520 6 42,000 Coders III 252,000 55,440 307,440 3 22,000 Electronic Management Clerks 66,000 14,520 80,520 2 26,500 Document Imaging Specialists 53,000 11,660 64,660 1 48,500 Transcription Supervisor 48,500 10,670 59,170 Subtotal: 1,442,500 317,350 1,759,850 Outsourced Services Transcription 175,000 Coding 105,000 Licenses/Software 3M Encoder and Abstracting Licenses 150,750 Educational Items Books 5,000 Webinars 1,000 National and State Meetings Travel 10,000 AHIMA Dues 875 Office Supplies 18,000 Operating Expenses Subtotal: 465,625 Revenue Physician Office Coding Contract 32,000 ROI Copying Fees 11,000 Total Revenue/Income: 43,000 Total Operating Budget Expenses: 2,225,475 Total Income: 43,000 Total HIM Budget: 2,182,475 Benefits (22% of salaries) Total Salaries/Wages/Be nefits
HIM Operating Budget Template Fiscal Year 2018 Quantity FY2018 Salary Positions FY2018 Salaries/Wage 1 87,000 HIM Director 87,000 19,140 106,140 1 75,000 HIM Coding Supervisor 75,000 16,500 91,500 3 60,000 Data Quality Specialists 180,000 39,600 219,600 2 50,000 Application Specialists 100,000 22,000 122,000 4 40,000 Release of Information Coordinators 160,000 35,200 195,200 3 30,000 Coders I 90,000 19,800 109,800 4 35,000 Coders II 140,000 30,800 170,800 3 40,000 Coders III 120,000 26,400 146,400 4 20,000 Electronic Management Clerks 80,000 17,600 97,600 2 25,000 Document Imaging Specialists 50,000 11,000 61,000 1 47,000 Transcription Supervisor 47,000 10,340 57,340 Subtotals: 1,129,000 248,380 1,377,380 Outsourced Services Transcription 250,000 Coding 75,000 Licenses/Software 3M Encoder and Abstracting Licenses 150,000 Educational Items Books 2,000 Webinars 500 National and State Meetings 6,000 AHIMA Dues 825 Office Supplies 16,000 Operating Expenses Subtotal 500,325 Revenue Physician Office Coding Contract 30,000 ROI Copying Fees 10,000 Total Revenue/Income 40,000 Total Operating Expenses: 1,877,705 Total Income/Revenue: 40,000 Total HIM Budget: 1,837,705 Benefits (22% of salaries) Total Salaries/Wages/B enefits - $$
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help