Question

3. The bookkeeper of Coast Co. gathered the following data from individual employee earnings records and daily time cards. Your task is to complete a payroll register on November 17. Cumulative Earning Daily Time before This Payroll M T W Hourly Rate of Pay T F FIT Allowance and Employee Marital Status Ryan, Pam M-1 Babu, Don S-O Dean, Ria M-3 Gray, Jane S-1 9 8 $6,400 17,500 107,150 21,000 10 6 5 5 7 12 11 3 11 6 9 10 6 9 7 $17 13 16 20 $39 66 36 99 9 8 8

the task is to prepare the patrol using the information provided in the images

prepare the payroll

Answer 1

S. No Employees Status Department CEBP Total Time Standerd (Overtime Hourly Over Time Gross Pay Federal FICA FICA Insurance Net Pay Rate per Income 6.2% on MEDI Weekly House Tax 106800 of CARE cum 1.45% G=E-F H I=H*1.50 =(E*H)+(FK L=J*6.20 M=J*1.45 N O=)- (K+L+M+N) $ 17.00 $ 25.50 $ 595.00$ 39.00 $ 36.89 $ 8.63 $28.00 $ 482.48 1 $ 13.00 $ 19.50 $ 552.50 $ 66.00 $ 34.26 $ 8.01 $ 28.00 $ 416.23 $ 16.00 $ 24.00 $ 760.00 $ 36.00 $ - $ 11.02 $ 28.00 $ 684.98 $ 20.00 $ 30.00 $ 800.00 $ 99.00 $ 49.60 $ 11.60 $ 28.00 $ 611.80 160.00 4.00 $66.00 $ 99.00 $2,707.50 $ 240.00 $120.75 $ 39.26 $112.00 $2,195.50 Ryan, Pam M-1 Babu, Don S-0 Dean, Ria M-3 Gray, Jane S-1 E=A+B+C+D Total Sales Office Sales Office $ 64,000.00 $ 17,500.00 $ 107,150.00 $ 21,000.00 $ 209,650.00 159.00

Notes:

Dean, Ria Cumulative before this payroll is higher than the threshold limit for FICA OASDI for $1,06,800/-, hence he is not eligible for FICA 6.20% Dedection