need help filling out journal entries for a payroll

D E F H 1 K L M B Chapter 11 Using Excel P11-35 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 FICAMedicare (1.45%). Ankel also pays payroll taxes for FICA-OASDI (6.2%), 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 Hours Beginning Name Time Worked Cumulative Rate Earnings Jimmy Chew $15 46 $420 Manny Blanik 50 540 Alexa King 22 38 480 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. 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 pay taxes related to the three employees on Saturday, March 31. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. d. Payment of wages on Tuesday, April 3. Requirement Complete the Payroll Register for the three employees for the week ended March 31, 2018. Payroll Register Earnings Vithholdings Pag Rate Other Employee Name Jimmy Chew Manny Blanit Alexa King Total Beginning Cumulative Earnings $420 540.00 480.00 Hours Yorked 46.00 50.00 38.00 134.00 Regular Pag 600.00 680.00 836.00 $600 Current Ending Period Cumulat Overtim Earning ive e Pal S Earning 135.00 735.00 1.155.00 255.00 935.00 1.475.00 836.00 1.316.00 390.00 2.506,00 3.946.00 Medicar OASDI e Incom 6.27 1.457 e Tax 45.57 10.66 147.00 57.97 13.56 187.00 51.83 12.12 167.20 155.37 36.34 501.20 Total Vithholdi ngs 203.23 258.53 231.15 692.91 Vages Check Ezpens No 1104 735.00 1105 935.00 1106 836.00 2,506.00 Net Pa 53177 676.47 604.85 1,813.09 17.00 22.00 Requirement Complete the Payroll Tax Register for the week ended March 31, 2018. Payroll Tax Register Earnings Employer Paroll Taxes Employee Beginning Curren Ending OASDI Medicar FUTA SUTA Name Cumulative Cumulat 6.272 1.45% 0.60% 5.407 Jimmy Chew $420 7:35.00 1,155.00 45.57 10.66 39.69 Manny Blanil 935.00 1.475.00 57.97 13.56 5.61 50.49 Alexa King $480 836.00 1.316.00 51.83 12.12 5.02 45.14 Total $1,440 $2,506 $3.946 $155 $36 $15 $185 Total Tazes 100.33 127.63 114.11 $342 Requirement Compute the total payroll expense for the week ended March 31. Amount Deseriptio Total Gross Payroll Taxe Total 1,034.88 Requirement Record the payroll entry Ankel makes for wages expense related to the three employees on Saturday, March 31. 3 Date Account/Explanation DR CR . March 31st Farewdwages enrerce and navdanes Requirement Record the payroll entry Ankel makes for employer payroll taxes related to the three employees on Saturday, March 31. 3 3 Date Account/Explanation DR CR 3 Toteocardez lover's ravodlareverse 1 Requirement Record the payroll entry Ankelmakes for payment of all payroll taxes (employee and employer related) on Tuesday, April 3. 2 Date Account/Explanation DR CR 5 26 27 28 23 A B D E 1 Requirement 4a Record the payroll entry Ankel makes for wages expense related to the three employees on Saturday, March 31. 2 3 Date Account/Explanation DR CR 4 March 31st 5 6 7 8 9 To record wages expense and payroll withholdings. 10 11 Requirement 4b Record the payroll entry Ankel makes for employer payroll taxes related to the three employees on Saturday, March 31. 12 13 Date Account/Explanation DR 14 CR 15 16 17 18 19 To record employer's payroll tax expense. 20 21 Requirement 4c Record the payroll entry Ankel makes for payment of all payroll taxes (employee and employer related) on Tuesday, April 3. 22 23 Date Account/Fynlanstinn cord employer's payroll tax expense. ord the payroll entry Ankel makes for payment of all payroll taxes (employee and employer related) on Tuesday, April 3. punt/Explanation DR record payment of payroll tax liabilities. cord the payroll entry Ankel makes for payment of wages on Tuesday, April 3. count/Explanation DR record payment of wages. tions Payroll Journal Entries B 9 To record employer's payroll tax expense. 0 1 Requirement 4c Record the payroll entry Ankel makes for payment of all payroll taxes (employee and employer related) on Tuesday, April 3. 2 Date Account/Explanation DR CR 4 25 2 To record payment of payroll tax liabilities. 31 32 Requirement 4d Record the payroll entry Ankel makes for payment of wages on Tuesday, April 3. 33 Date Account/Explanation DR CR 34 35 36 To record payment of wages. 37