K. Mello Company has three employees-a consultant, a computer programmer, and an administrato following payroll information is available for each employee: Administrator Consultant Computer Programmer $3,210 per week $30 per hour $46 per hour Not applicable 2 times hourly rate 1.5 times hourly rate $925 $255 $495 For hourly employees, overtime is paid for hours worked in excess of 40 hours per week. For the current pay period, the computer programmer worked 52 hours and the administrator work hours. Assume that the social security tax rate was 6.0%, and the Medicare tax rate was 1.5%. Line Item Description Regular earnings rate Overtime earnings rate Federal income tax withheld This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perfor required analysis, and input your answers in the questions below. Open spreadsheet Determine the gross pay and the net pay for each of the three employees for the current pay period

K. Mello Company has three employees-a consultant, a computer programmer, and an administrato following payroll information is available for each employee: Administrator Consultant Computer Programmer $3,210 per week $30 per hour $46 per hour Not applicable 2 times hourly rate 1.5 times hourly rate $925 $255 $495 For hourly employees, overtime is paid for hours worked in excess of 40 hours per week. For the current pay period, the computer programmer worked 52 hours and the administrator work hours. Assume that the social security tax rate was 6.0%, and the Medicare tax rate was 1.5%. Line Item Description Regular earnings rate Overtime earnings rate Federal income tax withheld This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perfor required analysis, and input your answers in the questions below. Open spreadsheet Determine the gross pay and the net pay for each of the three employees for the current pay period

Century 21 Accounting General Journal

11th Edition

ISBN:9781337680059

Author:Gilbertson

Publisher:Gilbertson

Chapter13: Accounting For Payroll And Payroll Taxes

Section: Chapter Questions

Problem 3AP

See similar textbooks

Similar questions

An analysis of the payroll for the month of November for CinMar Inc. reveals the information shown: All regular time Andrews, Lomax, and Herzog are production workers, and Dimmick is the plant manager. Hendrick is in charge of the office. Cumulative earnings paid (before deductions) in this calendar year prior to the payroll period ending November 8 were as follows: Andrews, 21,200; Lomax, 6,800; Herzog, 11,500; Dimmick, 116,200; and Hendrick, 32,800. The solution to this problem requires the following forms, using the indicated column headings: 1. Prepare an employee earnings record for each of the five employees. 2. Prepare a payroll record for each of the four weeks. 3. Prepare a labor cost summary for the month. 4. Prepare journal entries to record the following: a. The payroll for each of the four weeks. b. The payment of wages for each of the four payrolls. c. The distribution of the monthly labor costs per the labor cost summary. d. The company's payroll taxes covering the four payroll periods.
A weekly payroll summary made from labor time records shows the following data for Pima Company: Overtime is payable at one-and-a-half times the regular rate of pay and is distributed to all jobs worked on during the period. a. Determine the net pay of each employee. The income taxes withheld for each employee amount to 15% of the gross wages. b. Prepare journal entries for the following: 1. Recording the payroll. 2. Paying the payroll. 3. Distributing the payroll. (Assume that the overtime premium will be charged to all jobs worked on during the period.) 4. The employers payroll taxes. (Assume that none of the employees has achieved the maximum wage bases for FICA and unemployment taxes.)
You have been asked to record the November payroll information using a payroll register and a general journal. Review the printout of the worksheet PR, a computerized payroll register, that follows these requirements. The columns will automatically retotal as new entries are made. Entries in column B indicate whether or not employees are union members. Assume Joness cumulative gross pay at October 31 could be 85,000, or 105,000, or 125,000.
Payment and distribution of payroll The general ledger of Berskshire Mountain Manufacturing Inc. showed the following credit balances on January 15: Direct labor earnings amounted to 10,500 from January 16 to 31. Indirect labor was 5,700, and sales and administrative salaries for the same period amounted to 3,800. All wages are subject to FICA, FUTA, state unemployment taxes, and 10% income tax withholding. Required: 1. Prepare the journal entries for the following: a. Recording the payroll. b. Paying the payroll. c. Recording the employers payroll tax liability. d. Distributing the payroll costs for January 1631. 2. Prepare the journal entry to record the payment of the amounts due for the month to the government for FICA and income tax withholdings. 3. Calculate the amount of total earnings for the period from January 1 to 15. 4. Should the same person be responsible for computing the payroll, paying the payroll and making the entry to distribute the payroll? Why or why not?
Click the Chart sheet tab. On the screen is a chart of the four payroll taxes that a company might incur in total during the year. The four taxes are federal unemployment, state unemployment, Social Security, and Medicare. By the behaviors shown on the chart, identify below which of the four taxes each represents. Series 1 _____ Series 2 _____ Series 3 _____ Series 4 _____ When the assignment is complete, close the file without saving it again. TICKLERS (optional) Worksheet. A new employee was hired during November and was mistakenly omitted from the payroll register. The employees last name is Zuckerman, and his gross pay for November is 1,300. Add the new employee to the PR5 worksheet and include all standard withholding rates in computing net pay. Federal income tax withheld is 101. He is a union member. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as PRT. Chart. Using the PR4 file, prepare a 3-D pie chart to show the percentage of an employees gross pay that is withheld for taxes, Social Security, and so on, and how much is left over as net pay. Use Smith as your example. Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as PR4. Print the chart.
In the space provided below, prepare the journal entry to record the November payroll for all employees assuming that the payroll is paid on November 30 and that Joness cumulative gross pay (cell I13) is 85,000.