the state tax is 4%

Tje state tax is 4%

do yoi need any information ?

Employee Hourly Fing Name or Status Salary Number of Allowances for Federal and State Withholding Pay Hourly Hourly Over rate/hour worked worked time hours of For the For the hours acation first Second payroll payroll period period period each pay Hourly Single 0 15 50 9 10 Apple Suzie 3 Banana Hourly Married 1 25 70 60 3 Tim Married 3 20 60 70 Catalope, Salary Cheri 3 Da, Sadie Salary 3 35 70 65 Head of Household Hourly Single 0 13 55 Eggplant Bill 45 20 Fort, Kyle Hourly Married 0 15 45 55 3 Salary Gould Mutt Married 30 50 15 Hourly Single 1 65 Hamm Mason 56 Hourly Married 2 15 56 70 Igloo Alice 3 Hourly Single 2 25 Jasper Alex 55 is 3 Healthcare union Dental Vision Employee Name 401K Dependent Education Fund Accident Insuranc Apple Suzie 0 O 0 0 0 Banana, Tim $10 0 $5 ss O 0 $20 0 $5 10 6 O 12 Catalope Cheri DIR, Sadie 15 0 5 7 5 7 Eggplant Bio 0 D Fort, Kyle 0 O 0 0 15 Gould, Matt 20 0 9 0 15 10 0 0 0 0 0 0 Hamm Mason Igloo, Alice 0 0 0 O 0 0 15 Jasper, Alex 12 O 5 8 O 18 7. For FUTA, use .08 of the first $7,000 of each employee. For SUTA, use 5.4% of the first $8,500 of each employee. 8. In calculating totals in the worksheet, students must use Excel formulas including SUM, SUMIF, SUMIFS, and Subtraction. A formula should also be included to tie information between two worksheets. Other: . All of the employees are paid on a weekly basis on Friday. This project will focus on payroll for the dates ending 01/15/20 and 01/24/2020. . All employees carn 3 hours of vacation each pay period. For all voluntary benefits, there is a 50/50 cost sharing agreement Please include calculations for Social Security and Medicare regardless if these are put on hold because of the Corona Virus. Student Information: 1. Students are to open an Excel spreadsheet and create two tabs at the bottom-one for each payroll period. 2. Students are to create columns for the employee name, filing status, pay rate, gross pay, mandatory voluntary deductions, vacation, and gross pay. Assume that the employees have no cumulative carings prior to these payroll periods. 3. Students are to decide the pay rate for all employees and the number of hours worked. The number of hours worked must be different between the two payroll periods. In addition, three employees must have overtime in each payroll period. 4. Columns must also be created for hours worked, overtime, and Net Pay. 5. Students are to decide the cost of each voluntary benefit for each employee. 6. Students must include the mandatory withholdings. Use 6.2 percent for Social Security and 1.45 percent for Medicare for each employee. 7. For FUTA, use .08 of the first $7,000 of each employee. For SUTA, use 5.4% of the first $8,500 of each employee. 8. In calculating totals in the worksheet, students must use Excel formulas including SUM, SUMIF, SUMIFS, and Subtraction. A formula should also be included to tie information between two worksheets. Other: . All of the employees are paid on a weekly basis on Friday. This project will focus on payroll for the dates ending 01/15/20 and 01/24/2020. . All employees carn 3 hours of vacation each pay period. For all voluntary benefits, there is a 50/50 cost sharing agreement Please include calculations for Social Security and Medicare regardless if these are put on hold because of the Corona Virus. Student Information: 1. Students are to open an Excel spreadsheet and create two tabs at the bottom-one for each payroll period. 2. Students are to create columns for the employee name, filing status, pay rate, gross pay, mandatory voluntary deductions, vacation, and gross pay. Assume that the employees have no cumulative carings prior to these payroll periods. 3. Students are to decide the pay rate for all employees and the number of hours worked. The number of hours worked must be different between the two payroll periods. In addition, three employees must have overtime in each payroll period. 4. Columns must also be created for hours worked, overtime, and Net Pay. 5. Students are to decide the cost of each voluntary benefit for each employee. 6. Students must include the mandatory withholdings. Use 6.2 percent for Social Security and 1.45 percent for Medicare for each employee. 7. For FUTA, use .08 of the first $7,000 of each employee. For SUTA, use 5.4% of the first $8,500 of each employee. 8. In calculating totals in the worksheet, students must use Excel formulas including SUM, SUMIF, SUMIFS, and Subtraction. A formula should also be included to tie information between two worksheets. 9. Students must also include conditional formatting with at least two rules applied. 10. Students should use the formatting features of Excel to give the worksheet a professional appearance. 11. Following completion pf the two worksheets, students should prepare two word documents showing general journal entries for the employee and employer side, payment of wages, accrual of vacation time, and payment of tax liabilities. 1 Submit nuo 1 D. 7. Employee Hourly Filing Name Or Status Salary Number of Allowances for Federal and State Withholding Pay Hourly Hourly Over earn rate/hour worked worked time hours of For the For the hour vacation first second payroll payroll period period period each pay Hourly Single 0 15 50 45 10 Applie. Surie 3 Banana Hourly Married 1 25 70 60 Tim Married 3 20 Catalope, Salary Cheri 60 70 3 Dil, Sadie Salary 3 35 70 65 3 Head of Household Hourly Single 0 13 55 45 20 Eggplant Bill 3 Fort, Kyle Hourly Married 0 15 45 55 3 Salary Married 4 30 Gould Matt 60 65 Hourly Single 1 15 65 S6 Hamm Mason 3 Hourly Married 2 15 56 70 25 Igloo Alice 3 Hourly Single 2 25 Jasper, Alex 55 45 3 Employee Healthcare union Dental Vision 401K Name Dependent Education Fund Accident Insuranc Apple, Surie o 0 0 0 0 0 Banana, Tim $10 D $5 $5 D 0 $20 0 $5 10 6 0 12 Catalope, Cheri Dil, Sadie 15 0 5 7 5 7 25 Eggplant Bio 0 0 0 0 Fort, Kyle 0 O 0 0 0 0 15 Gould, Mart 20 0 9 8 0 0 15 10 0 0 0 0 0 0 Hamm Mason Igloo, Alice 0 o 0 0 O 15 O. Jasper, Alex 12 5 O O 18 Wage Bracket Method Tables for Income Tax Withholding SINGLE Persons-WEEKLY Payroll Period For Wages ud oh December 11, 2018 And the wages Al Bus 2 05 573 50 os os -1 0 50 35 1 9 M . 2000OOOOO ! 115 120 125 110 105 120 125 130 135 140 145 194 OOO OOOO OCE 135 140 149 150 E 185 170 175 150 185 170 125 150 15 100 195 200 012 OP OEZ ORE OPE GOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOO GOOOOOOOOOOOOOOOOOOO D00000000000000 SONG OCE OR gooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo 000 60000 6000 6000 - SIN RRRRRRRR 2000 22:29 ERROR RRARXARXAS 393 335 3383 38993 350 00000 DOOGDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD08 OVE os O OG 410 420 470 480 490 005 OS ots OCS ERNIARRARA ONES ERR 540 550 580 000 10 OCD 530 40 Page 48 Publication 15 (2018) oooo aaaaaaaaaaaaaaoooor 3, noooooooooooooo Tai 72 **% e to H= _ N M ,% %n% & G T2 Wage Bracket Method Tables for Income Tax Withholding SINGLE Persons-WEEKLY Payroll Period (For Wages Paid through December 31, 2016) And the number of wholding allowance claimed is The amount of income tax to be withold Butis And the war At least % Use Tableatora SINGLE ponon page 46. Also the instructions on page 44 $ VS %5mm ||||| - | 10 11 1 1 || 1 14 | 0 - 8 10 | 1 | 5650 TEL ATH, 15 1.The 1,180 136 26 12 1. 13, | 10 1.050 1040 1.060 1.040 20 1. 1.130 1990 190 190 114 1. 2 1. 9 1.210 1,390 1240 1.56 6 1.40 SOC . | - SP 115 805 5 775 || 675 55 COS -- 1 | SU SOS 1955 475 ||| 31 -- ||| 4 E SC sze === . | 6 dda E-my- :, gaoao aaaa 84,g #Jade doope doebe pogo godbooeeee eugeooooooooooom ###euTBB_ At least And the wages are Bullose 50 OTO The amount of income tax to be withheld is And the number of withholding allowances claimed For Wages Paid through December 31, 2018) MARRIED Persons-WEEKLY Payroll Period Wage Bracket Method Tables for Income Tax Withholding ,: - popeppape peoppeoppo oppp9 peopo noopeppepper gopogogogo gooooooooooooooooopO000000000000000000099999999 | ge 0 0 0 0 0 90 spoooooooooooooooooooooooo00000000000000 000 Soooooooooooooooooooooooooooop of ooooperse oooooooooooooooooop on o 00 ooooooop on res DOO BOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO GE 20090999999999999999 Wage Bracket Method Tables for Income Tax Withholding MARRIED Persons-WEEKLY Payroll Period For Wages Paid through December 31, 2016) And the wages are And the number of wit holding allowances claimed is At least Butless The amount of , me tax to be withheld is 0 8 ? mmn S JU wwwww :d d ts wn WHu 5 Q , TE 12, | 10 TEI 1 T16 98 :: aaXXmma x 8 ww ] Tt 3 EEEER MS 11 Jie obcaacobao as i-Bm 88 yy 24 spot N 9 12.3 124 1 18 11 11 11 11 11 | 117 122 14 11 1 OZI ||| TE | | | 12 EL $1,575 and over Use Table 1) for a MARRIED person on page 25. Also see the instructions on page 4 Employee Hourly Fing Name or Status Salary Number of Allowances for Federal and State Withholding Pay Hourly Hourly Over rate/hour worked worked time hours of For the For the hours acation first Second payroll payroll period period period each pay Hourly Single 0 15 50 9 10 Apple Suzie 3 Banana Hourly Married 1 25 70 60 3 Tim Married 3 20 60 70 Catalope, Salary Cheri 3 Da, Sadie Salary 3 35 70 65 Head of Household Hourly Single 0 13 55 Eggplant Bill 45 20 Fort, Kyle Hourly Married 0 15 45 55 3 Salary Gould Mutt Married 30 50 15 Hourly Single 1 65 Hamm Mason 56 Hourly Married 2 15 56 70 Igloo Alice 3 Hourly Single 2 25 Jasper Alex 55 is 3 Healthcare union Dental Vision Employee Name 401K Dependent Education Fund Accident Insuranc Apple Suzie 0 O 0 0 0 Banana, Tim $10 0 $5 ss O 0 $20 0 $5 10 6 O 12 Catalope Cheri DIR, Sadie 15 0 5 7 5 7 Eggplant Bio 0 D Fort, Kyle 0 O 0 0 15 Gould, Matt 20 0 9 0 15 10 0 0 0 0 0 0 Hamm Mason Igloo, Alice 0 0 0 O 0 0 15 Jasper, Alex 12 O 5 8 O 18 7. For FUTA, use .08 of the first $7,000 of each employee. For SUTA, use 5.4% of the first $8,500 of each employee. 8. In calculating totals in the worksheet, students must use Excel formulas including SUM, SUMIF, SUMIFS, and Subtraction. A formula should also be included to tie information between two worksheets. Other: . All of the employees are paid on a weekly basis on Friday. This project will focus on payroll for the dates ending 01/15/20 and 01/24/2020. . All employees carn 3 hours of vacation each pay period. For all voluntary benefits, there is a 50/50 cost sharing agreement Please include calculations for Social Security and Medicare regardless if these are put on hold because of the Corona Virus. Student Information: 1. Students are to open an Excel spreadsheet and create two tabs at the bottom-one for each payroll period. 2. Students are to create columns for the employee name, filing status, pay rate, gross pay, mandatory voluntary deductions, vacation, and gross pay. Assume that the employees have no cumulative carings prior to these payroll periods. 3. Students are to decide the pay rate for all employees and the number of hours worked. The number of hours worked must be different between the two payroll periods. In addition, three employees must have overtime in each payroll period. 4. Columns must also be created for hours worked, overtime, and Net Pay. 5. Students are to decide the cost of each voluntary benefit for each employee. 6. Students must include the mandatory withholdings. Use 6.2 percent for Social Security and 1.45 percent for Medicare for each employee. 7. For FUTA, use .08 of the first $7,000 of each employee. For SUTA, use 5.4% of the first $8,500 of each employee. 8. In calculating totals in the worksheet, students must use Excel formulas including SUM, SUMIF, SUMIFS, and Subtraction. A formula should also be included to tie information between two worksheets. Other: . All of the employees are paid on a weekly basis on Friday. This project will focus on payroll for the dates ending 01/15/20 and 01/24/2020. . All employees carn 3 hours of vacation each pay period. For all voluntary benefits, there is a 50/50 cost sharing agreement Please include calculations for Social Security and Medicare regardless if these are put on hold because of the Corona Virus. Student Information: 1. Students are to open an Excel spreadsheet and create two tabs at the bottom-one for each payroll period. 2. Students are to create columns for the employee name, filing status, pay rate, gross pay, mandatory voluntary deductions, vacation, and gross pay. Assume that the employees have no cumulative carings prior to these payroll periods. 3. Students are to decide the pay rate for all employees and the number of hours worked. The number of hours worked must be different between the two payroll periods. In addition, three employees must have overtime in each payroll period. 4. Columns must also be created for hours worked, overtime, and Net Pay. 5. Students are to decide the cost of each voluntary benefit for each employee. 6. Students must include the mandatory withholdings. Use 6.2 percent for Social Security and 1.45 percent for Medicare for each employee. 7. For FUTA, use .08 of the first $7,000 of each employee. For SUTA, use 5.4% of the first $8,500 of each employee. 8. In calculating totals in the worksheet, students must use Excel formulas including SUM, SUMIF, SUMIFS, and Subtraction. A formula should also be included to tie information between two worksheets. 9. Students must also include conditional formatting with at least two rules applied. 10. Students should use the formatting features of Excel to give the worksheet a professional appearance. 11. Following completion pf the two worksheets, students should prepare two word documents showing general journal entries for the employee and employer side, payment of wages, accrual of vacation time, and payment of tax liabilities. 1 Submit nuo 1 D. 7. Employee Hourly Filing Name Or Status Salary Number of Allowances for Federal and State Withholding Pay Hourly Hourly Over earn rate/hour worked worked time hours of For the For the hour vacation first second payroll payroll period period period each pay Hourly Single 0 15 50 45 10 Applie. Surie 3 Banana Hourly Married 1 25 70 60 Tim Married 3 20 Catalope, Salary Cheri 60 70 3 Dil, Sadie Salary 3 35 70 65 3 Head of Household Hourly Single 0 13 55 45 20 Eggplant Bill 3 Fort, Kyle Hourly Married 0 15 45 55 3 Salary Married 4 30 Gould Matt 60 65 Hourly Single 1 15 65 S6 Hamm Mason 3 Hourly Married 2 15 56 70 25 Igloo Alice 3 Hourly Single 2 25 Jasper, Alex 55 45 3 Employee Healthcare union Dental Vision 401K Name Dependent Education Fund Accident Insuranc Apple, Surie o 0 0 0 0 0 Banana, Tim $10 D $5 $5 D 0 $20 0 $5 10 6 0 12 Catalope, Cheri Dil, Sadie 15 0 5 7 5 7 25 Eggplant Bio 0 0 0 0 Fort, Kyle 0 O 0 0 0 0 15 Gould, Mart 20 0 9 8 0 0 15 10 0 0 0 0 0 0 Hamm Mason Igloo, Alice 0 o 0 0 O 15 O. Jasper, Alex 12 5 O O 18 Wage Bracket Method Tables for Income Tax Withholding SINGLE Persons-WEEKLY Payroll Period For Wages ud oh December 11, 2018 And the wages Al Bus 2 05 573 50 os os -1 0 50 35 1 9 M . 2000OOOOO ! 115 120 125 110 105 120 125 130 135 140 145 194 OOO OOOO OCE 135 140 149 150 E 185 170 175 150 185 170 125 150 15 100 195 200 012 OP OEZ ORE OPE GOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOO GOOOOOOOOOOOOOOOOOOO D00000000000000 SONG OCE OR gooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo 000 60000 6000 6000 - SIN RRRRRRRR 2000 22:29 ERROR RRARXARXAS 393 335 3383 38993 350 00000 DOOGDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD08 OVE os O OG 410 420 470 480 490 005 OS ots OCS ERNIARRARA ONES ERR 540 550 580 000 10 OCD 530 40 Page 48 Publication 15 (2018) oooo aaaaaaaaaaaaaaoooor 3, noooooooooooooo Tai 72 **% e to H= _ N M ,% %n% & G T2 Wage Bracket Method Tables for Income Tax Withholding SINGLE Persons-WEEKLY Payroll Period (For Wages Paid through December 31, 2016) And the number of wholding allowance claimed is The amount of income tax to be withold Butis And the war At least % Use Tableatora SINGLE ponon page 46. Also the instructions on page 44 $ VS %5mm ||||| - | 10 11 1 1 || 1 14 | 0 - 8 10 | 1 | 5650 TEL ATH, 15 1.The 1,180 136 26 12 1. 13, | 10 1.050 1040 1.060 1.040 20 1. 1.130 1990 190 190 114 1. 2 1. 9 1.210 1,390 1240 1.56 6 1.40 SOC . | - SP 115 805 5 775 || 675 55 COS -- 1 | SU SOS 1955 475 ||| 31 -- ||| 4 E SC sze === . | 6 dda E-my- :, gaoao aaaa 84,g #Jade doope doebe pogo godbooeeee eugeooooooooooom ###euTBB_ At least And the wages are Bullose 50 OTO The amount of income tax to be withheld is And the number of withholding allowances claimed For Wages Paid through December 31, 2018) MARRIED Persons-WEEKLY Payroll Period Wage Bracket Method Tables for Income Tax Withholding ,: - popeppape peoppeoppo oppp9 peopo noopeppepper gopogogogo gooooooooooooooooopO000000000000000000099999999 | ge 0 0 0 0 0 90 spoooooooooooooooooooooooo00000000000000 000 Soooooooooooooooooooooooooooop of ooooperse oooooooooooooooooop on o 00 ooooooop on res DOO BOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO GE 20090999999999999999 Wage Bracket Method Tables for Income Tax Withholding MARRIED Persons-WEEKLY Payroll Period For Wages Paid through December 31, 2016) And the wages are And the number of wit holding allowances claimed is At least Butless The amount of , me tax to be withheld is 0 8 ? mmn S JU wwwww :d d ts wn WHu 5 Q , TE 12, | 10 TEI 1 T16 98 :: aaXXmma x 8 ww ] Tt 3 EEEER MS 11 Jie obcaacobao as i-Bm 88 yy 24 spot N 9 12.3 124 1 18 11 11 11 11 11 | 117 122 14 11 1 OZI ||| TE | | | 12 EL $1,575 and over Use Table 1) for a MARRIED person on page 25. Also see the instructions on page 4