Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help please File Edit Insert Format Help x table [ [ A , B ] , [ 4 , Name ] , [ 7

Help please
File Edit Insert Format Help
x
\table[[A,B],[4,Name],[7,Jimmy Chew],[8,Manny Blanik],[1,Alexa King],[1,Requirement 1],[2,]]
Complete the Payroll Register for the three employees for the week ended March 31,2018. Note that Ankel pays time-and-a-half for overtime. **For columns C - E, reference cells in Payroll Data table; in all other columns, reference cells within Payroll Register table.
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or the Payroll Data table or if you type the numbers in, you will be marked wrong.)
\table[[Payroll Register],[Employee Name,Earnings,Withholdings,Net Pay,\table[[Check],[No]],\table[[Wages],[Expense]]],[\table[[Beginning],[Cumulative],[Earnings]],Pay Rate,\table[[Hours],[Worked]],Regular Pay,\table[[Overtime],[Pay]],\table[[Current],[Period],[Earnings]],\table[[Ending],[Cumulative],[Earnings]],OASDI,Medicare,\table[[Income],[Tax]],Other,\table[[Total]]],[6.2%,1.45%,20.00%,,],[Jimmy Chew,,,,,,,,,,,,,,1104,],[Manny Blanik,,,,,,,,,,,,,,1105,],[Alexa King,,,,,,,a,,,,,,,1106,],[Total,,,,,,,,,,,E,,,,]]
Requirement 2 Complete the Payroll Tax Register for the week ended March 31,2018.
**For columns C & D, reference cells in Payroll Register table; in all other columns, reference cells within Payroll Tax Register table.
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or the Payroll Data table or if you type the numbers in, you will be marked wrong.)
\table[[Payroll Tax Register],[Employee Name,Earnings,Employer Payroll Taxes],[\table[[Beginning],[Cumulative],[Earnings]],\table[[Current],[Period],[Earnings]],\table[[Ending],[Cumulative],[Earnings]],OASDI,Medicare,FUTA,SUTA,Total Taxes],[6.2%,1.45%,0.60%,5.40%
image text in transcribed

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

Step: 3

blur-text-image

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

Investment Analysis And Portfolio Management

Authors: Frank K. Reilly, Peggy L. Hedges, Philip Chang, Keith C. Brown, Hedges Reilly Brown

1st Canadian Edition

0176500693, 978-0176500696

More Books

Students also viewed these Finance questions