Complete TASK 1,2 & 3

i give you all require information.

If Sisters of Charity experienced an additional 6% inerease in Medicaid patients and lost 4X in managed care patients, what would be the effect on the operating loss? Put your numbers into your forecast spreadsheet. Your 2018 revenum forecast spreadsheet should look exactly like the 2017 revenue chart given above, but should reflect the necessary forecast projections. AFQUIRED: TASK 1-2OIS REVENUE PHOUECTION REQUIRED: TASK 2-2018 DXPENSE PROJECTION The CFO needs to understand the effects of the items noted below on the hospital's bottom line so he can decide what action to take. Concerning revenue, he is particularly worried about: As noted in the Case Detalis above, the CFO is also concerned about rising expenses. The following Information will heip you forecast the 2018 expenses. - Possible changes in payer mix since the hospital took on a new contract with Medicaid, which is expected to add 6% more patients to the current Medicaid patient load. 2018 Salary Expense Projection Information: - Possible changes in payer mix since the hospital just lost a managed care contract that represented a 49 decline from their current managed care patients. - The nursing shortage has caused salarles for the RNs to increase 6.5% and LPNs to increase 2.5% - Physicians are in high demand in the area, so their salaries will increase 7.0\%. Using the projection information given above, develop a spreadsheet as shown below to calculate your forecasted salary expense values. 2018 Non-Salary Expense Projection Information: In addition to the salary projection data given above, the CFO is also concerned with the following anticipated non-salary expense changes: - Medical devices and other supplies are expected to increase 5% overall. - Utilities are expected to increase 2.0\%. - Other operating expenses are expected to increase 3.5%. If Sisters of Charity experienced an additional 6% inerease in Medicaid patients and lost 4X in managed care patients, what would be the effect on the operating loss? Put your numbers into your forecast spreadsheet. Your 2018 revenum forecast spreadsheet should look exactly like the 2017 revenue chart given above, but should reflect the necessary forecast projections. AFQUIRED: TASK 1-2OIS REVENUE PHOUECTION REQUIRED: TASK 2-2018 DXPENSE PROJECTION The CFO needs to understand the effects of the items noted below on the hospital's bottom line so he can decide what action to take. Concerning revenue, he is particularly worried about: As noted in the Case Detalis above, the CFO is also concerned about rising expenses. The following Information will heip you forecast the 2018 expenses. - Possible changes in payer mix since the hospital took on a new contract with Medicaid, which is expected to add 6% more patients to the current Medicaid patient load. 2018 Salary Expense Projection Information: - Possible changes in payer mix since the hospital just lost a managed care contract that represented a 49 decline from their current managed care patients. - The nursing shortage has caused salarles for the RNs to increase 6.5% and LPNs to increase 2.5% - Physicians are in high demand in the area, so their salaries will increase 7.0\%. Using the projection information given above, develop a spreadsheet as shown below to calculate your forecasted salary expense values. 2018 Non-Salary Expense Projection Information: In addition to the salary projection data given above, the CFO is also concerned with the following anticipated non-salary expense changes: - Medical devices and other supplies are expected to increase 5% overall. - Utilities are expected to increase 2.0\%. - Other operating expenses are expected to increase 3.5%