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 19:40
The following cost and inventory data are taken from the accounting records of mason company for the year just completed: costs incurred: direct labor cost $ 90,000 purchases of raw materials $ 134,000 manufacturing overhead $ 205,000 advertising expense $ 45,000 sales salaries $ 101,000 depreciation, office equipment $ 225,000 beginning of the year end of the year inventories: raw materials $ 8,100 $ 10,300 work in process $ 5,900 $ 21,000 finished goods $ 77,000 $ 25,800 required: 1. prepare a schedule of cost of goods manufactured. 2. prepare the cost of goods sold section of mason company’s income statement for the year.
Answers: 3
question
Business, 23.06.2019 02:00
Donna and gary are involved in an automobile accident. gary initiates a lawsuit against donna by filing a complaint. if donna files a motion to dismiss, she is asserting that
Answers: 2
question
Business, 23.06.2019 02:30
Interview notes mike is 50 and made $36,000 in wages in 2017. he is single and pays all the cost of keeping up his home. mike's daughter, brittany, lived with mike all year. brittany's son, hayden, was born in november 2017. hayden lived in mike's home since birth. brittany is 25, single, and had $1,500 in wages in 2017. she is not disabled. mike provides more than half of the support for both brittany and hayden. mike, brittany, and hayden are all u.s. citizens with valid social security numbers. 4. who can mike claim as a qualifying child(ren) for the earned income credit?
Answers: 1
question
Business, 23.06.2019 10:00
In two or three sentences describe how open market operations change the money suppy
Answers: 3
You know the right answer?
PLEASEEE HEEELLLPPP MCreate a spreadsheet to calculate the your company's payroll or how much you pa...
Questions
question
Mathematics, 04.05.2021 01:00
question
Mathematics, 04.05.2021 01:00
question
Mathematics, 04.05.2021 01:00
question
Computers and Technology, 04.05.2021 01:00
Questions on the website: 13722367