Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please answer this question PLEASE by providing actual numbers needed as indicated in yellow. Thanks begin{tabular}{|c|c|c|c|c|c|c|c|} hline multicolumn{2}{|c|}{ Payroll Schedule } & multirow[b]{2}{*}{

image text in transcribed

Can someone please answer this question PLEASE by providing actual numbers needed as indicated in yellow. Thanks

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Payroll Schedule } & \multirow[b]{2}{*}{ Payroll End Date } & & & \multicolumn{3}{|c|}{ Q1 - Please determine the payroll accrual Amounts for closing March 2021} \\ \hline Pay Date & Payroll Start Date & & & & Q2 - Please prepare & arch2021 & \\ \hline 3/5/2021 & 2/14/2021 & 2/27/2021 & & & & & \\ \hline 3/19/2021 & 2/28/2021 & 3/13/2021 & & & & & \\ \hline 4/2/2021 & 3/14/2021 & 3/27/2021 & & & & & \\ \hline 4/16/2021 & 3/28/2021 & 4/10/2021 & & & & & \\ \hline 4/30/2021 & 4/11/2021 & 4/24/2021 & & & & & \\ \hline 5/14/2021 & 4/25/2021 & 5/8/2021 & & & & & \\ \hline 5/28/2021 & 5/9/2021 & 5/22/2021 & & & & & \\ \hline 6/11/2021 & 5/23/2021 & 6/5/2021 & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline Payroll Register - 0 & 04/02/2021 & & & & & Accrual for Ma & arch 2021 close \\ \hline Employee & Hire Date & Gross Pay & Employer Taxes & Employee Tax Withholding & Net Pay & Gross Pay & Payroll Taxes \\ \hline Employee A & 01/01/2020 & 6,923.08 & 553.85 & 1,523.08 & 5,400.00 & & \\ \hline Employee B & 05/15/2020 & 5,000.00 & 400.00 & 1,100.00 & 3,900.00 & & \\ \hline Employee C & 07/10/2020 & 4,615.38 & 369.23 & 1,015.38 & 3,600.00 & & \\ \hline Total & & 16,538.46 & 1,323.08 & 3,638.46 & 12,900.00 & 0.00 & 0.00 \\ \hline & & & & & & & \\ \hline Payroll Register - 0 & 04/16/2021 & & & & & Accrual for Ma & arch 2021 close \\ \hline Employee & Hire Date & Gross Pay & Employer Taxes & Employee Tax Withholding & Net Pay & Gross Pay & Payroll Taxes \\ \hline Employee A & 01/01/2020 & 6,923.08 & 553.85 & 1,523.08 & 5,400.00 & & \\ \hline Employee B & 05/15/2020 & 5,000.00 & 400.00 & 1,100.00 & 3,900.00 & & \\ \hline Employee C & 07/10/2020 & 4,615.38 & 369.23 & 1,015.38 & 3,600.00 & & \\ \hline Employee D & 04/01/2021 & 4,615.38 & 369.23 & 1,015.38 & 3,600.00 & & \\ \hline & & & & & & & \\ \hline Total & & 21,153.85 & 1,692.31 & 4,653.85 & 16,500.00 & 0.00 & 0.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Payroll Schedule } & \multirow[b]{2}{*}{ Payroll End Date } & & & \multicolumn{3}{|c|}{ Q1 - Please determine the payroll accrual Amounts for closing March 2021} \\ \hline Pay Date & Payroll Start Date & & & & Q2 - Please prepare & arch2021 & \\ \hline 3/5/2021 & 2/14/2021 & 2/27/2021 & & & & & \\ \hline 3/19/2021 & 2/28/2021 & 3/13/2021 & & & & & \\ \hline 4/2/2021 & 3/14/2021 & 3/27/2021 & & & & & \\ \hline 4/16/2021 & 3/28/2021 & 4/10/2021 & & & & & \\ \hline 4/30/2021 & 4/11/2021 & 4/24/2021 & & & & & \\ \hline 5/14/2021 & 4/25/2021 & 5/8/2021 & & & & & \\ \hline 5/28/2021 & 5/9/2021 & 5/22/2021 & & & & & \\ \hline 6/11/2021 & 5/23/2021 & 6/5/2021 & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline Payroll Register - 0 & 04/02/2021 & & & & & Accrual for Ma & arch 2021 close \\ \hline Employee & Hire Date & Gross Pay & Employer Taxes & Employee Tax Withholding & Net Pay & Gross Pay & Payroll Taxes \\ \hline Employee A & 01/01/2020 & 6,923.08 & 553.85 & 1,523.08 & 5,400.00 & & \\ \hline Employee B & 05/15/2020 & 5,000.00 & 400.00 & 1,100.00 & 3,900.00 & & \\ \hline Employee C & 07/10/2020 & 4,615.38 & 369.23 & 1,015.38 & 3,600.00 & & \\ \hline Total & & 16,538.46 & 1,323.08 & 3,638.46 & 12,900.00 & 0.00 & 0.00 \\ \hline & & & & & & & \\ \hline Payroll Register - 0 & 04/16/2021 & & & & & Accrual for Ma & arch 2021 close \\ \hline Employee & Hire Date & Gross Pay & Employer Taxes & Employee Tax Withholding & Net Pay & Gross Pay & Payroll Taxes \\ \hline Employee A & 01/01/2020 & 6,923.08 & 553.85 & 1,523.08 & 5,400.00 & & \\ \hline Employee B & 05/15/2020 & 5,000.00 & 400.00 & 1,100.00 & 3,900.00 & & \\ \hline Employee C & 07/10/2020 & 4,615.38 & 369.23 & 1,015.38 & 3,600.00 & & \\ \hline Employee D & 04/01/2021 & 4,615.38 & 369.23 & 1,015.38 & 3,600.00 & & \\ \hline & & & & & & & \\ \hline Total & & 21,153.85 & 1,692.31 & 4,653.85 & 16,500.00 & 0.00 & 0.00 \\ \hline \end{tabular}

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

Making Auditors Effective Theory Evidence Perspectives

Authors: Mark Schelker

1st Edition

3832934375, 978-3832934378

More Books

Students also viewed these Accounting questions

Question

b. Explain how you initially felt about the communication.

Answered: 1 week ago