Current Liabilities and Payroll Using Excel for Payroll Ankel Footwear employees three salespeople, and pays time-and-a-half for overtime. Weekly paychecks are distributed on the Tuesday following the last day of the week (Saturday). Ankel withholds income tax (20%), FICA-OASDI (6.2%), and FICA-Medicare (1.45%). Ankel also pays payroll taxes for FICA-OASDI (6.2%), FICA-Medicare (1.45%), and state and federal unemployment (S.4% and 0.6% respectively). The payroll data for the three salespeople for the week ended March 31 follows: Straight Beginning Cumulative Earnings $420.00 $540.00 $480.00 Hours Time Name Worked Rate Jimmy Chew Manny Blanik Alexa King $15.00 46 $17.00 $22.00 50 38 Requirements: 1 Complete the Payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. 2 Complete the Payroll Tax Register. 3 Compute the total payroll expense for the week ended March 31. Format to two decimal places. 4 Record the payroll entries Ankel makes for each of the following; use cell references to the tax registers for the amounts. a. Wage expense related to the three employees on Saturday, March 31. b. Employer payroll taxes related to the three employees on Saturday, March 31. c. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. d. Payment of wages on Tuesday, April 3. Payroll Duta Strght Bepning Cumule famings Houm Name Tme Werked Rate immy Chew S15.0 $420.0 Manny Mank $17.00 $540 00 AKing $22.00 $480.00 Complete the Parol Rster for the three emplotes for the wekended Mach 31, 201 Nete tha And pays timeandhalf fer overtine or columna C-fernce colls in Payrol Datat nther coluees, refermce c whin Paoll Rster e (Away use cell refermn and formulas where aporopriate t reveful credt Enter all amountpostive valu. De not useain ig or parethese for any walum Requirement1 Payroll Register taming Wahheldiog Curent Ending Beginning Cemtve Wag Employee Name Income T OASDI Medkare Tetal Check No Pay Rate Heun Wored Repe Pay Overtine Pay Pered her Cumulative Epense taring wwing ting taing 141% 20.00% my Che Manny a 1104 1105 116 Total Complete the Payroll Tax Register for the week ended March 31, 2018. For columns C D. reference cells in Payroll Register table in all other columns, reference cells within Payroll Tax Register table. (Always use cell relerences and formulas where appropriate to receive ful cedit. Enter all amount as positive values. Do not use a minus sign or parentheses for any values.) Requirement 2 Payroll Tax Register Employe Payret Ts faming Cement Medur SUTA DAD Ending Cumlute FUTA Begiing Cumate ting Empleyee Name fo taes Perted 3.40% tening teing inyChew Manty Tetal Compute the total pt tar the wnded Mach 1 JAway use cel fercnd fomule he erpritet Requiemet pwwh fery efced Enter l amentspovvaum De et e De n Ione Gres Pa Cant te fapnse tutal Amunt 43 Record the payroll entry Ankel makes for wages expense related to the three employees on Saturday, March 31, 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values) Requirement 4a Account/Explanation Date DR CR To record weges expense and payroll withholdings. Requirement 4b Record the payroll entry Ankel makes for employer payroll taves related to the three employees on Saturday. March 31, 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) DR Account/Explanation CR Date To record employer's payroll tox expense Record the payrol entry Ankel makes for payment of all payrol ta (employee and employer related) on Tuesday, Apri 3, 2018 (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sig or parentheses for any values) 3 Requirement 4 -4 CR DR Account/Explanation 27 28 Date 30 31 32 To record poyment of peyrol tox lobties 34 35 Record the payroll entry Ankel makes for payment of wages on Tuesday, April,2018. (Always use cel references and formulas where appropriate to receive full credit Enter all amunts as positive vallues Do not use a minus sign or parenthese for any values 36 Requirement 4d 37 DR 38 Account/Explanation Date 39 40 41 To record payment of wages 42 43 44 Current Liabilities and Payroll Using Excel for Payroll Ankel Footwear employees three salespeople, and pays time-and-a-half for overtime. Weekly paychecks are distributed on the Tuesday following the last day of the week (Saturday). Ankel withholds income tax (20%), FICA-OASDI (6.2%), and FICA-Medicare (1.45%). Ankel also pays payroll taxes for FICA-OASDI (6.2%), FICA-Medicare (1.45%), and state and federal unemployment (S.4% and 0.6% respectively). The payroll data for the three salespeople for the week ended March 31 follows: Straight Beginning Cumulative Earnings $420.00 $540.00 $480.00 Hours Time Name Worked Rate Jimmy Chew Manny Blanik Alexa King $15.00 46 $17.00 $22.00 50 38 Requirements: 1 Complete the Payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. 2 Complete the Payroll Tax Register. 3 Compute the total payroll expense for the week ended March 31. Format to two decimal places. 4 Record the payroll entries Ankel makes for each of the following; use cell references to the tax registers for the amounts. a. Wage expense related to the three employees on Saturday, March 31. b. Employer payroll taxes related to the three employees on Saturday, March 31. c. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. d. Payment of wages on Tuesday, April 3. Payroll Duta Strght Bepning Cumule famings Houm Name Tme Werked Rate immy Chew S15.0 $420.0 Manny Mank $17.00 $540 00 AKing $22.00 $480.00 Complete the Parol Rster for the three emplotes for the wekended Mach 31, 201 Nete tha And pays timeandhalf fer overtine or columna C-fernce colls in Payrol Datat nther coluees, refermce c whin Paoll Rster e (Away use cell refermn and formulas where aporopriate t reveful credt Enter all amountpostive valu. De not useain ig or parethese for any walum Requirement1 Payroll Register taming Wahheldiog Curent Ending Beginning Cemtve Wag Employee Name Income T OASDI Medkare Tetal Check No Pay Rate Heun Wored Repe Pay Overtine Pay Pered her Cumulative Epense taring wwing ting taing 141% 20.00% my Che Manny a 1104 1105 116 Total Complete the Payroll Tax Register for the week ended March 31, 2018. For columns C D. reference cells in Payroll Register table in all other columns, reference cells within Payroll Tax Register table. (Always use cell relerences and formulas where appropriate to receive ful cedit. Enter all amount as positive values. Do not use a minus sign or parentheses for any values.) Requirement 2 Payroll Tax Register Employe Payret Ts faming Cement Medur SUTA DAD Ending Cumlute FUTA Begiing Cumate ting Empleyee Name fo taes Perted 3.40% tening teing inyChew Manty Tetal Compute the total pt tar the wnded Mach 1 JAway use cel fercnd fomule he erpritet Requiemet pwwh fery efced Enter l amentspovvaum De et e De n Ione Gres Pa Cant te fapnse tutal Amunt 43 Record the payroll entry Ankel makes for wages expense related to the three employees on Saturday, March 31, 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values) Requirement 4a Account/Explanation Date DR CR To record weges expense and payroll withholdings. Requirement 4b Record the payroll entry Ankel makes for employer payroll taves related to the three employees on Saturday. March 31, 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) DR Account/Explanation CR Date To record employer's payroll tox expense Record the payrol entry Ankel makes for payment of all payrol ta (employee and employer related) on Tuesday, Apri 3, 2018 (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sig or parentheses for any values) 3 Requirement 4 -4 CR DR Account/Explanation 27 28 Date 30 31 32 To record poyment of peyrol tox lobties 34 35 Record the payroll entry Ankel makes for payment of wages on Tuesday, April,2018. (Always use cel references and formulas where appropriate to receive full credit Enter all amunts as positive vallues Do not use a minus sign or parenthese for any values 36 Requirement 4d 37 DR 38 Account/Explanation Date 39 40 41 To record payment of wages 42 43 44