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
- 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_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_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_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
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege 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 LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning