Need all of these filled out, id really appreciate it!!!
Paloma Company has four employees. FICA Social Security taxes are 6.2% of the first $137,700 paid to each employee, and FICA Medicare taxes are 1.45% of gross pay. Also. for the first $7,000 paid to each employee, the company's FUTA taxes are 0.6% and SUTA taxes are 5.4%. The company is preparing its payroll calculations for the week ended August 25 . Payroll records show the following information for the company's four employees. In addition to gross pay, the company must pay one-half of the $110 per employee weekly health insurance; each employee pays the remaining one-half. The company also contributes an extra 8% of each employee's gross pay (at no cost to employees) to a pension fund. Required: Compute the following for the week ended August 25. Note: Round your intermediate calculations and final answers to 2 decimal places. 3) Employer's FICA Taxes for Social Security \begin{tabular}{|c|c|c|c|c|c|} \hline Employee & Sub & \begin{tabular}{l} nings \\ ct to Tax \end{tabular} & Tax Rate & \multicolumn{2}{|c|}{ Tax Amount } \\ \hline Tax Rate & & & 6.20% & & \\ \hline Dali & $ & 1,100.00 & 6.20% & $ & 84.00 \\ \hline Trey & & 900.00 & 6.20% & & 55.80 \\ \hline Kiesha & & 450.00 & 6.20% & & 27.90 \\ \hline \multirow[t]{2}{*}{ Chee } & & 400.00 & 6.20% & & 24.80 \\ \hline & & & Total & $ & 192.50 \\ \hline \end{tabular} 4) Employer's FICA Taxes for Medicare \begin{tabular}{|c|c|c|c|c|c|} \hline Employee & \multicolumn{2}{|c|}{\begin{tabular}{c} Earnings \\ Subject to Tax \end{tabular}} & \multirow{2}{*}{\begin{tabular}{l} Tax Rate \\ 1.45% \\ \end{tabular}} & \multicolumn{2}{|c|}{ Tax Amount } \\ \hline Tax Rate & & & & & \\ \hline Dali & $ & 2,000.00 & 1.45% & $ & 29.00 \\ \hline Trey & & 900.00 & 1.45% & & 13.05 \\ \hline Kiesha & & 450.00 & 1.45% & & 6.53 \\ \hline Chee & & 400.00 & 1.45% & & 5.80 \\ \hline & & & Total & $ & 54.38 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ 5) Employer's FUTA Taxes } & \\ \hline Employee & \begin{tabular}{l} Earnings \\ Subject to Tax \end{tabular} & Tax Rate & Tax Amount & & \\ \hline Tax Rate & & 0.60% & & & \\ \hline Dali & 0.00 & 0.60% & & & \\ \hline Trey & 0.00 & 0.60% & & & \\ \hline Kiesha & 450.00 & & & & \\ \hline \multirow[t]{2}{*}{ Chee } & 400.00 & 0.60% & 2.40 & & \\ \hline & & Total & 2.40 & & \\ \hline \multicolumn{6}{|c|}{ 6) Employer's SUTA Taxes } \\ \hline Employee & \begin{tabular}{c} Earnings \\ Subject to Tax \end{tabular} & Tax Rate & Tax Amount & & \\ \hline Tax Rate & & 5.40% & & & \\ \hline Dali & 0.00 & 5.40% & & & \\ \hline Trey & 0.00 & 5.40% & & & \\ \hline Kiesha & 450.00 & & & & \\ \hline \multirow[t]{2}{*}{ Chee } & 400.00 & 5.40% & 21.60 & & \\ \hline & & Total & 21.60 & & \\ \hline \multicolumn{6}{|c|}{ 7) Each Employee's Net (take-home) Pay } \\ \hline Employee & Dali & Trey & Kiesha & Chee & Total \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{9}{|c|}{ 7) Each Employee's Net (take-home) Pay } & \multirow{2}{*}{\multicolumn{2}{|c|}{ Total }} \\ \hline Employee & \multicolumn{2}{|r|}{ Dali } & \multicolumn{2}{|c|}{ Trey } & \multicolumn{2}{|c|}{ Kiesha } & \multicolumn{2}{|c|}{ Chee } & & \\ \hline Gross Pay & $ & 5,800.00 & $ & 2,600.00 & $ & 1,200.00 & $ & 1,600.00 & $ & 11,200.00 \\ \hline Income tax withholding & & 639.00 & & 258.00 & & 61.00 & & 49.00 & & 1,007.00 \\ \hline FICA - Social Security & & 359.60 & & 161.20 & & 74.40 & & 99.20 & & 694.40 \\ \hline FICA - Medicare & & 29.00 & & 13.05 & & 6.53 & & 5.80 & & 54.38 \\ \hline Health Insurance & & & & & & & & & & 0.00 \\ \hline Net Pay & & & & & & & & & $ & 0.00 \\ \hline \multicolumn{11}{|c|}{ 8) Employer's Total Payroll-Related Expense for Each Employee. } \\ \hline Employee & \multicolumn{2}{|r|}{ Dali } & \multicolumn{2}{|r|}{ Trey } & \multicolumn{2}{|c|}{ Kiesha } & \multicolumn{2}{|c|}{ Chee } & \multicolumn{2}{|r|}{ Total } \\ \hline Gross Pay & $ & 5,800.00 & $ & 2,600.00 & $ & 1,200.00 & $ & 1,600.00 & $ & 11,200.00 \\ \hline FICA - Social Security & & 84.00 & & 55.80 & & 27.90 & & 24.80 & & 192.50 \\ \hline FICA - Medicare & & 29.00 & & 13.05 & & 6.53 & & 5.80 & & 54.38 \\ \hline FUTA & & 0.00 & & 0.00 & & 0.00 & & 2.40 & & 2.40 \\ \hline SUTA & & 0.00 & & 0.00 & & 0.00 & & 21.60 & & 21.60 \\ \hline Health Insurance & & & & & & & & & & 0.00 \\ \hline Pension & & & & & & & & & & 0.00 \\ \hline Total Payroll Expense & $ & 5,913.00 & $ & 2,668.85 & $ & 1,234.43 & $ & 1,654.60 & $ & 11,470.88 \\ \hline \end{tabular}