L M N O P 1 Current Liabilities and Payroll 2 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.2N), and FICA-Medicare (1.45%). Ankel also pays payroll taxes for FICA-CASDI (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: Name Straight Time Hours Worked Beginning Cumulative Earnings $420.00 $540.00 $480.00 Jimmy Chew Manny Blanik Alexa King $15.00 $17.00 $22.00 13 Use the blue shaded areas on the ENTER ANSWERS tab for inputs. 14 ALWAYS use cell references and formulas where appropriate to receive full credit. Copy/pasting values will NOT earn full points. Enter all amounts as positive values. Do not use a 15 minus sign or parentheses for any values. Powible Points SN 17 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. 3. 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. 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. 3 Format dollar amounts to two decimal places. 33 1 Requirement Record the prolontry Alles for pensered to the three employees on Saturday, March 31, 2018 (Always use creerence and forms where appropriate to receive full creditoral amounts as positive . Do not use a 2014. Do not useamna s prenons for y Ankelte for employer tunes ruted to the three employee on Saturd Saturday, March 31, 2018 ordmyerere Ropese Receed the payroly Annemates for payment of all payroltanes employee and employe EEEENNNNNNNHEIM d on Tuesday, April 2018 Account Explanation Becord the party Ankes for pentowe Tuesday, April, 2018 una positiews Do teams y Forderter the da 40 Celot CSDD in appropriate SO CL6020 nappropr SI CHO pr c o ncesto Payroll Ragstertain ENTERANSWERS1 worksheet i e cererences to Payroll Tax Ragstart in ENTERANSWERSI worksheet i ence to win INTRANSWERS Instructions ENTERANSWERS1 ENTERANSWERS Complete the "Yer forth for the and ended March 11, 2018 Nethet Ankel m the role Payroll Register Regale TI IL Complete the Payroll Tax Register for the week ended March 1, 2011 **For columns & Dreference Part n er comferences within Payroll Taxe Always user s and forms where propriate to receive Mo r mors as positive Done r parentheses for any Payroll Tax Register FI 13 NE ENTERANSWERS ENTERANSWERS
