----Please help me to using EXCEL sheet and show/explain detail solution--- -. T
ID: 2540527 • Letter: #
Question
----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.
Payroll for piece-rate wage system Grand Slam Manufacturing Co. operates on a modified wage plan. During one week's operation, the following direct labor costs were incurred: Units Completed Piece Rate per Employee 100 Units M T W T F A. Gonzalez .... $1.20 6,800 7,100 6,500 8,000 4,800 A. Pujols .. 1.10 6,300 6,400 2,900 2,800 7,000 R. Howard ...... 1.30 6,200 6,100 7,100 6,000 2,800 The employees are machine operators. Piece rates vary with the kind of product being produced. A minimum of $70 per day is guaranteed to each employee by union contract. Required: 1. Compute the weekly earnings for Gonzalez, Pujols, and Howard. 2. Prepare journal entries to: a. record the week's payroll, assuming that none of the employees has achieved the maximum base wage for FICA taxes. record payment of the payroll. record the employer's share of payroll taxes, assuming that none of the employees has achieved the maximum base wage for FICA or unemployment taxes.Explanation / Answer
Employee M T W T F Total Gonzales 81.6 85.2 78 96 70 410.8 Pujols 70 70.4 70 70 77 357.4 Howard 80.6 79.3 92.3 78 70 400.2 Total 232.2 234.9 240.3 244 217 1168.4 Debit Credit a. Payroll A/c Dr 1,168.40 Employees Income Tax Payable Cr 116.84 FICA Tax Payable Cr 46.74 Wages Payable Cr 1,004.82 b. Wages Payable Dr 1,004.82 Cash Cr 1,004.82 c. Factory Overhead Dr 105.16 FICA Payable Cr 46.74 Federal Unemployment Tax Payable Cr 11.68 State Unemployment Tax Payable Cr 46.74
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.