Excel

profileAmy1995
Lab3-2PHMReliableCateringWeeklyPayrollReportEX181.xlsx

Sheet1

PHM Reliable Catering
Weekly Payroll Report
Employee Hire Date Withholding Allowances Rate per Hour Hours Worked Gross Pay Federal Tax State Tax Net Pay
Amico, Kristin Saturday, January 03, 2015 1 18.5 45 878.75
Evans, Timothy Friday, February 06, 2015 2 14.25 28 399
Fernandez, Marissa Thursday, November 05, 2015 0 16 32.5 520
Hall, Richard Saturday, November 12, 2016 2 18.5 40 740
Mi, Emily Tuesday, August 09, 2016 2 14.25 30 427.5
Reed, Linda Saturday, April 15, 2017 3 19 52 1102
Smith, Caroline Friday, June 02, 2017 1 13 27.25 354.25
Totals 254.75 4421.5 0 0 0
Average 1.5714285714 16.2142857143 36.3928571429 631.6428571429 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Highest 3 19 52 1102 0 0 0
Lowest 0 13 27.25 354.25 0 0 0