Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
Metropolitan Zoo Glft Shop Department No. of Hourly Hours Overtime Dependents Wage Worked Regular Pay Pay Gross Pay Taxable Pay . Net Pay Abram 2...
I have a couple questions I need help with on my Metropolitan Zoo Giftshop
- Use the IF functions to calculate and the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. pay overtime only for overtime hours. Calculate the gross pay based on the regular and overtime pay. Adam's regular pay is $398. With 8 overtime hours, Adam's overtime pay is $119.40.
- I need help creating a formula in cell H5 to calculate the taxable pay.
- I have to use the VLOOKUP function in cell I5 to identify and calculate the federal withholding tax.
- I have to calculate a FICA in cell J5 based on gross pay and the FICA rate, and calculate the net pay in cell K5.
