subject
Business, 17.12.2020 14:00 mrnotsosmart2787

PLEASEEE HEEELLLPPP MCreate 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:

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.

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 07:50
Connors academy reported inventory in the 2017 year-end balance sheet, using the fifo method, as $154,000. in 2018, the company decided to change its inventory method to lifo. if the company had used the lifo method in 2017, the company estimates that ending inventory would have been in the range $130,000-$135,000. what adjustment would connors make for this change in inventory method?
Answers: 1
question
Business, 22.06.2019 14:00
Which of the following would be an accurate statement about achieving a balanced budget
Answers: 1
question
Business, 22.06.2019 15:40
Colter steel has $5,550,000 in assets. temporary current assets $ 3,100,000 permanent current assets 1,605,000 fixed assets 845,000 total assets $ 5,550,000 assume the term structure of interest rates becomes inverted, with short-term rates going to 10 percent and long-term rates 2 percentage points lower than short-term rates. earnings before interest and taxes are $1,170,000. the tax rate is 40 percent earnings after taxes = ?
Answers: 1
question
Business, 22.06.2019 16:40
Shawn received an e-mail offering a great deal on music, movie, and game downloads. he has never heard of the company, and the e-mail address and company name do not match. what should shawn do?
Answers: 2
You know the right answer?
PLEASEEE HEEELLLPPP MCreate a spreadsheet to calculate the your company's payroll or how much you pa...
Questions
question
Chemistry, 30.01.2020 00:47
Questions on the website: 13722367