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%), FICAOASDI (6.2%), and FICAMedicare (1.45%). Ankel also pays payroll taxes for FICAOASDI (6.2%), FICAMedicare (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:
The rest of the instructions are below in the screenshots! PLEASE HELP and show me how you did it, thank you so much
A B D E F G H H K L M M N 0 P Q R R S S V W 1 Chapter 1! 2 Using Excel P11-35 Using Excel for Payroll 4 Alexa King 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 (5.4% and 0.6% respectively). The payroll data for the three salespeople for the week ended March 31 follows: 5 6 7 Straight Hours Beginning 8 Name Time Worked Cumulative 9 Rate Earnings 10 Jimmy Chew $15 46 $4201 11 Manny Blanik 17 501 540 12 22 38) 480 13 Requirements: 14 1. Complete the Payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. 15 2. Complete the Payroll Tax Register. 16 3. Compute the total payroll expense for the week ended March 31. Format to two decimal places. 17 4. Record the payroll entries Ankel makes for each of the following; use cell references to the tax registers for the amounts. 18 a. Wage expense related to the three employees on Saturday, March 31. 19 b. Employer payroll taxes related to the three employees on Saturday, March 31. 20 C. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. 21 d. Payment of wages on Tuesday, April 3. 22 23 24 Excel Skills: 25 1. Use cell references, both absolute and relative. 26 2. Indent the credits in the journal entries using the Increase indent button in the Paragraph Group on the Home Tab. 27 28 29 30 31 3 Format dollar amounts to two decimal places. 32 33 34 35 36 37 38 an Instructions Payroll Journal Entries + A B C D E F G H J K L M N 0 P Q R S T Complete the Payroll Register for the three employees for the week ended March 31, 2018. 1 Requirement 1 2 3 4 5 Payroll Register Earnings Withholdings Current Period Earnings Hours Worked Total Ending Cumulative Earnings OASDI 6.2% Medicare 1.45% Income Tax Wages Expense Pay Rate Regular Pay Overtime Pay Other Withholdings Net Pay 6 7 8 9 10 11 Beginning Employee Name Cumulative Earnings Jimmy Chew Manny Blanik Check No 1104 1105 1106 Alexa King Total 12 13 14 Requirement 2 15 Complete the Payroll Tax Register for the week ended March 31, 2018. Payroll Tax Register Ending Cumulative OASDI 6.2% Employer Payroll Taxes Medicare FUTA 1.45% 0.60% SUTA 5.40% Total Taxes 16 17 18 19 20 21 22 23 Earnings Beginning Current Employee Name Cumulative Earnings Period Jimmy Chew Manny Blanik Alexa King Total Compute the total payroll expense for the week ended March 31. Description Amount 24 25 26 Requirement 3 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Instructions Payroll Journal Entries + A B C D D E F G G H I J J K L 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 5 6 7 8 9 To record wages expense and payroll withholdings. 10 Record the payroll entry Ankel makes for employer payroll taxes related to the three employees on Saturday, March 31. 11 Requirement 4b 12 13 Date Account/Explanation DR CR 14 15 16 17 18 19 To record employer's payroll tax expense. 20 Record the payroll entry Ankel makes for payment of all payroll taxes (employee and employer related) on Tuesday, April 3. 21 Requirement 4C 22 23 Date Account/Explanation DR CR 24 25 26 27 28 29 30 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. Instructions Payroll Journal Entries + A B C D E F G H I JK L 25 26 27 28 29 30 To record payment of payroll tax liabilities. 31 32 Requirement 4d 33 Date Record the payroll entry Ankel makes for payment of wages on Tuesday, April 3. Account/Explanation / DR CR 34 35 36 To record payment of wages. 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 Instructions Payroll Journal Entries + A B D E F G H H K L M M N 0 P Q R R S S V W 1 Chapter 1! 2 Using Excel P11-35 Using Excel for Payroll 4 Alexa King 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 (5.4% and 0.6% respectively). The payroll data for the three salespeople for the week ended March 31 follows: 5 6 7 Straight Hours Beginning 8 Name Time Worked Cumulative 9 Rate Earnings 10 Jimmy Chew $15 46 $4201 11 Manny Blanik 17 501 540 12 22 38) 480 13 Requirements: 14 1. Complete the Payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. 15 2. Complete the Payroll Tax Register. 16 3. Compute the total payroll expense for the week ended March 31. Format to two decimal places. 17 4. Record the payroll entries Ankel makes for each of the following; use cell references to the tax registers for the amounts. 18 a. Wage expense related to the three employees on Saturday, March 31. 19 b. Employer payroll taxes related to the three employees on Saturday, March 31. 20 C. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. 21 d. Payment of wages on Tuesday, April 3. 22 23 24 Excel Skills: 25 1. Use cell references, both absolute and relative. 26 2. Indent the credits in the journal entries using the Increase indent button in the Paragraph Group on the Home Tab. 27 28 29 30 31 3 Format dollar amounts to two decimal places. 32 33 34 35 36 37 38 an Instructions Payroll Journal Entries + A B C D E F G H J K L M N 0 P Q R S T Complete the Payroll Register for the three employees for the week ended March 31, 2018. 1 Requirement 1 2 3 4 5 Payroll Register Earnings Withholdings Current Period Earnings Hours Worked Total Ending Cumulative Earnings OASDI 6.2% Medicare 1.45% Income Tax Wages Expense Pay Rate Regular Pay Overtime Pay Other Withholdings Net Pay 6 7 8 9 10 11 Beginning Employee Name Cumulative Earnings Jimmy Chew Manny Blanik Check No 1104 1105 1106 Alexa King Total 12 13 14 Requirement 2 15 Complete the Payroll Tax Register for the week ended March 31, 2018. Payroll Tax Register Ending Cumulative OASDI 6.2% Employer Payroll Taxes Medicare FUTA 1.45% 0.60% SUTA 5.40% Total Taxes 16 17 18 19 20 21 22 23 Earnings Beginning Current Employee Name Cumulative Earnings Period Jimmy Chew Manny Blanik Alexa King Total Compute the total payroll expense for the week ended March 31. Description Amount 24 25 26 Requirement 3 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Instructions Payroll Journal Entries + A B C D D E F G G H I J J K L 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 5 6 7 8 9 To record wages expense and payroll withholdings. 10 Record the payroll entry Ankel makes for employer payroll taxes related to the three employees on Saturday, March 31. 11 Requirement 4b 12 13 Date Account/Explanation DR CR 14 15 16 17 18 19 To record employer's payroll tax expense. 20 Record the payroll entry Ankel makes for payment of all payroll taxes (employee and employer related) on Tuesday, April 3. 21 Requirement 4C 22 23 Date Account/Explanation DR CR 24 25 26 27 28 29 30 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. Instructions Payroll Journal Entries + A B C D E F G H I JK L 25 26 27 28 29 30 To record payment of payroll tax liabilities. 31 32 Requirement 4d 33 Date Record the payroll entry Ankel makes for payment of wages on Tuesday, April 3. Account/Explanation / DR CR 34 35 36 To record payment of wages. 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 Instructions Payroll Journal Entries +
