You have been hired as the new Chief Financial Officer for a large integrated health delivery organization. Your first goal is to improve the management information reporting of key company performance indicators. You have decided this information would best be monitored and communicated using a dashboard which contains the following financial and operational metrics.
Key Metric Titles:
Total Margin
Current Ratio
Profit Per Discharge
Occupancy Rate
Average Length of Stay
Return of Assets
Select company data:
2017 Net Income = $2,458,000
2016 Net Income = $2,102,000
2017 Total Assets = $54,275,000
2016 Total Assets = $52,964,000
2017 Total Revenues = $36,416,000
2016 Total Revenues = $32,429,000
2017 Current Assets = $11,732,000
2016 Current Assets = $11,969,000
2017 Current Liabilities = $4,401,000
2016 Current Liabilities = $4,097,000
2017 Inpatient Profit = $8,345,000
2016 Inpatient Profit = $6,919,000
2017 Inpatient Days = 40,062
2016 Inpatient Days = 42,434
2017 Total Discharges = 8,576
2016 Total Discharges = 8,318
2017 # of Licensed Beds = 210
2016 # of Licensed Beds = 210
Assignment:
Using the above select company data elements, develop a 1-page dashboard showing and comparing the above bullet point financial and operational metrics for 2 years. Separate the financial and operational metrics results by presenting the financial metrics together in the upper section of your dashboard and the operational metrics together in the lower section of your dashboard. Note: Label each metric title and show your calculations.
In addition, prepare a 1-page conclusion summarizing the results from your dashboard page, and based on your calculations and analysis, what is your overall assessment of the organization’s performance and condition?
