Payroll

Fabulous Footwear employs three salespeople, and pays time-and-a-half for overtime. Weekly paychecks are distributed on the Tuesday following the last day of the week (Saturday). Fabulous Footwear withholds income tax (20%), FICAOASDI (6.2%), and FICAMedicare (1.45%). Fabulous Footwear also pays payroll taxes for FICAOASDI (6.2%), FICAMedicare (1.45%), and state and federal unemployment (5.4% and 0.6% respectively). The payroll data for the three salespeople for the week ended March 31 follows:

Name Straight Time Rate Hours Worked Beginning Cumulative Earnings

Abbie Boland $15 45 $420

Bo Vincent $17 37 $540

Abbie Boland $22 42 $480

Requirements:

1. Complete the Payroll Register for the three employees for the week ended March 31, 2019. Format to two decimal places.

2. Complete the Payroll Tax Register.

3. Complute the total payroll expense for the week ended March 31. Format to two decimal places.

4. Record the payroll entries Fabulous Footwear makes for each of the following; use cell references to the tax registers for the amounts.

a. Wage expenses related to the three employees on Saturday, March 31.

b. Employer payroll taxes related to the three employees on Saturday, March 31.

c. Payment of all payroll taxes (employee and employer-related) on Tuesday, April 3.

d. Payment of wages on Tuesday, April 3.