Suljettu

excel spreadsheet

Tämä projekti sai 36 tarjousta lahjakkailta freelancereilta ja sen keskivertotarjous oli %project_bid_stats_avg_sub_45% %project_currencyDetails_sign_sub_46% (USD) .

Pyydä ilmaisia tarjouksia samanlaisesta projektista
Projektin budjetti
$10 - $30 USD
Huutoja yhteensä
36
Projektin kuvaus

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

Haluatko ansaita rahaa?

  • Aseta budjettisi ja määräaika
  • Hahmottele tarjouksesi
  • Saa maksu työstäsi

Palkkaa freelancereita, jotka tekivät myös tarjouksen tästä projektista

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online