Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10, Problem 2R
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 Jonesʼs cumulative gross pay at October 31 could be $85,000, or $105,000, or $125,000.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Assume that you are working with a payroll application that produces weekly paychecks, including paystubs. Listed below are 20 data elements that would appear on the paycheck/paystub. For each numbered item, indicate the immediate (versus ultimate) source of the item. For instance, the immediate source of the number of exemptions for an employee would be the employee master data, as opposed to the ultimate source, which is the W-4 form filed by the employee. Some items may have more than one source, as in the case of item 1. You have the following choices: Arrange your answer as follows: The items to be considered are as follows:
PAYROLLThe following describes the payroll procedures for a hypothetical company.Every Thursday, the timekeeping clerk sends employee time cards to the payrolldepartment for processing. Based on the hours worked reflected on the time cards, theemployee pay rate and withholding information in the employee file, and the tax ratereference file, the payroll clerk calculates gross pay, withholdings, and net pay for eachemployee. The clerk then manually pre-pares paychecks for each employee, files hardcopies of the paychecks in the payroll department, and posts the earnings to the hardcopy employee records. Finally, the clerk manually prepares a payroll summary andsends it and the paychecks to the cash disbursements department. The cashdisbursements clerk reconciles the payroll summary with the paychecks and manuallyrecords the transaction in the hard-copy cash disbursements journal. The clerk then filesthe payroll summary and sends the paychecks to the treasurer for signing.The signed…
Complete the FWT column (wage-bracket method) and SWT column of the payroll register using the employee data listed below. The associated pay period ends on 09/05/2021 (enter the year using four digits), with paychecks being printed and distributed six days later. Every employee earns hourly overtime wages 1.5 times greater than their regular wage rate. Enter all employees' names in the format Last Name, First Initial (for example: Rick Smith would be written as Smith, R). The state income tax withholding rate is 5.0% of taxable pay, with taxable pay being the same for federal and state income tax withholding. Note that the Voluntary Withholding column, for which partial information is provided below, has been populated based on the partial information shown here.
Luisa Williams earns $7.50/hour, and worked 44 hours during the most recent week. She makes a 401(k) retirement plan contribution of 14% of gross pay each period. Luisa Williams is single, and claims one withholding…
Chapter 10 Solutions
Excel Applications for Accounting Principles
Ch. 10 - Based on 2011 tax rates provided, use a calculator...Ch. 10 - You have been asked to record the November payroll...Ch. 10 - To make the worksheet reusable each month, the...Ch. 10 - Prob. 4RCh. 10 - Prob. 5RCh. 10 - In the space provided below, prepare the journal...Ch. 10 - In the space provided below, prepare the journal...Ch. 10 - Prob. 8RCh. 10 - Click the Chart sheet tab. On the screen is a...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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.)arrow_forwardIn 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.arrow_forwardAdams, Inc., pays its employees weekly wages in cash. A supplementary payroll sheet that lists the employees names and their earnings for a certain week is shown below. Complete the payroll sheet by calculating the total amount of payroll and indicating the least possible number of denominations that can be used in paying each employee. However, no employees are to be given bills in denominations greater than 20.arrow_forward
- On September 30, Hilltop Companys selected payroll accounts are as follows: Prepare general journal entries to record the following:arrow_forwardThe total wages and salaries earned by all employees of Langen Electronics, Ltd. during March, as shown in the labor cost summary and the schedule of fixed administrative and sales salaries, are classified as follows: a. Prepare a journal entry to distribute the wages earned during March. b. What is the total amount of payroll taxes that will be imposed on the employer for the payroll, assuming that two administrative employees with combined earnings this period of 3,000 have exceeded 8,000 in earnings prior to the period?arrow_forwardThe total wages and salaries earned by all employees of James Industries during the month of February, as shown in the labor cost summary and the schedule of fixed administrative and sales salaries, are classified as follows: a. Prepare a journal entry to distribute the wages earned during February. b. What is the total amount of payroll taxes that will be imposed on the employer for the payroll, assuming that three administrative employees with combined earnings this period of 4,500 have exceeded 8,000 in earnings prior to the period?arrow_forward
- 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.arrow_forwardClick 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.arrow_forwardThe following describes the payroll procedures for a hypothetical company.Every Thursday, the timekeeping clerk sends employee time cards to the payroll department for processing. Based on the hours worked reflected on the time cards, the employee pay rate and withholding information in the employee file, and the tax rate reference file, the payroll clerk calculates gross pay, withholdings, and net pay for each employee. The clerk then manually prepares paychecks for each employee, files hard copies of the paychecks in the payroll department, and posts the earnings to the hard-copy employee records. Finally, the clerk manually prepares a payroll summary and sends it and the paychecks to the cash disbursements department. The cash disbursements clerk reconciles the payroll summary with the paychecks and manually records the transaction in the hard-copy cash disbursements journal. The clerk then files the payroll summary and sends the paychecks to the treasurer for signing. The signed…arrow_forward
- You will complete the necessary payroll entries for the company at the end of the month. Below, you have been given a payroll register. Please journalize and post to the appropriate ledger accounts in excel Payroll register for the end of month on May 31with 4 employees. Daliah had: gross pay $1,000, FICA tax $62, Medicare tax $14.50, Federal Tax of $85, total deductions of $161.50, net pay of $838.50, matching FICA $62, matching Medicare tax $14.50. Micah had: gross pay of $450, FICA tax $27.90, Medicare tax $6.53, Federal income tax $72, total deductions $106.43, net pay $343.58, matching FICA $27.90, matching Medicare $6.53. Jacob had: gross pay $630, FICA tax $39.06, Medicare tax $9.14, Federal Income Tax $55, total deductions $103.20, net pay $526.81, matching FICA $39.06, matching Medicare $9.14. Jonah had: gross pay $580, FICA tax $35.96, Medicare tax $8.41, Federal income tax $44, total deductions $88.37, net pay $491.63, matching FICA $35.96, matching Medicare $8.41, Federal…arrow_forwardJournal entries to record both employee and employer payroll compensation and deductions. I strongly recommend that you print out these facts for easy reference in completing this lengthy payroll problem. Wind Beneath My Wings Inc. employs one person to run its wind energy company and July is the first pay period for this employee. The employee’s gross income for the month of July is $6,900. FUTA taxes are 0.6% and SUTA taxes are 5.4% of the first $7,000 paid to the employee. Payroll for the month of July is as follows: FICA Social Security tax rate at 6.2%, FICA Medicare tax rate at 1.45%, federal income tax of $445, state income tax of $82, health-care insurance premium of $450, and pension plan of $320. The employee is responsible for covering 35% of the health insurance premium and the employer is responsible for 65% of the health insurance premium. The employer matches 75% of employee pension plan contributions. Cash Health Insurance Payable Union Dues Payable Benefits…arrow_forwardThe payroll records of Brownlee Company provided the following information for the weekly pay period ended March 23, 2021: Required: 1. Enter the relevant information in the proper columns of a payroll register and complete the register, calculate CPP and El deductions. Charge the wages of Kathy Sousa to Office Wages Expense and the wages of the remaining employees to Service Wages Expense. Calculate Income tax deductions at 20% of gross pay. Employees are paid an overtime premium of 50% for all hours in excess of 40 per week. (Round your intermediate calculations and final answers to 2 decimal places.) Payroll Week Ended March 23, 2021 Employees Ray Loran Kathy Sousa Gary Smith Nicole Parton Diana Wood 1 2 3 4 5 Employment Insurance 0.00 Employee No. View transaction list CPP MTWT 11 8 12 0000 O 0.00 7 13 8 14 8 15 0 Daily Time 00 00 00 00 00000 8 8 6 Income Tax Journal entry worksheet 2 LL 8 7 8 8 8 8 8 6 6 0.00 F S S 4 4 SOO || 0 To 0 4 4 0 0 8 8 Hospital Insurance Total Hours 40.00…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
How JOURNAL ENTRIES Work (in Accounting); Author: Accounting Stuff;https://www.youtube.com/watch?v=Y-_Q3rANyxU;License: Standard Youtube License