Question: Please help finish this excel project. The blue boxes in the ENTERANSWERS1 and ENTERANSWERS2 tabs are what need filled in. If any boxes need formulas

Please help finish this excel project. The blue boxes in the "ENTERANSWERS1" and "ENTERANSWERS2" tabs are what need filled in. If any boxes need formulas please include them. Read through hints as well. Thanks in advance!
 Please help finish this excel project. The blue boxes in the
"ENTERANSWERS1" and "ENTERANSWERS2" tabs are what need filled in. If any boxes
need formulas please include them. Read through hints as well. Thanks in
advance! Font Current Liabilities and Payroll 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 (62%), and FICA- Medicare (145%). Arkel
also pays payroll taxes for FCA OASDI 62%), FCA Medicare 145% ,

Font Current Liabilities and Payroll 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 (62%), and FICA- Medicare (145%). Arkel also pays payroll taxes for FCA OASDI 62%), FCA Medicare 145% , 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 Rate Worked Cumulative Earnings Name $15.00 $17.00 $22.00 $420.00 $540.00 $480.00 immy 46 Manny Blanik$ Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. 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 minus sign or parentheses for any values. Requirements Possible Points 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 32 Instructions ENTERANSWERS1ENTERANSWERS2 Search the web and Windows

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!