Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Acct 202 Payroll Name: Rename File:Lname, Fname PRJ.xls 1. Calculate wages and withholding all empoloyees. Complete the Payroll Register. Include column totals req'd. 2. Journalize

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Acct 202 Payroll Name: Rename File:Lname, Fname PRJ.xls 1. Calculate wages and withholding all empoloyees. Complete the Payroll Register. Include column totals req'd. 2. Journalize the June 30, 2013 payroll register. 3. Journalize paying the employees. (Checks 101-104) July 3rd Page 512 4. Journalize the Employer Payroll expense. July 3rd Use "Payroll Expense" Page 514Fa Employer paid health insurance is $100 per employee per payroll period. FUTA IS.8%, SUTA is 4%. Federal income tax withholding tables in tabs below: Winnie Wu FIT is $1,000.00 FUTA and SUTA limits are $7,000. Social Security limit is $117,000 Use GL account names listed on the right for your journal entries. 5. Answer #5 at bottom of page. Payroll Register June 30, 2013 Number Hours IS Employee Marital of Overtime Gross Status Time Cumulative Exemptio Earnings prior Earnings Earnings Earnings after after Se Regular Cumulative Pay Rate worked this Earnings are datings Earnings W 1. Nelda Anderson Earl Benson Frank Cortez Winnie Wu Totals Married Married Married Single Single 4 2 3 9.50 50 6,700 11.00 10.00 4 8,000 90.00 45 114,000 Do Column totals for all greyed cells. >>> ies. 5. Answer # at bottom of page. ter June 30, 2013 Total Points: mulative Regular hings prior Time Earnings Overtime Earnings Gross Earnings Cumulative m ative Earnings after Social Security Wages Medicare w Wages ages W/H 6.2% W/H 6.2% Medicare W/H 1.45% Federal Income Tax WIH Net Pay Wages Expense 6,700 6,600 8,000 114,000 ed cells. >>> wroper JE format from Acct 2011 Ch 2 pg 65. No Mistakes in Payrollregister will generate errors in journal "One mistake begets another. Use proper format from Aset 2011 Ch 2 5 . 11 Payro og Frank 20 The first phase of the payroll cycle includes receiving time cards from the employees. After receiving the time cards what accounong Answer record does the accountant prepare? E83 8888 8888 8888 88888 8888 888 8888 88888 B agag TEX than leest But lesso 8 $988 888 88888 88888 88888 888 88888 88878 ilia igi TETE RC 28 28889 88888 8888 888 Voir UNT V WUNN WUODO ODO.8 at 6888 8888 93828 NARE: 8 oce Naw-OOO OOOOOOOOOOOOOO 38% 88% 8OWON ON HOW DO UN 40000 DODO Rosy DAUN DOUD OOOOO OOOOO OOOOO OD008 348 NENS Boost UN- OOOOO OOOOO OOOO OOOOO OOOOO D0008 the wages are MARRIED Persons-WEEKLY Payroll Period And the number of Withholding Lillowances dla med is For Wagua Pald Througn December 2013) 393 396 8 vuaWnHO DOODO OOOOO OOOOO OOOOO OOOOO 0000O OOOOO The amount of income tax to be withheld is RW.00 ONO UN-00 OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO es vom NODO DDODO DOOOO OOOOO OOOOO OOOOO OOOOO OOOOO D0000 00008 WN -0000 OOOOD DOCOO OOOOO OOOOO OOOOO OOOOO OOOOO OOOOO OOOOO OOOO8 2 COOCO DOOOO D0000 00000 DODOO D0000 COOOO OOOOO OOO OOOOO 00008 PO OOOOO OOOOO OOOOO OOOOO GOOOO OOOO OOOOO OOOOO DODDO CODDO OD008 OOOOO OOOOO OOOO OOOOO OOOOD WOOD OODOO OOOOD DODOO DODOO 00008 ERES XXX ESIT 1889! siasa 33368 &&&̼a 1982 Allout But loss then 6883 8888 88888 8888 888 Saits saigi gati 8888 o $ 458 48289 8&9R NE RRUG a ona wwaan the wages are 1 SINGLE Persons-WEEKLY Payroll Period 5889 82898 SNOEN P au . * N OOD CO.00 00008 1988 NE Bau 380Vonaw UNA 00000 . OOOOO OOOOO 00008 NAURU N-000 00000 DODOO OOOOO OOOOO DODOD D0008 By MUN -6000 DOOOO OOOOO D000 20000 0000 0000 00008 The amount of income tax to be withhold And the number of withholding Arowances claimed 3- UN DOODO DOOOO OOOOO OOOOO OOOOO OOOOO OODOO 0000 0000 ) DODOO OOOO COOOO OOOOO OOOOO DODGO CODOO OOOOO OOOOO GO BRM poo 20000 DOODO GODDO DOOOO OOOOO OOOOO OOOOO D0000 20000 poco POO OOOOO OOOOO OOOOO OOOOO OOOOO OOOOO OOOO OOOOO DODGO OD008 poo OOOOO GOODO O BODO DODOO OOOOO OOOOO OOOOO DOGOO OOOOO D0008 PO OOOOO 0000 0000 00000 2000 20000 DODOO OOOOO 00008 Acct 202 Payroll Name: Rename File:Lname, Fname PRJ.xls 1. Calculate wages and withholding all empoloyees. Complete the Payroll Register. Include column totals req'd. 2. Journalize the June 30, 2013 payroll register. 3. Journalize paying the employees. (Checks 101-104) July 3rd Page 512 4. Journalize the Employer Payroll expense. July 3rd Use "Payroll Expense" Page 514Fa Employer paid health insurance is $100 per employee per payroll period. FUTA IS.8%, SUTA is 4%. Federal income tax withholding tables in tabs below: Winnie Wu FIT is $1,000.00 FUTA and SUTA limits are $7,000. Social Security limit is $117,000 Use GL account names listed on the right for your journal entries. 5. Answer #5 at bottom of page. Payroll Register June 30, 2013 Number Hours IS Employee Marital of Overtime Gross Status Time Cumulative Exemptio Earnings prior Earnings Earnings Earnings after after Se Regular Cumulative Pay Rate worked this Earnings are datings Earnings W 1. Nelda Anderson Earl Benson Frank Cortez Winnie Wu Totals Married Married Married Single Single 4 2 3 9.50 50 6,700 11.00 10.00 4 8,000 90.00 45 114,000 Do Column totals for all greyed cells. >>> ies. 5. Answer # at bottom of page. ter June 30, 2013 Total Points: mulative Regular hings prior Time Earnings Overtime Earnings Gross Earnings Cumulative m ative Earnings after Social Security Wages Medicare w Wages ages W/H 6.2% W/H 6.2% Medicare W/H 1.45% Federal Income Tax WIH Net Pay Wages Expense 6,700 6,600 8,000 114,000 ed cells. >>> wroper JE format from Acct 2011 Ch 2 pg 65. No Mistakes in Payrollregister will generate errors in journal "One mistake begets another. Use proper format from Aset 2011 Ch 2 5 . 11 Payro og Frank 20 The first phase of the payroll cycle includes receiving time cards from the employees. After receiving the time cards what accounong Answer record does the accountant prepare? E83 8888 8888 8888 88888 8888 888 8888 88888 B agag TEX than leest But lesso 8 $988 888 88888 88888 88888 888 88888 88878 ilia igi TETE RC 28 28889 88888 8888 888 Voir UNT V WUNN WUODO ODO.8 at 6888 8888 93828 NARE: 8 oce Naw-OOO OOOOOOOOOOOOOO 38% 88% 8OWON ON HOW DO UN 40000 DODO Rosy DAUN DOUD OOOOO OOOOO OOOOO OD008 348 NENS Boost UN- OOOOO OOOOO OOOO OOOOO OOOOO D0008 the wages are MARRIED Persons-WEEKLY Payroll Period And the number of Withholding Lillowances dla med is For Wagua Pald Througn December 2013) 393 396 8 vuaWnHO DOODO OOOOO OOOOO OOOOO OOOOO 0000O OOOOO The amount of income tax to be withheld is RW.00 ONO UN-00 OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO es vom NODO DDODO DOOOO OOOOO OOOOO OOOOO OOOOO OOOOO D0000 00008 WN -0000 OOOOD DOCOO OOOOO OOOOO OOOOO OOOOO OOOOO OOOOO OOOOO OOOO8 2 COOCO DOOOO D0000 00000 DODOO D0000 COOOO OOOOO OOO OOOOO 00008 PO OOOOO OOOOO OOOOO OOOOO GOOOO OOOO OOOOO OOOOO DODDO CODDO OD008 OOOOO OOOOO OOOO OOOOO OOOOD WOOD OODOO OOOOD DODOO DODOO 00008 ERES XXX ESIT 1889! siasa 33368 &&&̼a 1982 Allout But loss then 6883 8888 88888 8888 888 Saits saigi gati 8888 o $ 458 48289 8&9R NE RRUG a ona wwaan the wages are 1 SINGLE Persons-WEEKLY Payroll Period 5889 82898 SNOEN P au . * N OOD CO.00 00008 1988 NE Bau 380Vonaw UNA 00000 . OOOOO OOOOO 00008 NAURU N-000 00000 DODOO OOOOO OOOOO DODOD D0008 By MUN -6000 DOOOO OOOOO D000 20000 0000 0000 00008 The amount of income tax to be withhold And the number of withholding Arowances claimed 3- UN DOODO DOOOO OOOOO OOOOO OOOOO OOOOO OODOO 0000 0000 ) DODOO OOOO COOOO OOOOO OOOOO DODGO CODOO OOOOO OOOOO GO BRM poo 20000 DOODO GODDO DOOOO OOOOO OOOOO OOOOO D0000 20000 poco POO OOOOO OOOOO OOOOO OOOOO OOOOO OOOOO OOOO OOOOO DODGO OD008 poo OOOOO GOODO O BODO DODOO OOOOO OOOOO OOOOO DOGOO OOOOO D0008 PO OOOOO 0000 0000 00000 2000 20000 DODOO OOOOO 00008

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel For Accountants Tips, Tricks & Techniques

Authors: Conrad Carlberg

1st Edition

1932925015, 9781932925012

More Books

Students also viewed these Accounting questions

Question

Do you agree with the results/recommendations?

Answered: 1 week ago