Calculate the federal tax withheld

Assignment Help HR Management
Reference no: EM132822931

Calculate the federal tax withheld. If an employee has a taxable income of greater than or equal to $689, then the federal tax withheld equals $110.85 plus the federal tax rate found in cell B19 multiplied by the taxable income in excess of $689. If an employee's taxable income is $689 or less, the federal tax withheld equals the taxable income multiplied by the federal tax rate found in cell B18. Use the IF function to calculate the federal tax in Column I.

A B C D E F G

Withholding Allowances Rate per Hour Hours Worked Gross Pay Taxable Income Social Security Medicare

1 18.50 45 878.75 788.75 56.68 13.62

Reference no: EM132822931

Questions Cloud

Control or display in environment : Select a control or display in your environment. Describe and evaluate it with respect to general guidelines for controls or displays. Should it be redesigned?
Why do think suspects there are so many species : Dr. Naskrecki, Why do you think he suspects there are so many more than the 2,829 species they have already identified living in the park?
Assignment on diverse workplace : Consider what diversity means to you, and what it might mean to work in a diverse organization. Have you ever been in a group of friends, classmates
What is amount of loss that purple company should recognize : Purple records losses that result from applying the lower of cost and net realizable value rule. What is amount of loss that Purple Company should recognize
Calculate the federal tax withheld : Calculate the federal tax withheld. If an employee has a taxable income of greater than or equal to $689, then the federal tax withheld equals $110.85 plus
Determine what price will the bond trade for : Suppose a seven-year, If the yield to maturity of the bond rises to 7% (APR with semiannual compounding), what price will the bond trade for?
Contrast incentive plans with that of traditional pay plans : -Compare and contrast incentive plans with that of traditional pay plans.
What is its investment in inventory : If a company has a current ratio of 1.2, a quick ratio of .8, and current assets of $600,000, what is its investment in inventory
Which one is the correct journal entry for re-issue : On December 12, On December 23, ABC company re-issued 400 shares for $15 each. Which one is the correct journal entry for re-issue?

Reviews

Write a Review

HR Management Questions & Answers

  Improve problem solving capabilities within organization

Types of teams as to their effectiveness that will improve problem solving capabilities within organizations.

  Influence tactics help in reducing organizations politics

Explain the different types of influence tactics that will be of a help “if adopted” in reducing the organizational politics.

  Report on citigroup''s hr service level agreement

Human Resources or Human Resource Management deals with HR Service Level Agreement. HR Service Level Agreement is an agreement made between the employer and the employee, which states that the employee would work under any client and sometimes any ti..

  A project report on hrm

Human Resource Management as the name suggests, it is a management discipline which deals with the human i.e. the workforce aspect of organizations. Need and practices of HRM are inevitable in present scenario of extreme competition where "Talent War..

  Hrp: recruitment and selection

Recruitment and Selection is the initial ladder of any Human Resource Planning process and contains an immense significance for any organisation.

  A project report on study of statutory complainces

Statutory compliance and its immense knowledge are crucial to be understood in an organization. It contains all the forms, procedures and acts applicable in a company.

  Operant conditioning and Reinforcement

Operant conditioning is a learning process where behaviour is controlled by its consequences. In this process an individual's behaviour can be modified through the use of positive or negative reinforcement.

  Effectiveness of training programs in achieving customers an

The main motive for conducting this research is to provide broad range of research of the literature and their reviews related to training and development and assisting the employees in providing customers satisfaction.

  A critical analysis of hr processes and practices in fedex c

FedEx is illustrious for its novel HR processes and practices that have greatly accounted for its success.

  Integrating culture and diversity in decision making

People in the organization are known as Google where they share common goals and have common vision.

  Impact of employee attrition on people management in organis

Talent management implies recognizing a person's inherent skills, traits, personality and offering him a matching job.

  Labour dissonance at maruti suzuki india limited: a case stu

This Case Study focuses on various issues related to Labour Unrest at Maruti Suzuki India Limited.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd