Consider the following scenario:

Sunnyside Nursing Home is an independent 200-bed nursing home in a community in southern New Jersey. The average daily census for the nursing home was 140 in 2015, 2016, and the first half of 2017. In late 2016, the nursing home became licensed to provide in-patient hospice services, which has been quite successful. In 2017, the nursing home started marketing their hospice services, with an average census of 10 patients and, in July 2017, finally saw an exponential increase in hospice utilization.

The Assignment is composed of two parts, and both must be submitted. Be sure to submit the PowerPoint presentation as the first part and then upload the Excel spreadsheet as the second part of the Assignment.

To Prepare:

Review the Week 4 Sunnyside Nursing Home Staffing Plan provided in this week’s Learning Resources
Review each tab to analyze the financial situation in Sunnyside Nursing Home.
2 West Staffing Plan
Review the staffing plan and the Table of Terms to get familiar with the mechanics of variable staffing
Actual Staffing
Complete the missing cells to determine the total variance
Review this tab and focus on the census and number of staff required. Think about the impact of using agency staff and overtime on the current staff
Table
Complete the Table to determine the impact on the budget due to the increase of hospice patients
Hospice
Review this tab to determine the impact of adding the new hospice patients to 2 West
Use formulas or copy and paste as shown in the media to ensure accuracy as you complete the sheets (if needed )
Based on the information and calculations derived in your spreadsheet, reflect on your findings as you prepare to develop a PowerPoint presentation