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 09:30
When you hire an independent contractor you don't have to pay the contractors what
Answers: 3
question
Business, 22.06.2019 10:10
True tomato inc. makes organic ketchup. to promote its products, this firm decided to make bottles in the shape of tomatoes. to accomplish this, true tomato worked with its bottle manufacture to create a set of unique molds for its bottles. which of the following specialized assets does this example demonstrate? (a) site specificity (b) research specificity (c) physical-asset specificity (d) human-asset specificity
Answers: 3
question
Business, 22.06.2019 15:20
Capital financial corporation will lend 90 percent against account balances that have averaged 30 days or less; 80 percent for account balances between 31 and 40 days; and 70 percent for account balances between 41 and 45 days. customers that take over 45 days to pay their bills are not considered acceptable accounts for a loan. the current prime rate is 16.50 percent, and capital charges 3.50 percent over prime to charming as its annual loan rate. a. determine the maximum loan for which charming paper company could qualify.
Answers: 1
question
Business, 22.06.2019 19:30
About 20 years ago, sturdy light, inc., produced a sturdy, lightweight backpack in a market that was rapidly growing. sturdy light became a leader in this market. eventually, the backpack market reached the maturity stage and slowed down. however, by this time, sturdy light had developed a strong brand name and continued to steadily lead the market. which of the following describes this scenario? a. sturdy light was a star that developed into a cash cow. b. sturdy light was a question mark that developed into a star. c. sturdy light was a dog that developed into a question mark. d. sturdy light was a cash cow that developed into a star.
Answers: 2
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
English, 06.03.2020 00:45
Questions on the website: 13722361