Suljettu

excel spreadsheet

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

• 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: [url removed, login to view]

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

Taidot: tiedonsyöttö, Excel, Photoshop, Tietojen kaavinta verkosta, verkkohaku

Näytä lisää: i want an excel spreadsheet written, want create ipad app excel spreadsheet, excel spreadsheet want convert app, free annual leave excel spreadsheet, excel spreadsheet stock control, multi level marketing pay plans excel spreadsheet, convert excel spreadsheet standalone application, convert excel spreadsheet label, excel spreadsheet surgery cost, year plan excel spreadsheet, reformat excel spreadsheet, send bulk mail excel spreadsheet, excel spreadsheet quickbooks, time management excel spreadsheet, excel spreadsheet copy paste values

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #15674740

36 freelancers are bidding on average $25 for this job

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ä
(212 arvostelua)
7.1
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ä
(206 arvostelua)
7.2
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ä
(124 arvostelua)
5.7
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ä
(62 arvostelua)
5.2
25 $ USD 1 päivässä
(26 arvostelua)
3.9
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ä
(18 arvostelua)
3.8
mtdevil369

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

15 $ USD 1 päivässä
(4 arvostelua)
1.6
HasinduMadushan

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
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
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
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
25 $ USD 2 päivässä
(0 arvostelua)
0.0
17 $ USD 1 päivässä
(0 arvostelua)
0.0
35 $ USD 5 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ä
(0 arvostelua)
0.0
josesol

I am willing to give much more than the requirement of your requirements so that the work is excellent a Habilidades y experiencia relevante I have developed spreadsheets working with different financial and logical f Lisää

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