Times New Roman V 12 v A Accounting Millil 191 Illil 191 v B F Paste BIU av Av $ % 12 A x V fx E Any hours exceeding 96 during this pay period are considered overtime for nonexempt employees. Computer the employee pay below. Update the Employees' Earning Records for the period's pay and update the YTD amount. 6 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. Complete the Payroll Register for October 31. Round wages to five decimal points and all other final 7 answers to two decimal points. 8 9 The hours for the employees are as follows: 5 10 Name Hourly rate (round to 5 decimals) Pay Period Hours 10/16-10/31 Commission Regular Overtime (round to 2 (round to 2 decimals) decimals) s 1,750.00 11 12 Chinson 13 Wayland 14 Peppinico 15 Varden 16 Hissop 17 You 18 19 20 Sunday s $ $ $ s S 11.53846 96 hours (exempt) 36.05769 96 hours (exempt) 20.91346 96 hours (exempt) 20.19231 100 hours 23.79807 103 hours 17.30769 98 hours Monday Saturday 6 22 23 October Tuesday Wednesday Thursday 1 3 8 9 10 15 16 17 22 23 24 29 30 31 7 14 21 28 Friday 4 11 18 25 20 27 12 19 26 26 27 28 Employer Info Employee hire info Oct 15 pay into Payroll Register Oct 15 Oct 31 pay Ready MacBook esc 20 3 Tools Excel File AutoSave Edit View Insert Format OFF QESU- Data Window Help Payroll Project Wage calculation assignment student worksh Review View Tell me eme Insert Draw Page Layout Formulas Data X Calibri (Body) v 11 ' General Conditional Formatti lo lili II Paste BIU ov Millo $ % ) Format as Table Cell Styles v 20 Ax fx B C DE F G H 1 M N 0 No. of No. of Overtime Holiday Hours Hours Commissio Gross ns Earning Taxable Taxable Wages for Wages for Federal W/H FICA Insurance 401(k) Name Anthohy Chinson Mark Wayland Sylvia Peppinico Stevon Varden Leonard Hissop Student Success No. of Regular M/S WH Hourly Rate Hours M 1 11.53846 M 5 36.05769 M 7 20.91346 M 2 20.19231 s 4 23.79807 S 1 17.30769 Total 4 s 6 7 8 9 200 21 22 23 24 25 26 27 28 29 30 Times New Roman V 12 v A Accounting Millil 191 Illil 191 v B F Paste BIU av Av $ % 12 A x V fx E Any hours exceeding 96 during this pay period are considered overtime for nonexempt employees. Computer the employee pay below. Update the Employees' Earning Records for the period's pay and update the YTD amount. 6 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. Complete the Payroll Register for October 31. Round wages to five decimal points and all other final 7 answers to two decimal points. 8 9 The hours for the employees are as follows: 5 10 Name Hourly rate (round to 5 decimals) Pay Period Hours 10/16-10/31 Commission Regular Overtime (round to 2 (round to 2 decimals) decimals) s 1,750.00 11 12 Chinson 13 Wayland 14 Peppinico 15 Varden 16 Hissop 17 You 18 19 20 Sunday s $ $ $ s S 11.53846 96 hours (exempt) 36.05769 96 hours (exempt) 20.91346 96 hours (exempt) 20.19231 100 hours 23.79807 103 hours 17.30769 98 hours Monday Saturday 6 22 23 October Tuesday Wednesday Thursday 1 3 8 9 10 15 16 17 22 23 24 29 30 31 7 14 21 28 Friday 4 11 18 25 20 27 12 19 26 26 27 28 Employer Info Employee hire info Oct 15 pay into Payroll Register Oct 15 Oct 31 pay Ready MacBook esc 20 3 Tools Excel File AutoSave Edit View Insert Format OFF QESU- Data Window Help Payroll Project Wage calculation assignment student worksh Review View Tell me eme Insert Draw Page Layout Formulas Data X Calibri (Body) v 11 ' General Conditional Formatti lo lili II Paste BIU ov Millo $ % ) Format as Table Cell Styles v 20 Ax fx B C DE F G H 1 M N 0 No. of No. of Overtime Holiday Hours Hours Commissio Gross ns Earning Taxable Taxable Wages for Wages for Federal W/H FICA Insurance 401(k) Name Anthohy Chinson Mark Wayland Sylvia Peppinico Stevon Varden Leonard Hissop Student Success No. of Regular M/S WH Hourly Rate Hours M 1 11.53846 M 5 36.05769 M 7 20.91346 M 2 20.19231 s 4 23.79807 S 1 17.30769 Total 4 s 6 7 8 9 200 21 22 23 24 25 26 27 28 29 30