subject
Business, 22.09.2020 20:01 NotYourStudent

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: 3

Another question on Business

question
Business, 21.06.2019 20:00
Which of the following statements is true about financial planning
Answers: 2
question
Business, 21.06.2019 22:50
Tara incorporates her sole proprietorship, transferring it to newly formed black corporation. the assets transferred have an adjusted basis of $240,000 and a fair market value of $300,000. also transferred was $10,000 in liabilities, $1,000 of which was personal and the balance of $9,000 being business related. in return for these transfers, tara receives all of the stock in black corporation. a. black corporation has a basis of $241,000 in the property. b. black corporation has a basis of $240,000 in the property. c. tara’s basis in the black corporation stock is $241,000. d. tara’s basis in the black corporation stock is $249,000. e. none of the above.
Answers: 1
question
Business, 22.06.2019 03:00
For each separate case below, follow the 3-step process for adjusting the prepaid asset account at december 31. step 1: determine what the current account balance equals. step 2: determine what the current account balance should equal. step 3: record the december 31 adjusting entry to get from step 1 to step 2. assume no other adjusting entries are made during the year. a. prepaid insurance. the prepaid insurance account has a $4,700 debit balance to start the year. a re- view of insurance policies and payments shows that $900 of unexpired insurance remains at year-end. b. prepaid insurance. the prepaid insurance account has a $5,890 debit balance at the start of the year. a review of insurance policies and payments shows $1,040 of insurance has expired by year-end. c.prepaidrent.onseptember1ofthecurrentyear,thecompanyprepaid$24,000 for 2 years of rentfor facilities being occupied that day. the company debited prepaid rent and credited cash for $24,000.
Answers: 3
question
Business, 22.06.2019 15:30
Susan is a 5th grade teacher and loves getting up every day and going to work to teach her students. this is an example of a. extrinsic value b. interests c. intrinsic value d. external value
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
Biology, 01.12.2020 08:20
question
Arts, 01.12.2020 08:20
question
Mathematics, 01.12.2020 08:20
question
Mathematics, 01.12.2020 08:20
question
French, 01.12.2020 08:20
question
Mathematics, 01.12.2020 08:20
question
English, 01.12.2020 08:20