HW Problem part $2-$ Module $6$

The following $2$ employees are PAID monthly and this is the last payday of the year $($Dec$).$

Each employee's taxable part of their wages is listed below. When applicable the company uses

the "Quick Charts" to determine federal income tax withholdings.

The company is located in Jasper County, IN

RebeccaR. Dec. regular pay

Federal taxable: $,$$$5,000$

Social Security taxable

Medicare taxable:

$ $5,900$

$$5\mathrm{.}200$

$$5,200$

Single $-$ Nothing else marked on the W$4$

Lives in Porter County, IN

Andrea $T$

Dec. regular pay

$$14,550$

Federal taxable:

Social Security taxable:

Medicare taxable:

Married $/$ W $4$ box $2$ is checked and item $3$ totals $$4,500$

Lives in Lake County, IN

Question $12$

How much in county withholding taxes should be deducted from

Andrea's check?

Use the following Word and Excel documents to answer the remaining

questions relating to Form $941$ and a W$2.$