Question

1 Approved Answer

Posted on Jul 15, 2024

I don't know where the mistake is happening. If I reconfigure the FIT, I am off by $28. If I don't reconfigure the FIT, I

image text in transcribed I don't know where the mistake is happening. If I reconfigure the FIT, I am off by $28. If I don't reconfigure the FIT, I am off by 212. I reconfigure the FIT because of the SMART contributions. Or if I don't, I'm still off. My gross pay is correct, as evidenced by the total earnings checkpoint on the far right. (The net paid on the far right is what I'm supposed to come up with.)

BA177 Ch7 2021 Project - Copy - Excel File Home Insert Draw Page Layout Formulas Data Review View Developer Help Tell me what you want to do Arial , 10.A AA = 96 Wrap Text Number Normal Bad Good AutoSum- FIN IN Paste X. Cut Da Copy Undo Format Painter Clipboard I New Group ES Insert Delete Format BIU B RE A 5 Merge & Center $ % 3 06 on 0 Conditional Formal as Formatting Table Neutral Calculation Check Cell Sad Filte Clear Font Alignment Number Styles Cells Editing ACS7 v . Z X fx 82 AA AB AC GLO-BRITE PAINT COMPANY AD AE AF AG AH AJ AJ AK AL AM AN AO AP AQ AR AS " 1 2 3 Deductions Net Paid Taxable Earnings Labor Cost Distribution FIT Group Ins. Union Dues Ck. SIMPLE No. SIT SUTA CIT Amount OASDI FUTA SUTA Admin Office Sales Plant 8.00 1,126.40 2.250.00 40.00 550.00 1.220 00 1.350.00 45.00 139.00 82.00 39.00 146,00 75.00 49 00 186 00 56.00 34.58 69.08 37.45 41.45 70.85 35.92 44 21 62.94 30.95 0.68 135 073 0.81 1.38 0.70 0.86 1.23 0.60 4361 87 10 47 23 52.26 89.34 45 29 55.75 79.36 39.02 16.50 26.40 14.40 15.90 27:00 14.10 16.80 24.00 11.70 703 891.86 1126 40 41126 40 500 00 1704 1254.94 2.250 00 2.250.00 705944.86 1.220.00 1,220.00 250,00 706847 30 1.350.00 1,350.00 700.00 707 1096 582.307.69 2.307 69 708 909.48 170.00 1.170.00 200.00 709 955 221,440.00 1 440.00 7101 1.539.64 2,050.00 2,050 00 711 79261 1 008 00 1.008 00 2.307.69 190.00 1.170.00 8.00 1.440.00 2,050.00 1.426.00 1008.00 817.00 427.43 8.34 538.96 166.80 16.00 1.650.00 9.232 49 13.92209 13,922 09 0.00 2.206.00 2307 693,398.00 3,600.00 4616.40 Total 4 4 NAME Earnings OASDI HI 54 Payday, November 20, 55 Bonno, A 1.126.40 69 84 16.33 56 Ferguson, J. 2.250.00 139.50 32.63 57 Ford, C. 1.220.00 75.64 17.69 58 Mann, D. 1.350.00 83.70 19.58 59 O'Neill, J. 2307.69 143.08 33.46 60 Russell V. 1,170.00 72 54 16.97 61 Ryan, N 1.440.00 89 28 20 88 62 Sokowski, T. 2050.00 127.10 29 73 63 (Student) 1,008,00 62.50 14.62 64 65 66 67 68 TOTALS 13.922 09 863.18 201.89 69 Payday, December 4, 70 Bonno, A 71 Ferguson, 72 Ford, C 73 Mann, D 74 O'Neill, J. 75 Russell V. 76 Ryan N. 77 Sokowski, T. 78 (Student) 79 Woods, B. 80 81 82 TOTALS 0.00 0.00) 0.00 83 Payday, December 14 84 Russell, V. 85 86 TOTALS 0.00 0.00 0.00 87 Payday, December 18 88 Bonno A 89 Ferguson J. 90 Ford. Fyral Instructions Tournal General Ledger 0.00 0.00 0.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0 00 0.00 0.001 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Payroll Register Employees' Earnings Records ' AC57 82 A B CD E F G H I J U V W X Y K L M N O P Q R S T PAYROLL REGISTER Time Record Regular Earnings 3 Overtime Earnings Filing Status MOI|PHI Rate Per Hrs. Hour Amount Amount 1.126.40 2.250.00 1.220.00 1,350.00 2,307 69 1,170.00 1,440.00 2,050.00 1.008.00 Rate Per 4 N/AME M T W T F S S M T W T F S Hrs. Hour 54 Payday, November 20, 20-- For Period Ending November 14, 20.. 55 Bonno, A MFJ N/A 8 8 8 8 8 8 8 8 64 17.600 56 Ferguson, J. MEJ NA 8 8 8 8 8 888 88 80 57 Ford, C. S 8 8 8 8 8 8 8 8 8 8 80 58 Mann. D. MEJ NA 8 8 8 8 8 8 8 8 88 80 59 O'Neill, J. MFJ N/A 8 8 8 8 8 8 18 8 88 80 60 Russell, V S N/A 6. 8 8 8 8 88 8 8 8 78. MFJ NA 61 Ryan N. 8 8 8 8 8 8 8 80 888 S N/A 62 Sokowski, T. 8 8 8 8 8 8 8 8 80 8 S N/A 8 8 63 Student) 8 8 8 4 8 884 72 64 65 66 67 68 TOTALS 69 Payday, December 4, 20-- For Period Ending November 28, 20- 70 Bonno, A MFJ NA 8 MFJ N/A 8 8 8 80 8 8 8 8 8 71 Ferguson, J 72 Ford C S N/A 73 Mann, D MFJ N/A 74 IO'Neill, J MFJ N/A 75 Russell, V. s N/A 76 Ryan, N MFJ N/A 77 Sokowski. T. s 13,922.09 co M nat as ble Neutral > Editing Cells Styles AV AW AU AS AR AN AQ AO AP Labor Cost Distribution nings Admin. Office Sales FUTA SUTA Plant Checkpoints Total earnings Net paid 1.126.40 13,922.09 9,444.49 2.250.00 1.220.00 40.00 550.00 1,350.00 2.307.69 190.00 1,170.00 1,440.00 2,050.00 1,426.00 1,008.00 0.00 2,206.00 2,307.69 3,398.00 3,600.00 4,616.40 Checkpoints Total earnings Net paid BA177 Ch7 2021 Project - Copy - Excel File Home Insert Draw Page Layout Formulas Data Review View Developer Help Tell me what you want to do Arial , 10.A AA = 96 Wrap Text Number Normal Bad Good AutoSum- FIN IN Paste X. Cut Da Copy Undo Format Painter Clipboard I New Group ES Insert Delete Format BIU B RE A 5 Merge & Center $ % 3 06 on 0 Conditional Formal as Formatting Table Neutral Calculation Check Cell Sad Filte Clear Font Alignment Number Styles Cells Editing ACS7 v . Z X fx 82 AA AB AC GLO-BRITE PAINT COMPANY AD AE AF AG AH AJ AJ AK AL AM AN AO AP AQ AR AS " 1 2 3 Deductions Net Paid Taxable Earnings Labor Cost Distribution FIT Group Ins. Union Dues Ck. SIMPLE No. SIT SUTA CIT Amount OASDI FUTA SUTA Admin Office Sales Plant 8.00 1,126.40 2.250.00 40.00 550.00 1.220 00 1.350.00 45.00 139.00 82.00 39.00 146,00 75.00 49 00 186 00 56.00 34.58 69.08 37.45 41.45 70.85 35.92 44 21 62.94 30.95 0.68 135 073 0.81 1.38 0.70 0.86 1.23 0.60 4361 87 10 47 23 52.26 89.34 45 29 55.75 79.36 39.02 16.50 26.40 14.40 15.90 27:00 14.10 16.80 24.00 11.70 703 891.86 1126 40 41126 40 500 00 1704 1254.94 2.250 00 2.250.00 705944.86 1.220.00 1,220.00 250,00 706847 30 1.350.00 1,350.00 700.00 707 1096 582.307.69 2.307 69 708 909.48 170.00 1.170.00 200.00 709 955 221,440.00 1 440.00 7101 1.539.64 2,050.00 2,050 00 711 79261 1 008 00 1.008 00 2.307.69 190.00 1.170.00 8.00 1.440.00 2,050.00 1.426.00 1008.00 817.00 427.43 8.34 538.96 166.80 16.00 1.650.00 9.232 49 13.92209 13,922 09 0.00 2.206.00 2307 693,398.00 3,600.00 4616.40 Total 4 4 NAME Earnings OASDI HI 54 Payday, November 20, 55 Bonno, A 1.126.40 69 84 16.33 56 Ferguson, J. 2.250.00 139.50 32.63 57 Ford, C. 1.220.00 75.64 17.69 58 Mann, D. 1.350.00 83.70 19.58 59 O'Neill, J. 2307.69 143.08 33.46 60 Russell V. 1,170.00 72 54 16.97 61 Ryan, N 1.440.00 89 28 20 88 62 Sokowski, T. 2050.00 127.10 29 73 63 (Student) 1,008,00 62.50 14.62 64 65 66 67 68 TOTALS 13.922 09 863.18 201.89 69 Payday, December 4, 70 Bonno, A 71 Ferguson, 72 Ford, C 73 Mann, D 74 O'Neill, J. 75 Russell V. 76 Ryan N. 77 Sokowski, T. 78 (Student) 79 Woods, B. 80 81 82 TOTALS 0.00 0.00) 0.00 83 Payday, December 14 84 Russell, V. 85 86 TOTALS 0.00 0.00 0.00 87 Payday, December 18 88 Bonno A 89 Ferguson J. 90 Ford. Fyral Instructions Tournal General Ledger 0.00 0.00 0.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0 00 0.00 0.001 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Payroll Register Employees' Earnings Records ' AC57 82 A B CD E F G H I J U V W X Y K L M N O P Q R S T PAYROLL REGISTER Time Record Regular Earnings 3 Overtime Earnings Filing Status MOI|PHI Rate Per Hrs. Hour Amount Amount 1.126.40 2.250.00 1.220.00 1,350.00 2,307 69 1,170.00 1,440.00 2,050.00 1.008.00 Rate Per 4 N/AME M T W T F S S M T W T F S Hrs. Hour 54 Payday, November 20, 20-- For Period Ending November 14, 20.. 55 Bonno, A MFJ N/A 8 8 8 8 8 8 8 8 64 17.600 56 Ferguson, J. MEJ NA 8 8 8 8 8 888 88 80 57 Ford, C. S 8 8 8 8 8 8 8 8 8 8 80 58 Mann. D. MEJ NA 8 8 8 8 8 8 8 8 88 80 59 O'Neill, J. MFJ N/A 8 8 8 8 8 8 18 8 88 80 60 Russell, V S N/A 6. 8 8 8 8 88 8 8 8 78. MFJ NA 61 Ryan N. 8 8 8 8 8 8 8 80 888 S N/A 62 Sokowski, T. 8 8 8 8 8 8 8 8 80 8 S N/A 8 8 63 Student) 8 8 8 4 8 884 72 64 65 66 67 68 TOTALS 69 Payday, December 4, 20-- For Period Ending November 28, 20- 70 Bonno, A MFJ NA 8 MFJ N/A 8 8 8 80 8 8 8 8 8 71 Ferguson, J 72 Ford C S N/A 73 Mann, D MFJ N/A 74 IO'Neill, J MFJ N/A 75 Russell, V. s N/A 76 Ryan, N MFJ N/A 77 Sokowski. T. s 13,922.09 co M nat as ble Neutral > Editing Cells Styles AV AW AU AS AR AN AQ AO AP Labor Cost Distribution nings Admin. Office Sales FUTA SUTA Plant Checkpoints Total earnings Net paid 1.126.40 13,922.09 9,444.49 2.250.00 1.220.00 40.00 550.00 1,350.00 2.307.69 190.00 1,170.00 1,440.00 2,050.00 1,426.00 1,008.00 0.00 2,206.00 2,307.69 3,398.00 3,600.00 4,616.40 Checkpoints Total earnings Net paid