Alignment Number Styles Clipboard Font A1 4 xfx Chapter 11 A 8 3 P11-35 Using Excel for Payroll D E F G H 3 K M 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 SO 540 12 Alexa King 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 > Instructions Payroll Journal Entries + WWUN Ready DC tv 8 D related to the tive employees on Saturday, March 33 A umere de Recer the payrolety Ankelmakes for 2 3 Accountant DR 4 7 9 Torrondwerkepent and payrol withholdings 10 Record the remakeste encorporated to the three employees on Saturday, March 31 1 que 12 Date 14 Account/uplanation OR 15 16 18 10 Torrordem players 20 21 gemeld Record the avrolet Ankelmakes for aumental savretexestemolove and emekwer related on Tuesday.forin Date Accountant DR a 26 BAXSARA forrerdumento portavobanes 12 mens derde para entre mikesfor payment of wageson Tuesday, April Date Account/uplanation DR CR 35 Tordeumet we 38 30 40 41