Name

$4$

Hourly Wage

Hours Worked

Regular Pay

Overtime Pay

Gross Pay

Taxable Pay

Federal Tax

FICA

Net Pay

$5$ Spencer

$2$

$ $11\mathrm{.}00$

$45$

S

$440\mathrm{.}00$

$ $82\mathrm{.}50$

$ $522\mathrm{.}50$

$ $422\mathrm{.}50$

$ $105\mathrm{.}63$

$ $39\mathrm{.}97$ $

$376\mathrm{.}90$

$5$ Wagner

$1$

$9\mathrm{.}00$

$38$

$342$

$0$

$342\mathrm{.}00$

$342\mathrm{.}00$

$85\mathrm{.}50$

$26$:$16$

$230\mathrm{.}34$

$7$

Harvey

$3$

S $8\mathrm{.}0021$

$168$

$0$

$168\mathrm{.}00$

$168\mathrm{.}00$

$25\mathrm{.}20$

$12\mathrm{.}85$

$129\mathrm{.}95$

$8$ Woods

$1$

$ $15\mathrm{.}00$

$33$

$495$

$0$

$495\mathrm{.}00$

$495\mathrm{.}00$

$138\mathrm{.}50$

$37\mathrm{.}87$

$318\mathrm{.}53$

$9$ Price

$ $15\mathrm{.}00$

$21$

$315$

$0$

$315\mathrm{.}00$

$315\mathrm{.}00$

$78\mathrm{.}75$

$24\mathrm{.}10$

$712\mathrm{.}15$

$10$ Gibson

$1$

$ $11\mathrm{.}00$

$21$

$231$

$0$

$231\mathrm{.}00$

$231\mathrm{.}00$

$34\mathrm{.}65$

$17\mathrm{.}67$

$178\mathrm{.}68$

$11$ Gutierrez

$3$

$ $14\mathrm{.}00$

$28$

$392$

$0$

$392\mathrm{.}00$

$392\mathrm{.}00$

$98\mathrm{.}00$

$29\mathrm{.}99$

$264\mathrm{.}01$

$12$

Willis

$2$

$ $13\mathrm{.}00$

$31$

$403$

$0$

$403\mathrm{.}00$

$403,00$

$100\mathrm{.}75$

$30\mathrm{.}83$

$271\mathrm{.}42$

$13$

Hayes

$3$

$8\mathrm{.}00$

$44$

$320$

$48$

$368\mathrm{.}00$

$368\mathrm{.}00$

$92\mathrm{.}00$

$28\mathrm{.}15$

$247\mathrm{.}85$

$14$

Cunningham

$2$

$ $15\mathrm{.}00$

$22$

$330$

$0$

$330\mathrm{.}00$

$330\mathrm{.}00$

$82\mathrm{.}50$

$25\mathrm{.}25$

$222\mathrm{.}26$

$15$ Martinez

$1$

$9\mathrm{.}00$

$45$

$360$

$67\mathrm{.}5$

$427\mathrm{.}50$

$427\mathrm{.}50$

$106\mathrm{.}88$

$32\mathrm{.}70$

$287\mathrm{.}92$

$16$ Davidson

$2$

S

$8\mathrm{.}00$

$34$

$272$

$0$

$272$

$272$

$59\mathrm{.}84$

$20\mathrm{.}808$

$191\mathrm{.}352$

$17$

Totals

$ $4,068\mathrm{.}00$

$ $198\mathrm{.}00$ $

$4,266\mathrm{.}00$

$ $4,166\mathrm{.}00$

$ $1,008\mathrm{.}29$

$ $326\mathrm{.}35$

$ $2,931\mathrm{.}36$

$18$

Overtime Pay

Name

Regular Pay

Gross Pay

Taxable Pay

Federal Tax

FICA

Net Pay

$19$

$20$

Wagner

$21$

$22$

Taxable Pay

Assumptions

Tax Rate

$23$

$24$

Base Work Hours

$40$

$15\%$

$25$

Overtime rate

$1\mathrm{.}5$

$$250$

$22\%$

$26$

FICA rate

$7\mathrm{.}65\%$

$$300$

$25\%$

$27$

Deduction per Depend S

$50\mathrm{.}00$

$$450$

$28\%$

$28$

$$525$

$31\%$

$29$

$30$

Notes

Summary Statistics

#of Hours

Gross Pay

Net Pay

Average

Highest

Lowest

$311.$

The base workweek is $40$ hours. Regular pay is based on hourly wage and hours worked up to $40.$

$32$

$2.$ Overtime pay is based on overtime hours, the hourly wage, and the overtime rate.

$333.$ The gross pay is the total of the regular pay and overtime pay.

$344.$ The taxable pay is the difference between the gross pay and the product of the number of dependents and deduction per dependent