Instructions: Using the Income Statement and Balance Sheet below, calculate each of the ratios below in the yellow cell. Use formulas to show your work. 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 W licensed and staffed beds Average daily census Total FTEs Inpatient FTEs 2017 S36,200,000 S67,850,000 104,050,000 S30,825,000 S31,050,000 5,925 34.575 200 95 1,025 575 OPERATING INDICATOR ANALYSIS WTRH 2017 Industry Average Profit per Discharge $785 Total discharges Net Price per Discharge $5,750 Total discharges Outpatient Revenue % 58.5% Net patient service revenue Occupany Rate 49.2% # Licensed beds x calendar days Average Length of Stay 4.7 Total discharges Inpatient FTEs per Occupied Bed 5.6 Average daily census Salary per FTE S32.987 Total salaries Total FTEs