Question

You have been hired as the new Chief Financial Officer for a large integrated health delivery organization and 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

questions:

1. 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.
2. 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?
3. Submit both your dashboard and written conclusion page together.

40 points

Answer 1