70.2K

Verified Solution

Link Copied!

please help

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-CASDI (6,2%), and FICA-Medicare (1.45%). Ankel also pays payroll taxes for FICA-OASDI (6.281. FICA-Medicare (1.45%), and state and federal unemployment (5.4% and 0.6% respectively. The payroll data for the three salespeople for the week ended March 31 follows: Straight Beginning Hours Name Time Cumulative 8 Rate Worked Earnings Jimmy Chew $15.00 46 $420.00 10 Manny Blank $17.00 50 $540.00 11 Aleca King $22.00 38 $480.00 12 13 Use the blue shaded areas on the ENTER ANSWERS tob for inputs. 14 Always use coll references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong Enter all amounts at positive 15 values. Do not use a minus sign or parentheses for any valued 16 17 Requirements: Possible Points 18 1 Complete the payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. 55 19 2 Complete the Payroll Tax Register. 32 20 3 Compute the total payroll expense for the week ended March 31. Format to two decimal places 21 4 Record the payroll entries Ankel makes for each of the following use cell references to the tax registers for the amounts. 75 22 a Wage expense related to the three employees on Saturday, March 31. 23 b. Employer payroll taxes related to the three employees on Saturday, March 31. 24 c. Payment of all payroll taxes employee and employer related) on Tuesday, April 25 d. Payment of wages on Tuesday, April 3 26 22 Payroll Data Sorghe Time Name Hours Worked Beginning Cumulative Jimmy Chow M NIE $15.00 512.00 127.00 50 5430.00 $54000 5480.00 10 ME Cimethylate for the orthwedd Mart 2011 otthonistiendo vertime csc Encein Part but in the reference with Pro will references and formules were preparert if you were the instructions to you will be response Mamthavales Payrol Register with malowane Bed Config Pave Home Wort Happy Dimaw Current Period GA Dure Medic Tuta Other New Checi 11 S6 17 11 AN 14N ON M Nein Tond 20 21 22 Requirement Power for the wheel 11.2014 WooCAD Proin with control www.retroveritif you contro tuwing was por Hp) 23 Requirement Complete the appoil Register for the weekended March 31, 2018 **For columns referencecells in Payroll Bagh table in other colorence calls within Payroll Tax Register table (Alwaysereferences and formulas where appropriate to receive credit. if you coast from the instructionstab, you will be wrongmon potem por parentheses for any 24 25 24 27 28 Payroll Tax Register Employee Name Garning Current Beginning Cumulative arning Period OASI Employer Pales Medie FUTA LAS OSON Ending Cumulative Earning SUTA Taties ON SAN 29 30 31 32 33 14 Chew MRI Nesting Tot 36 Requirements Com the payroll pense for the ended March 1 wwwyucan reference and formulas where pronto youcaporom the time. We wengine ili po DIN protestany 37 3 30 40 Amount Description Total Group Darell Tape Total 42 43 44 1 Requirements Record the payroll entry Ankelmakes for was operated to the three employees on Saturday, March 31, 2015 Always use cell references and formulas where appropriate to receive all credit. If you copierom the structions, you will be marked wrong Entermounts as putive values. Do not minus ignor parentheses for any values) Date Account/Explanation DR OR 7 9 10 11 Tomerd wages pense and well with oldings 12 Requirement 4b Record the payrollantry Anke makes for employer paroles related to the three employees on Saturday, March 31, 2016 Always celebrences and formulas where appropriate to receive full credit. If you copist from the intructions tab, you will be marked wrong interal amounts spots De nous minus nor parentheses for any values 13 Date Account/Explanation DR 15 16 17 10 19 20 21 22 to record ample all for expense Requirement 4 Hecord the payroll entry Ankelmakes for payment of payroll taxes employee and employer rated on Tuesday, April, 2018 Always use cell references and formulas where appropriate to receive full credit. If you copy/paste froes the instructions tab, you will be marked wrong Enteral amount positive values. Do not use minus signor parentheses for any values 7 Date Account/Explanation DR CR 9 0 32 33 34 35 36 Requirement 4d To record amento powoltaxabilities Record the payroll entry Ankelmakes for payment of wages on Tuesday, April 3, 2018 (Always use coll references and formulas where appropriate to receive full credit. If you copy/pade from the instructionstab, you will be marked wrong oral amount positive values. Door minus sienor parentheses for any values Date Account/Explanation DR 37 38 39 40 41 42 43 A4 To record payment of wages 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-CASDI (6,2%), and FICA-Medicare (1.45%). Ankel also pays payroll taxes for FICA-OASDI (6.281. FICA-Medicare (1.45%), and state and federal unemployment (5.4% and 0.6% respectively. The payroll data for the three salespeople for the week ended March 31 follows: Straight Beginning Hours Name Time Cumulative 8 Rate Worked Earnings Jimmy Chew $15.00 46 $420.00 10 Manny Blank $17.00 50 $540.00 11 Aleca King $22.00 38 $480.00 12 13 Use the blue shaded areas on the ENTER ANSWERS tob for inputs. 14 Always use coll references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong Enter all amounts at positive 15 values. Do not use a minus sign or parentheses for any valued 16 17 Requirements: Possible Points 18 1 Complete the payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. 55 19 2 Complete the Payroll Tax Register. 32 20 3 Compute the total payroll expense for the week ended March 31. Format to two decimal places 21 4 Record the payroll entries Ankel makes for each of the following use cell references to the tax registers for the amounts. 75 22 a Wage expense related to the three employees on Saturday, March 31. 23 b. Employer payroll taxes related to the three employees on Saturday, March 31. 24 c. Payment of all payroll taxes employee and employer related) on Tuesday, April 25 d. Payment of wages on Tuesday, April 3 26 22 Payroll Data Sorghe Time Name Hours Worked Beginning Cumulative Jimmy Chow M NIE $15.00 512.00 127.00 50 5430.00 $54000 5480.00 10 ME Cimethylate for the orthwedd Mart 2011 otthonistiendo vertime csc Encein Part but in the reference with Pro will references and formules were preparert if you were the instructions to you will be response Mamthavales Payrol Register with malowane Bed Config Pave Home Wort Happy Dimaw Current Period GA Dure Medic Tuta Other New Checi 11 S6 17 11 AN 14N ON M Nein Tond 20 21 22 Requirement Power for the wheel 11.2014 WooCAD Proin with control www.retroveritif you contro tuwing was por Hp) 23 Requirement Complete the appoil Register for the weekended March 31, 2018 **For columns referencecells in Payroll Bagh table in other colorence calls within Payroll Tax Register table (Alwaysereferences and formulas where appropriate to receive credit. if you coast from the instructionstab, you will be wrongmon potem por parentheses for any 24 25 24 27 28 Payroll Tax Register Employee Name Garning Current Beginning Cumulative arning Period OASI Employer Pales Medie FUTA LAS OSON Ending Cumulative Earning SUTA Taties ON SAN 29 30 31 32 33 14 Chew MRI Nesting Tot 36 Requirements Com the payroll pense for the ended March 1 wwwyucan reference and formulas where pronto youcaporom the time. We wengine ili po DIN protestany 37 3 30 40 Amount Description Total Group Darell Tape Total 42 43 44 1 Requirements Record the payroll entry Ankelmakes for was operated to the three employees on Saturday, March 31, 2015 Always use cell references and formulas where appropriate to receive all credit. If you copierom the structions, you will be marked wrong Entermounts as putive values. Do not minus ignor parentheses for any values) Date Account/Explanation DR OR 7 9 10 11 Tomerd wages pense and well with oldings 12 Requirement 4b Record the payrollantry Anke makes for employer paroles related to the three employees on Saturday, March 31, 2016 Always celebrences and formulas where appropriate to receive full credit. If you copist from the intructions tab, you will be marked wrong interal amounts spots De nous minus nor parentheses for any values 13 Date Account/Explanation DR 15 16 17 10 19 20 21 22 to record ample all for expense Requirement 4 Hecord the payroll entry Ankelmakes for payment of payroll taxes employee and employer rated on Tuesday, April, 2018 Always use cell references and formulas where appropriate to receive full credit. If you copy/paste froes the instructions tab, you will be marked wrong Enteral amount positive values. Do not use minus signor parentheses for any values 7 Date Account/Explanation DR CR 9 0 32 33 34 35 36 Requirement 4d To record amento powoltaxabilities Record the payroll entry Ankelmakes for payment of wages on Tuesday, April 3, 2018 (Always use coll references and formulas where appropriate to receive full credit. If you copy/pade from the instructionstab, you will be marked wrong oral amount positive values. Door minus sienor parentheses for any values Date Account/Explanation DR 37 38 39 40 41 42 43 A4 To record payment of wages

Answer & Explanation Solved by verified expert

See Answer