= . Calibri (Body) Date B IU K25 : 11 A @ abc E22 Wrap Text Merge Aai- General - % E . Conditional Styles Actions Themes Aay fx 3 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 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: Straight Time Name Hours Worked Beginning Cumulative Earnings Jimmy Chew S15 4 6 S420 Manny Blanik 17 5 0 540 Alexa King 22138480 13 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. 24 Excel Skills 1. Use cell references, both absolute and relative 2. Indent the credits in the journal entries using the increase indent button in the Paragraph Group on the Home Tab 25 28 14. Instructions Payroll journal Entries + Select destination and press ENTER or choose Paste Sumo 330di @ MA PXOCO 2018 I W