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 12:10
The cost of the beginning work in process inventory was comprised of $3,000 of direct materials, $10,000 of direct labor, and $10,000 of factory overhead. costs incurred during the period were comprised of $15,000 of direct materials costs, and $100,000 of conversion costs. the equivalent units of production (eup) for the period were 9,000 for direct materials and 6,000 for conversion. the costs per eup were:
Answers: 3
question
Business, 22.06.2019 14:50
One pound of material is required for each finished unit. the inventory of materials at the end of each month should equal 20% of the following month's production needs. purchases of raw materials for february would be budgeted to be:
Answers: 2
question
Business, 22.06.2019 19:00
Lucy is catering an important luncheon and wants to make sure her bisque has the perfect consistency. for her bisque to turn out right, it should have the consistency of a. cold heavy cream. b. warm milk. c. foie gras. d. thick oatmeal.
Answers: 3
question
Business, 22.06.2019 19:10
Do it! review 16-3 the assembly department for right pens has the following production data for the current month. beginning work in process units transferred out ending work in process 0 22,500 16,000 materials are entered at the beginning of the process. the ending work in process units are 70% complete as to conversion costs. compute the equivalent units of production for (a) materials and (b) conversion costs. materials conversion costs the equivalent units of production
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