Excel spreadsheet recreate
waterdawg77
NP_EX16_2a_MirielleWhite_1.xlsxDocumentation
| New Perspectives Excel 2016 | Module 2: SAM Project 1a | |
| The Good Breeze Hotel | |
| FORMATTING WORKBOOK TEXT AND DATA | |
| Author: | Mirielle White |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Hourly Compensation
| The Good Breeze Hotel | ||||||
| Hourly Workers' Compensation | ||||||
| Report Date: | 31-Jan-16 | |||||
| Weekly Hour | ||||||
| Employee | # Regular Hours | # Overtime Hours | Rate | Salary | Total # Hours | Percent Overtime |
| Sarah Marcus | 40 | 5 | 12 | 45 | ||
| Monica Pec | 40 | 2 | 10 | 42 | ||
| Sam Staszowski | 38 | 0 | 13 | 38 | ||
| George Ellerbee | 40 | 10 | 14 | 50 | ||
| Average | ||||||
| The Breakdown of Employee Hours are Shown in this Weekly Hour Chart | ||||||
Hours Worked by Employee
# Regular Hours
Sarah Marcus Monica Pec Sam Staszowski George Ellerbee 40 40 38 40 # Overtime Hours
Sarah Marcus Monica Pec Sam Staszowski George Ellerbee 5 2 0 10
