Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Calibi Wrap Text Conditional Format as Cell Insert Delete Format 0 Formatting Table- Styles Clipboand F12 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 payrol taxes for F CA OASDI 62% FICA Medicare 1.45% and state and federal unemployment 5.4% and 0.5% respectively). The payroll data for the three salespeople for the week ended March 31 follows: Straight Hours Beginning Worked Cumulative arnings Time Rate Name 10 Jimmy Chew Manny Blanik Alexa King 13 14 Requirements 15 16 Complete the Payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. Complete the Payrll Tax Register Record the payroll entries Ankel makes for each of the following: use cell references to the tax registers for the amounts. 1. 2. 17 3. Compute the total payroll expense for the week ended March 31. Format to two decimal places 18 19 20 21 4. 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. 23 25 Excel Skills: Instructions Payroll | Journal Entries