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 19:00
It is estimated that over 100,000 students will apply to the top 30 m.b.a. programs in the united states this year. a. using the concept of net present value and opportunity cost, when is it rational for an individual to pursue an m.b.a. degree. b. what would you expect to happen to the number of applicants if the starting salaries of managers with m.b.a. degrees remained constant but salaries of managers without such degrees decreased by 20 percent
Answers: 3
question
Business, 22.06.2019 21:30
Suppose that alexi and tony can sell all their street tacos for $2 each and all their cuban sandwiches for $7.25 each. if each of them worked 20 hours per week, how should they split their time between the production of street tacos and cuban sandwiches? what is their maximum joint revenue?
Answers: 3
question
Business, 22.06.2019 23:00
The quinoa seed is in high demand in wealthier countries such as the u.s. and japan. approximately 97% of all quinoa production comes from small farmers in bolivia and peru who farm at high elevations—8,000 feet or higher. the seed is considered highly nutritious. mostly grown and harvested in bolivia and peru, and sold to markets in other countries, the seed is now considered an important for these nations. the governments of bolivia and peru are hopeful that this product will increase the quality of life of their farmers.
Answers: 3
question
Business, 23.06.2019 01:30
Should i run away or get a boyfriend and be loved again
Answers: 3
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, 19.02.2021 14:00
question
Mathematics, 19.02.2021 14:00
question
Mathematics, 19.02.2021 14:00
question
Mathematics, 19.02.2021 14:00
question
Chemistry, 19.02.2021 14:00
question
Mathematics, 19.02.2021 14:00
Questions on the website: 13722362