Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please provide the formulas for this work. Read this scenario and related details. You are the manager of a nursing unit in a nursing home.
Please provide the formulas for this work.
- Read this scenario and related details.
- You are the manager of a nursing unit in a nursing home. It is budget season. Your organization has moved to zero-based budgeting, meaning you are not editing an existing budget. You are starting with a blank worksheet. The information below is what you know about your department and will have to be taken into account when creating your labor budget.
- The unit is 30 beds. A full-time equivalent (FTE) position is 40 hours and part-time is a minimum of 16 hours and a maximum of 29. Why 29 hours? Because the Affordable Care Act sets 30+ hours as full-time. Shifts are the traditional 7-3, 3-11, and 11-7 times.
- There is one manager and one assistant manager that work daylight. They are not replaced when they are off.
- A registered nurse (RN) is required for each shift.
- One certified nurse aide (CNA) is required for every 10 patients on each shift. One Licensed Practical Nurse (LPN) is required for every 15 patients on each shift. One unit clerk is assigned to the day shift Monday-Friday.
- Payroll taxes and employee benefits (PTEB) is assumed to be 30% of all wages. This includes employee health benefits, paid-time-off (PTO), Medicare, and Social Security taxes.
- Shift differential for 3-11 is $0.60 per hour and $1.00 per hour for 11-7.
- PTO coverage is factored at 10% for those positions requiring coverage (full time only). Direct care and administrative support staff earn PTO that must be covered.
- You are the manager of a nursing unit in a nursing home. It is budget season. Your organization has moved to zero-based budgeting, meaning you are not editing an existing budget. You are starting with a blank worksheet. The information below is what you know about your department and will have to be taken into account when creating your labor budget.
- Using the information in the scenario above, create an FTE budget for a one-year period, in Excel.
- Your column and row headers should look like this example.
- Please be sure to put your headers in row 2 as shown in the example picture above.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started