----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.

E3-13) Employees' earnings using hourly and piece-rate methods The payroll records of Linda Vista Machining Co. show the fol- lowing information for the week ended April 17: 01 Income Tax .03 Hours Production Employee Classification Worked (Units)RateW/held Manressa, C. Direct Dorr, M. Direct Ginty, D. Direct Norris, D. Direct Rancifer, K. Indirect Greer, B. Indirect Holbert, R. Indirect s 80 42 48 39 40 40 50 40 $18.00/hr $17.60/hr 2,000 $0.44/piece 110 1,800 $0.44/piece 100 $800/wk $1,600/wk $1,400/wk 84 100 240 120 Hourly workers are paid time-and-a-half for overtime. a. Determine the net earnings of each employee. b. Prepare the journal entries for the following 1. Recording the payroll. 2. Paying the payrol. 3. Distributing the payroll. (Assume that the overtime pre- mium will be distributed to all jobs worked on during the period.) 4. Recording the employer's payroll taxes. (Assume that none of the employees has achieved the maximum wage bases for FICA and unemployment taxes.)