Question: Tallridge Regional Medical Center Budget
This problem has been solved!
You'll get a detailed solution from a subject matter expert that helps you learn core concepts.
See Answer
Tallridge Regional Medical Center
Budget
Department
2018
2019
2020
2021
2022
Trend
Coronary Care
$ 4,590,049
$ 5,108,725
$ 4,991,224
$ 5,250,768
$ 5,124,750
Emergency
14,003,329
16,089,825
17,183,933
18,782,039
19,702,359
Endocrinology
2,775,520
2,850,459
2,841,908
2,847,592
2,893,153
Intensive Care
8,755,483
8,895,571
9,073,482
9,282,172
9,254,325
Neurology
5,095,866
5,289,509
5,363,562
5,283,109
5,864,251
Obstetrics
10,258,041
10,093,912
10,659,171
11,010,924
11,308,219
Oncology
10,617,497
10,734,289
11,732,578
12,448,265
13,518,816
Radiology
10,670,979
10,606,953
10,797,878
10,927,453
12,402,659
Total
$ 66,766,764
$ 69,669,243
$ 72,643,736
$ 75,832,322
$ 80,068,532
On the Budget worksheet, create a 2-D pie chart based on the non-adjacent range A5:A12 and F5:F12. Modify the chart as described below:
Resize and reposition the chart so that the upper-left corner is located within cell H4 and the lower-right corner is located within cell O22.
Apply Chart Style 3 to the chart.
Enter 2022 Budget by Department as the chart title,
