I need the following question to be answered. the tables are supposed to be used to answer the question.

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 cd managed care agreement with the city. Using differential " data, tell me the full cost profit/loss and the differential to cover our full cost? To cover our differential cost: Case Study: Hays County Integrate y County integrated 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) $76.725.792 7,000,000 8,000,000 8.500.000 7.500,000 6,500,000 8,000,000 Food (variable) Purchased Services (variable) Repairs and Maintenance (fixed) Utilities (fixed) Interest (fixed) Depreciation (fixed) TOTAL EXPENSES 9,000,000 8,021.440 3,000,000 $142,247.232 Case Study Hays TABLE IVA Mays County DS Discharges Service (LOS) Acute SNFC) Rehab Cao) 155 Home Health 7.298 27.915 Outpatient 16,826 2017 6.777 239 6,354 2016 20 5.3 251 Emergency 2015 5.93 247 199 4.866 32,207 19. 157 6,082 30,062 162 18.355 3.650 10$ length of stay. SNF s ed nursing for 34.354 22,942 36.500 26,000 TABLE IV-B Percentage of Discharges by Payer leeee 2013 2016 2017 Medicare Medicaid Commercial Managed Care-discount Managed Care-capitation Bad Debt Charity 39 o IN No 27 28 29 30 28 30 21,750 2 - 1725 33 - 37 23,200 st s 3,625 3145 i uso 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,000 28,000 Rehab 40,000 6,560,000 38.000 Home Health 400 460,000 Emergency 1,500 Outpatient 600 15,600,000 112600 SNF = skilled nursing facility 300 (1,60058,400,000 500 (326, 910,000 1843 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 cd managed care agreement with the city. Using differential " data, tell me the full cost profit/loss and the differential to cover our full cost? To cover our differential cost: Case Study: Hays County Integrate y County integrated 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) $76.725.792 7,000,000 8,000,000 8.500.000 7.500,000 6,500,000 8,000,000 Food (variable) Purchased Services (variable) Repairs and Maintenance (fixed) Utilities (fixed) Interest (fixed) Depreciation (fixed) TOTAL EXPENSES 9,000,000 8,021.440 3,000,000 $142,247.232 Case Study Hays TABLE IVA Mays County DS Discharges Service (LOS) Acute SNFC) Rehab Cao) 155 Home Health 7.298 27.915 Outpatient 16,826 2017 6.777 239 6,354 2016 20 5.3 251 Emergency 2015 5.93 247 199 4.866 32,207 19. 157 6,082 30,062 162 18.355 3.650 10$ length of stay. SNF s ed nursing for 34.354 22,942 36.500 26,000 TABLE IV-B Percentage of Discharges by Payer leeee 2013 2016 2017 Medicare Medicaid Commercial Managed Care-discount Managed Care-capitation Bad Debt Charity 39 o IN No 27 28 29 30 28 30 21,750 2 - 1725 33 - 37 23,200 st s 3,625 3145 i uso 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,000 28,000 Rehab 40,000 6,560,000 38.000 Home Health 400 460,000 Emergency 1,500 Outpatient 600 15,600,000 112600 SNF = skilled nursing facility 300 (1,60058,400,000 500 (326, 910,000 1843