NP_EX365_2021_CS5-8a_TramThai_2.xlsx
xlsx
keyboard_arrow_up
School
Tarrant County College, Fort Worth *
*We aren’t endorsed by this school
Course
5
Subject
Communications
Date
Apr 3, 2024
Type
xlsx
Pages
8
Uploaded by ChancellorPelican4250
Author:
Note
New Per
Tallridge Regional Medical Center
FORMATTING, FORMULAS, AND CHARTS
Tram Thai
e: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from th
rspectives Excel 365/2021 | Modules 1-4: SAM Capstone Project 1a
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
Tallridge Regional Medical Center
Staffing and Financial Summary by Department
Staff
Abbreviation
Department
MD
RN
Support
Total
Turnover
CCU
Coronary Care
5
8
15
28
4
EMR
Emergency
12
27
33
72
21
END
Endocrinology
3
6
4
13
0
ICU
Intensive Care
17
22
15
54
5
NEU
Neurology
6
15
8
29
1
OBS
Obstetrics
9
17
17
43
3
ONC
Oncology
5
3
9
17
8
RAD
Radiology
2
8
27
37
4
Total
59
106
128
293
46
Last update
5/13/2024
Today's date
3/30/2024
t
Turnover %
2024 Budget
Department summary
14% $ 5,250,768 5.20%
Abbreviation
ICU
29% $ 18,782,039 9.30%
Department
Intensive Care
0% $ 2,847,592 0.20%
MD
17
9% $ 9,282,172 2.30%
RN
22
3% $ 5,283,109 -1.50%
Support
15
7% $ 11,010,924 3.30%
Total
54
47% $ 12,448,265 6.10%
Turnover
5
11% $ 10,927,453 1.20%
Turnover %
9%
15%
$ 75,832,322 3.26%
2024 Budget
$9,282,172
2.30%
% change from 2023
% change from 2023
Tallridge Regional Medical Center
Budget
Department
2021
2022
2023
2024
Coronary Care
$ 4,590,049 $ 5,108,725 $ 4,991,224 $ 5,250,768 Emergency
14,003,329 16,089,825 17,183,933 18,782,039 Endocrinology
2,775,520 2,850,459 2,841,908 2,847,592 Intensive Care
8,755,483 8,895,571 9,073,482 9,282,172 Neurology
5,095,866 5,289,509 5,363,562 5,283,109 Obstetrics
10,258,041 10,093,912 10,659,171 11,010,924 Oncology
10,617,497 10,734,289 11,732,578 12,448,265 Radiology
10,670,979 10,606,953 10,797,878 10,927,453 Total
$ 66,766,764 $ 69,669,243 $ 72,643,736 $ 75,832,322 2021
2022
2023
2024
202
$0
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
Departmental Budget Comparison 2021-2025
Department
Coronary Care
Emergency
Endocrinology
In
Neurology
Obstetrics
Oncology
Radiology
To
Department Budgets
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
2025
Trend
$ 5,124,750 19,702,359 2,893,153 9,254,325 5,864,251 11,308,219 13,518,816 12,402,659 $ 80,068,532 25
$40,000,000 $45,000,000 $50,000,000 $55,000,000 $60,000,000 $65,000,000 $70,000,000 $75,000,000 $80,000,000 $85,000,000 ntensive Care
otal
Total Budget 6%
25%
4%
12%
7%
14%
17%
15%
2025 Budget by Department Coro
Eme
Endo
Inten
Neur
Obst
Onco
Radi
7%
21%
4%
13%
8%
15%
16%
16%
2021 Budget by Department Coron
Emer
Endoc
Intens
Neuro
Obste
Oncol
Radio
onary Care
ergency
ocrinology
nsive Care
rology
tetrics
ology
iology
nary Care
rgency
crinology
sive Care
ology
etrics
logy
ology