This wseniment is part of the Asigrunents category that is worth 20% of your owerall grade. Deadline Phease refer to your tracking calendar. Coinpleting this susessanent wall holp you to meot the following: Coune Outcomes - Recogrize the importance of accounting ethics and interpersonal skills when nosolving accounting isoves. - Solve a varity of payroll fuections useing computerization and Microsott Exel. Direction the Cieneral Ledger o 5 pts eash) ACCT10-MB - Payroll Entries Assignment Template Home insert Draw Page Layout Formulas Data Review View Help X cut Book Antiqus 12 B I U Format Painter Clipboard Font Wrap Text Merge\&Center 12 Confidential A B C D Alignment Grading Criteria: M3 - Payroll Entries Assignment 1. 2 Payroll Joumal Entries 2. 10 Postings to General Ledger. 25 E \begin{tabular}{rr} & 50 \\ & 50 \\ TOTAL & 100 \end{tabular} KJO Withholdings Employee Payroll Register For Period Ending March 31 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Enuployee Wases } & \multicolumn{4}{|c|}{ Emplover Payroll Tax } \\ \hline & & & & Federal & Total & & & & Federal & State \\ \hline Employe & Grons & FICA & Medicare & Income Tax & \begin{tabular}{c} Total \\ Deductions \\ \end{tabular} & Net Pay & FicA & Medicare & \begin{tabular}{c} Unemployment \\ Tax \end{tabular} & \begin{tabular}{c} Uneaploymen \\ Tax \end{tabular} \\ \hline 5nm & 125000 & 7750 & 18.13 & 95.00 & 190.63 & 1059.38 & 7730 & 18.13 & 0.00 & 0.00 \\ \hline Dule & & 4805 & 11.24 & 87,00 & 146,29 & 02871 & 48.05 & 11.24 & 0.00 & 0.00 \\ \hline Debbie & 750.00 & 46.50 & 10.58 & 87.00 & 144.38 & 605.03 & 4650 & 10.85 & 0.00 & 0.00 \\ \hline Alall & 615.00 & 38,13 & 8.92 & 65,00 & 11205 & 502.95 & 35,13 & 8.92 & 0.00 & 0.00 \\ \hline Katie & \begin{tabular}{|c|} 53000 \\ 53394000 \end{tabular} & 4.10 & 7.98 & 5200 & 94.08 & \begin{tabular}{r} 455.93 \\ \end{tabular} & 34.10 & 798 & 33.00 & 2255 \\ \hline & 5394000 & 524.28 & |s 37.13 & 5356,00 & \begin{tabular}{|ll|} 5 & 65741 \\ \end{tabular} & $3252.59 & 5244.28 & 557.13 & 33.00 & 22.55 \\ \hline \end{tabular} 17 This wseniment is part of the Asigrunents category that is worth 20% of your owerall grade. Deadline Phease refer to your tracking calendar. Coinpleting this susessanent wall holp you to meot the following: Coune Outcomes - Recogrize the importance of accounting ethics and interpersonal skills when nosolving accounting isoves. - Solve a varity of payroll fuections useing computerization and Microsott Exel. Direction the Cieneral Ledger o 5 pts eash) ACCT10-MB - Payroll Entries Assignment Template Home insert Draw Page Layout Formulas Data Review View Help X cut Book Antiqus 12 B I U Format Painter Clipboard Font Wrap Text Merge\&Center 12 Confidential A B C D Alignment Grading Criteria: M3 - Payroll Entries Assignment 1. 2 Payroll Joumal Entries 2. 10 Postings to General Ledger. 25 E \begin{tabular}{rr} & 50 \\ & 50 \\ TOTAL & 100 \end{tabular} KJO Withholdings Employee Payroll Register For Period Ending March 31 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Enuployee Wases } & \multicolumn{4}{|c|}{ Emplover Payroll Tax } \\ \hline & & & & Federal & Total & & & & Federal & State \\ \hline Employe & Grons & FICA & Medicare & Income Tax & \begin{tabular}{c} Total \\ Deductions \\ \end{tabular} & Net Pay & FicA & Medicare & \begin{tabular}{c} Unemployment \\ Tax \end{tabular} & \begin{tabular}{c} Uneaploymen \\ Tax \end{tabular} \\ \hline 5nm & 125000 & 7750 & 18.13 & 95.00 & 190.63 & 1059.38 & 7730 & 18.13 & 0.00 & 0.00 \\ \hline Dule & & 4805 & 11.24 & 87,00 & 146,29 & 02871 & 48.05 & 11.24 & 0.00 & 0.00 \\ \hline Debbie & 750.00 & 46.50 & 10.58 & 87.00 & 144.38 & 605.03 & 4650 & 10.85 & 0.00 & 0.00 \\ \hline Alall & 615.00 & 38,13 & 8.92 & 65,00 & 11205 & 502.95 & 35,13 & 8.92 & 0.00 & 0.00 \\ \hline Katie & \begin{tabular}{|c|} 53000 \\ 53394000 \end{tabular} & 4.10 & 7.98 & 5200 & 94.08 & \begin{tabular}{r} 455.93 \\ \end{tabular} & 34.10 & 798 & 33.00 & 2255 \\ \hline & 5394000 & 524.28 & |s 37.13 & 5356,00 & \begin{tabular}{|ll|} 5 & 65741 \\ \end{tabular} & $3252.59 & 5244.28 & 557.13 & 33.00 & 22.55 \\ \hline \end{tabular} 17