Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me with the payroll calculations for the table below: Payroll Register for the Period's (2/7-2/18) Gross Pay. Also please show your calculations so

Please help me with the payroll calculations for the table below: Payroll Register for the Period's (2/7-2/18) Gross Pay.
Also please show your calculations so I can better understand how to quickly compute the numbers in the future. Thanks in advance
image text in transcribed
image text in transcribed
\begin{tabular}{|c|c|c|} \hline Employee Number & Name and Address & Payroll information \\ \hline \multirow[t]{9}{*}{ A-Mille } & Thomas Millen & Hire Date: 2.1 .2022 \\ \hline & 1022 Forest School Road & Date of B1rth: 12-16-1992 \\ \hline & Woodstock, VT 05001 & Positionz Production Manager \\ \hline & 8824785855 & Part Time or Full Tine: Full Tine, exenpt \\ \hline & SSN: 031113456 & Marital Status: Mrried Filing Joint ly \\ \hline & A91 (k) deduction: 3x & Pay fate: $35,000 per year \\ \hline & Section 125 deduction: 5155 & Dependents under 17: 3 \\ \hline & & Dependents over 17: 1 \\ \hline & & Step 4 infornation: none \\ \hline \multirow[t]{10}{*}{ A-Tousle } & Avery Towle & Hire Date: 2-1-2022 \\ \hline & 4811 Route 100 & Date of Birth: 7-14-2aen \\ \hline & Plywouth, VT e51e2 & Position: Production Worker \\ \hline & 8029675873 & Part Tise or Full Tine: Full Tine, \\ \hline & SSN: 889749974 & nonexenpt \\ \hline & 401(k) deduction: 5% & Marital Status: Single \\ \hline & Section 125 deduction: $16e & Pay Rate: \$15.ee per hour \\ \hline & & Depeodents under 17 : e \\ \hline & & Dependents over 17 : e \\ \hline & & Step 4 infornation: none \\ \hline \multirow{10}{*}{A= Long } & Charlie Loeg & Hire bate: 2-1-2en2 \\ \hline & 242 Benedict Road 5 . & Date of Birth: 3-16-1997 \\ \hline & Woodstock, VT 05002 & Position: Production Worker \\ \hline & 8024293846 & Part Tine or Full Tine: Full Tine, \\ \hline & SSN: 056234593 & nonexempt \\ \hline & 481(k) deduction: 2 & Marital Status: Married Filling Joint ly \\ \hline & Section 125 deduction: $155 & Pay Rate: $15.60 per hour \\ \hline & & Dependents under 17:2 \\ \hline & & Dependents over 17: 8 \\ \hline & & Step 4 infornation: none \\ \hline \multirow[t]{11}{*}{ B-Shang } & Mary Shangraw & Hire Date: 212022 \\ \hline & 1901 Main Street number 2 & Date of Birth: 8201989 \\ \hline & Bridgewater, VT 65528 & Position: Administrative \\ \hline & 8025755423 & Assistant \\ \hline & SSN: 075288945 & Part Tine or Full Tine: Part Tine, \\ \hline & 401(k) deduction: 3x & nonexempt. \\ \hline & Section 125 deduction: $100 & Marital Status: Single \\ \hline & & Pay Rate: $15.60 per hour \\ \hline & & Dependents under 17 : 0 \\ \hline & & Dependents over 17:1 \\ \hline & & Step 4 infornation: none \\ \hline \multirow[t]{9}{*}{ B-Lewis } & Kristen Leuds & Hire Date: 2-1-2e22 \\ \hline & 84a Dally Hollow Road & Date of Birth: 4-6-1991 \\ \hline & Bridgewater, VT es523 & Position: office Manager \\ \hline & 8323995572 & Part Time or Full Tlee: full TIne, expenpt \\ \hline & SSN: 076395673 & Marital Status: Married Filing Jolntly \\ \hline & 401(k) deduction: 4x & Pay Rate: $32,600 per year \\ \hline & Section 125 deduction: $155 & Dependents under 17:2 \\ \hline & & Dependents over 17:1 \\ \hline & & Step 4 information: none \\ \hline \multirow[t]{10}{*}{ B-Schwa } & Joel Schwartz & Hire Date: 2-1-2e22 \\ \hline & S5 Maple Farn Kay & Date of Birth: 5231993 \\ \hline & Woodstock, VT e5534 & Position: Sales \\ \hline & 8824639985 & Part Time or Full Tine: Full Tine, exenpt: \\ \hline & SSN: 021349876 & Marital Status: Married Filling Joint ly \\ \hline & 401(k) deduction: 5x & Poy Rate: $32,000 per year base plus. \\ \hline & Section 125 deduction: $160 & 3x comission per case sold \\ \hline & & Dependents under 17:2 \\ \hline & & Dependents over 17:0 \\ \hline & & Step 4 infornation: none \\ \hline \multirow[t]{9}{*}{ B-Prevo } & Toni Prevosti & Hire Dotei 212022 \\ \hline & 820 Westminster Road & Date of Birth: 9191987 \\ \hline & Bridgewater, VT e5520 & Position: Oner or President \\ \hline & 8825553456 & Part Tine or Full Tine: Full TIne, exenpt \\ \hline & SSN: 055228443 & Marital Status: Married Filing Jolntly \\ \hline & Ae1 (k) deduction: 6% & Pay Rate: \$45, eee per year \\ \hline & Section 125 deduction: 5155 & Dependents under 17:3 \\ \hline & & Dependents over 17:2 \\ \hline & & Step 4 information; none \\ \hline \end{tabular} The hous for the nonesempt employees are as hollows: Pequired: troin the pilor paysoti peiriod Note: Fosind your anwwers for "Hounly Aate or Period Woge" to 5 decimal plates and all opher answers to 2 decimal places. Houns shouslit be entered as whele numbers

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

Financial Accounting A Global Perspective

Authors: Rod Monger

1st Edition

0470518405, 978-0470518403

More Books

Students also viewed these Accounting questions