Using the attached template, you are to compute the regular pay, overtime pay, gross pay, federal withholding, Social Security withholding, Medicare withholding and the net payment for this company. Assume there is no state income tax. Overtime is paid at a rate of 1.5 times the normal wage rate.

In addition, compute the totals for regular pay, overtime pay, gross pay, federal withholding, Social Security withholding, Medicare withholding and net payment for all the employees.

Further, create a pivot table indicating, by department and employee type, the following: number of regular hours worked, number of overtime hours worked, regular pay, overtime pay and net pay.

Please note you should use AutoFill to complete this assignment in an efficient manner.