NUR631 Module6 Activity Worksheet
Overview
The staffing budget frequently comprises a significant portion of a medical unit’s operating budget. For this assignment, you will utilize historical data and related assumptions to prepare a staffing budget for a 36-bed medical/surgical department. Directions Complete the Module Six Activity Worksheet linked in the What to Submit section below. Specifically, you must address the following rubric criteria:
Calculating Workload:
Using pro forma statements, calculate workload for nursing staff.
Calculating Metrics by Role:
Calculate the number of full-time employees, total hours, and total wages for each different nursing role.
Calculating Totals:
Calculate totals for full-time employees, total hours, and total wage for all nursing roles. Calculating Fringe Benefits:
NUR631 Module6 Activity Worksheet
Calculate a registered nurse’s total annual fringe benefits percentage. Completing this activity assignment will help you complete Project Two by helping you understand the process for creating a staffing budget.
What to Submit Worksheet:
Module Six Activity Worksheet Use this worksheet to help complete your assignment.
The staffing or personnel budget frequently comprises a significant portion of a medical unit’s operating budget. For this assignment, you will utilize historical data and assumptions to prepare a staffing budget for a 36-bed medical/surgical department.
Complete this worksheet by replacing the bracketed text with the relevant information. Use these pro forma statements (assumptions):
- The 8-hour shift model is used to define the workday.
- One full-time employee (FTE) is equal to one employee (or a combination of employees), who work full time or 80 hours per 14-day pay period, or for a total of 2,080 hours per year.
- The measurement of work is the average daily census at midnight, which is 30.
- The unit needs to be staffed 24 hours per day, 7 days a week, 365 days a year.
- The budgeted hours per patient day (HPPD) (or the average number of hours of care required over a 24-hour period) is 10.5.
- The skills mix includes nurse managers (1.59% of total FTEs), registered nurses (54.41% of total FTEs), nursing technicians (42.0 % of total FTEs), and unit secretaries (2.0% of total FTEs).
- Managers only work 8-hour dayshifts Monday through Friday.
- For calculating FTEs, assume 1.4 is the constant. It represents the 7 days in a week with an FTE working five days per week. (Note: 7 divided by 5 = 1.4).
- For the next step in calculating FTEs, assume that 1.14 is a constant, which includes 0.14 for nonproductive time, which could represent illness, sick time, personal time, or professional development for each 1.0 FTE.
NUR631 Module6 Activity Worksheet
Data Collection and Calculation of Workload for Nursing Staffing Budget
Complete the following table using the pro forma statements provided to prepare the staffing budget.
| Metric to Be Calculated | Calculations |
| State the average daily census (ADC)/Work Unit | [Insert text.] |
| Calculate total patient days
(ADC × 365 days) |
[Insert text.] |
| Identify the hours per patient day (HPPD) | [Insert text.] |
| Identify the workday unit used | [Insert text.] |
| Calculate the number of required FTEs
(ADC × nursing hours × 1.4 x 1.14) / 8 |
[Insert text.] |
Calculation of Wages for Operating Budget
Now that you have the number of FTEs to staff the unit, you will be able to determine the Cost for Wages line-item on the operating budget. Complete the following table.
Note: Utilize pro forma statements to calculate the skill mix allocation of FTEs.
NUR631 Module6 Activity Worksheet
| Position | Hourly Wage
(Average) |
Number of FTEs | Total Hours
(FTEs × 2,080) |
Total Wages
(Hourly Wage × Total Hours) |
| Nurse Manager | $55.0 | [Insert text.] | [Insert text.] | [Insert text.] |
| Registered Nurse (RN) | $39.50 | [Insert text.] | [Insert text.] | [Insert text.] |
| Nursing Technician | $22.75 | [Insert text.] | [Insert text.] | [Insert text.] |
| Unit Secretary | $18.50 | [Insert text.] | [Insert text.] | [Insert text.] |
| Totals | N/A | [Insert text.] | [Insert text.] | [Insert text.] |
Calculation of Total Annual Fringe Benefits Percentage
Now that you have the total wages for the next fiscal year, complete the chart using the following information. You will need to calculate one registered nurse’s total annual fringe benefits percentage.
- A registered nurse’s total salary is $39.50 per hour or $82,160 per year.
- A registered nurse’s annual fringe benefits including Federal Insurance Contributions Act (FICA); Social Security (SS); Medicare tax; unemployment taxes; workers’ compensation; employee health, dental, vision, disability, and life insurance; and retirement benefits estimated at $20,000 per year.
- You should use this formula: Employee annual fringe benefit ÷ annual salary. (Multiply result by 100 to get the percentage.) apa.
| Percentage to Be Calculated | Calculations |
| Registered Nurse’s Total Annual Fringe Benefits Percentage | [Insert text.] |