Concept explainers
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
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 employee’s 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 employee’s 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.
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
Excel Applications for Accounting Principles
- Wallace Corporation summarizes the following information from its weekly payroll records during April. Prepare the two journal entries to record the payment of the payroll and the accrual of its payroll taxes for April. Assume an 8% FICA rate for both employees and the employer. Also assume a 5.4% state unemployment tax rate, a 0.6% federal unemployment tax rate, and that all wages are subject to all payroll taxes. Round to the nearest dollar.arrow_forwardOn September 30, Cody Companys selected account balances are as follows: In general journal form, prepare the entries to record the following: Oct. 15Payment of liabilities for FICA taxes and the federal income tax. 31Payment of liability for state unemployment tax. 31Payment of liability for federal unemployment tax.arrow_forwardThe totals line from Nix Companys payroll register for the week ended March 31, 20--, is as follows: Payroll taxes are imposed as follows: Social Security tax, 6.2%; Medicare tax, 1.45%; FUTA tax, 0.6%; and SUTA tax, 5.4%. REQUIRED 1. a. Prepare the journal entry for payment of this payroll on March 31, 20--. b. Prepare the journal entry for the employers payroll taxes for the period ended March 31, 20--. 2. Nix Company had the following balances in its general ledger before the entries for requirement ( 1 ) were made: a. Prepare the journal entry for payment of the liabilities for federal income taxes and Social Security and Medicare taxes on April 15, 20--. b. Prepare the journal entry for payment of the liability for FUTA tax on April 30, 20--. c. Prepare the journal entry for payment of the liability for SUTA tax on April 30, 20--.arrow_forward
- Payrex Co. has six employees. All are paid on a weekly basis. For the payroll period ending January 7, total employee earnings were 12,500, all of which were subject to SUTA, FUTA, Social Security, and Medicare taxes. The SUTA tax rate in Payrexs state is 5.4%, but Payrex qualifies for a rate of 2.0% because of its good record of providing regular employment to its employees. Other employer payroll taxes are at the rates described in the chapter. REQUIRED 1. Calculate Payrexs FUTA, SUTA, Social Security, and Medicare taxes for the week ended January 7. 2. Prepare the journal entry for Payrexs payroll taxes for the week ended January 7. 3. What amount of payroll taxes did Payrex save because of its good employment record?arrow_forwardIn the Illustrative Case in this chapter, payroll transactions for Brookins Company were analyzed, journalized, and posted for the third quarter of the fiscal year. In this problem, you are to record the payroll transactions for the last quarter of the firms fiscal year. The last quarter begins on April 1, 20--. Refer to the Illustrative Case on pages 6-27 to 6-33 and proceed as follows: a. Analyze and journalize the transactions described in the following narrative. Use the two-column journal paper provided on pages 6-73 to 6-77. Omit the writing of explanations in the journal entries. b. Post the journal entries to the general ledger accounts on pages 6-78 to 6-83. Narrative of Transactions: c. Answer the following questions: 1. The total amount of the liability for FICA taxes and federal income taxes withheld as of June 30 is................................................................................ ________ 2. The total amount of the liability for state income taxes withheld as of June 30 is................................................................................................................ ________ 3. The amount of FUTA taxes that must be paid to the federal government on or before August 1 (assume July 31 is a Sunday) is........................................ ________ 4. The amount of contributions that must be paid into the state unemployment compensation fund on or before August 1 is.................................................. ________ 5. The total amount due the treasurer of the union is........................................ ________ 6. The total amount of wages and salaries expense since the beginning of the fiscal year is ................................................................................................... ________ 7. The total amount of payroll taxes expense since the beginning of the fiscal year is ............................................................................................................ ________ 8. Using the partial journal below, journalize the entry to record the vacation accrual at the end of the companys fiscal year. The amount of Brookins Companys vacation accrual for the fiscal year is 15,000.arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,College Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage Learning
- College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College PubCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781305084087Author:Cathy J. ScottPublisher:Cengage Learning