cations of Medicaid expansion forecasts) Analyze my capitated managed care cost analysis for 2017 data, tell me the cost profit/loss. Should we renew the con should we ask for a rate increase and if so, ho cd managed care agreement with the city. Using differential we ask for a rate increase and if so, how much rate increase do we need to cover our full cos? To cover our differential cost? Case Study: Hays County Integrated De tegrated Delivery System TABLE II ways County IDS Actual Expenses (S) through December 31, 2017 Wages, Taxes, Benefits 90% variable, 10% fixed) Professional Fees and Commissions (fixed) Drugs (variable) Medical and Other Supplies (variable) Food (variable) Purchased Services (variable) Repairs and Maintenance (fixed) Utilities (fixed) Interest (fixed) Depreciation (fixed) TOTAL EXPENSES $ 76,725.792 7,000,000 8,000,000 8.500.000 7.500,000 6,500,000 8,000,000 9,000,000 8,021.440 3,000,000 $142,247.232 Case Study Hayes TABLE IVA Mays County IDS Discharges Service (LOS 2017 Acute SNFC) 239 Rehab Cao) 155 Home Health 7.298 Emergency 27.915 Outpatient 16,826 6,354 2016 5.931 2017 157 6,082 30.062 2015 5.93 247 199 4.866 32,207 19.88 251 162 13.355 3.650 105 = length of stay. SNF s ed nursing for 22,942 36.500 26.000 12.500 TABLE IV-B Percentage of Discharges by Payer 2013 24 2016 2017 Medicare Medicaid Commercial Managed Care-discount Managed Care-capitation Bad Debt Charity 20 o 28 29 30 28 30 21,750 2 725 33 - 32 23,200 5 | 6 3 1 3. 1950 1245 TCOGS TABLE IV-C 2017 Charges per Discharge/Visit (5) HCH St. Teresa Acute 40,000 237,240, 38,200 SNF 30,000 1,650,00 28,000 Rehab 40,000 66,560,000 38,000 Home Health 400 460,000 Emergency Outpatient 600 15,600,000 SNF skilled nursing facility 300 1,60058,400,000 1.500 500 (326, 910,000 cations of Medicaid expansion forecasts) Analyze my capitated managed care cost analysis for 2017 data, tell me the cost profit/loss. Should we renew the con should we ask for a rate increase and if so, ho cd managed care agreement with the city. Using differential we ask for a rate increase and if so, how much rate increase do we need to cover our full cos? To cover our differential cost? Case Study: Hays County Integrated De tegrated Delivery System TABLE II ways County IDS Actual Expenses (S) through December 31, 2017 Wages, Taxes, Benefits 90% variable, 10% fixed) Professional Fees and Commissions (fixed) Drugs (variable) Medical and Other Supplies (variable) Food (variable) Purchased Services (variable) Repairs and Maintenance (fixed) Utilities (fixed) Interest (fixed) Depreciation (fixed) TOTAL EXPENSES $ 76,725.792 7,000,000 8,000,000 8.500.000 7.500,000 6,500,000 8,000,000 9,000,000 8,021.440 3,000,000 $142,247.232 Case Study Hayes TABLE IVA Mays County IDS Discharges Service (LOS 2017 Acute SNFC) 239 Rehab Cao) 155 Home Health 7.298 Emergency 27.915 Outpatient 16,826 6,354 2016 5.931 2017 157 6,082 30.062 2015 5.93 247 199 4.866 32,207 19.88 251 162 13.355 3.650 105 = length of stay. SNF s ed nursing for 22,942 36.500 26.000 12.500 TABLE IV-B Percentage of Discharges by Payer 2013 24 2016 2017 Medicare Medicaid Commercial Managed Care-discount Managed Care-capitation Bad Debt Charity 20 o 28 29 30 28 30 21,750 2 725 33 - 32 23,200 5 | 6 3 1 3. 1950 1245 TCOGS TABLE IV-C 2017 Charges per Discharge/Visit (5) HCH St. Teresa Acute 40,000 237,240, 38,200 SNF 30,000 1,650,00 28,000 Rehab 40,000 66,560,000 38,000 Home Health 400 460,000 Emergency Outpatient 600 15,600,000 SNF skilled nursing facility 300 1,60058,400,000 1.500 500 (326, 910,000