A 16 23456 B FOR PERIOD ENDING D E F G H January 8, 20-- J K L M N 0 P ย U V W X Y Z AA AE AC AC AE AF AG AP Al AJ AK AL AM AN AC AP AC AR AS AT BM 17 18 19 EMPLOYEE 11 Carson, Fran M. 12 Wilson, William A. STATUS FILING NO. OF WH ALLOW HOURS WORKE REGULAR EARNINGS OVERTIME EARNINGS DEDUCTIONS NET PAY TAXABLE EARNINGS RATE PER D HOUR AMOUNT HOURS WORKE RATE PER TOTAL FICA D HOUR AMOUNT EARNINGS OASDI HI FIT SIT SUTA CIT 40 $17.50 700.00 $26.25 700.00 43.40 10.15 SIMPLE 20.00 GROUP HEALTH INSURANCE INSURANCE CHECK NO 313 AMOUNT OASDI IH FUTA SUTA 40 $17.25 700.00 700.00 690.00 8 $25.88 207.04 897.04 55.62 13.01 50.00 314 20 13 Utley, Harry T 897.04 37 1/2 $18.10 897.04 678.75 $27.15 www 678.75 42.08 9.84 40.00 315 678.75 21 21 Fife, Lawrence R. 678.75 40 $17.90 716.00 6 $26.85 161.10 877.10 54.38 12.72 50.00 316 877.10 877.10 22 22 Smith, Lucy K. 40 $19.75 790.00 $29.63 790.00 48.98 11.46 20.00 317 790.00 790.00 23 31 Fay, Gretchen R. 41 1/4 515.00 1.25 $19.32 24.15 539.15 33.43 7.82 40.00 318 539.15 539.15 24 32 Robey, Glenda B. 40 623.08 $23.37 623.08 38.63 9.03 50.00 319 623.08 623.08 25 33 Schork, Thomas K. 40 773.08 $29.00 773.08 47.93 11.21 60.00 320 773.08 773.08 26 51 Hardy, Barbara T. 44 579.23 4 $21.72 86.88 666.11 41.30 9.66 30.00 321 666.11 666.11 27 99 Kipley, Carson C. 40 1,000.00 $37.50 28 Totals 7,065.14 479.17 1,000.00 7,544.31 62.00 14.50 80.00 322 1.000.00 1,000.00 467.75 109.40 440.00 7.544.31 7.544.31 29 30 31 32 33 DATE JOURNAL DESCRIPTION DEBIT CREDIT 34 20- 35 Jan. 12 36 37 38 39 40 41 42 43 44 45 46 47 12 48 49 50 51 52 53 14 Wages and Salaries FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable SIMPLE Deductions Payable Group Insurance Premiums Collected Health Insurance Premiums Collected Salaries Payable Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable Salaries Payable Taxable Earnings Net Rate FUTA Tax Net FUTA SUTA Tax SUTA 54 Cash 55 56 F7 < > Excel Instructions Continuing Problem-A + 50%
Could you help me fill in all the blank spaces in this Excel table?
Please tell me the formula so I can do it with an Excel formula.
Thank you very much
. In the appropriate columns of your payroll register, record the filing status for each
employee using the information provided.
2. Record the payroll deductions for the SIMPLE plan that the employer has established for
participating employees. All of the employees are participating, and their weekly
contributions are listed below. The tax deferral on these deductions applies only to the
federal income tax.
3. Record the amount of federal income taxes using the wage-bracket method and standard
withholding.
4. Record the state income taxes on the gross weekly earnings for each employee. The rate
is 3.07% for the state of Pennsylvania.
5. Record the city income taxes on the gross weekly earnings of each employee. The rate is
3% for the city of Pittsburgh residents.
Time Card
No.
Filing
Status
No. of Withholding
Allowances
SIMPLE
Deductions
11 S N/A $20
12 S N/A 50
13 MFJ N/A 40
21 MFJ N/A 50
22 S N/A 20
31 MFJ N/A 40
32 MFJ N/A 50
33 S N/A 60
51 MFJ N/A 30
99 MFJ N/A 80
Continuing Payroll Project-Unit 5
Refer to the partially completed payroll register that you worked on at the end of Chapter 4. Complete
the SUTA deduction column—employees pay 0.06% on total gross pay. You will now compute the
employer’s liability for
computations will be used at the end of Chapter 6 in recording the payroll tax entries.
To compute the employer’s liability for unemployment taxes, proceed as follows:
1. Enter each employee’s gross earnings in the Taxable Earnings—FUTA and SUTA
columns.
2. Total the Taxable Earnings—FUTA and SUTA columns.
3. At the bottom of your payroll register, compute the following:
1. Net FUTA tax. Since this is the first pay period of the year, none of the
employees are near the $7,000 ceiling; therefore, each employee’s gross
earnings is subject to the FUTA tax.
2. SUTA tax. Since Kipley Company is a new employer, Pennsylvania has assigned
the company a contribution rate of 3.689% on the first $10,000 of each
employee’s earnings. Employees pay 0.06% on total gross pay
Step by step
Solved in 2 steps
