subject
Business, 16.04.2020 03:34 tatilynnsoto17

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:00
Aprofessional does specialized work that's primarily: degree based. medical or legal. well paying. intellectual and creative
Answers: 2
question
Business, 22.06.2019 17:40
Croy inc. has the following projected sales for the next five months: month sales in units april 3,850 may 3,875 june 4,260 july 4,135 august 3,590 croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. direct material costs $2.50 per pound, and each unit requires 2 pounds. raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. raw materials on hand at march 31 totaled 3,741 pounds. 1. determine budgeted production for april, may, and june. 2. determine the budgeted cost of materials purchased for april, may, and june. (round your answers to 2 decimal places.)
Answers: 3
question
Business, 22.06.2019 19:50
On july 7, you purchased 500 shares of wagoneer, inc. stock for $21 a share. on august 1, you sold 200 shares of this stock for $28 a share. you sold an additional 100 shares on august 17 at a price of $25 a share. the company declared a $0.95 per share dividend on august 4 to holders of record as of wednesday, august 15. this dividend is payable on september 1. how much dividend income will you receive on september 1 as a result of your ownership of wagoneer stock
Answers: 1
question
Business, 23.06.2019 06:50
How is a federal loan different from a private loan for an education? a federal loan is available for any student who meets the government's lending standards. a private loan is only available for students who show a need. a federal loan is only available for students who show a need. a private loan is available for any student who meets the bank's lending standards. a federal loan can only be used to pay for a student's tuition. a private loan can be used to pay for a student's tuition and any other expenses. a federal loan can be used to pay for a student's tuition and any other expenses. a private loan can only be used to pay for a student's tuition.
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, 30.07.2021 03:10
question
Mathematics, 30.07.2021 03:20
Questions on the website: 13722362