Purchase Solution

Canseco Company Payroll Calculations

Not what you're looking for?

Ask Custom Question

ED-3 Canseco Company has the following data for the weekly payroll ending January 31.

Employee, M. Hindi, E. Benson, K.Estes

Employees are paid 1 1/2 times the regular hourly rate for all hours worked in excess of 40 hours per week. FICA taxes are 8% on the first $87,900 of gross earnings. Canseco Company is subject to 5.4% state unemployment taxes on the first $9,800 and 0.8% federal unemployment taxes on the first $7,000 of gross earnings.

Instructions
(a) Prepare the payroll register for the weekly payroll.
(b) Prepare the journal entries to record the payroll and Canseco's payroll tax expense.

Attachments
Purchase this Solution
Solution Summary

This solution is comprised of a detailed explanation to answer the request of the assignment in excel file.

Solution Preview

Weekly period ended January 31 PAYROLL REGISTER

EMPLOYEE NAME EARNINGS FEDERAL FICA HEALTH TOTAL NET PAY
REGULAR OVERTIME TOTAL INCOME TAX TAX INSURANCE
M. Hindi 440 99 539 34 43.12 10 87.12 451.88
E. Benson 520 39 559 37 44.72 15 96.72 462.28
K. Estes 560 84 644 58 51.52 15 124.52 519.48
Total 1742 129 139.36 40 308.36 1433.64

For the regular earning for each employee, I sum all of the hours worked for each ...

Purchase this Solution
Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

View More Free Quizzes
Related BrainMass Solutions

  • Accounting Problem - Payroll

    117511 Accounting Problem - Payroll Prepare payroll register and record payroll and payroll tax expense. (SO 2, 3) Canseco Company has the following data for the weekly payroll ending January 31.

  • Cardinal Company

    Exercise D-3 (from Appendix D) Canseco Company has the following data for the weekly payroll ending January, 31: Hours Employee M T W T F S Hourly rate "Fed Inc Tax W/H" "Health Ins" M.

  • Prepare a payroll register and accompanying journal entries

    Canseco Company Payroll Register for the week ended Gross FICA FIT Insurance Net 31-Jan Pay M Hendi $539.00 $43.12 $34.00 $10.00 $451.88 E Benson $559.00 $44.72 $37.00 $15.00 $462.28 K Estes $644.00

  • Canseco Plumbing Fixtures: Depreciation Expense

    The company expects the machine to operate for 10,000 hours.

  • Calculations for the Weekly Payroll of the Piniella Company

    402770 Calculations for the weekly payroll of the Piniella Company Piniella Company company has the following data for the weekly payroll ending January 31.

  • Jones Company has the following employees on payroll:

    450207 Jones Company has the following employees on payroll: Semimonthly Withholding Marital Payroll Allowances Status Heather $4,500 4 Married Keith

  • Payroll Register and Journal Entries

    See attached MS Excel document for complete payroll register, payroll journal entry, and payroll tax expense entry. All of the calculations are shown in the far right columns.

  • The Effect of Taxes on Accounts and Financial Statements

    For your review, I have attached a formatted MS Excel spreadsheet which illustrates calculations of the accrued payroll taxes for the Newman Publishing Company. Subsequent journal entries are also included in this example.

  • Calculating OASDI

    The silver Gym Company pays its salaried employees monthly on the last day of each month. The annual salary payroll for 2007 follows. Compute the following for the payroll of December 28.

View More Related Solutions