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
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
Get step-by-step solutions from verified subject matter experts
