1) Preparing a Payroll Register for Throwback Industries: | |||||||||||||
Throwback Industries Inc. | |||||||||||||
Payroll Register | |||||||||||||
For the week ended Dec 9 20Y8 | |||||||||||||
Earnings | Earnings | Earnings | Deductions Withheld | Deductions Withheld | Deductions Withheld | Deductions Withheld | Deductions Withheld | Paid | Paid | Account Debited | Account Debited | ||
Employee | Total Hours | Regular | Overtime | Total | Social Secutiry Tax | Medicare Tax | Fedral Income Tax | US Savings Bonds | Total | Net Pay | Ck.No | Sales Salaries Expense | Office Salaries Expense |
a | b | c | d | e | f = e*6% | g = e*1.5% | h | i | j =f+g+h+i | k = e-j | l | m | n |
Aaron | 46 | $2,720.00 | $612.00 | $3,332.00 | $199.92 | $49.98 | $750.20 | $100.00 | $1,100.10 | $2,231.90 | 901 | $3,332.00 | |
Cobb | 41 | $2,480.00 | $93.00 | $2,573.00 | $154.38 | $38.60 | $537.68 | $110.00 | $840.66 | $1,732.35 | 902 | $2,573.00 | |
Clemente | 48 | $2,800.00 | $840.00 | $3,640.00 | $218.40 | $54.60 | $832.64 | $120.00 | $1,225.64 | $2,414.36 | 903 | $3,640.00 | |
DiMaggio | 35 | $1,960.00 | $0.00 | $1,960.00 | $117.60 | $29.40 | $366.04 | $0.00 | $513.04 | $1,446.96 | 904 | $1,960.00 | |
Grifey Jr | 45 | $2,480.00 | $465.00 | $2,945.00 | $176.70 | $44.18 | $641.84 | $130.00 | $992.72 | $1,952.29 | 905 | $2,945.00 | |
Mantle | $1,800.00 | $108.00 | $27.00 | $342.45 | $120.00 | $597.45 | $1,202.55 | 906 | $1,800.00 | ||||
Robinson | 36 | $1,944.00 | $0.00 | $1,944.00 | $116.64 | $29.16 | $382.56 | $130.00 | $658.36 | $1,285.64 | 907 | $1,944.00 | |
Williams | $2,000.00 | $120.00 | $30.00 | $398.24 | $125.00 | $673.24 | $1,326.76 | 908 | $2,000.00 | ||||
Vaughn | 42 | $2,480.00 | $186.00 | $2,666.00 | $159.96 | $39.99 | $584.72 | $50.00 | $834.67 | $1,831.33 | 909 | $2,666.00 | |
Total | $16,864.00 | $2,196.00 | $22,860.00 | $1,371.60 | $342.90 | $4,836.37 | $885.00 | $7,435.87 | $15,424.13 | $19,060.00 | $3,800.00 |
2) Preparing the Journal Entry to Record the Payroll for the Week: | |||||
Date | General Journal | Debit | Credit | ||
9-Dec | Sales Salaries Expense | $ 19,060.00 | |||
Office Salaries Expense | $ 3,800.00 | ||||
Social Security Tax Payable | $ 1,371.60 | ||||
Medicare Tax Payable | $ 342.90 | ||||
Employees Federal Income Tax Payable | $ 4,836.37 | ||||
US Savings Bonds Deductions Payable | $ 885.00 | ||||
Salaries Payable | $ 15,424.13 | ||||
(To record payroll expense for the week) |
Throwback Industries Inc. | ||||||||
Calculation of Earnings | ||||||||
For the week ended Dec 9 20Y8 | ||||||||
Regular Earnings | Overtime Earnings | Total Earnings | ||||||
Name | Total Hours Worked | Normal Hours | Rate per Hour | Regular Earnings Amount | Overtime Hours | Rate per Hour | Overtime Earnings Amount | |
a | b | c | d | e=c*d | f | g = 1.5*d | h =f*g | i=e+h |
Aaron | 46.00 | 40.00 | $ 68.00 | 2,720.00 | 6.00 | 102.00 | 612.00 | 3,332.00 |
Cobb | 41.00 | 40.00 | $ 62.00 | 2,480.00 | 1.00 | 93.00 | 93.00 | 2,573.00 |
Clemente | 48.00 | 40.00 | $ 70.00 | 2,800.00 | 8.00 | 105.00 | 840.00 | 3,640.00 |
DiMaggio | 35.00 | 35.00 | $ 56.00 | 1,960.00 | 0.00 | 84.00 | 0.00 | 1,960.00 |
Grifey Jr | 45.00 | 40.00 | $ 62.00 | 2,480.00 | 5.00 | 93.00 | 465.00 | 2,945.00 |
Robinson | 36.00 | 36.00 | $ 54.00 | 1,944.00 | 0.00 | 81.00 | 0.00 | 1,944.00 |
Vaughn | 42.00 | 40.00 | $ 62.00 | 2,480.00 | 2.00 | 93.00 | 186.00 | 2,666.00 |
Totals | 16,864.00 | 2,196.00 | 19,060.00 |
Feel free to ask any clarification, if required. Kindly
provide feedback by thumbs up, if satisfied. It will be highly
appreciated.
Thank you.
The following data for Throwback Industries Inc. relate to the payroll for the week ended December...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 20Y8: Employee Hours Worked Hourly Rate Weekly Salary Federal Income Tax Retirement Savings Aaron 46 $68 $750.20 $115 Cobb 41 62 537.68 125 Clemente 48 70 836.44 135 DiMaggio 35 56 366.04 0 Griffey, Jr. 45 62 641.84 145 Mantle $1,800 342.45 135 Robinson 36 54 382.56 145 Williams 2,000 398.24 140 Vaughn 42 62 584.72 80 Employees Mantle and Williams are office...
Payroll Register The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 2018: Hours Hourly Federal Retirements Weekly Salary Eme Worked Rate Income Tax Savings Aaron $46 $486.68 Cobb 295.84 Clemente 216.6 DiMaggio 264.18 Griffey, 3r. Mantle $2,140 Robinson 458.64 513.60 189.00 528.00 249.20 Williams 2.400 Vaughn Employees Mantle and Williams are office staff, and all of the other employees are sales personnel. All sales personnel are paid 1 times the regular rate...
Payroll Register The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 2018: Hours Hourly Weekly Federal Retirements Employee Worked Rate Salary Income Tax Savings Aaron $30 $327.75 Cobb 388.29 205.01 Clemente DiMaggio Griffey, Jr. 302.4 367.08 Mantle $2,210 530.40 Robinson 178.50 Williams 2,480 545.60 Vaughn 478.40 Employees Mantle and Williams are office staff, and all of the other employees are sales personnel. All sales personnel are paid 1 times the regular rate...
AutoSave Off H D - 15e_PR 10-4A - Excel 0 - 0 X Comments File Home Insert Draw Page Layout Formulas Data Review View Help Search Share C2 X foc A B C D E F 12 Enter a zero in cells you would otherwise leave blank. G H I J K L M N O P Q R S T U V W X Y Z AA AB A PAYROLL FOR WEEK ENDING December 9 EARNINGS PAID DEDUCTIONS Federal...
Payroll Register The following data for Throwback Industries, Inc. relate to the payroll for the week ended December 9: Hours Hourly Weekly Federal U.S. Savings Employee Worked Rate Salary Income Tax Bonds Blanda $310.96 $75 Dawson 435.16 Fouts 277.78 Griese 217.56 Namath 418.95 Marino $1,960 470.40 Staubach 157.50 Starr 2,200 484.00 Unitas 332.00 45 Employees Marino and Starr are office staff, and all of the other employees are sales personnel. All sales personnel are paid 12 times the regular rate...
Payroll Register The following data for Throwback Industries, Inc. relate to the payroll for the week ended December 9: Hours Hourly Weekly Federal U.S. Savings Employee Worked Rate Salary Income Tax Bonds Blanda 42 $26 $257.14 $70 Dawson 46 44 463.54 85 Fouts 43 34 287.47 75 Griese 38 28 223.44 40 Namath 48 42 458.64 90 Marino $2,150 516.00 90 Staubach 35 30 157.50 70 Starr 2,410 530.20 110 Unitas 45 40 380.00 80 Employees Marino and Starr are...
Payroll Register The following data for Throwback Industries, Inc. relate to the payroll for the week ended December 9: Hours Hourly Weekly Federal U.S. Savings Employee Worked Rate Salary Income Tax Bonds Blanda 44 $40 $423.20 $45 Dawson 42 28 258.86 60 Fouts 45 36 324.9 85 Griese 36 38 287.28 70 Namath 48 44 480.48 95 Marino $1,990 477.60 100 Staubach 38 32 182.40 40 Starr 2,230 490.60 40 Unitas 43 46 409.40 110 Employees Marino and Starr are...
eBook Calculator Chapter 11 1. EX 11 11 BLANKSHEETALCO 2. EX 11.01 ALGO Payroll Register The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 2018: Hours Hourly Weekly Federal Retirements Employee Worked Rate Salary Income Tax Savings 520 $266.11 $40 3. PR 11.05 ALGO 4. PE 11.04.BLANKSHEET ALGO . Aaron 85 Cobe 48 491.92 44 5. PR 11 04 ALGO 30 50 Clemente 6. EX 11 21 50 36 211.00 DiMaggio Grey,...
PR 11-4B Payroll register OBJ. 2,3 The following data for Flexco Inc. relate to the payroll for the week ended December 9, 2048: 1. Total net pay $16,592.58 Hours Worked Hourly Rate $50.00 Weekly Salary Retirement Savings $ 60 100 $4,000 Employee Carlton Grove Johnson Koufax Maddux Seaver Spahn Winn Young 52.00 58.00 45.00 Federal Income Tax $667.00 860.00 355.68 578.55 349.65 768.00 382.20 572.00 480.60 44 3,200 120 0 46 52.00 50.00 54.00 80 Employees Grove and Seaver are...
PR 11-4B Payroll register Obj. 2, 3 The following data for Flexco Inc. relate to the payroll for the week ended December 9, 2018: Hours Worked 52 Weekly Salary Hourly Rate $50.00 52.00 58.00 45.00 Retirement Savings $ 60 100 $4,000 Employee Carlton Grove Johnson Koufax Maddux Seaver Spahn Winn Young 36 Federal Income Tax $667.00 860.00 355.68 578.55 349.65 768.00 382.20 572,00 480.60 44 62 120 3.200 52.00 50.00 54.00 Employees Grove and Seaver are office staff, and all...