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 9R
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Prepare the general journal entry to record the employer's payroll taxes. Assume rates of 0.6 percent for federal unemployment tax and 5.4 percent for state unemployment tax based on the first $7,000 for each employee. Also assume that no employee has earned more than $7,000. If an amount box does not require an entry, leave it blank. If required, round your intermediate calculations and final answers to the nearest cent and use the rounded answers in subsequent computations.
Eaton Enterprises uses the wage-bracket method to determine federal income tax withholding on its employees.
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
Open spreadsheet
Find the amount to withhold from the wages paid each employee. Enter all amounts as positive numbers. If an amount is zero, enter "0". Round interim calculations to two decimals and use in subsequent computations. Round final answer to two decimal places.
As we go to press, the federal income tax rates for 2022 are being determined by budget talks in Washington and not available for publication. For this edition, the 2021 federal income tax tables for Manual Systems with Forms W-4 from 2020 or later with Standard Withholding and 2020 FICA rates have been used.
Click here to access the Wage-Bracket Method Tables.
Employee
FilingStatus
No. ofWithholdingAllowances
Payroll…
Journalize each of the payroll transactions listed below. Post all entries except the last two to the appropriate general ledger accounts.
The journal page and the ledger accounts are supplied below. The balances listed in the general ledger accounts for Cash, FUTA Taxes Payable, SUTA Taxes Payable, Employees SIT Payable, Wages and Salaries, and Payroll Taxes are the results of all payroll transactions for the first quarter, not including the last pay of the quarter. The balances in FICA Taxes Payable—OASDI, FICA Taxes Payable—HI, and Employees FIT Payable are the amounts due from the March 15 payroll.
March 31, 20--: Paid total wages of $9,350.00. These are the wages for the last semimonthly pay of March. All of this amount is taxable under FICA (OASDI and HI). In addition, withhold $1,175 for federal income taxes and $102.03 for state income taxes. These are the only deductions made from the employees' wages.
March 31, 20--: Record the employer's payroll taxes for the last pay in…
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
- Recording payroll and payroll taxes. Assume that the company is subject to a 2% state unemployment tax and 0.6% federal unemployment tax. REQUIRED: Record the following in general journal entry form on May 31. A. Accrual of monthly payroll B. Payment of the net payroll C. Accrual of employers payroll taxes(assume that the FICA matches the amount withhold) D. Payment of these payroll related liabilities. (assume that all are settled at the same time) The options for the shaded drop boxes are : Administrative salaries expense, cash, custodial salaries expense, federal income tax withholding payable, federal unemployment tax payable, FICA tax payable, payroll payable, payroll tax expense, sales salaries expense, state unemployment tax payable.arrow_forwardObj. 2 PR 10-3A Wage and tax statement data on employer FICA tax Ehrlich Co. began business on January 2. Salaries were paid to employees on the last day of each month, and social security tax, Medicare tax, and federal income tax were withheld in the required amounts. An employee who is hired in the middle of the month receives half the monthly salary for that month. All required payroll tax reports were filed, and the cor- rect amount of payroll taxes was remitted by the company for the calendar year. Early in the following year, before the Wage and Tax Statements (Form W-2) could be prepared for dis- tribution to employees and for filing with the Social Security Administration, the employees' earnings records were inadvertently destroyed. None of the employees resigned or were discharged during the year, and there were no changes in salary rates. The social security tax was withheld at the rate of 6.0% and Medicare tax at the rate of 1.5% on salary. Data on dates of employment,…arrow_forwardExercise 9-11 (Algo) Computing payroll taxes LO P2, P3 Mest Company has nine employees. FICA Social Security taxes are 6.2% of the first $137,700 paid to each employee, and FICA Medicare taxes are 1.45% of gross pay. FUTA taxes are 0.6% and SUTA taxes are 5.4 % of the first $7,000 paid to each employee. Cumulative pay for the current year for each of its employees follows. Employee Ken S Tim V Steve S Cumulative Pay $ 5,200 44,400 91,000 Employee Ken S Tim V Complete this question by entering your answers in the tabs below. Required A Compute the amounts in this table for each employee. Pay Subject to FICA Social Security Steve S Julie W Michael M Zach R Christina S Kitty O John W Totals a. Compute the amounts in this table for each employee. b. For the company, compute each total for FICA Social Security taxes, FICA Medicare taxes, FUTA taxes, and SUTA taxes. Hint Remember to include in those totals any employee share of taxes that the company must collect. Required B Employee Julie W…arrow_forward
- Based on the information in problem 2, calculate and record the employers payroll taxes for the period in the general journal below. The state employment tax rate is 5.4 percent, and the federal unemployment tax rate is 0.8 percent.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_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
- 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_forwardPayroll Accounting Jet Enterprises has the following data available for its April 30, 2019, payroll: *All subject to Social Security and Medicare matching and withholding of 6.2% and 1.45%, respectively. Federal unemployment taxes of 0.70% and state unemployment taxes of 0.90% are payable on $405,700 of the wages earned. Required: 1. Compute the amounts of taxes payable and the amount of wages that will be paid to employees. Then prepare the journal entries to record the wages earned and the payroll taxes. ( Note: Round to the nearest penny.) 2. CONCEPTUAL CONNECTION Jet would like to hire a new employee at a salary of $65,000. Assuming payroll taxes are as described above (with unemployment taxes paid on the first $9,000) and fringe benefits (e.g., health insurance, retirement, etc.) are 25% of gross pay, what will be the total cost of this employee for Jet?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
- The payroll register of Seaside Architecture Company indicates $840 of social security and $213 of Medicare tax withheld on total salaries of $14,200 for the period. Assume earnings subject to state and federal unemployment compensation taxes are $4,900 at the federal rate of 0.80% and state rate of 5.40%. Required: Prepare the journal entry to record the payroll tax expense for the period. Refer to the Chart of Accounts for exact wording of account titles. Round your answers to two decimal places. CHART OF ACCOUNTS Seaside Architecture Company General Ledger ASSETS 110 Cash 111 Accounts Receivable 112 Interest Receivable 113 Notes Receivable 115 Inventory 116 Supplies 118 Prepaid Insurance 120 Land 123 Building 124 Accumulated Depreciation-Building 125 Office Equipment 126 Accumulated Depreciation-Office Equipment LIABILITIES 210 Accounts Payable 213 Interest Payable 214 Notes Payable 221 Salaries Payable 222…arrow_forwardThe payroll register of Seaside Architecture Company indicates $820 of social security and $215 of Medicare tax withheld on total salaries of $14,400 for the period. Assume earnings subject to state and federal unemployment compensation taxes are $4,900 at the federal rate of 0.80% and state rate of 5.40%. Required: Prepare the journal entry to record the payroll tax expense for the period. Refer to the Chart of Accounts for exact wording of account titles. Round your answers to two decimal places.arrow_forwardThe payroll register of Seaside Architecture Company indicates $820 of social security and $215 of Medicare tax withheld on total salaries of $14,400 for the period. Assume earnings subject to state and federal unemployment compensation taxes are $4,900 at the federal rate of 0.80% and state rate of 5.40%. Required: Prepare the journal entry to record the payroll tax expense for the period. Refer to the Chart of Accounts for exact wording of account titles. Round your answers to two decimal places. Chart of Accounts CHART OF ACCOUNTS Seaside Architecture Company General Ledger ASSETS 110 Cash 111 Accounts Receivable 112 Interest Receivable 113 Notes Receivable 115 Inventory 116 Supplies 118 Prepaid Insurance 120 Land 123 Building 124 Accumulated Depreciation-Building 125 Office Equipment 126 Accumulated Depreciation-Office Equipment LIABILITIES 210 Accounts Payable 213 Interest Payable 214 Notes…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
College Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
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
College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
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