Note that all tax payments and filings are made on the due date. Based on the data provided here, you will complete the following:
1. Establish an employee earnings record for each of the company's four employees. Complete the top portion of each record.
Earnings and voluntary deduction information for each of the four employees is as follows: Regular Annual Weekly 401(k) Weekly Charitable Name Wage Rate Salary Deduction Contribution Hunter Cranston $15/hour N/A 6% of gross pay $5 Allison Harrison $23/hour N/A 5% of gross pay $5 John Parker N/A $203,000.20 N/A $20 Pierre Sternberg N/A $112,000.20 1% of gross pay N/AThe first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as of 11/30/2019. Payroll data for each of the four employees for the first three quarters of the year, as well as for the months of October and November, is as follows: Hunter Cranston Gross Federal State Social Medicare 401(k) Charitable Period Earnings Income Tax Income Tax Security Tax Tax Deduction Cont. 1st quarter $7,800 $221 $366.60 $483.60 $113.10 $468 $65 2nd quarter $7,800 $221 $366.60 $483.60 $113.10 $468 $65 3rd quarter $7,800 $221 $366.60 $483.60 $113.10 $468 $65 October $2,400 $68 $112.80 $148.80 $34.80 $144 520 November $3,000 $85 $141 $186 $43.50 $180 $25 Allison Harrison U Gross Federal State Social Medicare 401(k) Charitable Period Earnings Income Tax Income Tax Security Tax Tax Deduction Cont. 1st quarter $11,960 $416 $568.10 $741.52 $173.42 $598 $65 2nd quarter $11,960 $416 $568.10 $741.52 $173.42 $598 565 3rd quarter $11,960 $416 $568.10 $741.52 $173.42 $598 $65 October $3,680 $128 $174.80 $228.16 $53.36 $184 $20 November $4,600 $160 $218.50 $285.20 $66.70 $230 $25John Parker Gross Federal State Social Medicare 401(k) Charitable Period Earnings Income Tax Income Tax Security Tax Tax Deduction Cont. 1st quarter $50,750.05 $10,929.36 $2,537.47 $3,146.52 $735.93 SO $260 2nd quarter $50,750.05 $10,929.36 $2,537.47 $3,146.52 $735.93 SO $260 3rd quarter $50,750.05 $10,929.36 $2,537.47 $1,946.76 $735.93 SO $260 October $15,615.40 $3,362.88 $780.76 SO $226.44 SO $80 November $19,519.25 $4,203.60 $975.95 SO $283.05 SO $100Pierre Sternberg Gross Federal State Social Medicare 401(k) Charitable Period Earnings Income Tax Income Tax Security Tax Tax Deduction Cont. 1st quarter SO SO SO SO SO SO SO 2nd quarter SO SO SO SO SO 3rd quarter SO SO SO SO SO October SO SO SO SO SO SO November $2, 153.85 $224.36 $106.62 $133.54 $31.23 $21.54 Note that all tax payments and filings are made on the due date. Based on the data provided here, you will complete the following: 1. Establish an employee earnings record for each of the company's four employees. Complete the top portion of each record.Weekly Hours Worked Weekly Start Date Hunter Cranston Allison Harrison November 30 40 37 December 7 38 41 December 14 43.5 0 December 21 40 0 WARNING! The above dates are weekly start dates. Refer to a calendar to determine the weekly end dates and associated pay dates. Keep in mind that tax liability and payment amounts are determined based on the weekly pay dates. 3. Complete the employee earnings records for December for each of the four employees. Divide the voluntary deductions from the payroll register appropriately across the associated columns within the employee earnings records. If directed to do so by your instructor, record the necessary journal entries for each pay period
