Breakin Away Company has three employees—a consultant, a computer programmer, and an administrator. The following payroll information is available for each employee: Consultant Computer Programmer Administrator
Regular earnings rate $4,000 per week $60 per hour $50 per hour
Overtime earnings rate* Not applicable 1.5 times hourly rate 2 times hourly rate
Number of withholding allowances 2 1 2
* For hourly employees, overtime is paid for hours worked in excess of 40 hours per week.
For the current pay period, the computer programmer worked 50 hours and the administrator worked 48 hours. The federal income tax withheld for all three employees, who are single, can be determined from the wage bracket withholding table in Exhibit 2. Assume further that the social security tax rate was 6.0%, the Medicare tax rate was 1.5%, and one withholding allowance is $75.
Determine the gross pay and the net pay for each of the three employees for the current pay period. If required, round your answers to two decimal places.
Consultant Computer Programmer Administrator
Gross pay $ $ $
Net pay $ $ $

Gross pay:

consultant $4,000 computer programmer $3,300 administrator $2,800

Net pay:

consultant $2,767.98 computer programmer $2,295.48 administrator $1,993.98

Explanation:

                                           regular earnings     overtime    withholding  

                                                                                              allowances

Consultant                        $4,000 per week       N/A                2

Computer programmer          $60 per hour        1.5                  1

Administrator                          $50 per hour          2                  2

computer programmer worked 50 hours = ($60 x 40) + ($60 x 10 x 1.5) = $3,300

administrator worked 48 hours = ($50 x 40) + ($50 x 8 x 2) = $2,800

Social security taxes:

Consultant = 6% x $4,000 = $240                         Computer programmer = 6% x $3,300 = $198         Administrator = 6% x $2,800 = $168

Medicare taxes:

Consultant = 1.5% x $4,000 = $60                         Computer programmer = 1.5% x $3,300 = $49.50         Administrator = 1.5% x $2,800 = $42

Federal income taxes:

Consultant: amount subject to withholding = $4,000 - (2 x $75) = $3,850. Federal income taxes = $356.90 + [28% x ($3,850 - $1,796) = $932.02                         Computer programmer = amount subject to withholding = $3,300 - (1 x $75) = $3,225. Federal income taxes = $356.90 + [28% x ($3,225 - $1,796) = $757.02             Administrator = amount subject to withholding = $2,800 - (2 x $75) = $2,650. Federal income taxes = $356.90 + [28% x ($2,650 - $1,796) = $596.02  

Gross pay:

consultant $4,000 computer programmer $3,300 administrator $2,800

Net pay:

consultant $4,000 - ($240 + $60 + $932.02) = $2,767.98 computer programmer $3,300 - ($198 + $49.50 + $757.02) = $2,295.48 administrator $2,800 - ($168 + $42 + $596.02) = $1,993.98