Spring 2018 HCM 5575-Financial Management of Health Organizations lI Homework #2 Name: 1. Using the BudgetCh04.xis file and Table 4.3A tab, forecast discharges and length of stay for 2015 using a) two compound growth rates (base year 1999 and 2004), b) an unweighted three year moving average, c) exponential smoothing (a 0.80, the 2014 discharge and LOS forecast were 35,597,792 and 4.6 (no change expected from 2013), and a composite forecast with equal weights, 0.25, for the four previously calculated forecasts. Discharges LOS Total Pat. Days T2004 Moving Average Exp. Smoothing Composite 2. Using the Table 4.2 tab calculate the CMI for the hospital. Given the hospital's payment rate is $3,800 Spring 2018 HCM 5575-Financial Management of Health Organizations lI Homework #2 Name: 1. Using the BudgetCh04.xis file and Table 4.3A tab, forecast discharges and length of stay for 2015 using a) two compound growth rates (base year 1999 and 2004), b) an unweighted three year moving average, c) exponential smoothing (a 0.80, the 2014 discharge and LOS forecast were 35,597,792 and 4.6 (no change expected from 2013), and a composite forecast with equal weights, 0.25, for the four previously calculated forecasts. Discharges LOS Total Pat. Days T2004 Moving Average Exp. Smoothing Composite 2. Using the Table 4.2 tab calculate the CMI for the hospital. Given the hospital's payment rate is $3,800