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.

• Staff Member

• FTE

• Monday

• Tuesday

• Wednesday

• Thursday

• Friday

• Saturday

• Sunday

• Days/Week

• Hours/Week

• 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:

• Days/Week

• Hours/Week

• 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: [login to view URL]

Rubric

Element Points

The spreadsheet contains all of the staffing requirements listed in the assignment

40

There are appropriately calculated formulas in the cells that represent sums and totals of FTEs, staff per day, hours per week, weekly salary, etc.

40

The spreadsheet is well organized and easy to understand

20

Total

100

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #15674740

## 34 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

mantislin

Hi sir, I am scraping expert, I have did more than 350+ scraping project, please check my feedback then you will know. Can we discuss more details about this project? then I will provide example data/scr Lisää

\$80 USD 2 päivässä
(252 arvostelua)
7.3
schoudhary1553

Hello Sir, I am the expert freelancer for excel spreadsheet job . i have deliver more than 250 projects with 100% client satisfaction. so please give me chance to work on your job. Relevant Skills and Experience I h Lisää

\$30 USD 1 päivässä
(241 arvostelua)
7.5
vlayausa

Hello, I have experience with similar projects before. I would love to help you with this one. Relevant Skills and Experience I am proficient with Excel and can finish this very quick and accurate. Proposed Mileston Lisää

\$35 USD 1 päivässä
(135 arvostelua)
5.8
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free ot message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones \$2 Lisää

\$25 USD 1 päivässä
(69 arvostelua)
5.3
mtdevil369

i hope i can help [login to view URL] 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

\$15 USD 1 päivässä
(34 arvostelua)
4.7
insidenetsoft

Hi, The exercise looks interesting and I would like to help you. By choosing me you will have the opportunity to understand exactly how it works because I will explain you everything we did. Relevant Skills and Expe Lisää

\$20 USD 1 päivässä
(26 arvostelua)
4.3
\$25 USD 1 päivässä
(33 arvostelua)
4.1
c22atianci4

Hi there! I believe I can be of great help to you. I am a new freelancer but I'm not new to providing quality administrative services. I'm an experienced associate teacher in a Computer Institute here in Cebu, Philippi Lisää

\$15 USD 1 päivässä
(4 arvostelua)
3.4
rajgopaliitr

can provide you good excel as required Relevant Skills and Experience MS Excel, internet Proposed Milestones \$20 USD - time managemant

\$20 USD 1 päivässä
(0 arvostelua)
0.0
Cksiddiq

A proposal has not yet been provided

\$22 USD 1 päivässä
(0 arvostelua)
0.0
atz49

hi, i can do the job for you.

\$30 USD 2 päivässä
(0 arvostelua)
0.0
MaySoeThu

I am a new freelancer and so I took an average price. Relevant Skills and Experience I am a health data scientist currently working at a hospital and so drawing a shift with excel is a piece of cake for me. Proposed Lisää

\$25 USD 1 päivässä
(0 arvostelua)
0.0
\$35 USD 5 päivässä
(0 arvostelua)
0.0
\$17 USD 1 päivässä
(0 arvostelua)
0.0

Hi!...... Are you looking for a VERY GOOD 100% ACCURATE data entry clerk?Then you have been looked for me. I have very good experience in excel and especially in financial section .I can do your job JUST FOR \$10 WIT Lisää

\$10 USD 3 päivässä
(0 arvostelua)
0.0
saintshabz

hello sir I am interested in doing this project for you ASAP depending upon your requirements. You can see my profile for my expertise. Regards

\$25 USD 3 päivässä
(1 arvostelu)
0.0
nibban

A Relevant Skills and Experience A Proposed Milestones \$25 USD - A

\$25 USD 2 päivässä
(0 arvostelua)
0.0
beban

The spread sheet shall be prepared with all the columns and rows as mentioned in the description of work. the weekly and annual budgetary provisions shall be done. Relevant Skills and Experience skill and experienc Lisää

\$20 USD 0 päivässä
(1 arvostelu)
0.0
\$20 USD 1 päivässä
(0 arvostelua)
0.0
fazlaymishu

A proposal has not yet been provided

\$25 USD 2 päivässä
(0 arvostelua)
0.0