9. At Hollywood Winery another pay period has concluded (as of 10/9) and Taylor once again needs your help to adjust the worksheet and create accurate payroll figures. The information is below:

Hours worked:

Doris: 60

Douglas: 64

Dee: 50

Earl: 80

Dusty: 60

Ferris: 38 (out one week due to sickness).

Ella: 59

Kenya: 68

Health insurance at the Family level has increased to $201/pay period. Douglas switched to Single for health insurance since it is cheaper if he and his spouse, who works at a different business, are on individual policies.

Cases Sold

Doris: 6

Douglas: 14

Dee: 8

Earl: 10

Dusty: 0

Ferris: 4

Ella: 16

Kenya: 14

Merchandise: The only employees who sold more than $200 were Dee, Ella and Kenya. Make up data for the employees as to how much they sold.

Prizes are the same.

The IRS has published new tax brackets and tax rates. If taxable income is less than $24,000 the rate is 6.75%; from $24,000 to $29,000, the rate is 8%; from $29,000.01 to $35,000, the rate is 10.25%; and if over $35,000 the rate is 12%.

FICA is now 7.75%.

Retirement has changed. If an employee earns less than or equal to $750/pay period, they pay 4% of their GROSS pay into a retirement account. If they earn $1,250/pay period or less, 5.5% is deducted; if they earn less than $1,750/pay period the rate is 7% and over 1,750 per pay period, the rate is 9%.

Adjust the payroll sheet as needed.