Question

I need help with making the formulas in this. I'll type the rest in the comment section.

Create a spreadsheet to calculate the your company's payroll or how much you pay each employee and the total you pay all employees.

You pay your employees every two weeks, and for the last two weeks, your employees worked the following hours:

Employee 1: 78
Employee 2: 75
Employee 3: 80
Employee 4: 45
Employee 5: 50
Employee 6: 80
Employee 7: 65
Employee 8: 60
Employee 9: 78
Employee 10: 75
Your spreadsheet should calculate:

Answer 1

the total hours worked for each employee;
the gross pay for each employee (pay rate is $12.50 per hour);
the state income tax for each employee. Use 5.7%;
the Federal income tax for each employee. Use 15%;
Social Security for each employee. Use 3.5 %;
the net pay for each employee by subtracting the income tax and Social Security from the gross pay;
the total gross pay, total state income tax, total Federal income tax, total Social Security, and total net pay paid to all employees.
When you finish your spreadsheet, estimate your answers to check for accuracy. Make any necessary corrections. Use formatting techniques to make your spreadsheet easy to read. Save and print your spreadsheet.