|
Fed. Tax Rate |
0.3 |
|
|
|
|
|
|
|
|
Overtime rate |
1.5 |
|
|
|
|
|
|
Hourly |
Regular |
Overtime |
Gross |
Federal |
Net |
|
| ID |
First Name |
Last Name |
Rate |
Hours |
Hours |
Pay |
Tax |
Pay |
|
| 1300 |
Ashley |
Zwierlein |
25.25 |
40 |
14 |
=(D5*E5)+(F5*C2*D5) |
=$C1*G5 |
=$G5-H5 |
|
| 1301 |
Gerald |
Bobinsky |
23.45 |
40 |
13 |
=(D6*E6)+(F6*C2*D6) |
=C1*G6 |
=G6-H6 |
|
| 1364 |
Melissa |
Pruski |
17.5 |
21 |
|
=(D7*E7)+(F7*C2*D7) |
=C1*G7 |
=G7-H7 |
|
| 1528 |
Phan |
Tran |
19.75 |
40 |
8 |
=(D8*E8)+(F8*C2*D8) |
=C1*G8 |
=G8-H8 |
|
| 1695 |
Luke |
Nagasaki |
21.85 |
40 |
|
=(D9*E9)+(F9*C2*D9) |
=C1*G9 |
=G9-H9 |
|
| 2240 |
Hermione |
Gingrich |
22.3 |
14 |
|
=(D10*E10)+(F10*C2*D10) |
=C1*G10 |
=G10-H10 |
|
| 2318 |
Holly |
GoLightly |
21.5 |
40 |
18 |
=(D11*E11)+(F11*C2*D11) |
=C1*G11 |
=G11-H11 |
|
| 2754 |
Barbara |
Streisand |
15.2 |
40 |
19 |
=(D12*E12)+(F12*C2*D12) |
=C1*G12 |
=G12-H12 |
|
| 3370 |
Keifer |
Sutherland |
18.25 |
22 |
|
=(D13*E13)+(F13*C2*D13) |
=C1*G13 |
=G13-H13 |
|
| 3432 |
George |
Jones |
26.2 |
40 |
16 |
=(D14*E14)+(F14*C2*D14) |
=C1*G14 |
=G14-H14 |
|
| 3436 |
John |
Lennon |
20.35 |
15 |
|
=(D15*E15)+(F15*C2*D15) |
=C1*G15 |
=G15-H15 |
|
| 3458 |
Bob |
Cobb |
24 |
27 |
|
=(D16*E16)+(F16*C2*D16) |
=C1*G16 |
=G16-H16 |
|
| 3609 |
Estelle |
Constanza |
16.25 |
16 |
|
=(D17*E17)+(F17*C2*D17) |
=C1*G17 |
=G17-H17 |
|
| 3692 |
Frank |
Constanza |
17.5 |
40 |
11 |
=(D18*E18)+(F18*C2*D18) |
=C1*G18 |
=G18-H18 |
|
| 3700 |
Hello |
Newman |
17.5 |
23 |
|
=(D19*E19)+(F19*C2*D19) |
=C1*G19 |
=G19-H19 |
|
| 3892 |
George |
Constanza |
18.35 |
31 |
|
=(D20*E20)+(F20*C2*D20) |
=C1*G20 |
=G20-H20 |
|
| 3943 |
Cosmo |
Kramer |
25.25 |
40 |
12 |
=(D21*E21)+(F21*C2*D21) |
=C1*G21 |
=G21-H21 |
|
| 4012 |
Elaine |
Benis |
23.1 |
40 |
15 |
=(D22*E22)+(F22*C2*D22) |
=C1*G22 |
=G22-H22 |
|
| 4029 |
Jerry |
Seinfeld |
16.75 |
31 |
|
=(D23*E23)+(F23*C2*D23) |
=C1*G23 |
=G23-H23 |
|
| 4057 |
Fred |
Flintstone |
17.75 |
40 |
4 |
=(D24*E24)+(F24*C2*D24) |
=C1*G24 |
=G24-H24 |
|
| 4058 |
Barney |
Rubble |
24.65 |
25 |
|
=(D25*E25)+(F25*C2*D25) |
=C1*G25 |
=G25-H25 |
|
| 4082 |
Wilma |
Flintstone |
24 |
40 |
19 |
=(D26*E26)+(F26*C2*D26) |
=C1*G26 |
=G26-H26 |
|
| 4112 |
Brett |
Goldstein |
22.45 |
14 |
|
=(D27*E27)+(F27*C2*D27) |
=C1*G27 |
=G27-H27 |
|
|
|
=SUM(E5:E27) |
=SUM(F5:F27) |
=SUM(G5:G27) |
=SUM(H5:H27) |
=SUM(I5:I27) |
|
|
|
|
|
|
|
|
|
|
|