Question

Please help! I am stuck on this problem

Ch 11-3 Exercises and Problems Calculator eBook Show Me How Print Item 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 $2,510 per week $30 per hour $42 per hour Overtime eanings rate Not applicable 1.5 times hourly rate 2 times hourty rate Number of withholding allowances For the current pay period, the computer programmer worked 60 hours and the administrator worked 50 hours. The federal income tax withheld for all three employees, who are single, can be determined by adding $356.90 to 28% of the difference between the employee's amount subject to withholding and $1,796.00. Assume further that the social security tax rate was 6%, the Medicare tax rate was 1.5%, and one withholding allowance is $70. Determine the gross pay and the net pay for each of the three employees for the current pay period. Assume the normal working hours in a week are 40 hours. If required, round your answers to two decimal places. Consultant Computer Programmer Administrator 2,300 x Gross pay 1,960 X 2,490 x Net pay 1,115.71 X 1,399.68 X 411.3 X Feedek Check My Work Gross pay represents the total earnings of an employee for a speciffic pay period, prior to taxes and deductions. Net pay is also known as take-home pay. Locate the proper withholding wage bracket in the withholding table. Pay attention to the number of exemptions each employee is claiming.

Answer 1

	Consultant	Computer Programer	Administrator
Gross Pay	$ 2,510	$ 2,100	$ 2,520
Net Pay	$ 1,823.73	$ 1,539.68	$ 1,790.98

Calculation;

# Consultant ;

Gross Pay = Regular Pay + Overtime Pay

= $ 2,510 + Nil = $ 2,510

# Computer Programmer ;

Gross Pay = Regular Pay + Ovettime Pay

= ( $ 30 * $ 40 ) + ($30 * 20 * 1.5 )

= $ 1200 + $ 900 = $ 2,100

# Administrator

Gross Pay = Regular Pay + Overtime Pay

= ($ 42 * 40 ) + ($ 42 * 10 * 2 )

= $ 1,680 + $ 840 = $ 2,520

Calculation for Net Pay

​Consultant ;

Particulars	Amount
Gross Pay	$ 2,510
Less: Deduction
Federal Income Tax Withholding	($ 498.02)
Social Security Tax ($ 2,510 * 6 % )	( $ 150.6)
Medicare Tax ( $ 2,510 * 1.5 % )	($ 37.65)
Net Pay	$ 1,823.73

Computer Programmer

Particulars	Amount
Gross Pay	$ 2,100
Less: Deduction
Federal Income Tax Withholding	( $ 402.82)
Social Security Tax ( $ 2100 * 6 % )	( $ 126)
Medicare Tax ($ 2100 * 1.5 % )	( $ 31.5 )
Net Pay	$ 1539.68

Administrator

Particulars	Amount
Gross Pay	$ 2520
Less Deduction
Federal Income Tax Withholding	( $540.02)
Social Security Tax ( $ 2520 * 6 % )	( $ 151.20 )
Medicare Tax ( $ 2520 * 1.5 % )	( $ 37.8)
Net Pay	$ 1,790 .98

Calculation of Federal Income Tax Withholding For

Particulars	Consultant	Computer Programmer	Administrator
Gross weekly Pay	$ 2,510	$ 2,100	$ 2,520
No of withholding Allowances	3	2	1
Value of one allowance	$ 70	$ 70	$ 70
Amount to be deducted	$ 210	$ 140	$ 70
Amount Subject to with holding	$ 2,300	$ 1,960	$ 2,450
Initial Withholding	$ 356.90	$ 356.90	$ 356.90
Bracket %( 28% )Over Bracket Excess	( $ 2300 - $1,796)	( $ 1,960 - $ 1,796)	( 2,450 - $ 1796)
	$ 141.12	$ 45.92	$ 183.12
Amount Withheld	$ 498.02	$ 402.82	$ 540.02