NU 576 Excel Workbook Exercise
The purpose of this exercise is to familiarize you with the effective use of Excel as a tool to manage finances and numbers. You are to create an Excel worksheet that demonstrates a staffing plan with salary information for a small hospital unit. The Unit is staffed in three 8 hour shifts. There is 1 nurse manager who works Monday through Friday during the day shift. However, the unit is an inpatient unit that operates 24/7. Each day and evening shift should be staffed with 4 RNs, 2 Nursing Assistants and 1 Unit Clerk. Each night shift should be staffed with 3 RNs and 2 Nursing Assistants.
Your spreadsheet should have the following columns:
• Staff Member
• Hourly Rate
• Weekly Salary
Create a row for each staff member and subtotals for each category of staff for the Day, Evening and Night shifts. Calculate the weekly staff salary budget and the annualized salary budget.
You should be using formulas for the following cells on your spreadsheet:
• Weekly Salary
• Subtotals for each category of staff for each shift
• FTE subtotals for each category of staff for each shift and total numbers for the unit
• Weekly salary budget and annual salary budget
You may organize your spreadsheet in any way that makes sense and is easy to understand. All the data should be on a single worksheet. If you are unfamiliar with Excel, you may want to view the videos available on the Microsoft website that are free training classes for Excel: [url removed, login to view]
The spreadsheet contains all of the staffing requirements listed in the assignment
There are appropriately calculated formulas in the cells that represent sums and totals of FTEs, staff per day, hours per week, weekly salary, etc.
The spreadsheet is well organized and easy to understand
36 freelancers are bidding on average $25 for this job
i hope i can help [url removed, login to view] please give me message and come to inbox Relevant Skills and Experience Data Entry, Excel, Photoshop, Web Scraping, Web Search Proposed Milestones $115 USD - project