Can you help me please to create excel sheet
Employee Hourly Filing Name Status Salary or Number of Allowances for Federal and State Withholding Pay Hourly Hourly Over rate/hour worked worked time For the For the hours first second payroll payroll period earn hours of vacation each pay period period Hourly Single 0 15 50 45 10 Applie, Suzie 3 Hourly Married 1 25 70 60 Banana, Tim 3 3 Salary Married 3 20 60 Catalope, Cheri 70 3 3 35 Dill, Sadie Salary Head of Household 70 65 3 Hourly Single 0 13 55 45 20 Eggplant, Bill 3 3 Fort, Kyle Hourly Married 0 15 45 55 3 Salary Married 4 30 60 65 Gould, Matt 3 Hourly Single 1 15 65 56 Hamm, Mason 3 Hourly Married 2 15 56 70 25 Igloo, Alice 3 Hourly Single 2 25 55 45 Jasper, Alex 3 Healthcare, union Dental Vision 401K Employee Name Dependednt Education Fund Accident Insuranc Applie, Suzie o 0 0 0 o 0 0 Banana, Tim $10 0 $5 $5 0 0 $20 0 $5 10 6 0 O Catalope, Cheri 12 Dill, Sadie 15 0 5 7 5 7 25 Eggplant, Billo 0 0 0 0 0 Fort, Kyle 0 O 0 0 0 0 15 Gould, Matt 20 0 9 8 0 0 15 10 0 O 0 0 0 0 0 Hamm, Mason Igloo, Alice 0 0 0 0 0 0 15 Jasper, Alex 12 0 5 8 0 0 18 open an Excel spreadsheet and create two tabs at the bottom - one for each payroll period. 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. created for hours worked, overtime, and Net Pay. use Excel formulas including SUM, SUMIF, SUMIFS, and Subtraction. A formula should also be included to tie information between two worksheets. include conditional formatting with at least two rules applied, and use the formatting features of Excel to give the worksheet a professional appearance information 1-Students must include the mandatory withholdings. Use 6.2 percent for Social Security and 1.45 percent for Medicare for each employee. 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. All of 2- the employees are paid on a weekly basis on Friday. 3-This project will focus on payroll for the dates ending 01/15/20 and 01/24/2020. 4- For all voluntary benefits, there is a 50/50 cost sharing mont 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 Filing Name Status Salary or Number of Allowances for Federal and State Withholding Pay Hourly Hourly Over rate/hour worked worked time For the For the hours first second payroll payroll period earn hours of vacation each pay period period Hourly Single 0 15 50 45 10 Applie, Suzie 3 Hourly Married 1 25 70 60 Banana, Tim 3 3 Salary Married 3 20 60 Catalope, Cheri 70 3 3 35 Dill, Sadie Salary Head of Household 70 65 3 Hourly Single 0 13 55 45 20 Eggplant, Bill 3 3 Fort, Kyle Hourly Married 0 15 45 55 3 Salary Married 4 30 60 65 Gould, Matt 3 Hourly Single 1 15 65 56 Hamm, Mason 3 Hourly Married 2 15 56 70 25 Igloo, Alice 3 Hourly Single 2 25 55 45 Jasper, Alex 3 Healthcare, union Dental Vision 401K Employee Name Dependednt Education Fund Accident Insuranc Applie, Suzie o 0 0 0 o 0 0 Banana, Tim $10 0 $5 $5 0 0 $20 0 $5 10 6 0 O Catalope, Cheri 12 Dill, Sadie 15 0 5 7 5 7 25 Eggplant, Billo 0 0 0 0 0 Fort, Kyle 0 O 0 0 0 0 15 Gould, Matt 20 0 9 8 0 0 15 10 0 O 0 0 0 0 0 Hamm, Mason Igloo, Alice 0 0 0 0 0 0 15 Jasper, Alex 12 0 5 8 0 0 18 open an Excel spreadsheet and create two tabs at the bottom - one for each payroll period. 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. created for hours worked, overtime, and Net Pay. use Excel formulas including SUM, SUMIF, SUMIFS, and Subtraction. A formula should also be included to tie information between two worksheets. include conditional formatting with at least two rules applied, and use the formatting features of Excel to give the worksheet a professional appearance information 1-Students must include the mandatory withholdings. Use 6.2 percent for Social Security and 1.45 percent for Medicare for each employee. 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. All of 2- the employees are paid on a weekly basis on Friday. 3-This project will focus on payroll for the dates ending 01/15/20 and 01/24/2020. 4- For all voluntary benefits, there is a 50/50 cost sharing mont 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
