----Please help me to using EXCEL sheet and show/explain detail solution----. Thank you very much for your help.

It helps me a lot to learn this course. This way I can study myself. I really appreciate for your help.

I need to answer bottom of excel sheet on by one. Thank you so much.

(If you want to make pics big or clear -> "copy of the picture and paste to Word or Excel, to make a big picture"

P3-8

3-8) Payroll work sheet and journal entries The payroll records of Software Inc. for the week ending Octo- ber 7, the 40th week in the year, show the following: LO2 Salary or Wage per Hours Tax through 39th Income Gross Earnings LO3 Employee Classification 40-Hour Week Worked Withheld Week President Vice President- $2,489 $488 $109,560 Devine 2,233 40 402 99,500 Administration Fiorelli Supervisor- 180 27.300 Production O'Clock O'Reilly Pawlukiewicz Factory-Direct Surdick Trebbi Webb Factory-Direct 500 150 160 110 120 19,820 17,200 16,600 15,200 7,800 6,600 ory-Direct 46 400 Factory-Direct Factory-Indirect Factory ndi rect 42 60 Required 1. Complete a work sheet with the following column headings: Employee 3 columns for Earnings for Week: . Use one for Regular Pay. . Use one for Overtime Premium Pay. (The company pays time-and-a-half for overtime for all employees below the supervisory level.) e Use one for Total for Week. Total Earnings through 40th Week FICA Taxable Earnings FICA Income Tax Withheld Net Earnings Prepare journal entries for the following: a. Payroll for the 40th week. b. Payment of payroll for the week. c. Distribution of the payroll costs, assuming that overtime 2. premium is charged to all jobs worked on during the period. Employer's payroll tax liability. ies a disability insurance policy for the cost of $15 per week for each employee ployer's cost of insurance premiums for 3. The company carri employees at a Journalize the em the week