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

  Achieve a common goal or set of goals

Which of the following is best defined as a consciously coordinated social unit, composed of two or more people, which functions on a relatively continuous basis to achieve a common goal or set of goals?

  Should the candidate be subjected to training

A potential male candidate has been hired, based upon his high score in a general multiple choice "Ability Test." Should this candidate be subjected to training

  Significant impact on employee engagement

According to research, which of the following has a significant impact on employee engagement?

  Explain how does agency check the needs and opportunities

Explain How does the agency check the needs and opportunities for services it may provide and How does it involve the community in its assessment process

  Application of hrm practices that inform

Critically evaluate the employee relations and the application of HRM practices that inform and influence decision making in an organizational context.

  Explain the labor laws with sufficient academic data

Explain the Labor Laws with sufficient academic data and include why the law was needed, and what changes the laws made to the workplace

  Describe unique features of your chosen film

Describe unique features of your chosen film and genre and explain what you like and/or dislike about the genre.conduct some research on notable films.

  Federal and state legislation that supports fair workplace

A brief description of the event and the work environment the discrimination occurred (Omit identifying demographic information and use fictitious names as needed.) Federal and state legislation that supports fair workplace practices

  Hr polices and programsthink about your current or any

hr polices and programsthink about your current or any previous employer you have observed. as you consider the hr

  Dscuss the basic steps in the planning process explain

in a four- to five-page paper excluding the title and references pages discuss the strategic planning process. in your

  Encounter ethical dilemmas

Businesses often encounter ethical dilemmas. Depending on the industry, there may be consequences to business behavior that ignores ethical standards.

  How team communication problems can lead to disaster

What are some of the possible biases and points of error that may arise in team communication systems? In addition to those cited in the opening of Chapter 6.

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