name	address	social security #	federal witholding allowances	state witholding allowances	martial status
Hunter Cranston	85 Southern Road Herndon, VA 20170	111-11-1111	2	2	Married
Allison Harrison	203A Pine Court Herndon, VA 20170	777-77-7777	4	3	Married
John Parker	212 Tradition Lane Herndon, VA 20170	444-44-4444	1	1	Single
Pierre Sternberg	41 Seward Boulevard Herndon, VA 20170	333-33-3333	2	2	Married

Earnings and voluntary deductions

Hunter Cranston Regular Wage: $15/hr Annual Salary: N/A 401(k) Weekly: 6% of gross pay Charity Contributions: $5

Allison Harrison Regular Wage: $23/hr Annual Salary:N/A 401(k) Weekly:%5 of Charity Contributions: gross pay $5

John Parker Regular Wage:N/A Annual Salary: $203,000.20 401(k) Weekly:N/A Charity Contributions:$20

Pierre SternbergRegular Wage: N/A Annual Salary:$112,000.20 401(k) Weekly:1% of gross pay Charity Contributions: N/A

complete payroll register for each week of payroll, employee earnings record per employee, journal entry that summarizes salary and wage expense for each week, journal entry for employer payroll expense, form 941 and 940, W2 for each employee, W3 for company.

PLEASE use the IRS 2019 tax bracket wage method and 2019 percentage wage method

overtime rate 1.5 / SUTA tax 2.53% / Virginia SUTA wage base $8,000 / social security tax 6.2% / social security wage base $132,900 / 1.45% medicare tax Notes: all employees work a regular 40 hour work week

Actober and November las foto Autor Cranston GrOSS Earnings Federal income Tax $7,800 S221 Stare Income Tax $7,800 $221 Security Tax Medicare A $7 800 $221 Deduction Cont Charitable $2,400 5366.60 $68 $43.0 $3,000 $112.80 143 50 517310 $85 5113.10 wober 5741 3186 53430 5150 Alison Harrison Gross Earnings Federal income Tax State Income Tax Auriod $11.960 $416 Social Medicare Security Tax Tax est Quarter $568.10 $ 11,960 $416 $741.52 401(K) Charitable Deduction Cont. 5598 and quarter $568.10 5173.42 $11.960 $416 $741.52 $173.42 365 $568.10 Sird quarter $741.52 5598 $3,680 $128 sos October $174.80 $173.42 $228.16 565 $4,600 $160 553.36 $218.50 $184 Avember $285.20 $20 $66.70 5230 525 John Parker Gross Earnings Federal Income Tax State Social Medicare 401(k) Charitable Income Tax Security Tax Tax Deduction Cont. Period $50,750.05 $10,929.36 $2,537.47 $3,146.52 $735.93 st quarter $0 $260 $735.93 $0 $260 $3,146.52 $2,537.47 and quarter $50,750.05 $10,929.36 $0 $260 $735.93 $2,537.47 $1,946.76 Idquarter $50,750.05 $10.929.36 $226.44 $0 $80 $780.76 $0 $15,615,40 $3,362.88 SO $100 $283.05 $0 $975.95 Ovember $19,519.25 $4,203.60 Pierre Sternberg Medicare Tax 401(k) Deduction Charita Gross Earnings Social Security Tax Period Federal Income Tax State Income Tax Cont SO So 50 Ist quarter SO sa $0 SO SO SO $0 2nd quarter SO 50 so so SO $0 50 3rd quarter So so $0 SO SO SO October 50 $0 30 $0 SO $133.54 531 23 $21.54 November $0 $2 153,85 $224.36 $106.62 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. 2. Establish and complete the payroll register for each weekly pay period during December. When calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage method only when necessary. Note that as of December 7, Hunter Cranston requests that his federal withholding allowances increase from two to three (Ellipses Corp. makes this change). Additionally, for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable state's withholding tables. Payroll checks are remitted to the employees in the same order (Cranston, Harrison, Parker, Sternberg) each pay period and are written from a bank account that is used solely for these payments. The first payroll check written in December is check #762. Note that all charitable contributions are deemed to be made on the final day of each pay period. The following information will be required for the completion of these records for the two employees who are compensated via an hourly wage: Weekly Hours Worked Weekly Start Date Hunter Cranston Allison Harrison November 30 40 37 December 7 38 41 December 14 43.5 December 21 40 WARNING! The above dates are weekly start dates. Refer to a calendar to determine the we end dates and associated pay dates. Keep in mind that tax liability and payment amounts are determined based on the weekly pay dates. mplete the employee earnings records for December for each of the four employees. Divide the volu uctions from the payroll register appropriately across the consiste louer Actober and November las foto Autor Cranston GrOSS Earnings Federal income Tax $7,800 S221 Stare Income Tax $7,800 $221 Security Tax Medicare A $7 800 $221 Deduction Cont Charitable $2,400 5366.60 $68 $43.0 $3,000 $112.80 143 50 517310 $85 5113.10 wober 5741 3186 53430 5150 Alison Harrison Gross Earnings Federal income Tax State Income Tax Auriod $11.960 $416 Social Medicare Security Tax Tax est Quarter $568.10 $ 11,960 $416 $741.52 401(K) Charitable Deduction Cont. 5598 and quarter $568.10 5173.42 $11.960 $416 $741.52 $173.42 365 $568.10 Sird quarter $741.52 5598 $3,680 $128 sos October $174.80 $173.42 $228.16 565 $4,600 $160 553.36 $218.50 $184 Avember $285.20 $20 $66.70 5230 525 John Parker Gross Earnings Federal Income Tax State Social Medicare 401(k) Charitable Income Tax Security Tax Tax Deduction Cont. Period $50,750.05 $10,929.36 $2,537.47 $3,146.52 $735.93 st quarter $0 $260 $735.93 $0 $260 $3,146.52 $2,537.47 and quarter $50,750.05 $10,929.36 $0 $260 $735.93 $2,537.47 $1,946.76 Idquarter $50,750.05 $10.929.36 $226.44 $0 $80 $780.76 $0 $15,615,40 $3,362.88 SO $100 $283.05 $0 $975.95 Ovember $19,519.25 $4,203.60 Pierre Sternberg Medicare Tax 401(k) Deduction Charita Gross Earnings Social Security Tax Period Federal Income Tax State Income Tax Cont SO So 50 Ist quarter SO sa $0 SO SO SO $0 2nd quarter SO 50 so so SO $0 50 3rd quarter So so $0 SO SO SO October 50 $0 30 $0 SO $133.54 531 23 $21.54 November $0 $2 153,85 $224.36 $106.62 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. 2. Establish and complete the payroll register for each weekly pay period during December. When calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage method only when necessary. Note that as of December 7, Hunter Cranston requests that his federal withholding allowances increase from two to three (Ellipses Corp. makes this change). Additionally, for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable state's withholding tables. Payroll checks are remitted to the employees in the same order (Cranston, Harrison, Parker, Sternberg) each pay period and are written from a bank account that is used solely for these payments. The first payroll check written in December is check #762. Note that all charitable contributions are deemed to be made on the final day of each pay period. The following information will be required for the completion of these records for the two employees who are compensated via an hourly wage: Weekly Hours Worked Weekly Start Date Hunter Cranston Allison Harrison November 30 40 37 December 7 38 41 December 14 43.5 December 21 40 WARNING! The above dates are weekly start dates. Refer to a calendar to determine the we end dates and associated pay dates. Keep in mind that tax liability and payment amounts are determined based on the weekly pay dates. mplete the employee earnings records for December for each of the four employees. Divide the volu uctions from the payroll register appropriately across the consiste louer