I think ive completed everything correctly besides the general journal. just want clarification if i completed it correctly and if it's wrong please offer a step by step explanation. thank you

Payroll Data for Dec 15th Pay Day 021 A B C D E F G 1 General Journal \begin{tabular}{|c|c|c|c|c|} \hline & & Account & Debit & Credit \\ \hline & 15-Dec & Salary and Wage Expense & 10,022 & \\ \hline & & Federal Income Tax Payable & & 2,150 \\ \hline & & State Income Tax Payable & & 560 \\ \hline 7 & & Social Security Payable (Employee contribution) & & 621 \\ \hline 8 & & Medicare Payable & & 145 \\ \hline 9 & & Cash & & 6,546 \\ \hline 10 & & December 15 th payrall & 10,022 & 10,022 \\ \hline 11 & & & Debit & Credit \\ \hline 12 & 15-Dec & ec Payroll Tax Expense & 10,022 & \\ \hline 13. & & FiCA Payable (Employer Contribution) & & 2,150 \\ \hline 14 & & \begin{tabular}{l} SUTA Payable \\ Su \end{tabular} & & 164 \\ \hline 15 & & FUTA Payable & & 28 \\ \hline 16 & & December Payroll Taxes & & \\ \hline 17 & & & & \\ \hline \begin{tabular}{l} 18 \\ 19 \end{tabular} & & & & \\ \hline 20 & & & & \\ \hline \end{tabular} The assignment requires that vou record the payroll in an Excel workbook Creative Thought inc, has four emplovees. On Dec. 15sn, the company has paid the employees for theli work of the last two weeks. Below is some summary information regarding the December 15 paytoll. Overtime pay of 1.5 times the regular hourly rate is paid to the hourly ttaff. Sam junes is the caly emplopet who carns a salary and therefore, be does not earn overtime pay. (FiCA). Social secarity is 6.2% of wapes/salary and Medicare is 1.45% and those rates apply fo al four employen of Experse). Expense). State (SUTA) and federal (FUTA) unemployment taxes must also be paid by Creative Thought inc. on behalf of its employees. SUTA and FUTA are imposed on the first $7,000 of wages paid during the vear. The state unemployment tax rate is 3.55% and because the employers are allowed credits apalist the federal: unemployment tax rate, the net FUTA rate is .6% of wages/salary. As of 12/15, onllelielen Crump and Ellie Walker have Ross earnings below the $7,000 limit. This is payroll is Helen Crimp's fint paycheck. Instructions: 1. Download the Payroll Assignment Ixcel wochbook from the rnyCourses' assignment 2. Complete the Payroll Summary (the 2nd Excel workheet in the workbol) for Dec 15 " by eatering payrolf information for each employee. PLEASE use cell references to the Pavroll Data sheet (the first dheet) and formulas in any cerl where a calculation is required. ermployed's record up to-date, Use cell references and formulas for calculations (i.e., Net Pay and Tetalis). have already been entered, Use cell references. 4. Journalize the Payroll Tax Pxpenses by entering the amounts (debits and credits) time and increase the odds of accuracy. You cin Google how to do that or follow these steps: - Click the cell in which you want to enter the cell relerence or formula - In the formula bar, type = (equal sgn). - Do one of the following, select the cell that contains the value you want or type its cell referenos prent ChponardisFont \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlineA & B & C & D & E & F & G & H & 1 & 1 \\ \hline \multicolumn{10}{|c|}{ Payroll Journal } \\ \hline & & \multicolumn{3}{|c|}{ Earnings } & \multicolumn{4}{|c|}{ Deductions } & \\ \hline Date & Employee & Regular & Overtime & Gross Pay & \begin{tabular}{r} Social \\ Security \end{tabular} & Medicare & \begin{tabular}{r} Federal \\ Income Tax \end{tabular} & \begin{tabular}{r} State \\ Income Tox \end{tabular} & Net Pay \\ \hline Dec 15th & Sam lones & 80.00 & 0.00 & 3,000.00 & 186.00 & 43.50 & 750.00 & 200.00 & 1.80.00 \\ \hline Dec 15th & Heten Crump & 80.00 & 6.00 & 1,780,00 & 110.36 & 25.81 & 350.00 & 90.00 & 1,203.83 \\ \hline Dec 15 th & Barney file & 80.00 & 0.00 & 2,400.00 & 148.80 & 34.10 & 50000 & 11000 & 1,586,40 \\ \hline Dec 15th & Cllie Walker & 80.00 & 12.00 & 2,842,00 & 176.20 & 41.21 & 55000 & 140.00 & 1,934.59 \\ \hline Dec 15th & Totals & 320.00 & 18.00 & 10,022,00 & 621.36 & 145.32 & 2,15000 & 560.00 & 6.544 .87 \\ \hline \end{tabular}