CH04 Case Study_Answer Key (1)
xlsx
keyboard_arrow_up
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
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