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,