Instructions: Using the Income Statement and Balance Sheet below, calculate each of the ratios below in the yellow cell. Use formulas to show WEST TEXAS REGIONAL HOSPITAL OPERATING DATA Net inpatient revenue Net outpatient revenue Net patient service revenue Inpatient operating expenses Total salaries Total discharges Inpatient days # licensed and staffed beds Average daily census Total FTES Inpatient FTES 2017 $36,200,000 $67,850,000 $104,050,000 $30,825,000 $31,050,000 5,925 34,575 200 95 1,025 575 OPERATING INDICATOR ANALYSIS WTRH 2017 Industry Average $785 Profit per Discharge Inpatient profit Total discharges Indicator Analysis Comparative Analysis $5,750 Net Price per Discharge Net inpatient revenue Total discharges Indicator Analysis Comparative Analysis 58.5% Outpatient Revenue % Net outpatient revenue Net patient service revenue Indicator Analysis Comparative Analysis 49.2% Occupany Rate Inpatient days # Licensed beds x calendar days Indicator Analysis Comparative Analysis 4.7 Average Length of Stay Inpatient days Total discharges Indicator Analysis Comparative Analysis 5.6 Inpatient FTEs per Occupied Bed Inpatient FTES Average daily census Indicator Analysis Comparative Analysis Salary per FTE $32,987 Indicator Analysis Comparative Analysis Total salaries Total FTES Number Styles Cells Editing Ideas - H For each ratio, provide a brief ratio analysis, trend analysis and comparative analysis. Ratio Analysis: Briefly explain what the ratio means Trend Analysis Compare 2017 numbers with 2016 numbers and explain if the numbers improved or declined and briefly why this could have occurred Comparative Analysis Compare WTRH 2017 with industry averages and explain how WTRH did compared to other comparable hospitals. Instructions: Using the Income Statement and Balance Sheet below, calculate each of the ratios below in the yellow cell. Use formulas to show WEST TEXAS REGIONAL HOSPITAL OPERATING DATA Net inpatient revenue Net outpatient revenue Net patient service revenue Inpatient operating expenses Total salaries Total discharges Inpatient days # licensed and staffed beds Average daily census Total FTES Inpatient FTES 2017 $36,200,000 $67,850,000 $104,050,000 $30,825,000 $31,050,000 5,925 34,575 200 95 1,025 575 OPERATING INDICATOR ANALYSIS WTRH 2017 Industry Average $785 Profit per Discharge Inpatient profit Total discharges Indicator Analysis Comparative Analysis $5,750 Net Price per Discharge Net inpatient revenue Total discharges Indicator Analysis Comparative Analysis 58.5% Outpatient Revenue % Net outpatient revenue Net patient service revenue Indicator Analysis Comparative Analysis 49.2% Occupany Rate Inpatient days # Licensed beds x calendar days Indicator Analysis Comparative Analysis 4.7 Average Length of Stay Inpatient days Total discharges Indicator Analysis Comparative Analysis 5.6 Inpatient FTEs per Occupied Bed Inpatient FTES Average daily census Indicator Analysis Comparative Analysis Salary per FTE $32,987 Indicator Analysis Comparative Analysis Total salaries Total FTES Number Styles Cells Editing Ideas - H For each ratio, provide a brief ratio analysis, trend analysis and comparative analysis. Ratio Analysis: Briefly explain what the ratio means Trend Analysis Compare 2017 numbers with 2016 numbers and explain if the numbers improved or declined and briefly why this could have occurred Comparative Analysis Compare WTRH 2017 with industry averages and explain how WTRH did compared to other comparable hospitals
