Create an MS Excel worksheet based on the information below that determines how
ID: 467777 • Letter: C
Question
Create an MS Excel worksheet based on the information below that determines how much nurse "CB" earned per day and what she earned for the week.
Excel File Development Information
Nurse: CB Week 3 Time Sheet
Hourly wage: $35.75
Monday: 12 hours
Tuesday: 12 hours
Wednesday: 0 hours
Thursday: 8 hours
Friday: 8 hours
Saturday: 0 hours
Sunday: 0 hours
Create a professional MS Word letter to your supervisor, using MS Word, summarizing the information in the worksheet and using the name and address information below.
Supervisor: Mr. Alan Griffy, Nursing Supervisor, Critical Care
Mucho Grando Hospital System
Nursing Office, Suite
45-B 545
Emerald Way
Simpsonati, NY 01010
You: Use your real name
Nurse Manager,ICU
Mucho Grando Hospital System
6767 Whisper Way
Columbianati, MA 98989
After completion, submit your MS Excel and Word files
Explanation / Answer
To,
Mr. Alan Griffy, Nursing Supervisor, Critical Care
Mucho Grando Hospital System
Nursing Office, Suite
45-B 545
Emerald Way
Simpsonati, NY 01010
Subject: Summery of weekly wages of Nurse CB, Week 3 Time Sheet
Dear Sir/Madam,
This is for your information and further action that nurse CB has worked for 40 hours in week 3 have earned $1,430 for the whole week at the rate of $35.75 per hour. For detailed information regarding daily wages, kindly refer the excel file attached herewith.
Kindly do the needful.
Thanking You
From,
XYZ (Use your real name)
Nurse Manager,ICU
Mucho Grando Hospital System
6767 Whisper Way
Columbianati, MA 98989
Nurse: CB Week 3 Time Sheet Day Hourly wage ($35.75) Number of Hours worked each day Total Wage for the day Monday $35.75 12 $429.00 Tuesday $35.75 12 $429.00 Wednesday $35.75 0 $0.00 Thursday $35.75 8 $286.00 Friday $35.75 8 $286.00 Saturday $35.75 0 $0.00 Sunday $35.75 0 $0.00 Total 40 $1,430.00Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.