Chapter7One-MonthProjectPayrollData.xlsx
Sheet1
| Hunter Cranston |
| Period | Gross Earnings | Federal Income Tax | State Income Tax | Social Security Tax | Medicare Tax | 401(k) Deduction | Charitable Cont. |
| 1st quarter | $ 7,800.00 | $ 221.00 | $ 366.60 | $ 483.60 | $ 113.10 | $ 468.00 | $ 65.00 |
| 2nd quarter | $ 7,800.00 | $ 221.00 | $ 366.60 | $ 483.60 | $ 113.10 | $ 468.00 | $ 65.00 |
| 3rd quarter | $ 7,800.00 | $ 221.00 | $ 366.60 | $ 483.60 | $ 113.10 | $ 468.00 | $ 65.00 |
| October | $ 2,400.00 | $ 68.00 | $ 112.80 | $ 148.80 | $ 34.80 | $ 144.00 | $ 20.00 |
| November | $ 3,000.00 | $ 85.00 | $ 141.00 | $ 186.00 | $ 43.50 | $ 180.00 | $ 25.00 |
| Allison Harrison |
| Period | Gross Earnings | Federal Income Tax | State Income Tax | Social Security Tax | Medicare Tax | 401(k) Deduction | Charitable Cont. |
| 1st quarter | $ 11,960.00 | $ 416.00 | $ 568.10 | $ 741.52 | $ 173.42 | $ 598.00 | $ 65.00 |
| 2nd quarter | $ 11,960.00 | $ 416.00 | $ 568.10 | $ 741.52 | $ 173.42 | $ 598.00 | $ 65.00 |
| 3rd quarter | $ 11,960.00 | $ 416.00 | $ 568.10 | $ 741.52 | $ 173.42 | $ 598.00 | $ 65.00 |
| October | $ 3,680.00 | $ 128.00 | $ 174.80 | $ 228.16 | $ 53.36 | $ 184.00 | $ 20.00 |
| November | $ 4,600.00 | $ 160.00 | $ 218.50 | $ 285.20 | $ 66.70 | $ 230.00 | $ 25.00 |
| John Parker |
| Period | Gross Earnings | Federal Income Tax | State Income Tax | Social Security Tax | Medicare Tax | 401(k) Deduction | Charitable Cont. |
| 1st quarter | $ 50,750.05 | $ 10,929.36 | $ 2,537.47 | $ 3,146.52 | $ 735.93 | $ - 0 | $ 260.00 |
| 2nd quarter | $ 50,750.05 | $ 10,929.36 | $ 2,537.47 | $ 3,146.52 | $ 735.93 | $ - 0 | $ 260.00 |
| 3rd quarter | $ 50,750.05 | $ 10,929.36 | $ 2,537.47 | $ 1,946.76 | $ 735.93 | $ - 0 | $ 260.00 |
| October | $ 15,615.40 | $ 3,362.88 | $ 780.76 | $ - 0 | $ 226.44 | $ - 0 | $ 80.00 |
| November | $ 19,519.25 | $ 4,203.60 | $ 975.95 | $ - 0 | $ 283.05 | $ - 0 | $ 100.00 |
| Pierre Sternberg |
| Period | Gross Earnings | Federal Income Tax | State Income Tax | Social Security Tax | Medicare Tax | 401(k) Deduction | Charitable Cont. |
| 1st quarter | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 2nd quarter | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 3rd quarter | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| October | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| November | $ 2,153.85 | $ 224.36 | $ 106.62 | $ 133.54 | $ 31.23 | $ 21.54 | $ - 0 |