You are a financial analyst working for the controllers group for the California location of Kindred Hospital group. Your controller has highlighted the fact that gross revenue consists of both inpatient revenue and outpatient revenue. However, only one facility Kindred Hospital- Rancho has outpatient revenue. Therefore, the controller wants a full understanding of inpatient revenue by facility for 2019. Specifically, you are asked to understand the dollar amount of inpatient revenue contributed by each facility in 2019, and how inpatient revenue has changed since 2018. Finally, the controller is creating a financial forecast for inpatient revenue for 2020 and wants to understand the utilization data that may contribute to the generation of this forecast. To satisfy your company cotroller, you are planning your analysis and have started the chart which follows. The controller has also provided you with a data dictionary for the data relevant to this analysis. Variables Definition per Data Dictionary DayTotal Patient Days Total OccupancyLicensed Occupancy rate Licensed beds OccupancyAvailable Occupancy rate Available beds AverageLengthStayAll Average Length of Stay Including Long Term Care AverageLengthStayNoLTC Average Length of Stay Excluding Long Term Care GrossInpatientRevenue Gross Inpatient Revenue Complete the chart for descriptive, diagnostic, and predictive analytics. Objective Initial Question Sub-questions Possible Measures Descriptive Analysis: Understand gross inpatient revenue for the year 2019, which is the year under audit. What happened to gross patient revenue during 2019? 1. 2. Diagnostic Analysis: Understand what happened to gross inpatient revenue for the year 2019 compared to 2018. How has revenue changed at the locations? 3. 4. Predictive Analysis: Identify the utilization measures that are related to in-patient revenue. Are there any measures correlated to inpatient revenue? 5. 6. 7. Use the data available to calculate the measures.