Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Please help with this excel project. The blue boxes in the ENTERANSWERS1 and ENTERANSWERS2 are what need filled out. Thanks in advance! File Insert Page

Please help with this excel project. The blue boxes in the "ENTERANSWERS1" and "ENTERANSWERS2" are what need filled out. Thanks in advance! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
File Insert Page LayoutFomulas Data Revien iew Help X Cut 2 Copy Format PaindesIU Conditional Format as Cell insert De formating- Table Styles 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). Anked withholds income tax (20%), FICA-OASD' (.2%. and FICA-Medicare (LASS). Arkel also pin payoll taes Or ICA-OASDI ( 6.2%), FICA-Medicare ( 1.45%. and state and federal unemployment for the week ended March 31 follows (SAS and as% respectively). The payroll data for the three salespeople Straight Time ours Beginning Rate WorkedCumulative Jimmy Chew Manny Blanik S0$540. 3) 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 5 positive values. Do not use a minus sign or parentheses for any values 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 Instructions ENTERANSWERS ENTERANSWERS2 Search the web and Windows 40 2 4 5 6 File Insert Page LayoutFomulas Data Revien iew Help X Cut 2 Copy Format PaindesIU Conditional Format as Cell insert De formating- Table Styles 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). Anked withholds income tax (20%), FICA-OASD' (.2%. and FICA-Medicare (LASS). Arkel also pin payoll taes Or ICA-OASDI ( 6.2%), FICA-Medicare ( 1.45%. and state and federal unemployment for the week ended March 31 follows (SAS and as% respectively). The payroll data for the three salespeople Straight Time ours Beginning Rate WorkedCumulative Jimmy Chew Manny Blanik S0$540. 3) 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 5 positive values. Do not use a minus sign or parentheses for any values 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 Instructions ENTERANSWERS ENTERANSWERS2 Search the web and Windows 40 2 4 5 6

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions