No. of Dependent Hourly Hours Regular Overtime Taxable Federal Withholdin 4 Name S Wage Worked Pay Pay Gross Pay Pay g Tax FICA 5 Alex 2 9.95 48 398 6 Andrew 1 9.55 48 7 Billie 11.75 50 8 Hema 11.75 35 9 Ingrid 1 10 40 10 Joey 1 9.55 44 11 Lisa 3 15.75 40 12 Mimi 2 12.25 20 13 Ruth 3 13.35 38 14 Sally 2 10 45 15 Tom. 1 9.95 15 16 Wally 2 11.75 41 17 Totals 18 19 Net Pay Taxable Summary 20 Assumptions 21 Base Work Hours 22 Overtime rate 23 FICA rate Pay Tax Rate Statistics # of Hours Gross Pay Net Pay 40 $0 17% Average 1.5 $250 23% Highest 8.25% $300 27% Lowest 24 Deduct per Depend $ 100.00 $450 29% 25 $525 31% 26 27 Notes 28 1. The base workweek is 40 hours. Regular pay is based on hourly wage and hours worked up to 40. 29 2. Overtime pay is based on overtime hours, the hourly wage, and the overtime rate. Sheet1 +