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:
I need help getting the answers to #4!!
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_forwardI need help getting the answer to #3!!arrow_forward
- I need help getting the answer to #5!!arrow_forwardYou 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_forwardCould you help me fill in all the blank spaces in this Excel table?Please tell me the formula so I can do it with an Excel formula.Thank you very much . In the appropriate columns of your payroll register, record the filing status for eachemployee using the information provided.2. Record the payroll deductions for the SIMPLE plan that the employer has established forparticipating employees. All of the employees are participating, and their weeklycontributions are listed below. The tax deferral on these deductions applies only to thefederal income tax.3. Record the amount of federal income taxes using the wage-bracket method and standardwithholding.4. Record the state income taxes on the gross weekly earnings for each employee. The rateis 3.07% for the state of Pennsylvania.5. Record the city income taxes on the gross weekly earnings of each employee. The rate is3% for the city of Pittsburgh residents.Time CardNo.FilingStatusNo. of WithholdingAllowancesSIMPLEDeductions11 S N/A $2012 S…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