I need help solving the excel sheet Below you will find a copy of a weekly payroll report. Each employee has received pay from a

I need help solving the excel sheet image text in transcribed

Below you will find a copy of a weekly payroll report. Each employee has received pay from a variety of methods. The employee could have worked regular hours, could have worked over- time hours, sick hours, vacation hours, holiday pay hours or other (like bereavement). Take the information that follows and key it into the Excel Spreadsheet and make sure you are on the PayRpt tab on the excel spreadsheet. Weekly Time Sheet and Time Report - #6: Employee Name Regular O/T Sick Vacation Holiday Other Hrs. Hrs. Hrs. Hrs Hrs. r TOTAL Hrs 16 40 40 56 16 8 40 40 16 8 Berex 40 W. Day 0 0 0 0 0 B. Myers-cook 40 C. Bunting-cook 24 M. Miller-food 40 server J. Jones-food 32 server D. Doster-food 40 server I. Campbell 16 food server F. Chase 40 T. Hogg 40 0 C. Fisk 20 R. Phillips 15 Line server I. Jacobini 32 V. Murray 30 M. Winford 25 D. Dowling 40 Secretary Total Hours/Col Additional Hrs Total Hrs in Week Payroll Dollars Total Payroll 40 40 0 20 15 8 40 30 25 40 J34 Xfx R V IN Q S T U MANAGER NAME: 2 3 TOT. PAY SICK $$ VAC $$ HOL $$ OTHER $$ Employee Name + 5 $0.00 $0.00 $0.00 $0.00 $0.00 I. Morton 6 $0.00 $0.00 $0.00 $0.00 $0.00 U. Smith 7 $0.00 $0.00 $0.00 $0.00 $0.00 L. Graves 8 $0.00 $0.00 $0.00 $0.00 $0.00 B. Myers 9 $0.00 $0.00 $0.00 $0.00 $0.00 J. Nichols 10 $0.00 $0.00 $0.00 $0.00 $0.00 B. Collins 11 $0.00 $0.00 $0.00 $0.00 $0.00 C. Bunting 12 $0.00 $0.00 $0.00 $0.00 $0.00 B. Smith 13 $0.00 $0.00 $0.00 $0.00 $0.00 R. Phillips 14 $0.00 $0.00 $0.00 $0.00 $0.00 J Crocker 15 $0.00 $0.00 $0.00 $0.00 $0.00 M. Miller 16 $0.00 $0.00 $0.00 $0.00 $0.00 J. Shaffer 17 $0.00 $0.00 $0.00 $0.00 $0.00 F. lacobini 18 $0.00 $0.00 $0.00 $0.00 $0.00 J. Jones 19 $0.00 $0.00 $0.00 $0.00 $0.00 D. Doster 20 $0.00 $0.00 $0.00 $0.00 $0.00 1. Campbell 21 $0.00 $0.00 $0.00 $0.00 $0.00 D. Chimes 22 $0.00 $0.00 $0.00 $0.00 $0.00 D. Jones 23 $0.00 $0.00 $0.00 $0.00 $0.00 V. Murray 24 $0.00 $0.00 $0.00 $0.00 $0.00 F. Chase 25 $0.00 $0.00 $0.00 $0.00 $0.00 T. Hogg 26 $0.00 $0.00 $0.00 $0.00 $0.00 A. Dogg 27 $0.00 $0.00 $0.00 $0.00 $0.00 C. Fisk 28 $0.00 $0.00 $0.00 $0.00 $0.00 M. Winford 29 $0.00 $0.00 $0.00 $0.00 $0.00 S. Rain 30 $0.00 $0.00 $0.00 $0.00 $0.00 W. Day 31 $0.00 $0.00 $0.00 $0.00 $0.00 D. Dowling 32 TOT Pay Sick $$ VAC $$ HOL $$ OTHER S$ Employee Name 33 34 35 $0.00 $0.00 $0.00 $0.00 $0.00 36 37 --- -- --- A C 0 F H E WEEK X N 5 T JOOSTER CAFE 0 R MANAGER NAME Nane Position Pay Rate Reg Hr Sickes Vus Mrs Hels Cook Cook 2 Smith 7L . Men LO 100 $12.00 $10.00 1100 110.00 1750 1750 17 SADO 100 3000 se od 10 10 30.00 Other Total Reg Hun 000 000 00 6.00 6.00 6.00 600 6.00 000 0.00 0.00 000 000 RA Cook Cook Cook Cock Lira Ure Ure resu res UPM NEC Bunting 28 Pos dar 15 1 MM 17 F 5705 175 15 0750 57 35 3735 1735 1000 3D 20 cm OTS RG PAY OT PAY TOT. PAY SICK 55 VAC 55 HOL 15 OTHER 11 Employee Name 10.60 5000 3000 S BD 3660 1000 50.00 Melon 1000 3000 10.00 100 3000 10000 | 1000 3000 000 3000 5000 draws 1000 1000 1000 100 M 100 Joo 1000 9000 1000 1000 1000 1600 ca 30 100 18 1000 0.00 BODO 10.00 Core tee 10.00 $9.000 1.00 300 ope 1600 10 09 10.00 $0.00 ure 1000 10.00 10.00 $0.00 SO 5000 sco 1000 1000 $0.00 100 SO 30 10.00 90.00 Joe 1000 10.00 SOTO 16.00 face 1000 kr se 300C 10.00 19.00 30 od 9000 MM 3.co Boco 000 10.00 1000 so SOBO 100 1000 100 10.00 0 0 ta SOCO 19 FOOD 100 HO 10.00 300 100 S000 000 1000 Bad so 3000 0.00 1000 Camel 10.00 10.00 SO so 1000 1000 to che so HO SOCO 3000 500 SOCO 000 BODO 1000 3000 000 so 100 10 V BOD 3000 SOCO 1000 50 1000 De 0 0 1060 1000 1000 1000 1000 seed 1006 $0.00 1000 A D 1000 1000 1900 1600 106 100 B000 1000 1000 1600 3000 8000 3000 3000 MW 1000 1000 10. Han 10 B000 360 3000 Way JO 1000 OT , Meg Pay 9.10.2011 OTP TOTS iki VAGIRRE HOLIDORETI Employee Name Law 3000 210 0 V My Sara to e 2 ce 000 0.00 000 000 000 0.00 000 000 18.00 67 75 123 3009 de A De 1 San 36.00 w 371 ST 50 100 Pay Rate Reg 00 600 100 ce 100 100 We Other 1992. Totaleg ELILOR NOUS WORKID TOTALE 1000 Below you will find a copy of a weekly payroll report. Each employee has received pay from a variety of methods. The employee could have worked regular hours, could have worked over- time hours, sick hours, vacation hours, holiday pay hours or other (like bereavement). Take the information that follows and key it into the Excel Spreadsheet and make sure you are on the PayRpt tab on the excel spreadsheet. Weekly Time Sheet and Time Report - #6: Employee Name Regular O/T Sick Vacation Holiday Other Hrs. Hrs. Hrs. Hrs Hrs. r TOTAL Hrs 16 40 40 56 16 8 40 40 16 8 Berex 40 W. Day 0 0 0 0 0 B. Myers-cook 40 C. Bunting-cook 24 M. Miller-food 40 server J. Jones-food 32 server D. Doster-food 40 server I. Campbell 16 food server F. Chase 40 T. Hogg 40 0 C. Fisk 20 R. Phillips 15 Line server I. Jacobini 32 V. Murray 30 M. Winford 25 D. Dowling 40 Secretary Total Hours/Col Additional Hrs Total Hrs in Week Payroll Dollars Total Payroll 40 40 0 20 15 8 40 30 25 40 J34 Xfx R V IN Q S T U MANAGER NAME: 2 3 TOT. PAY SICK $$ VAC $$ HOL $$ OTHER $$ Employee Name + 5 $0.00 $0.00 $0.00 $0.00 $0.00 I. Morton 6 $0.00 $0.00 $0.00 $0.00 $0.00 U. Smith 7 $0.00 $0.00 $0.00 $0.00 $0.00 L. Graves 8 $0.00 $0.00 $0.00 $0.00 $0.00 B. Myers 9 $0.00 $0.00 $0.00 $0.00 $0.00 J. Nichols 10 $0.00 $0.00 $0.00 $0.00 $0.00 B. Collins 11 $0.00 $0.00 $0.00 $0.00 $0.00 C. Bunting 12 $0.00 $0.00 $0.00 $0.00 $0.00 B. Smith 13 $0.00 $0.00 $0.00 $0.00 $0.00 R. Phillips 14 $0.00 $0.00 $0.00 $0.00 $0.00 J Crocker 15 $0.00 $0.00 $0.00 $0.00 $0.00 M. Miller 16 $0.00 $0.00 $0.00 $0.00 $0.00 J. Shaffer 17 $0.00 $0.00 $0.00 $0.00 $0.00 F. lacobini 18 $0.00 $0.00 $0.00 $0.00 $0.00 J. Jones 19 $0.00 $0.00 $0.00 $0.00 $0.00 D. Doster 20 $0.00 $0.00 $0.00 $0.00 $0.00 1. Campbell 21 $0.00 $0.00 $0.00 $0.00 $0.00 D. Chimes 22 $0.00 $0.00 $0.00 $0.00 $0.00 D. Jones 23 $0.00 $0.00 $0.00 $0.00 $0.00 V. Murray 24 $0.00 $0.00 $0.00 $0.00 $0.00 F. Chase 25 $0.00 $0.00 $0.00 $0.00 $0.00 T. Hogg 26 $0.00 $0.00 $0.00 $0.00 $0.00 A. Dogg 27 $0.00 $0.00 $0.00 $0.00 $0.00 C. Fisk 28 $0.00 $0.00 $0.00 $0.00 $0.00 M. Winford 29 $0.00 $0.00 $0.00 $0.00 $0.00 S. Rain 30 $0.00 $0.00 $0.00 $0.00 $0.00 W. Day 31 $0.00 $0.00 $0.00 $0.00 $0.00 D. Dowling 32 TOT Pay Sick $$ VAC $$ HOL $$ OTHER S$ Employee Name 33 34 35 $0.00 $0.00 $0.00 $0.00 $0.00 36 37 --- -- --- A C 0 F H E WEEK X N 5 T JOOSTER CAFE 0 R MANAGER NAME Nane Position Pay Rate Reg Hr Sickes Vus Mrs Hels Cook Cook 2 Smith 7L . Men LO 100 $12.00 $10.00 1100 110.00 1750 1750 17 SADO 100 3000 se od 10 10 30.00 Other Total Reg Hun 000 000 00 6.00 6.00 6.00 600 6.00 000 0.00 0.00 000 000 RA Cook Cook Cook Cock Lira Ure Ure resu res UPM NEC Bunting 28 Pos dar 15 1 MM 17 F 5705 175 15 0750 57 35 3735 1735 1000 3D 20 cm OTS RG PAY OT PAY TOT. PAY SICK 55 VAC 55 HOL 15 OTHER 11 Employee Name 10.60 5000 3000 S BD 3660 1000 50.00 Melon 1000 3000 10.00 100 3000 10000 | 1000 3000 000 3000 5000 draws 1000 1000 1000 100 M 100 Joo 1000 9000 1000 1000 1000 1600 ca 30 100 18 1000 0.00 BODO 10.00 Core tee 10.00 $9.000 1.00 300 ope 1600 10 09 10.00 $0.00 ure 1000 10.00 10.00 $0.00 SO 5000 sco 1000 1000 $0.00 100 SO 30 10.00 90.00 Joe 1000 10.00 SOTO 16.00 face 1000 kr se 300C 10.00 19.00 30 od 9000 MM 3.co Boco 000 10.00 1000 so SOBO 100 1000 100 10.00 0 0 ta SOCO 19 FOOD 100 HO 10.00 300 100 S000 000 1000 Bad so 3000 0.00 1000 Camel 10.00 10.00 SO so 1000 1000 to che so HO SOCO 3000 500 SOCO 000 BODO 1000 3000 000 so 100 10 V BOD 3000 SOCO 1000 50 1000 De 0 0 1060 1000 1000 1000 1000 seed 1006 $0.00 1000 A D 1000 1000 1900 1600 106 100 B000 1000 1000 1600 3000 8000 3000 3000 MW 1000 1000 10. Han 10 B000 360 3000 Way JO 1000 OT , Meg Pay 9.10.2011 OTP TOTS iki VAGIRRE HOLIDORETI Employee Name Law 3000 210 0 V My Sara to e 2 ce 000 0.00 000 000 000 0.00 000 000 18.00 67 75 123 3009 de A De 1 San 36.00 w 371 ST 50 100 Pay Rate Reg 00 600 100 ce 100 100 We Other 1992. Totaleg ELILOR NOUS WORKID TOTALE 1000