Answered step by step
Verified Expert Solution
Link Copied!

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.

  1. 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.
  2. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Retailing Management

Authors: Michael Levy

11th Edition

1264157444, 9781264157440

More Books

Students also viewed these General Management questions

Question

What are the pros and cons of using credit? (p. 321)

Answered: 1 week ago