At Community Hospital, each full-time employee is required to work 2,080 hours annually
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →At Community Hospital, each full-time employee is required to work 2,080 hours annually. The table that follows shows the amount of time that five employees were absent from work over the past year. Create an Excel spreadsheet to answer the questions that follow. Round all answers to two decimal places. Hint: add columns to the spreadsheet for each calculation in a and 13; add a total row for part c. Community Hospital Health Infomatlon Management Department Coding Section Absentee Report Annual Statistics zoxx Employee Name Vacation Hours Used Sick Leave Hours Used A 40 6 B 22 16 C 36 8 D 80 32 E 16 40 a. What is the total absentee rate for each employee? b. What is the sick leave rate for each employee? c. What is the total sick leave rate for this group of employees for the year?
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds