Answered step by step
Verified Expert Solution
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}{*}{
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started