Question: Hello, I need help with this question please and can you please do it in excel Thaak you E HCC Online The following information is

Hello, I need help with this question please and can you please do it in excel Thaak you
E HCC Online The following information is for employee Ella Dodd for the week ended March 15 answered Points out of 14.00 P Flag Total hours worked: 48 Rate: $15 per hour, with double time for all hours in excess of 40 Federal income tax withheld: $200 United Fund deduction: $50 Cumulative earnings prior to current week: $6,400 Tax rates: Social security: 696 with no maximum earnings. Medicare tax: 1.5% on all earnings. State unemployment: 3.4% with no mnaximum earnings, on employer Federal unemployment: 0.3% with no maximum earnings, on employer REQUIRED: a) Determine (1) total earnings. (2) total deductions, and (3) cash paid b) Determine each of the employer's payroll taxes related to the earnings of Ella Dodd for the week ended March 15
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
