70.2K

Verified Solution

Link Copied!

I need some help with this part of the project cant seem to get the FIT amounts right for December 4 and 18, also if there's any incorrect amounts please let me know as the book makes project very confusing. thanks

7-3n December 4 Project Audit No. 19 Prepare the payroll for the first biweekly pay period of December from Time Clerk's Report Nos. 46 and 47, and record the paychecks issued to all employees. Record this payroll at the top of the third payroll register sheet. Note: Thursday, November 26, is a paid holiday for all workers. Also, record the employer's payroll taxes. Net Paid $10,970.92 Time Lost Time Clerk's Report No. 46 For Week Ending November 21, 20. Time Record Time Employee S ' WT F S Worked Bonno, A. V 8 8 8 40 hrs. Ford, C.L. 8 8 8 40 hrs. Russell, V. A. 8 8 8 40 hrs. Ryan, N. A. 8 8 4 36 hrs. Student 8 8 4 36 hrs. Woods, B. A. 8 8 32 hrs. *Time lost on account of personal business, deduct 4 hours' pay. 00 00 00 00 00 00 00 00 00 00 00 00 4 hrs. Time Lost Time Clerk's Report No. 47 For the Week Ending November 28, 20-- Time Record Time Employee S WTF S Worked Bonno, A. V..... 8 8 48 hrs. Ford, C.L. 8 8 8 40 hrs. Russell, V. A.... 8 40 hrs. Ryan, N. A. 9 10 43 hrs. Student. 8 36 hrs. Woods, B. A..... 8 8 40 hrs. *Double time. 2000 OOO OO 00 00 00 00 00 00 00 PAID HOLIDAY 00 00 00 00 00 File Home Insert Formulas Data Review View Help Tell me what you want to do Open in Desktop App Share Comments AE81 V W X Y Z AD AE BCD E F G H I J K L M N O P Q R S T U PAYROLL REGISTER AF AA AB AC GLO-BRITE PAINT COMPANY 1 2 IVI Time Record Regular Earnings Overtime Earnings Deductions Rate Per MTWTFS Hrs. Hour Rate Per Amount | Hrs. Hour Amount Total Earnings SMTW F OASDI HI FIT SIT SUTA CIT 13,922.09 13,922.09 863.18 201.891 623.00 427.43 8.34 540.30 1 5 8 8 8 8 8 8 80|17.601 8||35.201 281.601 8 8 888 8 8 8 88 8 8 8 8 8 ari tal St at 4 NAME us 67 68 TOTALS 69 Payday, December 4, 20- 70 Bonno, A. M 71 Ferguson, J. M 72 Ford, C. S 73 Mann, D. M 74 O'Neill, J. M 75 Russell, V. S 76 Ryan, N. M 77 Sokowski, T. S 78 (STUDENT) S 79 Woods, B. S 80 81 82 TOTALS 8 5 2 8 8 8 8 8 8 88 88 N... 18181818 0 8 8 8 8 8 8 8 8 oc 8 8 8 8 3 2 8 8 1,408.00 2,250.00 1,280.00 1,350.00 2,307.69 1,260.00 1,368.00 2,050.00 1,008.00 1,080.00 1,689.60 2,250.00 1,280.000 1,350.00 2,307.691 1,260.00 1,449.00 2,050.00 1,008.00 1,080.000 104.76 139.50 79.36 83.70 143.08 78.12 89.84 127.10 62.50 66.96 24.501 32.63 18.56 19.581 33.46 18.27 21.01 29.73 14.62 15.66 51.87 69.081 39.30 41.45 70.851 38.68 44.48 62.94 30.95 33.16) 1.01 1.35 0.77 0.81 1.38 0.76 0.87 1.23 0.60 0.65 65.57 87.321 49.681 52.39) 89.56) 48.90 56.23 79.56) 39.12 41.91 8 8 8 88 8 8 8 8 8 4 8 8 8 8 3||27.00 81.00 4 2 8 8 8 8 8 8 8 8 8 8 8 8 8 88 76|18.00 80 72||14.00 721 8 8 8 8 8 8 8 8 8 8 8 8 8 15,361.69 362.60 15,724.291 974.92 228.02 0.00 482.761 9.43 610.24 Excel Instructions Journal General Ledger Payroll Register Employees' Earnings Records File Home Insert Formulas Data Review View Help Tell me what you want to do Open in Desktop App Share V Comments AE81 H A U V W Y Z AD AE AF BCD E F G H I J K L M N O P Q R S PAYROLL REGISTER AA AB GLO-BRITE PAINT COMPANY 1 2 IVI 3 Time Record Regular Earnings Overtime Earnings Deductions ari tal St at Rate Per SMTWTFSSMTWTFS Hrs. Hour Rate Per Amount Hrs. Hour Amount Total Earnings 4 NAME us OASDI FIT SIT SUTA CIT 8 8 8 1235.200 422.40 48 8 88 8 8 8 8 8 8 8 8 8 8 8 8 8 88 8 8 8 8 8 88 8888 88888 8 8 8 88 8 8 88 8 8888 8 8 8 8 88 8 8888 8 8 8 80||17.601 80 80|| 16.00 80|| 16.881 801 80||18.00 80||25.63 7114.00 80115.000 80|| 15.75 87 Payday, December 18, 20 88 Bonno, A. M | 5 89 Ferguson, J. M 5 90 Ford, C. S 2 91 Mann, D. M 0 92. O'Neill, J. M|| 3 93 Ryan, N. S 2 94 Sokowski, T. M 4 95 (STUDENT) S 2 96 Woods, B. S 1 97 Young, P. S 98 99 100 101 TOTALS 1,408.00 2,250.00 1,280.00 1,350.00 2,307.69 1,440.00 2,050.00 994.00 1,200.00 1,260.00 85,000.00 189.00 1,830.401 2,250.00 1,280.00 1,350.00 87,307.69 1,629.00 2,050.00 994.00 1,200.00 1,260.00 113.48 26.54 139.50 32.63 79.36 18.56 83.700 19.58 5,020.56||1,265.96 101.00 23.621 127.10 29.73 61.63 14.41 74.40 17.40 78.12 18.27 56.191 69.08 39.30 41.45 2,680.35 50.01 62.941 30.52 36.84 38.68 1.10 1.35 0.77 0.81 52.38 0.98 1.23 0.60 0.72 0.76 71.041 87.32 49.68 52.39 3,388.32 63.22 79.56 38.58 46.57 48.900 8 8 7||27.00 8 8 8 7 8 4 8 8 88 88 8 8 8 4 8 8 84 8 8 8 8 8 8 8 8 8 8 8 8 8 15,539.69 |85,611.40 101,151.09 5,878.85|1,466.70 0.00 3,105.36| 60.70 3,925.58) 10 Excel Instructions Journal General Ledger Payroll Register Employees' Earnings Records 7-3n December 4 Project Audit No. 19 Prepare the payroll for the first biweekly pay period of December from Time Clerk's Report Nos. 46 and 47, and record the paychecks issued to all employees. Record this payroll at the top of the third payroll register sheet. Note: Thursday, November 26, is a paid holiday for all workers. Also, record the employer's payroll taxes. Net Paid $10,970.92 Time Lost Time Clerk's Report No. 46 For Week Ending November 21, 20. Time Record Time Employee S ' WT F S Worked Bonno, A. V 8 8 8 40 hrs. Ford, C.L. 8 8 8 40 hrs. Russell, V. A. 8 8 8 40 hrs. Ryan, N. A. 8 8 4 36 hrs. Student 8 8 4 36 hrs. Woods, B. A. 8 8 32 hrs. *Time lost on account of personal business, deduct 4 hours' pay. 00 00 00 00 00 00 00 00 00 00 00 00 4 hrs. Time Lost Time Clerk's Report No. 47 For the Week Ending November 28, 20-- Time Record Time Employee S WTF S Worked Bonno, A. V..... 8 8 48 hrs. Ford, C.L. 8 8 8 40 hrs. Russell, V. A.... 8 40 hrs. Ryan, N. A. 9 10 43 hrs. Student. 8 36 hrs. Woods, B. A..... 8 8 40 hrs. *Double time. 2000 OOO OO 00 00 00 00 00 00 00 PAID HOLIDAY 00 00 00 00 00 File Home Insert Formulas Data Review View Help Tell me what you want to do Open in Desktop App Share Comments AE81 V W X Y Z AD AE BCD E F G H I J K L M N O P Q R S T U PAYROLL REGISTER AF AA AB AC GLO-BRITE PAINT COMPANY 1 2 IVI Time Record Regular Earnings Overtime Earnings Deductions Rate Per MTWTFS Hrs. Hour Rate Per Amount | Hrs. Hour Amount Total Earnings SMTW F OASDI HI FIT SIT SUTA CIT 13,922.09 13,922.09 863.18 201.891 623.00 427.43 8.34 540.30 1 5 8 8 8 8 8 8 80|17.601 8||35.201 281.601 8 8 888 8 8 8 88 8 8 8 8 8 ari tal St at 4 NAME us 67 68 TOTALS 69 Payday, December 4, 20- 70 Bonno, A. M 71 Ferguson, J. M 72 Ford, C. S 73 Mann, D. M 74 O'Neill, J. M 75 Russell, V. S 76 Ryan, N. M 77 Sokowski, T. S 78 (STUDENT) S 79 Woods, B. S 80 81 82 TOTALS 8 5 2 8 8 8 8 8 8 88 88 N... 18181818 0 8 8 8 8 8 8 8 8 oc 8 8 8 8 3 2 8 8 1,408.00 2,250.00 1,280.00 1,350.00 2,307.69 1,260.00 1,368.00 2,050.00 1,008.00 1,080.00 1,689.60 2,250.00 1,280.000 1,350.00 2,307.691 1,260.00 1,449.00 2,050.00 1,008.00 1,080.000 104.76 139.50 79.36 83.70 143.08 78.12 89.84 127.10 62.50 66.96 24.501 32.63 18.56 19.581 33.46 18.27 21.01 29.73 14.62 15.66 51.87 69.081 39.30 41.45 70.851 38.68 44.48 62.94 30.95 33.16) 1.01 1.35 0.77 0.81 1.38 0.76 0.87 1.23 0.60 0.65 65.57 87.321 49.681 52.39) 89.56) 48.90 56.23 79.56) 39.12 41.91 8 8 8 88 8 8 8 8 8 4 8 8 8 8 3||27.00 81.00 4 2 8 8 8 8 8 8 8 8 8 8 8 8 8 88 76|18.00 80 72||14.00 721 8 8 8 8 8 8 8 8 8 8 8 8 8 15,361.69 362.60 15,724.291 974.92 228.02 0.00 482.761 9.43 610.24 Excel Instructions Journal General Ledger Payroll Register Employees' Earnings Records File Home Insert Formulas Data Review View Help Tell me what you want to do Open in Desktop App Share V Comments AE81 H A U V W Y Z AD AE AF BCD E F G H I J K L M N O P Q R S PAYROLL REGISTER AA AB GLO-BRITE PAINT COMPANY 1 2 IVI 3 Time Record Regular Earnings Overtime Earnings Deductions ari tal St at Rate Per SMTWTFSSMTWTFS Hrs. Hour Rate Per Amount Hrs. Hour Amount Total Earnings 4 NAME us OASDI FIT SIT SUTA CIT 8 8 8 1235.200 422.40 48 8 88 8 8 8 8 8 8 8 8 8 8 8 8 8 88 8 8 8 8 8 88 8888 88888 8 8 8 88 8 8 88 8 8888 8 8 8 8 88 8 8888 8 8 8 80||17.601 80 80|| 16.00 80|| 16.881 801 80||18.00 80||25.63 7114.00 80115.000 80|| 15.75 87 Payday, December 18, 20 88 Bonno, A. M | 5 89 Ferguson, J. M 5 90 Ford, C. S 2 91 Mann, D. M 0 92. O'Neill, J. M|| 3 93 Ryan, N. S 2 94 Sokowski, T. M 4 95 (STUDENT) S 2 96 Woods, B. S 1 97 Young, P. S 98 99 100 101 TOTALS 1,408.00 2,250.00 1,280.00 1,350.00 2,307.69 1,440.00 2,050.00 994.00 1,200.00 1,260.00 85,000.00 189.00 1,830.401 2,250.00 1,280.00 1,350.00 87,307.69 1,629.00 2,050.00 994.00 1,200.00 1,260.00 113.48 26.54 139.50 32.63 79.36 18.56 83.700 19.58 5,020.56||1,265.96 101.00 23.621 127.10 29.73 61.63 14.41 74.40 17.40 78.12 18.27 56.191 69.08 39.30 41.45 2,680.35 50.01 62.941 30.52 36.84 38.68 1.10 1.35 0.77 0.81 52.38 0.98 1.23 0.60 0.72 0.76 71.041 87.32 49.68 52.39 3,388.32 63.22 79.56 38.58 46.57 48.900 8 8 7||27.00 8 8 8 7 8 4 8 8 88 88 8 8 8 4 8 8 84 8 8 8 8 8 8 8 8 8 8 8 8 8 15,539.69 |85,611.40 101,151.09 5,878.85|1,466.70 0.00 3,105.36| 60.70 3,925.58) 10 Excel Instructions Journal General Ledger Payroll Register Employees' Earnings Records

Answer & Explanation Solved by verified expert

See Answer