CAPELLA UNIVERSITY Vila Health: Developing an Operating Budget FY 2017 Variance YTD FY 2017 YTD (Jul- FY 2017 Dec) Budget Operating Revenue Inpatient Revenue $345,040,349 $700,000,000 $(4,959,651) Outpatient Revenue $232,498,397 $525,000,000 $(30,001,603) Total Patient Services Revenue $577,538,746 $1,225,000,000 $(34,961,254) Deductions From Revenue Contractual Adjustments $476,543,215 $950,000,000 $1.543,215 Charity and Uncompensated Care $6,725,412 $14,000,000 $(274,588) Total Deductions From Revenue $483,268,627 $964,000,000 $1.268,627 Net Patient Services Revenue $94,270,119 $261,000,000 $(36 229,881) Other Operating Revenue Other Operating Revenue $3,500,000 $10,000,000 $(1,500,000) Total Operating Revenue $97.770,119 $271,000,000 $(37,729,881) Operating Expenses Salaries and Wages $42.932.230 $88,000,000 $(1,067,770) Employee Benefits S12,624,012 $25,000,000 $124.012 Professional Fees $4,082,215 $9,000,000 $(417.785) Supplies $23,883,407 S46,000,000 S883,407 Purchased Services - Utilities $1,632.191 $3,000,000 $132, 191 Purchased Services - Other $11,536,320 $22,000,000 $536,320 $8,455,254 $17,000,000 $(44.746 Depreciation $2,252,670 Rentals and Leases $252,670 $4,000,000 $5,000,000 $2.715,378 $215,378 Insurance $7.992,144 $18,000,000 $(1,007856 License and Taxes $8,393,790 $18,000,000 $(606,210) Interest Provision for Bad Debts $4,744,642 $8,000,000 $744.642 Other Direct Expenses $131,244.253 $263,000,000 S(255,747) Total Operating Expenses $(33,474,134) $8,000,000 S(37,474.134) Net Operating Revenue $8,000,000 $(37.474.134) Net Revenue Before Items Listed Below $(33,474,134) Extraordinary Item $(33,474,134) $8,000,000 $(37.474 134) Net Revenue or (Expense) FY 2017 YTD (Jul - Dec) FY 2017 Budget FY 2017 Variance YTD Operating Revenue $50,000,000 $(3,876 484) $21,123,516 Inpatient Revenue $50,000,000 $(3,876,484) Total Patient Services Revenue $21,123,516 wh health plece e Benefits asional Foos urchased Services - Utilities purchased Services - Other insurance $3.040.400 $250.160 55.883,497 S27,456 $23,484 $57,315 S21.456 S972,157 $22.433.565 S(1,310,049) 55.750.000 $400,000 $10,000,000 550.000 550.000 $105.000 540.000 $1.500.000 $40.895.000 $9,105.000 5165,408 $50.160 5883,497 $2.456 $(1 516) 54.815 $1.456 $222,157 $(1.986.065) $(5.862 549) License and Taxes Other Direct Expenses Total Operating Expenses Net Revenue or (Expense) My Questions Question: After hearing Owen's message and looking at the draft budget, what are your initial thoughts My Answer: Question: What cuts were made in the Pediatrics budget? My Answer: Question: Is it clear why they were made? My Answer: Question: Vhat ramifications do these adjustments have? ly Answer: Festion: at would you have done differently? Answer: CAPELLA UNIVERSITY Vila Health: Developing an Operating Budget FY 2017 Variance YTD FY 2017 YTD (Jul- FY 2017 Dec) Budget Operating Revenue Inpatient Revenue $345,040,349 $700,000,000 $(4,959,651) Outpatient Revenue $232,498,397 $525,000,000 $(30,001,603) Total Patient Services Revenue $577,538,746 $1,225,000,000 $(34,961,254) Deductions From Revenue Contractual Adjustments $476,543,215 $950,000,000 $1.543,215 Charity and Uncompensated Care $6,725,412 $14,000,000 $(274,588) Total Deductions From Revenue $483,268,627 $964,000,000 $1.268,627 Net Patient Services Revenue $94,270,119 $261,000,000 $(36 229,881) Other Operating Revenue Other Operating Revenue $3,500,000 $10,000,000 $(1,500,000) Total Operating Revenue $97.770,119 $271,000,000 $(37,729,881) Operating Expenses Salaries and Wages $42.932.230 $88,000,000 $(1,067,770) Employee Benefits S12,624,012 $25,000,000 $124.012 Professional Fees $4,082,215 $9,000,000 $(417.785) Supplies $23,883,407 S46,000,000 S883,407 Purchased Services - Utilities $1,632.191 $3,000,000 $132, 191 Purchased Services - Other $11,536,320 $22,000,000 $536,320 $8,455,254 $17,000,000 $(44.746 Depreciation $2,252,670 Rentals and Leases $252,670 $4,000,000 $5,000,000 $2.715,378 $215,378 Insurance $7.992,144 $18,000,000 $(1,007856 License and Taxes $8,393,790 $18,000,000 $(606,210) Interest Provision for Bad Debts $4,744,642 $8,000,000 $744.642 Other Direct Expenses $131,244.253 $263,000,000 S(255,747) Total Operating Expenses $(33,474,134) $8,000,000 S(37,474.134) Net Operating Revenue $8,000,000 $(37.474.134) Net Revenue Before Items Listed Below $(33,474,134) Extraordinary Item $(33,474,134) $8,000,000 $(37.474 134) Net Revenue or (Expense) FY 2017 YTD (Jul - Dec) FY 2017 Budget FY 2017 Variance YTD Operating Revenue $50,000,000 $(3,876 484) $21,123,516 Inpatient Revenue $50,000,000 $(3,876,484) Total Patient Services Revenue $21,123,516 wh health plece e Benefits asional Foos urchased Services - Utilities purchased Services - Other insurance $3.040.400 $250.160 55.883,497 S27,456 $23,484 $57,315 S21.456 S972,157 $22.433.565 S(1,310,049) 55.750.000 $400,000 $10,000,000 550.000 550.000 $105.000 540.000 $1.500.000 $40.895.000 $9,105.000 5165,408 $50.160 5883,497 $2.456 $(1 516) 54.815 $1.456 $222,157 $(1.986.065) $(5.862 549) License and Taxes Other Direct Expenses Total Operating Expenses Net Revenue or (Expense) My Questions Question: After hearing Owen's message and looking at the draft budget, what are your initial thoughts My Answer: Question: What cuts were made in the Pediatrics budget? My Answer: Question: Is it clear why they were made? My Answer: Question: Vhat ramifications do these adjustments have? ly Answer: Festion: at would you have done differently