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.

Answer 2

you need to post this in the math area there are alot of people who can help you there

Answer 3

just click the find more subjects on the top of the page

Answer 4

it is kind of hard to write a spread sheet here, but this should not be that difficult

Answer 5

you have to put in the first two columns by hand

Answer 6

do you know how to write a formula in a spread sheet?

Answer 7

in the cell C2 you can write =12.5 B2
then pull it down

Answer 8

actually it is = 125*B2
dont forget the equal sign

Answer 9

following so far?

Answer 10

Yes i am, thank you

Answer 11

sate income tax 5.7 percent, in D2 you can put = c2*.057
do you know what i mean when i say "pull it down"?

Answer 12

drag the cell down? i'm not very good at spreadsheats, i'm working on a bca class, "Alternative Business Computer Information Systems I-A 2013-2014 (2013)"

Answer 13

you mouse over the cell at the bottom right corner, wait till you see a small +
then pull down the column

Answer 14

wait in the 3rd spreedsheet you sent, do i still put the formulas? or ???

Answer 15

i put in cell D2
=.057C2
which finds 5.7% of the entry in C2
then i pulled it down to do the same thing

Answer 16

in E2 you can put
= .15*C2
that will find 15% of C2

Answer 17

i gotta run, you can see the formulas i used if you click on the sheet

Answer 18

okay thank you