HMT - 220

REQUIRED: TASK 2-2018 EXPENSE PROJECTION As noted in the Case Details above, the CFO is also concerned about rising expenses. The following information will help you forecast the 2018 expenses. 2018 Salary Expense Projection Information: The nursing shortage has caused salaries 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. Position 2017 Total Salary/Benefits % Increase Dollar Increase 2018 Projection Registered Nurse $ 1,465,740.00 Licensed Practical Nurse 1,604,320.00 Physicians 1,582,410.00 Total $ 4,652,470.00 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%