please iI want to resolve this project
this all information i have
the ga state tax is 4%
and this the employee inforamtion updated
Any information students need to use such as tax tables, should be retrieved from the Georgia Department of Revenue and Internal Revenue Service using the 2018 tax year. Employee Hourly Name Salary Filing Status Voluntary Deductions or Number of Allowances for Federal and State Withholding 0 Single None Applie, Hourly Suzie Banana, Hourly Tim Married 1 Married 3 Catalope, Salary Cheri Dill, Sadie Salary 3 Head of Household Healthcare, Dental, Vision, and 401K Dental, 401K, Union Health, Dental, Vision, Dependednt Education Fund, 401K, Accident Insurance None Single 0 Married 0 401K Eggplant, Hourly Bill Fort, Hourly Kyle Gould, Salary Matt Married 4 Heath, Dental, Vision, 401K Health Hourly Single 1 Hourly Married 2 401K Hamm, Mason Igloo, Alice Jasper, Alex Hourly Single 2 Health, Dental, Vision 401K 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 earn 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 earnings 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. 12 Suhmi to +1 D. 76 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 Any information students need to use such as tax tables, should be retrieved from the Georgia Department of Revenue and Internal Revenue Service using the 2018 tax year. Employee Hourly Name Salary Filing Status Voluntary Deductions or Number of Allowances for Federal and State Withholding 0 Single None Applie, Hourly Suzie Banana, Hourly Tim Married 1 Married 3 Catalope, Salary Cheri Dill, Sadie Salary 3 Head of Household Healthcare, Dental, Vision, and 401K Dental, 401K, Union Health, Dental, Vision, Dependednt Education Fund, 401K, Accident Insurance None Single 0 Married 0 401K Eggplant, Hourly Bill Fort, Hourly Kyle Gould, Salary Matt Married 4 Heath, Dental, Vision, 401K Health Hourly Single 1 Hourly Married 2 401K Hamm, Mason Igloo, Alice Jasper, Alex Hourly Single 2 Health, Dental, Vision 401K 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 earn 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 earnings 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. 12 Suhmi to +1 D. 76 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
