***Must use EXCEL spreadsheet and show formulas***

Sacramento Memorial Hospital has the following financial data and operational metrics:

Number of beds : 250

Total inpatient admissions : 12,250

Total outpatient visits : 90,754

Total patient revenues : $111,900,050

Outpatient mix : 16.2%

Medicare payment percentage (revenues) : 28%

Average length of stay : 5.8 days

Net price per discharge : $7,653

Cost per discharge : $6,292

a. What is the hospitals profit per discharge? b. What is the hospitals total inpatient and total outpatient revenue? (Hint: Apply patient mix metrics to total revenues.) c. Verify your Part b answer for total inpatient revenue using volume and profitability metrics. (Hint: Calculate price per discharge.) d. What are the hospitals total revenues from Medicare patients? e. What is the total number of inpatient days? f. What is the hospitals occupancy rate?