Continuing Payroll Problem A

Refer to the partially completed payroll register which you worked on at the end of Chapter 3. You will now determine the amount of income tax to withhold for each employee, proceeding as follows:

In the appropriate columns of your payroll register, record the filing status for each employee using the information provided.

Record the payroll deductions for the SIMPLE plan that the employer has established for participating employees. All of the employees are participating, and their weekly contributions are listed below. The tax deferral on these deductions applies only to the federal income tax.

Record the amount of federal income taxes using the wage-bracket method and standard withholding.

Record the state income taxes on the gross weekly earnings for each employee. The rate is 3.07% for the state of Pennsylvania.

Record the city income taxes on the gross weekly earnings of each employee. The rate is 3% for the city of Pittsburgh residents.

CAUTION: See "round" rules in Excel Instructions before calculating OT and when creating formulas for employee/employer taxes. Continuing Payroll Problem-A KIPLEY COMPANY, INC. FOR PERIODENNDING January 8,20 -- PAYROLL REGISTER \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{3}{*}{ EMPLDYEE } & \multirow{3}{*}{ } & & & \multicolumn{3}{|c|}{ OVERTIME EARNNINGS } & \multirow{3}{*}{\begin{tabular}{|c|} TOTAL \\ EARNNNGS \\ \end{tabular}} & \multicolumn{9}{|c|}{ DEDUCTIONS } & \multicolumn{2}{|c|}{ NETPAY } & \multicolumn{4}{|c|}{ TAXXABLE EARNINGS } \\ \hline & & & & \begin{tabular}{l} RATE \\ PER \end{tabular} & & & \begin{tabular}{l} RATE \\ PER \end{tabular} & & & \multicolumn{2}{|c|}{ FICA } & \multirow[b]{2}{*}{ FIT } & \multirow[b]{2}{*}{ SIT } & \multirow[b]{2}{*}{ SUTA } & \multirow[b]{2}{*}{CIT} & \multirow[b]{2}{*}{ SIMPFLE } & \multirow{2}{*}{\begin{tabular}{|c|} GROUP \\ INSURANCE \\ \end{tabular}} & \multirow{2}{*}{\begin{tabular}{|l||} HEALTH \\ INSURANCE \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} CHECK \\ NO. \end{tabular}} & \multirow[b]{2}{*}{ AMMUNT } & \multirow[b]{2}{*}{ASDI} & \multirow[b]{2}{*}{HI} & \multirow[b]{2}{*}{ FUTA } & \multirow[b]{2}{*}{ SUTA } \\ \hline & & & & HOUR & AMOUNT & & HOUR & AMOUNT & & ASDI & HI & & & & & & & & & & & & & \\ \hline 11 Carson, Fran M. & & & & & & & & & & & & & & & & & & & 313 & & & & & \\ \hline 12 Wilson, William A. & & & & & & & & & & & & & & & & & & & 314 & & & & & \\ \hline 13 Utley, Harry T. & & & & & & & & & & & & & & & & & & & 315 & & & & & \\ \hline 21 Fife, Lawrence R. & & & & & & & & & & & & & & & & & & & 316 & & & & & \\ \hline 22 Smith, Lucy K. & & & & & & & & & & & & & & & & & & & 317 & & & & & \\ \hline 31 Fay, Gretchen R. & & & & & & & & & & & & & & & & & & & 318 & & & & & \\ \hline 32 Robey, Glenda B. & & & & & & & & & & & & & & & & & & & 319 & & & & & \\ \hline 33 Schork, Thomas K. & & & & & & & & & & & & & & & & & & & 320 & & & & & \\ \hline 51 Hardy, Barbara T. & & & & & & & & & & & & & & & & & & & 321 & & & & & \\ \hline 99 Kipley, Carson C. & & & & & & & & & & & & & & & & & & & 322 & & & & & \\ \hline \begin{tabular}{|c|c|} Totals \\ \end{tabular} & & & & & & & & & & & & & & & & & & & & & & & & \\ \hline \end{tabular} CAUTION: See "round" rules in Excel Instructions before calculating OT and when creating formulas for employee/employer taxes. Continuing Payroll Problem-A KIPLEY COMPANY, INC. FOR PERIODENNDING January 8,20 -- PAYROLL REGISTER \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{3}{*}{ EMPLDYEE } & \multirow{3}{*}{ } & & & \multicolumn{3}{|c|}{ OVERTIME EARNNINGS } & \multirow{3}{*}{\begin{tabular}{|c|} TOTAL \\ EARNNNGS \\ \end{tabular}} & \multicolumn{9}{|c|}{ DEDUCTIONS } & \multicolumn{2}{|c|}{ NETPAY } & \multicolumn{4}{|c|}{ TAXXABLE EARNINGS } \\ \hline & & & & \begin{tabular}{l} RATE \\ PER \end{tabular} & & & \begin{tabular}{l} RATE \\ PER \end{tabular} & & & \multicolumn{2}{|c|}{ FICA } & \multirow[b]{2}{*}{ FIT } & \multirow[b]{2}{*}{ SIT } & \multirow[b]{2}{*}{ SUTA } & \multirow[b]{2}{*}{CIT} & \multirow[b]{2}{*}{ SIMPFLE } & \multirow{2}{*}{\begin{tabular}{|c|} GROUP \\ INSURANCE \\ \end{tabular}} & \multirow{2}{*}{\begin{tabular}{|l||} HEALTH \\ INSURANCE \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} CHECK \\ NO. \end{tabular}} & \multirow[b]{2}{*}{ AMMUNT } & \multirow[b]{2}{*}{ASDI} & \multirow[b]{2}{*}{HI} & \multirow[b]{2}{*}{ FUTA } & \multirow[b]{2}{*}{ SUTA } \\ \hline & & & & HOUR & AMOUNT & & HOUR & AMOUNT & & ASDI & HI & & & & & & & & & & & & & \\ \hline 11 Carson, Fran M. & & & & & & & & & & & & & & & & & & & 313 & & & & & \\ \hline 12 Wilson, William A. & & & & & & & & & & & & & & & & & & & 314 & & & & & \\ \hline 13 Utley, Harry T. & & & & & & & & & & & & & & & & & & & 315 & & & & & \\ \hline 21 Fife, Lawrence R. & & & & & & & & & & & & & & & & & & & 316 & & & & & \\ \hline 22 Smith, Lucy K. & & & & & & & & & & & & & & & & & & & 317 & & & & & \\ \hline 31 Fay, Gretchen R. & & & & & & & & & & & & & & & & & & & 318 & & & & & \\ \hline 32 Robey, Glenda B. & & & & & & & & & & & & & & & & & & & 319 & & & & & \\ \hline 33 Schork, Thomas K. & & & & & & & & & & & & & & & & & & & 320 & & & & & \\ \hline 51 Hardy, Barbara T. & & & & & & & & & & & & & & & & & & & 321 & & & & & \\ \hline 99 Kipley, Carson C. & & & & & & & & & & & & & & & & & & & 322 & & & & & \\ \hline \begin{tabular}{|c|c|} Totals \\ \end{tabular} & & & & & & & & & & & & & & & & & & & & & & & & \\ \hline \end{tabular}