Chamberlain College of Nursing NR 533 Financial Management in Healthcare Organizations

Week 4:Staffing Budgets/FTEs/ Variance Analysis Assignment Guidelines with Scoring Rubric PURPOSE This assignment provideslearners with the opportunity to apply budgeting knowledge and skills by calculating full-time equivalents for a nursing unit, projecting FTE needs related to census changes, and analyzing a variance scenario. DUE DATE: Sunday 11:59 p.m. MT at the end of Week 4 TOTAL POINTS POSSIBLE: 150 REQUIREMENTS Description of the Assignment This assignment is in two scenario-based sections each related to staffing budgets. In the first, the student will perform multistep calculations of FTEs and projection of future FTE needs for a selected nursing unit. The second section involves calculation of budget variance and its analysis. Each section requires supported written interpretation of findings. Criteria for Content Answer the questions and complete the calculations required for the two sections of the assignment. Key points related to Calculations: 1. When performing calculations, standard rounding rules apply. If the number to the right of the decimal is less than 5, round down to the nearest whole number, e.g., 33.4 = 33 If the number to the right of the decimal is 5 or greater, round up to the nearest whole number, e.g. 33.5 =34. 2. Read the question carefully. Pay close attention to the units be asked and keep them consistent. For example, hours vs FTEs; days vs months vs years. 3. Provide ALL formulas with references. Designate which formula associates with which source. It is not sufficient to simply list the source at the beginning of the section. Write out the formula used BEFORE filling in the numbers. Example: Efficiency Variance + Volume Variance + Cost Variance = Total Variance Rundio, A. (2016). The nurse manager’s guide to budgeting and finance. 2nd. Ed., Indianapolis, IN: Sigma Theta Tau International. • Section One: Staffing Budget and FTEs o Calculations of full-time equivalents (FTEs) o Project FTE needs related to census changes • Section Two: Variance Analysis o Calculating variance o Variance analysis with explanation Download the Assignment Word Document and submit your answers directly onto the form. When completed, upload into the assignment portal in your course. For the questions requiring a written response, please adhere to proper grammar and syntax, and provide references. For the questions requiring calculations, show all your work including the formula used. Include the references for formula chosen. PREPARING THE ASSIGNMENT Section One—Staffing Budget and FTEs Personnel Budget Case Study Sandra Chambers has recently accepted the position of assistant administrator for the department of nursing at Potter Regional Medical Center where she will oversee the operations of five medical units. As she evaluates the budgets for the different cost centers, she finds that all are being used at near or full capacity. The activity in four of the five has remained steady over the past 2 years. A fifth unit has realized a steady increase in patient volume during that time and is currently at 88% capacity. It has been projected that within the next 12 months the volume of patients moving through that unit will increase by 20%. Sandra needs to determine if the current FTEs for the unit will be sufficient to ensure quality and safe care continues to be provided, and if not, what is the number of FTEs that will be needed to cover a 20% increase in volume. 1. Suggest all the information Sandra needs to collect in order to project the FTEs needed for the next fiscal year accounting for the projected increased capacity. Remember, she is new to her position so be sure to include background data on the unit itself as it relates to previous budgets, nursing staff, and the organization. In other words, summarize your approach to this Case Study. For Sandra to accurate forecast the next financial year’s budget, the information that are supposed to be gathered are the average length that patients stay, care hours offered per the total days of the patient, average of the total number of the days a patient stays in the hospital, and the daily census of the patients (Leger & Dunham-Taylor, 2018). The other aspect that Sandra should focus on is the unit acuity. Besides, additional expenses associated with non-staff may comprise of supplies (clerical and medical), and equipment, service and maintenance contracts, as well as certification costs, tuition reimbursement, and the cost of training that may be financed by the department. 2. Sandra has collected the following census information on all five units for the last month, in addition to what was asked in question number one. Calculate the ADC and Occupancy Rate for each unit using the Daily Census/Occupancy Rate table to determine which unit is currently at 88% occupancy rate and projected to increase over the next year. Total 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 3 3 Patie Unit 1 2 3 4 5 6 7 8 9 24 25 28 29 Beds 0 1 2 3 4 5 6 7 8 9 0 1 2 3 6 7 0 1 nt Days 3 3 3 3 2 3 3 3 3 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 A 35 32 31 33 31 0 941 1 0 1 0 9 0 1 0 1 9 9 2 1 3 1 1 3 4 4 4 4 2 0 0 0 4 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 B 15 9 7 17 16 16 14 0 424 5 4 1 2 2 5 3 3 6 5 5 5 6 6 5 4 5 6 5 3 3 5 6 5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 C 13 12 12 13 13 0 372 0 2 1 1 1 3 3 3 2 3 2 2 2 3 3 3 3 3 3 3 3 3 3 2 2 3 3 2 2 2 2 2 2 2 2 2 2 2 3 2 3 3 3 3 3 3 3 3 2 2 2 3 D 32 25 25 31 31 0 841 0 7 7 4 6 3 7 9 8 8 5 7 0 6 1 1 0 0 0 2 2 2 6 5 3 0 E 6 6 3 3 3 3 5 5 5 2 2 2 2 4 4 3 3 0 0 0 6 5 5 3 3 3 2 5 4 3 3 0 97 (adapted from…..Healthcare Financial Management Association (2012). Managing fiscal resources: A budget and productivity case study. Retrieved from ADC = total days of a patient/ number of days in a given month Occupancy = total number of days of a patient / (total number of days in a month * the total number of beds) (American Health Information Management Association, 2014) Average Daily Census/Occupancy Rate Unit ADC Occupancy (%) A 941 = 31.67. 32 30 941 ×100 = 90% 35 × 30 patients B 424 = 14.13. 14 424 ×100=94 % 30 15 × 30 patients C 372 = 12.4. 12 372 ×100=95 % 30 13 × 30 patients D 841 =28.03. 28 841 ×100=88 % 30 32 ×30 patients E 97 = 3.23. 3 patients 97 ×100=54 % 30 6 × 30 The Unit with an 88% occupancy rate is The answer is D . 3. Using data contained in the first questions, complete the table below and determine the Average Length of Stay (ALOS) for the following three units. Show your work. ALOS = Patient Days ¿ Discharges Unit # Beds Patient Days # Discharges Average Length of Stay