I think you are missing wages data...
Please verify.
employees earnings through prior pay period earnings this pay period
d. adams 11,300 3,900
j. hess 6,100 2,500
r. lui 9,500 3,100
r. morales 4,800 1,400
l. vang 10,000 3,000
Total payroll expenses for current period $1139.25
Formulas for unemployment tax are:
=IF(C3>7000,0,IF((C3+D3)>7000,7000-C3,D3))*0.008
=IF(C3>7000,0,IF((C3+D3)>7000,7000-C3,D3))*0.025
Tax Preparer
Personal Investment, Tax Preparation