Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 10, Problem 4R
To determine
Compute the net pay by entering the gross pay and federal income tax withheld and enter $85,000 in the cumulative gross pay cell.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
At the end of the weekly payroll period on June 30, the payroll register of Concord Consultants showed employee earnings of
$71,000. Determine the firm's payroll taxes for the period. Use a social security rate of 6.2 percent, Medicare rate of 1.45 percent, FUTA
rate of 0.6 percent, and SUTA rate of 5.4 percent. Consider all earnings subject to social security tax and Medicare tax and $40,908
subject to FUTA and SUTA taxes. (Round your answers to 2 decimal places.)
Base
Rate
Tax
Social security
Medicare
FUTA
SUTA
Total
%
%
%
%
Amount
The weekly payroll of Abkar Hardware includes 19 employees who earn $280.00 each. Using a 6.2% FICA Social Security rate and a 1.45% FICA Medicare rate, how much is the employer's share of total social security and Medicare taxes for the first quarter of the year?
From the following information, calculate the payroll tax expense for Bowling Company for the payroll of April
(Click the icon to view the payroll)
The FICA tax rate for OASDI is 6.2% on the first $127.200 eamed, and Medicare is 1.45% on all earnings. Federal unemployment tax is 0.6% on the first $7,000 eamed by each employee. The
SUTA tax rate for Bowling Company is 5.4% on the first $7,000 of employes earnings for state unemployment purposes. (Round to the nearest cent as needed)
Total
CELES
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
Similar questions
- 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_forwardOn January 21, the column totals of the payroll register for Great Products Company showed that its sales employees had earned 14,960, its truck driver employees had earned 10,692, and its office employees had earned 8,670. Social Security taxes were withheld at an assumed rate of 6.2 percent, and Medicare taxes were withheld at an assumed rate of 1.45 percent. Other deductions consisted of federal income tax, 3,975, and union dues, 560. Determine the amount of Social Security and Medicare taxes withheld and record the general journal entry for the payroll, crediting Salaries Payable for the net pay. All earnings were taxable. Round amounts to the nearest penny.arrow_forwardWallace 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_forward
- The following information about the payroll for the week ended December 30 was obtained from the records of Qualitech Co.: Tax rates assumed: Social security, 6% Medicare, 1.5% State unemployment (employer only), 5.4% Federal unemployment (employer only), 0.8% Instructions 1. Assuming that the payroll for the last week of the year is to be paid on December 31, journalize the following entries: a. December 30, to record the payroll. b. December 30, to record the employers payroll taxes on the payroll to be paid on December 31. Of the total payroll for the last week of the year, 35,000 is subject to unemployment compensation taxes. 2. Assuming that the payroll for the last week of the year is to be paid on January 5 of the following fiscal year, journalize the following entries: a. December 30, to record the payroll. b. January 5, to record the employers payroll taxes on the payroll to be paid on January 5. Because it is a new fiscal year, all 675,000 in salaries is subject to unemployment compensation taxes.arrow_forwardToren Inc. employs one person to run its solar management company. The employees gross income for the month of May is $6,000. Payroll for the month of May is as follows: FICA Social Security tax rate at 6.2%, FICA Medicare tax rate at 1.45%, federal income tax of $400, state income tax of $75, health-care insurance premium of $200, and union dues of $50. The employee is responsible for covering 30% of his or her health insurance premium. A. Record the journal entry to recognize employee payroll for the month of May, dated May 31, 2017. B. Record remittance of the employees salary with cash on June 1.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
- Trowbridge Company has just completed the processing of its year-end payroll and distributed all the weekly paychecks. The payroll department is now computing the amount of the annual bonus to be given each worker. What methods may be used by the company in determining the amount of federal income taxes to be withheld from the annual bonus payments?arrow_forwardPaloma Company has four 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. Also, for the first $7,000 paid to each employee, the company's FUTA taxes are 0.6% and SUTA taxes are 5.4%. The company is preparing its payroll calculations for the week ended August 25. Payroll records show the following information for the company's four employees. Current Week ces Name Gross Pay through August 18 $ 124,100 Dali Trey Kiesha Chee 133,900 9,100 3,050 Gross Pay Income Tax Withholding $ 4,800 $ 568 3,800 298 1,000 56 1,000 45 In addition to gross pay, the company must pay one-half of the $100 per employee weekly health insurance; each employee pays the remaining one-half. The company also contributes an extra 8 % of each employee's gross pay (at no cost to employees) to a pension fund. Required: Compute the following for the week ended August 25. Note: Round your intermediate calculations and final answers…arrow_forwardPaloma Company has four 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. Also, for the first $7,000 paid to each employee, the company's FUTA taxes are 0.6% and SUTA taxes are 5.4%. The company is preparing its payroll calculations for the week ended August 25. Payroll records show the following information for the company's four employees. Name Dali Trey Kiesha Chee Gross Pay through August 18 $ 125,400 135,300 7,800 1,750 Employee Tax Rate Dali Current Week Trey Kiesha Chee Gross Pay $ 5,600 2,400 1,600 2,000 In addition to gross pay, the company must pay one-half of the $74 per employee weekly health insurance, each employee pays the remaining one-half. The company also contributes an extra 8% of each employee's gross pay (at no cost to employees) to a pension fund. Required: Compute the following for the week ended August 25 Note: Round your intermediate calculations and final answers to 2…arrow_forward
- Paloma Company has four 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. Also, for the first $7,000 paid to each employee, the company's FUTA taxes are 0.6% and SUTA taxes are 5.4%. The company is preparing its payroll calculations for the week ended August 25. Payroll records show the following information for the company's four employees. Name Dali Trey Kiesha Chee Gross Pay through August 18 $ 124,100 133,900 9,100 3,050 Current Week Gross Pay $ 4,800 Income Tax Withholding 3,800 $ 568 298 1,000 1,000 56 45 In addition to gross pay, the company must pay one-half of the $100 per employee weekly health insurance; each employee pays the remaining one-half. The company also contributes an extra 8% of each employee's gross pay (at no cost to employees) to a pension fund. Required: Compute the following for the week ended August 25. Note: Round your intermediate calculations and final answers to 2…arrow_forwardPaloma Company has four 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. Also, for the first $7,000 paid to each employee, the company's FUTA taxes are 0.6% and SUTA taxes are 5.4%. The company is preparing its payroll calculations for the week ended August 25. Payroll records show the following information for the company's four employees. Current Week Gross Pay through August 18 $ 124,200 134,300 9,000 2,950 Income Tax Name Gross Pay $ 4,700 3,400 1,600 1,000 Withholding $ 554 Dali Trey Kiesha 306 55 Chee 44 In addition to gross pay, the company must pay one-half of the $98 per employee weekly health insurance; each employee pays the remaining one-half. The company also contributes an extra 8% of each employee's gross pay (at no cost to employees) to a pension fund. Required: Compute the following for the week ended August 25. (Round your intermediate calculations and final answers to 2 decimal…arrow_forwardces Paloma Company has four 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. Also, for the first $7,000 paid to each employee, the company's FUTA taxes are 0.6% and SUTA taxes are 5.4%. The company is preparing its payroll calculations for the week ended August 25. Payroll records show the following information for the company's four employees. Name Dali Trey Kiesha Chee Employee Tax Rate Dali Trey Kiesha Chee In addition to gross pay, the company must pay one-half of the $82 per employee weekly health insurance; each employee pays the remaining one-half. The company also contributes an extra 8% of each employee's gross pay (at no cost to employees) to a pension fund. 1) Employees' FICA Withholdings for Social Security Earnings Subject to Tax Employee Required: Compute the following for the week ended August 25. Note: Round your Intermediate calculations and final answers to 2 decimal places. Tax…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege 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
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCollege Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781305084087
Author:Cathy J. Scott
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning