subject
Business, 30.05.2020 16:59 antlife555

Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell G5, calculate the gross pay based on the regular and overtime pay. Abram’s regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40.

Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents (column B) by the deduction per dependent (A24) and subtract that from the gross pay. With two dependents, Abram’s taxable pay is $417.40.

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 11:10
Your team has identified the risks on the project and determined their risk score. the team is in the midst of determining what strategies to put in place should the risks occur. after some discussion, the team members have determined that the risk of losing their network administrator is a risk they'll just deal with if and when it occurs. although they think it's a possibility and the impact would be significant, they've decided to simply deal with it after the fact. which of the following is true regarding this question? a. this is a positive response strategy.b. this is a negative response strategy.c. this is a response strategy for either positive or negative risk known as contingency planning.d. this is a response strategy for either positive or negative risks known as passive acceptance.
Answers: 2
question
Business, 22.06.2019 16:50
Coop inc. owns 40% of chicken inc., both coop and chicken are corporations. chicken pays coop a dividend of $10,000 in the current year. chicken also reports financial accounting earnings of $20,000 for that year. assume coop follows the general rule of accounting for investment in chicken. what is the amount and nature of the book-tax difference to coop associated with the dividend distribution (ignoring the dividends received deduction)?
Answers: 2
question
Business, 22.06.2019 17:30
Kevin and jenny, who are both working full-time, have three children all under the age of ten. the two youngest children, who are three and five years old, attended eastside pre-school for a total cost of $3,000. ervin, who is nine, attended big kid daycare after school at a cost of $2,000. jenny has earned income of $15,000 and kevin earns $14,000. what amount of childcare expenses should be used to determine the child and dependent care credit?
Answers: 3
question
Business, 22.06.2019 19:30
Which of the following occupations relate to a skill category of words and literacy
Answers: 1
You know the right answer?
Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek i...
Questions
question
Mathematics, 16.12.2020 18:50
question
Mathematics, 16.12.2020 18:50
question
Social Studies, 16.12.2020 18:50
question
Mathematics, 16.12.2020 18:50
question
History, 16.12.2020 18:50
question
Mathematics, 16.12.2020 18:50
question
Mathematics, 16.12.2020 18:50
question
Mathematics, 16.12.2020 18:50
question
Mathematics, 16.12.2020 18:50
Questions on the website: 13722361