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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!